two account ID in the same rows

[michele_medaglia5]

Hi Bpc Friend

I have a report quite complex.

For a section of this report, the user doesn't want anymore to separate the Total Operating expenses and the shared service total but would like to have row by row the sum of both by category.

How can I have in the same row both?

Thanks

[former_member186338]

Sorry but not clear...

Please provide the sample of the required report

[michele_medaglia5]

Hi Vadim

I would like to have in the first row that you can see in the screen shot above Total Opex 3+ Shared Service Cost (a quote of 9) because the second column is the category Total Editorial and Production Cost Category, something like creating in the report a new account that is the sum of Total Opex + Shared Service

[former_member186338]

You will have to create the new parent of Total Opex and Shared Service

May be in the new hierarchy...

[michele_medaglia5]

I thought was possible to do something smarter.

Is there any EPM formula to do that or local member?

[former_member186338]

Common parent is a smart and recommended method!

Not smart:

- Use EPMRetrieveData in some local member to get the value of second member - slow!

- Separate report with Total Opex and Shared Service in page axis - also slow

[michele_medaglia5]

thanks Vadim

The finance boss doesn't want to create a new parent in the account dimension

Which alternative solution do you recommend to me?

[former_member186338]

"The finance boss doesn't want to create a new parent in the account dimension" it's you job to explain him that this is the only correct way! You may create the second hierarchy in account dimension to have this parent.

You can also create a member with dimension member formula to sum Total Opex and Shared Service and use it in the report instead of hierarchy parent. Not perfect but will work.

[michele_medaglia5]

I will create a dimension member formula

Thanks

Michele

[former_member186338]

But the answer is not accepted!

[michele_medaglia5]

Hi Vadim

What do you mean?

what is the benefit to create a new parent instead of a dimension member formula?

[former_member186338]

Member formulas will slow down the report, hierarchy parent is much faster! For only few members with member formulas the result may be still acceptable.