on 06-15-2011 7:11 AM
Hi All,
My BO Universe is based on BW BEx Query which is built on top of Cube.
0EMPLOYEE having the attribute as Annual Salary when OLAP Universe is generated the datatype is changed to "detail" even though it is a keyfigure in BW side.
Please suggest what needs to be done to fetch this as a measure in BO side. As there is a requirment for total salary to be computed.
Thanks,
Vijay
Hi,
First check in the universe Annual Salary is coming in the class in Key Figures class or not.Key Figures usually come in the Key Figures class with sub class and measure objects.
if you object is detail then you can change in the object properties tab but ensure data type is number for that object.
Thanks,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Due to INR in the column value so this is not the number and it will through an error when you trying to convert as number.
Is it possible to to separate currency from the annual salary objects in the BEx query.if yes then do on the BEx level and and update the object in the universe.
Thanks,
Amit
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.