on 10-15-2014 1:06 PM
Hi Experts,
I created 1 Actual's cube (Ex: ZIC_A) and 1 for Plan (Ex: ZIC_P) and put these two into one MP, and build Agg level on MP, filter, planning function and planning sequence.
I am trying to copy 2014 data to 2015, but while executing my Planning sequence it is saying 4 records read, 0 generated, 0 changed, 0 deleted.
can any one please help me, where i did wrong in this scenario?
In Aggregation Level i took all char and Key figures
In Filter - i didn't select any thing
Planning Function - selected from values - Year as 2014 and Data Target as ZIC_A TO values are year 2015 and Data Target AIC_P.
Planning Sequence - selected above all and executed manually.
Thanks
Venkat
Hi,
Filter should has a target restriction: YEAR is 2015
Planning function: FROM is 2014 TO is 2015
BR,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkat,
Try giving Planning Filter as below
InfoProvider = ZIC_A & ZIC_P
Year = 2014 & 2015
Hope it will solve the issue.
Regards,
Gopi R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Venkat,
You can achieve the same either by using Standard Copy Planning Function or By using the Code.
where you have to follow the below steps:
1) Chosse Fields to be Changed so that it can be avialabkle in the Operands
2) Declare the Fields.
3) in FOREACH maintain your need ones.
then read the data from the source and keep it in the Local variable
ex : zkf = {Skf,info1,info2,info3,sourcecube,-------}.
{Tkf,info1,info2,info3,targetcube,-----} = zkf.
ENDFOR.
Hope this will help you to achieve your Requirement.
Regards,
PJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Venkat,
did you use standard copy function?
are there any more char that are used in actual cube but not in planning cube - or the other way?
are there any more time char in your aggregation level?
the 4 data records that are read - are they from 2014?
regards
Cornelia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
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.