Hi
I am trying to create chart report. i have created MDX query using Query Designer.I have created query with 4 query filters in query designer.
I have developed chart report,and ran the reports it showing 4 list box to select the filters. These list boxes are showing with 'select all', 'All' and values. Now i am selecting the 'select all' from the list, report is giving error.
When i saw the my datasources it got creted 5 queries one is i have designed main query. remaiming 4 quereis are which iam using dimenssion queries i.e paramerters. these foure got creted as cascading. All 5 queries automatically created in designer with strtoset function with [CONSTRAINED] flag.
if i remove the [CONSTRAINED] flag from all 5 queries, and i ran report. i am getting error it's query is using parmetervalue from dataset1 etc.,
how can implement filters without strtoset function and i need to select 'select all' or any other values.
Please let us know how do i implement this. required help....
Thanks,
I am trying to create chart report. i have created MDX query using Query Designer.I have created query with 4 query filters in query designer.
I have developed chart report,and ran the reports it showing 4 list box to select the filters. These list boxes are showing with 'select all', 'All' and values. Now i am selecting the 'select all' from the list, report is giving error.
When i saw the my datasources it got creted 5 queries one is i have designed main query. remaiming 4 quereis are which iam using dimenssion queries i.e paramerters. these foure got creted as cascading. All 5 queries automatically created in designer with strtoset function with [CONSTRAINED] flag.
if i remove the [CONSTRAINED] flag from all 5 queries, and i ran report. i am getting error it's query is using parmetervalue from dataset1 etc.,
how can implement filters without strtoset function and i need to select 'select all' or any other values.
Please let us know how do i implement this. required help....
Thanks,