Update: Read my SAP latest blog at BabaGyan Blog – GyanKund: LifeSaver: Differences between UDT and IDT
Starting writing and sharing because many times I had to search a lot and learn myself, so thought to help the ones who are starting with BO now on.
Lets start up with a tip which we all know but many of us do not follow – 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.
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 of 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.
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 webI whether you need it or not.
For those who know already – great.. those who didn’t before today – I am glad you know it know. Help me improve by comments/messages.
Update: Read my SAP latest blog at BabaGyan Blog – GyanKund: LifeSaver: Differences between UDT and IDT and more at BabaGyan Blog – GyanKund