This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Re: Tip/Trick to copy data in Period Dimension

January 12 2017 at 4:04 PM
No score for this post
Anonymous 
from IP address 199.229.224.3


Response to Tip/Trick to copy data in Period Dimension

If you want to calculate and store result you can do something like this:

FIX(Day02:Day365)
WeekDay(
IF(@COUNT(Periods,@CURRMBRRANGE(Periods,LEV,0,,0))-@COUNT(Periods,@CURRMBRRANGE(Periods,LEV,0,,-1)) < 7)
IF(@PRIOR(WeekDay)+1 >7)
WeekDay=1;
ELSE
WeekDay=(@PRIOR(WeekDay)+1;
ENDIF;
ENDIF;
)
ENDFIX;

In order to do that as dynamic calc member then you need to create WeekDay_inout member to store value for Day01 and create dynamic calc member WeekDay with this formula:

IF(@ISMBR(Day01))
WeekDay=WeekDay_input
ELSE
IF(@COUNT(Periods,@CURRMBRRANGE(Periods,LEV,0,,0))-@COUNT(Periods,@CURRMBRRANGE(Periods,LEV,0,,-1)) < 7)
IF(@PRIOR(WeekDay)+1 >7)
WeekDay=1;
ELSE
WeekDay=(@PRIOR(WeekDay)+1;
ENDIF;
ENDIF;
ENDIF;

Regards,
Yuri

 
Scoring disabled. You must be logged in to score posts.Respond to this message   

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.