Variable row member descriptions

[richard_steffer]

Greeting experts,

Does anyone know how I can get an EPM V10 report to show member id and description on row headers for base member accounts and only the description for calculated hierarchy members?  An example of my row header is included below.  Any help is appreciated!!

6100 - Salary Adjustment

6101 - Exempt Regular Salaries

Salaries - Salaries

6109 - Incentive

Other_Compensation - Other Compensation

6201 - Benefits

6250 - Employee Recognition, Service, and Other

Other_Benefits - Other Benefits & Payroll Taxes

Salaries_Benefits - Salaries & Benefits

[Shrikant_Jadhav · Accepted solution]

Hi Richard,

Create two local member in column axis, in first member write formula to fined out whether member is calculated or not. In second local member write "IF" condition like if member is calculated put description else ID & description. Hied the actual row axis and first local member.

Shrikant

[richard_steffer]

Thank you Shrikant and Andy. Appreciate your help.

[Shrikant_Jadhav]

You are welcome Richard !

Kindly close the thread if you query is resolved .

How to close a discussion and why

Shrikant

[Former Member]

Hi Richard,

in an empty column next to the row expansion you can use formula to determine what to display, then just hide the row expansion column.

you can use combination of EPMMemberProperty to determine the nodes, then use EPMMemberDesc and EPMMemberID to archive your requirement.

Andy