select parameter values which are not available in a cube

hi all,

i have created report graph. graph type should changed depending on parameter value.(graph1, graph2,graph3 etc).

the problem values not in cube.

so when try specify details of parameters definte in query, can not selct dimension , hierachy , defualt values etc.

can tell me how please?

thanks

 

---

shamen

hi shamen,

according description, use parameter supply different graph,please follow steps below, , check if works you.

1. in report data pane, right-click on dataset created sql server analysis services data source type, , clicks query. mdx query designer opens in design mode.
2. on toolbar, click design toggle query mode.
3. on mdx query designer toolbar, click query parameters. query parameters dialog box opens.
4. in parameter column, click <enter parameter>, , type name of parameter.
5. in dimension column, choose value drop-down list, example, select “date”.
6. in hierarchy column, choose value drop-down list, example, select “date.date”
7. in default column, type in value used default value, example, type in “2010-4-1”

in report data pane, expand parameters node display report parameter automatically created filter. , can repeat steps above add parameter in dataset.

for more details it, please see following article,
how to: define parameters in mdx query designer analysis services (report builder 3.0 , ssrs): http://technet.microsoft.com/en-us/library/ms156303.aspx

if have question, please feel free ask.

thanks,
eileen

SQL Server  >  SQL Server Reporting Services, Power View