Can we uplaod Actuals and planned data into one infocube, plz clear me it is urgent.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My scenario like this, My transaction data is comming from sales and my budget data is available in flatfile, these two data i want to uplaod into only one cube. plz correct me.
Plz suggest me, how to uplaod these data into system, plz give me some procedure to understanding and how i can uplaod this data.
0VTYPE, and 0VERSION will distingish between the plan and actuals into the same cube while loading and designing queries.
For Example : In your query if you want to display the data for actuals you need to restrict your chars with value type 10, and for plan value type 20. create a seperate column in your report for plan and actuals with above restriction you will be able to see the plan and actuals.
Yes. U can Load the Actuals and Planned data to the same Cube.
Yess, We can load plan and actual data in one cube and even SEM also we can change the plan cube(transactional cube) to non-transactional cube and load the Actual values into the cube. Hope it helps.