Sitemap

Amicuk Programming Answers

@PRIOR @MDSHIFT

-0001-11-30   Views:24

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 cant seem to find a thread to answer this question. I have have one I mac, both my wife and I have a user account each, we both have our own apple ID's is there away they can be used at the same time? As so far I can't find a way of doing this. It [More]
EP6.0 offers a nice tool to <b>upload roles</b> together with the <b>user mapping</b> from an R/3 backend system to the portal. This works very well, but in an environment where the user mapping happens on the backend system this & [More]
Is it possible to create a new JDBC (JNDI) connection at runtime using the propertyBag to set the attributes?  I tried this but received error message stating "error finding jndi name".Are you specifying a JDBC or JNDI connection? If JDBC, did y [More]
No DSL and satellite. seems to have a lot of problems, so we're on Alltel internet, a tethered Razr used to dial in. Alltel (I mean...now Verison, so the store looks now) re-installed my softwear on the Razr and I have EV back (PRL is 300xx). Speeds [More]
From YouTube I downloaded the Mozart opera "Cosi Fan Tutti" as an MPEG4. The resulting video image is nice and clear with good sound, but it is larger than my screen. The usual video controls such as play, pause, etc are below the bottom horizon [More]
I am having trouble figuring out what to do with this else statement error.........I can't seem to see where I am going wrong...............can anyone help? I can compile it but I just keep getting this one error I can't fix..................... Prog [More]
I also want to down grade to IOS 5IOS downgrading is not support by apple. How ever if your device isnt being recongized by itunes try these steps -using a different usb port -restarting the computer and the device -use a different cord -update itune [More]
Apple has disable my AppStore account and I need it back URGENTLY. I have sent several message to Apple support but I havent get any answers. What can I do?Go here - http://www.apple.com/support/mac/app-store/  - or - http://www.apple.com/support/itu [More]
I use Jboss's datapool to realize the connection to Sybase Database.And after connected to the database I wrote "con.setAutoCommit(false)" then the error occured. The error is "java.sql.SQLException: JZ0SJ: Metadata accessor information was [More]
using Iphoto 11 I can see on my mac my photos in alphabetical order, not on my Iphone 3GS. have you got any suggest?Data Recovery – Best Data Recovery – Disk Drill Data Recovery – Data Rescue Data Recovery – File Salvage Data Recovery – Stellar Phoen [More]