Expand multiple members in a report

[Former Member]

Hi experts,

I have a report with accounts and another dimension (aux dimension) on rows:

This aux dimension has a property that is linked with account.

Each account has one member of aux dimension:

I would like to know if is possible to do a report like if aux dimension has "group" expand account (base level) else not expand.

For example:

Aux Dimension // Account

NONE -- Account1

NONE -- Account2

GROUP-- Account3

NONE -------Account3.1

NONE--------Account3.2

NONE -- Account4

GROUP-- Account5

NONE --------Account5.1

NONE --------Account5.2
NONE --------Account5.3

To get relation between aux dimension and account I use this property doing report:

Any help??

Thanks!

[former_member186338]

Hi Alex,

If you have AUX dimension linked to property AUX_DIM of ACCOUNT dimension in the row axis then you can only play with members of ACCOUNT dimension (EPMDimensionOverride or other...). AUX members will be shown automatically. And you can't expand by AUX dimension.

Vadim

[Former Member]

Ok,

with dimensionoverride could I make following formula?

=EPMDimensionOverride("000";"ACCOUNT";IF(AUX_DIM)<>GROUP; BAS(ACCOUNT);ACCOUNT))

Is possible? Can u help me with syntax?

Thanks

[former_member186338]

To show only GROUP accounts use:

=EPMDimensionOverride("000","ACCOUNT","AUX_DIM=GROUP")

[former_member186338]

Not clear, what do you want to achieve with IF(AUX_DIM)<>GROUP; BAS(ACCOUNT);ACCOUNT)??

Can't help without clear understanding of the desired result...

[Former Member]

I want to show AUX_DIM<>GROUP-->ACCOUNT

AUX_DIM=GROUP--->BAS(ACCOUNT)

Is possible?

Like my first post.

[former_member186338]

Sorry, I am unable to understand what do you mean by "I want to show AUX_DIM<>GROUP-->ACCOUNT

AUX_DIM=GROUP--->BAS(ACCOUNT)"

Please explain from the ACCOUNT point of view...

[former_member186338]

Something like:

I have ACCOUNT dimension with a property AUX_DIM and hierarchy:

A1 - AUX_DIM?

  A1.1 - AUX_DIM?

  A1.2 - AUX_DIM?

    A1.2.1 - AUX_DIM?

    A1.2.1 - AUX_DIM?

  A1.3 - AUX_DIM?

    A1.3.1 - AUX_DIM?

A2 - AUX_DIM?

Base members has - AUX_DIM?

Node members has - AUX_DIM?

What do you want to hide?

[Former Member]

Ok,

I'll explain from point of view account.

I want to show (self)account or bas(account) depending another row dimension (auxdim).

my report has two dimensions on rows: Aux dimension and dimension account.

aux dimension has linked to dimension account by property. For this link I obtain next combination on rows:

Aux Dimension // Account Dimension

NONE -- Account1

NONE -- Account2

GROUP-- Account3

NONE-- Account4.

My requeriment is:

If Aux dimension member is "GROUP" I'll have to show Basmembers of that Account,

Else Selfmember of account

My desired result was:

NONE -- Account1

NONE -- Account2

GROUP-- Account3

NONE -------------->Account3.1

NONE--------------->Account3.2

NONE-- Account4

Please if you need to explain more details tell me.

Thank you very much!

[former_member186338]

Forget about AUX dimension, think about Accounts and AUX_DIM property.

And explain not expanding but what accounts you want to hide.

Please answer questions from my prev. message...

[Former Member]

ok,

I don't want to hide any account, I want to show self(account) when property Auxdim was NONE and show Basmembers(account) when property was GROUP.

Thanks!

[former_member186338]

Ok, there is absolutely no way to expand nodes conditionally - based on property!

That's why I was asking you if you have full list of account members - what do you want to hide.

My description will be:

I do not want to show members having parent (or grand parent) with the property AUX_DIM: NONE

Is it correct?

If correct - unfortunately it's also not possible