Using @SUBSTRING in a FIX possible?

3921866

My outline is in red to the right.   My Fix is in Green to left.  My PBCS Calc Mgr Log is below.

The rule validates.  But when it runs, it doesn't just AGG 'FY20' and 'Apr'.  It's aggregating the entire years and periods.

Can I derive just the 'Apr' and the 'FY20' from my outline members into a FIX?  I'm stumped and no idea at this point.  Can't seem to find any help.

Thanks for reading and any assistance!

amith.madisetty

Hey

I think you already asked the question in Customer Connect.

Below is the solution for your problem

As document states "EndPosition : Optional. An integer greater than or equal to 1, where 1 corresponds to the first character in String, 2 corresponds to the second character, and so on. If EndPosition is not specified or is less than StartPosition, Essbase returns all remaining characters from the source string. Note that this is a different numbering scheme that the start position uses."

@Member(@Substring(@Name("POVApr"),3,6))

@Member(@Substring(@Name("POVFY20"),3,7))

or

Am sure below would work, i need to test if above works,

@Member(@Substring(@Name("POVApr"),3))

@Member(@Substring(@Name("POVFY20"),3))

Cheers

Amith

3921866

Amith,

Yes this works:

@Member(@Substring(@Name("POVApr"),3))

@Member(@Substring(@Name("POVFY20"),3))

However now I need to substitute "POVApr" with:   Parent of 'POVMo'.  I had to switch outline a bit as it has to be Parent as that always can only return a single member.

Tried this: 

@Member(@Substring(@Name(@Parent(POVMo)),9 ))

But get 'Invalid Object Type' error.

Is this possible, that way it can be dynamic as the parent 'POVLoadMoApr' will always be dynamic and have a single child named 'POVMo'.

3921866

So the @CHILD validates for some reason but it shouldn't because what if parent has more than one child.  So I changed to @Parent and thought, this will work....   Nope:  Invalid Object Type

3921866

For some reason my pic didn't attach.  Here's how I tried to change to @Parent.

amith.madisetty

I dont think you can use Parent function in fix statement.

If you can share the complete code or code block, we can help with some way to get it working.

Cheers

3921866

So the @Parent can only work within an IF?

amith.madisetty

Yes, document states

• You cannot use the @PARENT function in a FIX statement.
• You can use the @PARENT function on both the left and right sides of a formula. If you use this function on the left side of a formula in a calculation script, associate it with a member. For example:

  Sales(@PARENT(Product) = 5;);

In some cases, the @PARENT function is equivalent to the @PARENTVAL function, except in terms of calculation performance. For example, the following two formulas are equivalent:

Sales = @PARENT(Profit); 
Sales = @PARENTVAL(Profit);

• The time required for retrieval and calculation may be significantly longer if this function is in a formula attached to a member tagged as Dynamic Calc or Dynamic Calc and Store.
• If you are using the @PARENT function within @XREF, the @XREF function requires the @NAME function to be used around @PARENT. For example:

  COGS=@XREF(Sample, @NAME(@PARENT(Product)),Sales);

3921866

Yep. Issue is I'm AGGREGATING thus need in a FIX.....

amith.madisetty

I still dont get that why aggregate only against a parent node, if your hierarchies are not too big, you can fix children of stats.

Cheers

3921866

Hi,

Does this help?

I'm not aggregating against parent node per se.   I need to get the 3 char month from the parent node as that will change every month.  Depending on what month it is, the parent node can be:

POVLoadMoApr

POVLoadMoMay

POVLoadMoJun

Then my AGG script can be dynamic without EPM Automate or SubVars.  All withing Data Management in PBCS without users updating SubVars.

So in below the 'Apr' and 'FY20' will be dynamic based on the parent value which will be created dynamically every month in Data Management.......

Fix ("Apr" , "FY20" , ..........)

AGG ("Entity" , "Function" et....);

Endfix