MDX Query Filters


  • Hi,

    I am creating report using reporting service and datasource is SQL Server 2005 Cube.

    I am using query builder and i am creating query parameters in the query builder but when  i run the report is showing the filters but data is not filtering based on which i selected from the list.

    How do i create filters?? Please help out on this.




    Friday, November 10, 2006 9:08 PM

All replies

  • Switch to MDX mode and see the underlying query. There should be a subselect filter in the WHERE clause.
    Monday, November 13, 2006 1:35 AM
  • Thanks,

    Now i am able to see the subqueries in MDX, but  i am getting error when select the 'select all' from the list the following error message getting.

    "An error occured during local report processing. Query execution failed for data set 'Dataset1' Query (1,461) The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated.

    Please help on this.





    Tuesday, November 14, 2006 12:51 AM
  • The CONSTRAINED flag requires the selected member name to be resolved to a qualified member name. Drop a textbox on your report and set it to expression:

    =Join(Parameters!<parameter name>.Value,", ")

    Run the report. Does the output looks like valid member names?

    Tuesday, November 14, 2006 4:10 PM
  • I am also getting silimar error... I get he error when i Select-All on the server for the report that i have deployed is there any work around for this issue?


    Wednesday, April 30, 2008 10:59 AM