Real BO Web Intelligence Report basic

A very serious day... High learning though.

Here is an interesting problem which turns the BO developer into a fool like face. Thought to put it on here since the developer's search for resolution was a failure.
Creating a Web I report on top of a universe created for a SAP BW query got tricky. We had provided some input parameters and selected just a couple of fields.

Now, the parameters were on a field something like country. It was noticed that when the parameter is provided, say India, then the data was shown only for India however the number orlf rows returned were no less than the total number of rows present for all the countries.
Even the attempt to create restricted variables on BW queries did not work.

Solution: Include a key figure in the selection of the web I query. This will return the filter data and exact rows as returned by BW query.
Techsi for the day: A key figure is must in a Web I report without which the data will be fetched from the masters dicectly and the number of rows will be equal to the numbers of the masters, i.e. for all values.

From next time..have a key figure in web I whether you need it or not.

More to come, hopefully.

The first one on blogger - lets keep it technical

I used to write down few of the memorable things...but later there was not enough time for it.
There is so much to learn everyday at job..talking just about the technical stuff here. Couldn't get much inspiration to note down all the learnings till now.
But from now on - blogger will be colored by the technical stuff at least.

I work in SAP BO now..earlier was Oracle. Lots of things to share which will do one by one as and when I remember.

SAP BO techsi for the day - If you are just starting to use it better make a habit of proper naming conventions for every variable you create. You may not be able to document from day one but a logical name would help good way.

More to come, hopefully.