Last post Mar 06, 2012 10:14 AM by Srikanth Kasturi
Feb 28, 2012 06:15 PM|venu.iapn|LINK
We are creating SSRS reprots using SSAS OLAP database.
i want to create a report with 4 parameters, From date (date control), To Date (date control), State (Dropdown), Referral (Dropdown)
and State and Referral dropdowns are optional parameters that means if i enter from date and to date i should get data without selecting state and referral.
i have created 3 dataset using SSAS Cubes 1) state dropdown 2) Referral Drodown 3) Report Details
and i have created 4 parameters 1) Form Date 2) To date 3) State 4) Referral
my question is when i am review my report with from data and to date it's giving alert message "select state" like this
If i select from date and to date then i shold get all the records between date range from dataset
if i select any dropdown i should get all the records between date range and selected dropdown data.
Feb 29, 2012 08:15 AM|Nishantg|LINK
You need to add one Default value in your Dropdown parameter like the following
Select 'Default' as ColName from dual Union All your query
And then give the default value of your dropdown parameter. While building your query just check your dorpdown parameters if there is only "Default" is selected don't include it in your where condition otherwise include it.
Feb 29, 2012 06:25 PM|venu.iapn|LINK
But i want that query in MDX query (SSAS OLAP Database ) not in T-Sql query.
Mar 06, 2012 06:27 AM|Ashutosh Pathak|LINK
well what i think is: you can have a seperate dataset that Create your MDX statement based on the dropdown selected.
now pass this query to your next dataset to pick your data from the OLAP.
Mar 06, 2012 10:14 AM|Srikanth Kasturi|LINK
In the reporting server, for that particular parameter, allow nulls and in your MDX query too, allow nulls for the same paramters. This will solve your issue.