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?
Quote from: MikeG on 11 Mar 2015 10:54:53 AM
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.
Hi
Yes Region is a level, corrected filter to your recommendation and hey-presto it worked
thanks for your help