on 2009 Apr 19 10:50 AM
Hi,
I have a scenario like i have to copy the two planned cubes data one(A cube) is 1year and one(b cube) is 6years data.
and how to copy the data to another planned cube.
Do i need to create the another planned cube(c cube) and create multiprovider and assign the plannng area?
If it is the case what is the steps?
done
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Data modeling depends on the business requirement. Please let us know what data the two cubes hold? Why are you copying? What will be the final use of copied data? Will you use it only for reporting or plan further? Are the cubes structure same?
1) You can create a multiprovider using these two cubes and plan directly. In that case you need not copy the data.
2) You can also create a new VERSION in one of the cube and add the other cube values to it.
3) You can also copy the values of these two cubes into a third cube and plan on it.
regards,
Lokesh Nandula
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Data modeling depends on the business requirement. Please let us know what data the two cubes hold? Why are you copying? What will be the final use of copied data? Will you use it only for reporting or plan further? Are the cubes structure same?
1) You can create a multiprovider using these two cubes and plan directly. In that case you need not copy the data.
2) You can also create a new VERSION in one of the cube and add the other cube values to it.
3) You can also copy the values of these two cubes into a third cube and plan on it.
Hi Lokesh Thanks for your reply.
I would like to copy the data of two infocubes which is planned data to another infocube(3 rd infocube).
3) You can also copy the values of these two cubes into a third cube and plan on it.
I want only to copy the data of cubeA(1 YEAR data)+cube b(6year data)=3RD infocube(in this cube i am not doing any calculations.
I am taking as reference of this cube 3 data for further planning(creating 4th planning cube(this cube is feed from another actual data and cube 3 data.
My question is:
How to copy the data of two infocubes of A and B to C.
Can i create the multiprovider of CUBE A and cube b and cube c(same structure of cube a and cube b) and assign the planning area?
is it possible?
You don't even need two planning cubes where you are planning to copy the data.
You simply need to create three basic planning areas on
1. Cube A
2. Cube B
3. Actual cube
then create multi-planning area on these 3 planning areas and you will be able to access all data of the above three cubes in the planning functions created on multi-planning area.
This will save you from creating two planning cubes and the copy function.
Hi,
If you are completly decided to copy data between infocubes then you have two functional options:
1) Use Formulas FOX (custom code) to copy
2) Use Standard Planning Functions (COPY)
For the first case.. This is an example of custom copy FOX code to accomplish the req.
Suppose FTBCH = {KF, 0FISCYEAR, 0VERSION, 0INFOPROV}
VAR_YEAR: Actual fiscal year from user input.
0INFOPROV: Char reference by multi-planning to indicate source/destination
DATA FISCYEAR TYPE 0FISCYEAR.
DATA VERSION TYPE 0VERSION.
DATA VAR_YEAR TYPE 0FISCYEAR.
VAR_YEAR = VARV('ZVAR_YEAR').
* From 3 years behind and one year for planning horizon
FRMYEAR = TMVL(VAR_FISCYEAR, -3).
TOYEAR = TMVL(VAR_FISCYEAR, 1).
FOREACH FISCYEAR, VERSION.
IF FISCYEAR >= FRMYEAR AND FISCYEAR <= TOYEAR.
{KF_PLAN, FISCYEAR, VERSION, 'PLAN_CUBE'} = {KF_ACTUAL, FISCYEAR, #, 'ACTUAL_CUBE'}
ENDIF.
ENDFOR.
For the second case, actually the copy function is implemented already, just define from where to where you want to copy as well.
Hope this helps.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
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.