on 10-02-2006 5:37 PM
Hello Gurus,
I have a field in the cube called AMOUNT. It is plan or actual value based on a field called VERSION in the ODS.
Can you please tell me how to display two columns in the report (Acutal and Plan columns) from one field called AMOUNT in the cube, based on the VERSION field value in ODS.
Your responses are highly appreciated,
Thanks,
Regards,
aarthi
aarthi.sap@gmail.com
Hi,
You need to create two restricted key figures. In each put version filtered with corresponding values (actual and plan) and also put the amount key figure.
Hope this helps.
Regards,
Diego
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Diego,
I dont have version field in the Cube. It is available only in the ODS. So, how to filter based on VERSION.
Hi Oscar,
Is there any way I can access the VERSION value from ODS in the report.
Thanks
Regards,
aarthi
aarthi.sap@gmail.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can do a multicube with the cube and ODS, then you will see version in query definition, but it is no relationed with the amount.
You are loading cube from ODS, right? I think amount in cube is result of summing actual and plan and because of that you want to split it, but in aggragation you have lost this split.
the best solution is to add a new dimension to cube with version char, then you will have splited the amount into actual and plan.
You should add version to your cube too, else how you identify which value is actual and which one plan? which is the relationship between amount in cube and version in ods?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
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.