Uncategorized

My blog is somewhat playing the sounds of silence recently. I don’t really have the chance to write posts a lot these days. At least not if I want to blog with sufficient details. And yes, I know I still owe you several posts / topics.

Sorry guys. Content coming up soon 😉

Uncategorized

Hi guys,

Just quickly to let you all know. I’m not cutting you out of the loop by not writing on the details, but if I’d have to document all tests I run and all issues I find, I will still be here next month.

Bottom line:
– watch out for 10.1.3.4.0 with 734908
– watch out for 10.1.3.4.0 with 844119
– watch out for 10.1.3.4.1

With those three versions be VERY careful that you test each and every report you have running against Essbase.

I will update you as soon as I can with a finalized overview. Probably only once Oracle has come back…

Uncategorized

Last week I had the chance an (honestly) privilege to take part in the BI Forum in Brighton. First and foremost, I’d like to say a huge thanks to the team of RittmanMead for organizing this and giving us geeks a chance to unite. We’ve got to do this more often!

Next up, something personal. I was extremely happy to finally meet Venkat face to face. We seem to have developed one of those friendships that start online and when you meet, it’s like you know each other since years. Also, I was extremely content to meet Ed again. Damn already a year since we finished our last project together.

Let’s get back to business. The lineup of speakers was quite something to say the least. I’m not going to name anyone in special since I then need to name each and every one of them…….ok here we go: Craig Stewart, Edward Roske (We’re not wooorthy!), Mark Rittman, John Minkjan, Venkat (I think, you’re actually entitled to carry “Venkat” as your sole identifier. Everyone else must change his name ;-)), Adam Bloom, Andreas Nobbmann, Mike Durran, Emiel von Bockel, Maarten-Jan Kampen, Adrian Ward, Antony Heljula and Peter Brink. Total quality in all presentations and here’s my 10 cents on them:

a) “BI Apps with ODI” from Craig Stewart: Now here we have an interesting new piece in Oracles product portfolio. Good for new customers. Questionable (at best) for existing ones.

b) Edward Roskes “Internals of Essbase”. What can I say? Edward Roske. On Essbase. Ocean. Lots of Water. Understatement. And I just loooved his texan humour.

c) Mark Rittman spoke about “BI Apps Optimization”. Do have to say “see b) ?”. Didn’t think so.

d) John Minkjan had a very nice presentation on caching. I would have like to taped it and hit a lot of people over the head with the tape (and the camera). Listen to him, people. Caching is a tool, a technique, something that can help you. It’s NOT the solution for your problems! Thanks John.

e) Venkat had a cool gimmick prepared. He had actually written a program to keep OBIEE and Essbase security in line. Extremely nice stuff! It was his first presentation in a forum like this and in Europe. Well done! I’m going to steal that 😉

f) Then we “blew up a BI server” with Adam Bloom. Talk about small cuase with huge effect. Ouch.

g) Andreas Nobbmanns “UDML and XML for grown-ups” session. I vote for his presentation to be judged “Too dangerous to be known widely!”. Please don’t let kids touch that one. They destroy enough as it is. Personally…I loved it 😉

h) Friday started with Mike Durran on 11g. I won’t say more. Or I will have to kill you. Seriously. Ed Roske has the gun.

i) Emiel von Bockels presentation. Now THAT spawned discussions. Great stuff! I’d love to see how their solution evolves over the nexst 3 to 5 years. I hope he keeps us up to date.

j) Oh yeah…I’m still not over Maarten-Jan Kampens statement on using “a bit of code” for his “OBIEE and Mapviewer” integration. Dude…copyright that stuff.

k) Adrian gave me permission to skip his session since I had stuff to do, so not much to say here.

l) Antony Heljulas “SOA” bit was cool. Reminded me of my first trials after Marks mastclass last year. Gotta say though. Very nicely presented. Better than most of Oracles sales force.

m) Peter Brinks “Cube Organized Materialized views”. Essbase cubes? Oracle OLAP? Cube Organized Materialized Views? It seems we’re actually getting too many options from Oracle right now. Would be interesting to see how Oracle positions those options with the clients.

Wrapping the whole event up in one word sounds like this: awesome. In two words: fraking awesome! Loved it, look forward to the next, want to do one myself in Switzerland now. (Check my blog or Andreas for news on that idea).

That’s it from my side for today. Off to catch some sleep.

Cheers,
Christi@n

Uncategorized

I noticed something very disturbing after applying 10.1.3.4.1 to our development environment: report grand totals for tables and row totals for pivots don’t yield any results anymore unless you manually set all fact columns to “Sum” or “Avg” in the report. The “Aggr_External” which has normally had its effect (by importing it from the cube through the physical to the BMM layer to presentation layer) no longer takes care of this.

