Filter rows axis dimension with page axis dimensions

[Former Member]

Hi Experts

I’m making a new report with EPM10 Excel Addin

My requeriment is:

I have one filter called Family Dimension, then I have rows with Product Dimension.

I would to see if I choose Family 1, my rows would be BASELEVEL(products) of family 1. If I choose family 2, BASELEVEL(products) of family2...

How can I achieve this??

  Thanks!!

[former_member210696 · Accepted solution]

Hi alex,

You can make use of function EPMDimensionOverride to override your row axis. You can build the required dimension members elsewhere in your report based on user selection of Family Dimension.

Try searching for EPMDImensionOverride and you will get many threads.

http://scn.sap.com/thread/3179311

http://scn.sap.com/thread/3432844

Regards,

Ashish

[former_member210696 · Accepted solution]

Just to add, you would need something like below -

=EPMDimensionOverride("000","Product","CALC=N AND Family="&A1)

where 000 is report ID (default in this case)

Calc=N to fetch base members

A1 is the cell where users can select the family (family1 or 2, etc.)

Assumption - Family is a property name in product dimension with valid members maintained as family1, etc.

Regards,

Ashish

[former_member186338]

Hi Alex,

Your requirements are not clear. What dimensions you are talking about? What dimension do you have on page axis and what - on row axis?

Vadim

[Former Member]

Hello!

Ok!

I have one dimension called Family in page axis and different dimension called products in row axis.

I would like to show BASE LEVEL Products depends of member of family dimensions.

[former_member186338]

Depends - how???

What is the relation between FAMILY and PRODUCT dimensions?

Vadim

[Former Member]

I have a property name in product dimension for each product like

ID----NAME----FamilyProperty

0001--Product1---Family1

0002-Product2----Family1

0003--Product3---Family2

0004-Product4----Family3

0005--Product5---Family4

0006-Product6----Family4

Which is the formula that I have to apply in row axis?? EPMDimensionOverride?

Thanks!

[former_member186338]

In this case Ashish proposal

is correct.

Vadim

[N1kh1l]

This message was moderated.

[former_member210696]

Nikhil,

Just wondering what value addition your above post does over my post?

Posting same thing again just for the sake of posting something?

Regards,

Ashish

[Former Member]

Hi experts! I think that is a good option but I have an error using EPMDimensionOverride.

My formula is:

EPMDimensionOverride("000";"CUSTOMERGRP";"ID='GC_25' AND CALC='N'")

I would like to filter by ID AND CALC=N but I have an error using previous formula?

In my report I would like to see:

First Group GC_25 and second all members base level of this group.

Any help??

Thanks!

[former_member186338]

Hi Alex,

You formula looks strange: you select only one (parent?) member ID='GC_25' from CUSTOMERGRP and want to have some base members???

You have to use property of Product dimension...

Vadim

[Former Member]

GC_25 is a parent, correct. And I think that my property is ID. Is correct using ID Property for this function?

[former_member210696]

Alex,

ID is not a property as such. It's the actual dimension member ( the master data), your property must be Family as you said in your previous post.

Just try with below formula once -

=EPMDimensionOverride("000","Product","CALC=N AND Family=GC_25")

provided Family is a property maintained in product dimension whose value is maintained as GC_25.

Above statement means that Product dimension would expand on all base level members where property family is maintained as GC_25.

For dynamic expansion based on property being fetched from a different cell, look at my earlier post.

Regards,

Ashish

[former_member186338]

You select with AND 2 conditions:

ID='GC_25' - single parent member

CALC='N' - base members

Result - NOTHING

[former_member186338]

Well, in this case ID can be treated as property, but the rest is correct

[former_member210696]

I know, that's why I reframed the statement - 'ID can't be a property' to 'ID is not a property as such'