on 12-02-2008 9:44 AM
Hi,
we built a universe on top of a sap bi query with several key figures. When creating a webi query for this universe the original decimal places will not show.
We have tried the following:
- Define the object format of the keyfigure as "#.##0,00" in webi --> the keyfigure gets decimal places, but always "*,00". The orginial decimal places will not be showed.
- Define the object format in universe --> same problem as defining the format in webi.
- Take the formatted value of the keyfigure --> decimal places will show correct, but we cannot make a sum of all rows. This is because the formatted value is a dimension, not a measure.
- Save the formatted keyfigure value as a mesaure --> measure cannot be showed in webi Error: "#Datatype"
For example:
KF original 123,45
KF from universe 123
KF formatted 123,00
formatted KF 123,45 EUR
formatted KF as measure #Datatype
Is there any solution to show the correct keyfigure values from sap bi in universe included all decimal places???
We would be very glad if anyone can give us a solution or a hint how we get the decimal places!
Thanks
Claudia
P.S. we use BO XI 3.0
Edited by: Claudia Liebl on Dec 2, 2008 10:44 AM
Hi Claudia,
It normally should work.
We are aware of similar cases, but we are not sure if it is the same.
So I suggest you to enter a case to the support.
Didier
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
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.