Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Using @SUBSTRING in a FIX possible?

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!
Answers
-
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
-
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'.
-
For some reason my pic didn't attach. Here's how I tried to change to @Parent.
-
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
-
So the @Parent can only work within an IF?
-
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);
-
Yep. Issue is I'm AGGREGATING thus need in a FIX.....
-
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
-
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