Sitemap

Amicuk Programming Answers

@PRIOR @MDSHIFT

-0001-11-30   Views:23

Advertisement

I need to calculate a Member for FY2012 as follows: FIX("Feb") "Member1" = "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> &

I need to calculate a Member for FY2012 as follows:
FIX("Feb")
"Member1" = "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> "FY11" + "Member2" -> "Oct" -> "FY11" + "Member2" ->"Sep" -> "FY11"
ENDFIX
FIX("Mar")
"Member1" = "Member2" -> "Feb" + "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> "FY11" + "Member2" -> "Oct" -> "FY11"
ENDFIX
..and so forth.
this is a simplified formula but basically i want the formula to go back to previous year as well. using @PRIOR but the rangelist can be either period or Year, while in @MDSHIFT it can be in both current year and previous year.. is there a way I can achieve or have to write these detailed formulas by fixing on each month.
Thank You for your help

The replay answer
Advertisement
Hi,
So basically you just want to calculate the last 5 trailing months ?
To do this I use a variable to calculate the index of the current Period. Then I use a @SUMRANGE and I defined my starting and ending period based on the index of the current period using @HspNthMbr.

Go to See the other 2 answers

@PRIOR @MDSHIFT

Category:DefaultRelease time:-0001-11-30Views:130

I need to calculate a Member for FY2012 as follows: FIX("Feb") "Member1" = "Member2" -> "Jan" + "Member2" -> "Dec" -> "FY11" + "Member2" -> "Nov" -> &[More]

@MOVAVG,MDSHIFT and PRIOR

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am new to Essbase and looking forward for your help in order to develop the below scenarios. First one I need an essbase function that calculates the average of the last three months. so if i am in Apr the value would be the average of JAN,FEB[More]

@MDSHIFT

Category:DefaultRelease time:2015-10-11Views:130

I am writing a calc script for Hyperion Planning 11.1.1.2 that will calculate new maintenance revenue for 15 months based on on accumulation of license revenue with a 60 day delay. A simple example is: Year 1 Jan = 0 Feb = 0 Mar = Jan * rate Apr = Ja[More]

Problem with a calc involving @MDSHIFT and Dynamic Calc

Category:DefaultRelease time:2015-10-11Views:130

Hi all, I have a problem with the calculation of a member in a calc script. The formula of this member is : "R70100" IF(@ISMBR("M01")) ("T_008"->"Cumul"->"HT"+"T_003"->"Cumul"-[More]

Ending Inventory / Balnce using @Prior

Category:DefaultRelease time:-0001-11-30Views:130

On 9.3.1 and my time dimension spans two dimensions (Periods and years). Measures in outline: Inventory (LabelOnly) ----OpeningInventory (store) ----Additions (store) ----Sales (store) ----EndingInventory (store) Years (labelOnly) ----2010 ----2011 -[More]

Error using @MDShift Function

Category:DefaultRelease time:-0001-11-30Views:130

I'm trying to create a calc script that will move the prior month's ending balance into the current month's beginning balance. After looking through the technical reference guide, I thought using the @MDshift function would be my best option. My calc[More]

MDSHIFT help

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have below formula, and understand it partly. If the Year member is 'Actuals13' then 'Tot_Sales' is back 1 member in the 'FiscalYear' dim..... Then it get's fuzzy with the remainder... How exactly would I explain this in layman's terms? IF(@ISM[More]

@MDSHIFT for future

Category:DefaultRelease time:-0001-11-30Views:130

i've been successful in using @MDSHIFT fwhen going backwards in the "Years" dimension, but i can not get it to go forward to the next year in the year dimension. i've read the doc and it says it's similar to PRIOR but, doesn't really say for nex[More]

How to get NEXT/PRIOR member's name (Hyperion Planning)

Category:DefaultRelease time:-0001-11-30Views:130

Hello! How can I get the name of the member prior or next to current or even mdshifted? The main task is calculate the sum of the 12 month starting from the next. Something like this: @SUMRANGE(MbrName, @XRANGE (@CURRMBR(Period), Dec)) + @SUMRANGE(Mb[More]

@PRIOR unexpected behavior

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a BR with the following calculation: FIX( ..., "Jan":"Dec", ... ) "CMR031"( IF(@ISMBR("Jan")) "CMR031"="CMR034"->"Dec"->&PrevYear; ELSEIF(@ISMBR("Feb":&qu[More]

Averaging an member of a range list of prior year

Category:DefaultRelease time:-0001-11-30Views:130

Hi our requirement is : Account1-> Budget = Avg of Account1 of prior year from Jun to Mar ->Actual+ Avg of Account1 of prior to prior year for Apr & May->Actual I tried with @Avgrange & @ Prior but without success. Can anyone provide a so[More]

Hot
I hope someone can help with this problem. The start of these messages is at the bottom. Any suggestions would be most welcome...Bill Allen Hi David (00)... Thanks for your reply. I just wanted to let you know that I am going to post all of this corr [More]
We recently moved to 6i R2 non-versioned from 2.1.2. We have several projects that use the repository for development in various business areas of the agency. We have 100+ application containers and only 5 active projects at this time. Many of the co [More]
I have two problems that appeared in Elemens 8.0 and Adobe Brigde CS4 recently.  I'm using the Mac version and a Macbook Pro (4 months old). I don't really know where to address the problem, but I hope someone in this forum would be able to advice me [More]
good day everyone, i am puzzled by this weired question and couldn't find similar post on the forum. A user is using acrobat 8 to convert excel to pdf. The excel sheet is set to landscape and everything look fine under print preview. However, after u [More]
How can we add a new developper person in oracle designer 6i to an existing system?The SCM (Repository) Install Guide on OTN (http://otn.oracle.com/docs/products/designer/content.html) has details on how to setup new users for your existing system. T [More]
Hello I'm trying to load a master data infoobject with a flat file and getting errors. The infoobject ZCOLLECT_DATE has two fields - ZQUARTER and ZCOLLECTDATE ZCOLLECT_DATE is of Data type NUMC, Length 5, conversion routine PERI5 and Output length 6 [More]
I have having trouble opening or playing anything in the CD/DVD player. I am getting the messages either: D: application not found, or D: is not accessible. The request could not be performed because of an I/O device error. Please helpHi, Sounds like [More]
Depending on your typing style, you may need to change how you type for this keyboard to work properly. For example, many people type quickly and simply press keys on the edge rather than in the middle or top. For this reason, some keyboards have a l [More]
Hi Folks, When printing an email from Eudora, nice headers & footers are added containing the name of the person printing, as well as the date it was printed, and to whom the printed email was from. Can headers & footers be added to print jobs fro [More]
Photoshop Elements 7 will not open.  Indicates an error message upon trying to open application in Windows Vista.Can you try some of teh trubleshooting steps at this link http://www.johnrellis.com/psedbtool/photoshop-elements-faq.htm. Also try this o [More]