hey guys,
I created a dataset using a design view of the MDX query designer. As you know, in the filter pane of the MDX query, there is check box if you want to parameterized your report. When I checked that option, SQL Server created a dataset specifically for the report parameter. So my question is that I can see this dataset in the data tab of the report designer but not in the Report Datasets list. Do you have any idea why this happened?
waiting to hear soon.
Sincerely,
Amde
Report designer will mark MDX parameter datasets as "auto-generated" in the underlying RDL representation:
<rd:AutoGenerated>true</rd:AutoGenerated>
Reasoning: in general the parameter valid value lists of MDX queries are only relevant for parameter selection.
You can still use those datasets by removing the the rd:AutoGenerated element from the dataset in the RDL file (and have it then show up in the dataset list), or by looking up the name and fields of the autogenerated dataset and hand-writing expressions.
-- Robert
|||Hey Robert,
I really appreciate your assistance. I got the solution. By the way removing the rd:AutoGenerated element from the rdl file didn't help me to see the dataset. What I did is changing the hidden property of the dataset to false. Now I can see the dataset in the list.
Thank you Robert again.
Sincerely,
Amde
|||Yes you right - I forgot to mention to remove the <rd:Hidden> element.
-- Robert
|||Hi Robert,Is there any tutorial/link for rdlc report creation using mdx query/OLAP database?
