cancel
Showing results for 
Search instead for 
Did you mean: 

EPM Local Member in between rows

sap_user62
Active Participant
0 Kudos

Hi Friends,

Env -EPM 10.1

I have built a local connection to a BW cube to fetch data to a tab in a EPM report.

I need GL Account hierarchy, Profit Center hierarchy in Rows and Audit Trail in columns. The rows need to be dynamic for the users to expand and collapse.

In local connection, I see that we can select only the description or the ID for any dimension, we do not have the option to select both ID and description. The users want to see both the ID and description in one or in separate columns.

I have known that you could not insert local members nested in between 2 rows.

We can create local members both for ID as well as description, but the local members are not dynamic anymore, you cannot double click to expand

     

Rows                                                                  column  

                                                                      Audit Trail

GL Account ID GL Account Desc Profit Center

Thanks for your time.

Ed.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Yes, this is the limitation, you can't click on local member!

sap_user62
Active Participant
0 Kudos

Thanks Vadim for your reply.

Is there any alternative to get the results needed.

Ed.

former_member186338
Active Contributor
0 Kudos

As far as I know - no!

Theoretically you can create some sophisticated vba code that will intercept dowble click on local member ad perform double click on the member itself... But I don't like this idea.