EPMDimensionOverride with Parentafter

[Former Member]

Hello, I'm having an issue using EPMDimensionOverride.  We are using BPC10 MS.  My formula is as follows:

= EPMDimensionOverride("000","Account","all(assets);acc_level=GAAP_Node,parentafter")

My report is pulling from the account dimension in the row key range.  The column does not expand, only the row will need to.  I want the result to pull all the dimension members that fall under the "Assets" hierarchy that have the property "acc_level=GAAP_Node" but I want it to show me the parent member after the applicable GAAP_Node.  The parent member (i.e. Cash_and_cash_equiv) does not have the same acc_level.

Here is a sample screen shot of our hierarchy:

Essentially, I would like my report to show:

I cannot get the parentafter to pull in at all.  I've searched SNC and have seen other examples but they have not worked for my report.  I have even tried taking the property level out and just putting =EPMDimensionOverride("000","account","all(assets),parentafter") and that is not pulling the parent either.   Any help would be appreciated.  Thanks.

[jrg_finster3]

Hi

i just tested with:

ALL(ALLEGEBAEUDE) and TERMINAL = N, PARENTAFTER

Works fine for me. What EPM SP are you using?

And as DiAn said, the property must be set for the Parent nodes also...that should be clear

Regards

Jörg

[Former Member]

We are on SP25

I cannot use the Report Editor because my row key range is dynamic based on user selections, hence, why I am using the EPMDimensionOverride functionality.

My property value for the parent is not the same as the bas members.  So you are saying that it is impossible in BPC10 to utilize parentafter if that's the case?

If I were to add the property of the parent, how would I get that to display where I want it to.  For example, if I added the property of that parent, I would not want all members with that property to show on the report together (because there would be more than one member with that property value), I would want it to display as the parent, after the applicable children of that parent as shown in my screen shot above.

I did realize that might be an issue, having a different property for the parent, however, this functionality worked just fine in BPC 7.5 and gave me the results I wanted.

[Former Member]

I suggest you try adding the property to cash and equiv and test.  I think it may just work for you...let us know!

[Former Member]

If the parents (e.g. cash and cash equivalents, etc) are not tagged as "GAAP_Node" then they will be filtered out and hence not show on report. 

Is there a reason why you need to build your report using this method?  Have you tried creating it using the EPM report builder?