Skip to Content
0
Former Member
Aug 02, 2016 at 07:30 AM

Issue while expanding Hierarchy - EPM Formatting not reflecting in rows

207 Views

Hello Experts,

In my report, structure as below -

when I double click on Org hierarchy D000CT120202 with the intention of expanding it to see its immediate descendants, the hierarchy doesn't expand. Rather it expands to show the EPMOLAPMEMBERO formula.

This is the case for only this Member and not the others. We noticed that this issue started occurring after adding the Order % and Sales % Local members in the report.

The Order % and Sales % are Local members that have been enabled and added against the members O. Profit and S. Profit respectively.

If we disable these two Local members then the above mentioned issue doesn't occur. Because of this same problem, the EPMFormatting on the members also get affected.

Order % = O. Profit/Order - The Percentage calculation is done by EPMFormatting

Sales % = S. Profit/Sales - The Percentage calculation is done by EPMFormatting


Kindly advise how we can overcome this issue.

Regards,

Sachin

Attachments

report.JPG (82.9 kB)