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.
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.
No comments:
Post a Comment