Epmdimensionoverride using property selection

[former_member196865]

Hi,

I am creating a report by overriding a dimension by the property department.

=epmdimensionoverride("000","employee","department="&c2)

In C2 we have the department number.

The report works fine, but can we see the total by department only rather than the base members?

For example:

What we see

                                                            Year 1 Year 2

Employee(Department):

Emp1

Emp2

Emp3

What I want is

                                                            Year 1 Year 2

Employee(Department):

[former_member186338 · Accepted solution]

Please provide additional info: do you have department as another dimension or it's just a property?

What is the structure of your employee dimension?

You can't aggregate by property!

Vadim

[former_member196865 · Accepted solution]

Hi Vadim,

Thanks for the reply. Department is a property of the dimension Employee. Is there any other way we can aggregate it?

[former_member186338 · Accepted solution]

No way!

You can aggregate using local member on the report level, but individual employees will be shown in this case!

Vadim

[former_member196865 · Accepted solution]

Ok Thanks.

What if I move the Employee dimension to the Page Axis?

Can I override the page axis selection with the dimension property?

[former_member186338 · Accepted solution]

You can't use EPMDimensionOverride for page axis ! No way!

Only if you manually select multiple members for page axis (first - enable multimember selection) - you will get a single line... But it's not what you want.

Vadim

[former_member196865 · Accepted solution]

Gah...

I think unless I use member sorting and grouping I cannot aggregate the totals-but it still displays each and every member.

Thanks anyway.

[former_member186338 · Accepted solution]

Yes, you can use local member etc... but you CAN'T aggregate on PROPERTY! My first reply!