Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX Query Filters

Status
Not open for further replies.

anumala28

Programmer
Jun 28, 2002
87
US
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,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top