Let’s look at the issue in detail:

Upgrading to 10.1.3.4.1, this is what we find as a default behaviour in a simple table report:

And in a pivot:

Now think about the concept behind building an rpd on top of an Essbase source for a second. Ponder what Venkat wrote about aggregations in for 4-article series here, here, here and here. No longer utilizing Aggr_External and just no longer aggregating at all is just plain stupid. (Yes, I’m on kind of a rant here…)

Now to correct that quick & dirty in the report, we assign an aggregation rule in the column formula:

And…oh miracle…we have data again:

Now as I said, I find this nothing but retarded.
Why has this been changed? Is this actually expected behaviour? If so…what’s the rationale behind that? Normally, aggregation rules set on the BMM layer always persist unless they are explicitly overwritten either in the column formula or for pivots in the measures. Why drop this all of a sudden?

My manual intervention is a workaround, but I’m facing several cubes and almost a hundred reports. Furthermore, one of the Account dimensions has more than 400 members. So manually changing 400 potentially mapped account members isn’t fun…

So the solution (if I will actually keep 10.1.3.4.1 and not just drop if for a downgrade) would be to modify the BMM layer and change all normal account members to “Sum” and all percentages to “Avg” as aggregation rule.

Stay tuned for my upcoming rant on dimension members and filters. Another extremely intelligent change with 10.1.3.4.1.

Update:
Venkat reacted to my post here. I tested it and it seems that despite having label only top level members like he mentioned, some analyses seem to work with totals and grand totals. This will need more investigating.

Cheerioh,
Christi@n

Uncategorized

I still haven’t blogged about the BI Forum in Brighton, the things I saw there, the things I wanted to test afterwards OR the things I need to blog in detail to explain my ad-hoc speech…

…all because of bloody 10.1.3.4.1! God that release is a pain when you’re using Essbase. I know it’s bad form to blog about what you’re about to blog about, but I will definitely fire off a huge rant with detailed descriptions soon.

Cheers,
Christi@n

Uncategorized

John Minkjan has won the race for the first post on 10.1.3.4.1!

http://obiee101.blogspot.com/2009/04/obiee-10341-is-out.html
http://obiee101.blogspot.com/2009/04/obiee-10341-first-impressions.html

You just gotta love the little things he immediately found.

  • 100% installation
  • old samplesales
  • BIP still not working OOB

Well let’s hope that the background looks better and all the bugs have been fixed that plagued us in the base release. Off to searching for a list of fixed bugs and patches included.

Cheers,
Christi@n

Uncategorized

No use hiding, folks. I see that there’s people from CH browsing my blog. Yes, and I’ve also seen the connection from Baden and the Oracle CH offices 😉

So please leave a comment. I’d like to see who’s actually interested in this here in Switzerland.

Cheers,
Christi@n

Uncategorized

Greetings, programs!

Back on April 3rd, when I initially wanted to get patch #8293083, I hit a wall.

Description OBIEE GENERATED MDX CAUSES PERFORMANCE ISSUE
Product Oracle BI Suite EE
Release 10.1.3.4.0
Last Updated 18-MAR-2009

The patch had been made obsolete over night. So I raised an SR with Oracle. First response on the 14th:

“Bug 8293083 is a duplicate of Bug 8332167.

Bug 8332167 is fixed in 10.1.3.4.410
Also in patch for Linux ARU 11105211
No patch for Windows.”

Sweet. So because it was a duplicate of a Linux patch the Windows patch was made obsolete? My mind boggles trying to understand that logic, but anyways I insisted on getting the patch and voilà! The patch exists again for Windows since the 17th.

Sounds good? No, not really.

8293083 is actually QF420 and in order to install it, you need to replace your whole OracleBIserverbin folder. In itself, not an issue, but there’s also patch 8290868 (QF410), which is a patch for 7482937 which resolves a rather serious issue for MDX generation for and/or filters.

The issue being that 8290868 – like 8293083 – replaces the whole bin folder. And Oracle still can’t confirm that 8293083 is an incremental patch and includes all of 8290868.

So right now there’s a choice.
a) Use 8293083, but not be sure that 8290868 and 7482937 function correctly

or

b) Use 8290868and 7482937 and wait for a final statement from Oracle.

I’ve gone for b) since it’s extremely difficult to track down each and every weird behaviour in the MDX generation for all filters, EVALUATE statements, unions etc etc.

Of course I will keep you guys updated with my latest findings and Oracles statements.

End of line.