August 7, 2008 at 5:58 am
i have a report which shows data for all the countries by default and i have a country parameter .
so when user selects a particular country ...the data can b viewed for that country .
but the problem is there are many countries for which data is not available and in parameter it shows all the countries .
i want to show country having data in parameter selection...i.e. country without data should not come in parameter selection box
has any one tried this....please help
Note: DataSource is a CUBE (SSAS)
Thanks in Advance
Ravi
August 13, 2008 at 5:38 am
hi,
when you create datasource at that time you need to write query string. It must be coming from some table.
You can write query where country is not null or country <> ''. it will filter your list and appear in your list.
hope it helps.
August 14, 2008 at 7:04 am
I once had the same problem with Years and a measure, say Count.
I ended up creating a new data set (with a new data source with the OLE DB Provider for Analysis Services 9.0) for the parameter and used the NON_EMPTY_BEHAVIOR:
WITH MEMBER [Measures].[ParameterCaption] AS '[Year].[Year].CURRENTMEMBER.MEMBER_CAPTION',
NON_EMPTY_BEHAVIOR = {[Measures].[Count]}
MEMBER [Measures].[ParameterValue] AS '[Year].[Year].CURRENTMEMBER.UNIQUENAME',
NON_EMPTY_BEHAVIOR = {[Measures].[Count]}
MEMBER [Measures].[ParameterLevel] AS '[Year].[Year].CURRENTMEMBER.LEVEL.ORDINAL',
NON_EMPTY_BEHAVIOR = {[Measures].[Count]}
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,
NON EMPTY [Year].[Year].MEMBERS ON ROWS
FROM [My Cube]
I then changed the parameter's data set to the new one and updated the field names for the Value and Label. The parameter list then only shows Years for which the Count measure has values.
Worked for me, but maybe some expert could suggest a simpler solution...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply