Using a dropdown to select the Dimension of a column in a report

[former_member409271]

Hi Experts

I am building a report on BPC 10.1

What I would like do is set my column/row dimensions using a drop down chosen by a user. So for example, A user will select from a drop down the column dimension and from another drop the row dimension, thereafter refreshes the sheet and the data will populate.

I know using EPMDimensionOveride you can override the member or members from the column/row, what I want is to change the whole dimension not just its members within.

This was a extremely simple task in BPC 7.x where you would just say Column axis equals to dimension in dropdown.

Thanks

Regards

Aadil

[Former Member · Accepted solution]

Hi,

In BPC 10 I would simply show users how to replace the dimensions in the report using drag and drop in the report pane on the right hand side of the screen in Excel.

BR,

Arnold

[former_member409271 · Accepted solution]

Hi Arnold

Thanks for the reply.

This is not ideal for us as we have a large users base.

We have a template on 7.x where a user can just choose from the drop down and the template populates. This template is ideal for users to view data that gets populated from source systems. We have a lot of users that do not Use BPC a lot and we want to make using BPC as easy as possible.

Regards

Aadil

[Former Member · Accepted solution]

Hi,

You can develop template based on the user selection. For that you have use some basic excel functionality  and some BPC.

1)List all the Dimension name in cells as shown in fig (Column A)

2) Using that create Drop down list (Column D and F)

3) Use EPM function EPMDimensionPropertyValues bring master data of selected dimension (Column B)

4) Use EPMAxisoverride function to override members once for row axis and second for column axis(A18 and A19)

5) You can hide columns upto C column.

Note: here i have used BAS() in formula.(A21).

Hope This will help you. 

[former_member409271 · Accepted solution]

Hi There

Thanks a lot for this, looks very helpful

I will work on my template using your suggestions.

Thanks again

Aadil

[former_member409271 · Accepted solution]

Hi There

Thanks a lot, EPMAxisOverride worked - exactly what I was looking for.

Regards

Aadil
.