Hi All,
I have a requirement like this...........
Cube 0CCA_11(Costs & Allocatons) queries contain----- Actual cost and plan cost.
Cube 0CCA_2(Costs & Allocations - by activity type) queries contain------Actal activity qauntity and plan activity quantity.
Now I need a query which conains fileds like
field1 = ACTUAL COST/ACTUAL ACTIVITY QUANTITY.
field2 = PLAN COST/PLAN ACTIVITY QUANTITY.
Is there any query satisfying these requirements???????
If not, How to build it???? if it can be possible with multiporvider, please send me the step by step peocedure to build it........
I deadly require the solution for this problem as soon as possible.........
Plzzzzzz Help me........I will assign points........
Thanks,
Kamal.
Hi
in your 0cca_c11 there is a field called 'activity type of partner cost center'
i hope it can solve your problem..you may don't need to go for the second one..
If it not satisfies your requirement,you have to go for multi provider..
1) create multi provider(right click on infoarea) and select the required tw cubes..
select the characterstics and key figures required and time chars required activate it..when you selecting characterstics,just drag and drop into the required dimensions..you can create dimensions by right click on dimensions folder..
Hope it helps,
If you need further information,please come back
Thanks
Teja
Add a comment