Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datacopy to multiple years from the current year in Planning

KrishnaSandeepMar 14 2016 — edited Mar 18 2016

Hello All,

I have a set of Balance accounts and I want to to copy the December YTD values of these accounts to the BegBalance of all years till FY50. Since Year dimension is Sparse i am facing block creation issues. I tried the createblock function @CREATEBLOCK(@RELATIVE("Years",0)); and then tried to fix on all the years that have a UDA tagged as "FutureYear" and within the fix i tried assigning a value to BegBalance from &Curr_Year->"DEC YTD";

But this is not working.

I cant use datacopy because the number of target blocks is more than the number of my source blocks. I don't want to write multiple datacopy commands either(one for each future year).

Is there a way i can loop a single Datacopy command in such a way that in each loop it copies data from current year december YTD to future years one by one?

Thanks

Regards,

Krishna

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2016

Added on Mar 14 2016

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

3 comments

1,371 views