Error With Filter function

[MikeG]

I have 2 reports on the same page derived from 2 different cubes. I want the prompt from the first to filter the second. The prompt uses the member description attribute from the Region level ( ?Parameter2? )

In the second report I put in a filter to select the Member Description from the second cube (Contribution reporting) and thus have the same Region as the first report


item (filter ([Contribution Reporting].[Country].[Country].[Region].[Member Description] = ?Parameter2?), 0 )

When I validate this function I get an error message stating that the filter function should have 2 arguments, which has me baffled. I have enclosed a screen shot to help
any ideas?

[MFGF]

I have 2 reports on the same page derived from 2 different cubes. I want the prompt from the first to filter the second. The prompt uses the member description attribute from the Region level ( ?Parameter2? )

In the second report I put in a filter to select the Member Description from the second cube (Contribution reporting) and thus have the same Region as the first report


item (filter ([Contribution Reporting].[Country].[Country].[Region].[Member Description] = ?Parameter2?), 0 )

When I validate this function I get an error message stating that the filter function should have 2 arguments, which has me baffled. I have enclosed a screen shot to help
any ideas?

Hi,

The filter function takes the form:

filter([your level or set], <some expression that equates to true or false>)

So in your case, I'm guessing your level is [Contribution Reporting].[Country].[Country].[Region] - is that correct?

If so, your expression should be:

item (filter ([Contribution Reporting].[Country].[Country].[Region], [Contribution Reporting].[Country].[Country].[Region].[Member Description] = ?Parameter2?), 0 )

Cheers!

MF.

[MikeG]

Hi

Yes Region is a level, corrected filter to your recommendation and hey-presto it worked

thanks for your help