Locam Member Dynamic Description based on variable excel cells

[Former Member]

Hi All,

I am looking for any solution, where the Description of Local Member changes dynamically.

I know we can have one dynamic local member description based on single variable cell reference( as shown in EPM Academy videos).

My scenario is I have Row A with Segment, Row B  as Product. For Difference Segments by Products like can be same or different.

In Column A I have Time and Column B I have Account.

To get repletion of Column of Columns headers, I have created Column A and Column B as Local members.

I want description of Column A which is having Local member relating to Time, description of Segment.

Here is the screenshot of my Report.

I have tried creating another local member based on Row formula, it works fine but Formatting is wrong? I have 35 Segments, so I want to use EPM Formatting feature than excel formatting by cell.

How to change the formatting to get the first report like format for the new Local Member(New Desc in the above screenshot)?

Thanks

[former_member186338 · Accepted solution]

Sorry, I am unable to understand the report structure... Please show all local member formulas and the final result to be achieved...

[Former Member · Accepted solution]

Hi Vadim,

Here is the report and local members:

I have created 2 Local members Product Group and Time.

But I want Description of Time Local member name to be equal to cell containing Market segment i.e Wholesale in first part of report and Retail in second part of the report.

Like this

Local member 1: Product_Group

Local Member 2: Time, in tis dimension I want Description field to be dynamic and based in EPMOLAPMEMBER of MAR_SEC.

I am expecting Dynamic description of local members based in EPMOlapmember.

As second alternative I have created another Local member in Column with if condition and below is the report.

Sales Report:

But the formatting should be Blue colour and not the gren colour.

Green colur is copied because it is value filed of Local member.

How to change the Green colour of Columns with description WholeSale and ProductGroup is my doubt.  Here is the screen shot of EPM formatting I am using.

Thanks.

[former_member186338 · Accepted solution]

"But the formatting should be Blue colour and not the gren colour." - Please format manually and present the final expected result!

[Former Member · Accepted solution]

Hi Vadim,

Here are the final formated result required.

This is the final report for User( Group the first 2 columns).

[former_member186338 · Accepted solution]

You simply don't need the extra local member - just play with description of TIME local member (in my sample LM002):

The formula "&INDIRECT("A"&ROW())&" - will get the value from the current line in column A.

Then format local members (LM001 - PRODUCT GROUP, LM002 - TIME, LM003 - TOTAL SALES):

Result:

Hide column A

Vadim

[Former Member · Accepted solution]

Wow Vadim, your solution is the best.

[former_member186338 · Accepted solution]

By the way, if Wholesale & Retail are member descriptions (not a member ID!) - then you can use documented way to put outer member description in the local member description:

Vadim