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