Filtering in BPC 10 input form

[inna_maltz2]

I'm creating an input form and can't figure out if there is any way to filter out certain dimension members based on their relationship to another member. My input form consists of Project, Account, Expense type in Rows and Time in columns. Each account only has several expense types that are relevant to it and therefore should not display all the possible expense types in the hierarchy. I know I can enter specific values and keep/exclude others, but as soon as I refresh with another project number, I get all the possible values in Expense Type again.

Example:

What I have:

Project     Account     Expense Type     April  2015

300000     6500010     10                   

300000     6500010     20

300000     6500010     30

300000     6500010     40

300000     6500020     10

300000     6500020     20

300000     6500020     30

300000     6500020     40

What I want:

Project     Account     Expense Type     April  2015

300000     6500010     10                   

300000     6500010     20

300000     6500020     30

300000     6500020     40

[Former Member · Accepted solution]

Hi,

you can use a dimension property to filter elements:

As an example for the above screenshot, have entity and intco in rows. For entity select members in any way, then for intco select as shown above.

This will for each row look at the entity in that row, look for the value of the intco property of that entity and display that element. It's not a very useful example but easy to build and it explains what happens.

BR,
Arnold

[inna_maltz2 · Accepted solution]

That did the trick! Thank you so much.

[former_member186498 · Accepted solution]

Hi Inna,

please don't leave open threads as "not answered" if there are solved, please close these marking the "correct answer" this will help other users with same issue to find quickly a solution.

Read please The SCN Rules of Engagement and How to close a discussion and why

Regards

     Roberto