Can't do multiple Selection in Row or Column

[former_member182305]

Hello experts,

I write this time because we have a requirement where the customer wants to do multiple selection for columns. We are on BPC 10.1 Component CPMBPC 810, SP Level 0009.

The EPM is SP 17 Patch 2.

I followed the steps describe in the next link to do the multiselection to test by rows and then change it by column to see if it worked.

In the image above I show the 2 reports I created. In the first one I have HOTEL Dimension as Page axis, TIME as column and ACCOUNTS as rows.

In the second report I have TIME as Columns and HOTEL as Rows.

I want to have the possibility of multiselect the dimension members in HOTEL. I'm using the fórumla EPMDMIENSION Override as is shown in the image and try to Override the HOTEL for for Report 001.

Am I doing anything wrong? becaus it is not working.

Thanks for your post.

Kind Regards.

[former_member182305 · Accepted solution]

I was trying to do the Override, the issue was that in the report 000 I was displaying the ID and the Description. It seem that just the ID should be displayed in order the function takes the VALUE.

Best Regards.

[former_member186338 · Accepted solution]

Yes

[former_member186338]

In the first report you must select ID only to show in HOTEL page axis! Like:

Vadim

[former_member186338]

P.S. For single member in the first report page axis you can use ID and Description, but for multiple members the ID+Description has to be surrounded by single quotes like:

'NA_HOTEL - N/A Hotel','Hote2 - Hotel 2'

And it's not an easy way to add quotes to this string