on 05-31-2011 3:37 PM
Hi,
I have a BW Query based in a multiprovider, it has some mandatory variables like 0CALMONTH and it works very well there. But I've created a Universe based on this Query and when I try to use this universe in WEBI or Xcelsius I have some problems, variable baseed on 0CALMONTH shows strange and intelligible values like 09.0077, 06.0000, 05.0014 for the months.
I have other universes based on queries with mandatory variables and not based on Multicubes which works perfectly.
Does anyone know if there is any problem in creat Universe based on Query from a Multiprovider?
Thanks,
Wanderly
Hi,
I have a BW Query based in a multiprovider, it has some mandatory variables like 0CALMONTH and it works very well there. But I've created a Universe based on this Query and when I try to use this universe in WEBI or Xcelsius I have some problems, variable baseed on 0CALMONTH shows strange and intelligible values like 09.0077, 06.0000, 05.0014 for the months.
I have other universes based on queries with mandatory variables and not based on Multicubes which works perfectly.
Does anyone know if there is any problem in creat Universe based on Query from a Multiprovider?
Thanks,
Wanderly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In SAP BI, Multiprovider, is a Logical join of tables you can treat it this way a union of two tables, it never stores any data.
The reason you are seeing those wierd values, is because of master data of the Infoobject 0CALMONTH.
I must say, to solve this , put some key figures(Measure in your report), then it will bring the actual data .
This is a known behavior with Queries based out of multiprovider, for which I guess SAP has no solution, the workaround is put some measures in report, let the Query acutually read the base table(Infoproviders) and then it will bring exact values in tables.
Hope it helps.
Deepak
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.