Dimension expansion based on Local Member Posible?

[former_member182305]

Hello Gurus,

I am doing payroll, and the request is to budget by job position. I have in rows, Job Position, Building and Cost Center. My Cost Center depends on my Company Code, wich is selected on the Context, the Building wich is expand in rows and the position which also is expand in rows.

The Cost Center is  composed=  Company Code  + Building  + job Position.

I create a Local Member to concatenate those dimensions, I pretend to override the Cost Center expanded by row for the Local Member calculated by Row.

I wonder if it is possible.

I don't set an attribute to the Position named Cost Center because it may change when I change the building to budget.

As you can see in the image, the Job Position change. In this case Im planning for building JXIR but the building can be selected in context. LCECO is my Local Member where I want to set as Cost Center. I used epmdimensionoverride in the column where is say OverCeco. But it doesn't work.

how could I make Dynamic the cost Center if i have to Plan by Job Position.

Any idea?

Best Regards.

[former_member186338 · Accepted solution]

epmdimensionoverride will not work in the local member

Unfortunately you can't combine id's of 3 dimensions and use it as id of another dimension in rows. No way!

Vadim

[former_member186338 · Accepted solution]

The only thing you can do (and it will be slow) - you can override content of data cells (in the formatting sheet) with formula:

=EPMRetrieveData(...)

where you can concatenate id!

[former_member182305 · Accepted solution]

Even if the Dimension CECO has that ID??

Regards

[former_member186338 · Accepted solution]

"Even if the Dimension CECO has that ID??" - and what?

In EPM report lines you can only link one dimension id with the property of another dimension. No other options!

And epmdimensionoverride affects the whole report and can be only one.

Vadim