Search
BWFreak - Journey to the center of Business Intelligence

Archive for December, 2009

Autobiography by Louis MacNeice

Posted on December 20th, 2009

Autobiography
by Louis MacNeice
In my childhood trees were green
And there was plenty to be seen.
Come back early or never come.
My father made the walls resound,
He wore his collar the wrong way round.
Come back early or never come.
My mother wore a yellow dress;
Gentle, gently, gentleness.
Come back early or never come.
When I was five the black dreams came;
Nothing [...]

InfoProvider Query

Posted on December 11th, 2009

If you have a query with all the characteristics and key figures from an InfoProvider, users will be very happy to use it instead of creating their new queries. The trick is the have all major variables in the varaible screen and train the users to use “Save View” feature of Bex web.
BW also provides similar feature through RSRT, except [...]

After addin more and more aggregates to the cubes, it becomes tough to estimate when the load would finish, as sometimes the Attribute Change Run takes 10 min to run, sometimes, 2 hours.
There are many ways to deal with it. For example, reduce the percentage of DB statistics calculation, switch off the aggregates…
The following SAP OSS note might help. [...]

To be able to monitor the BO connection with BW server easily, I decided to use system users for creating universe.  
This user doesn’t need a lot of accesses.
First, make sure profile is correctly generated in pfcg; turn on the Authorization trace; watch st22 for authorization related dumps.
Authorization object: S_RFC
RFC_TYPE FUGR
RFC_NAME SUSO, SUNI, RSCR, SH3A, RFC1, RZX0, RZX2, [...]

Merry Christmas and Happy New Year!

Posted on December 3rd, 2009

Here are my recent Christmas and New Year findings
1. A Christmas Carol – A thin book but better read multiple times with a dictionary handy.
2. Turkey – Not only it has a lot of meat, the rib cage looks like the cylon ship in Battlestar Galactica.
3. The SidePillow by Tempur-Pedic has excellent support for [...]

It’s a brave new world (Universe)!

Posted on December 3rd, 2009

My company recently purchased Xcelsius. So, I got a chance to play with SAP Business Objects, including Universe, Webi, Live Office, Xcelsius, Polestar, mobile application, Crystal Report, etc, etc.
I need some time to get to know the functionality of these new tools. When I am able to create some fancy schmancy Xcelsius dashboard in 5 [...]