Report Builder, limiting the Dimensions

Hi,

I created a report model based over the cube. The problme is, it retrieves all dimensions from the cube regardless those are checked or not even in the prespective.

It does work with Measure but not with Dimensions.

Appreciate if some one can drop a line here and help me out.

Thank you

Imran

You need to make manual changes to the model for this to happen.

1. Create a new Report Builder project.

2. Save the auto-generated SMDL file from Report Manager.

3. Add it to the Report Builder project.

4. Open the model in the Model Designer and select the root Model node.

5. On the right pane, right-click on the perspective desired and choose Edit.

6. In the Edit Perspective dialog box, unselect all dimensions that you don't need.

7. When you are done, go back to the Report Manager and update the model (click the Update button).

HTH

|||

The model is generated from the cube... It is not over the relational database where I can create and edit prepectives.

Imran

|||

I understand your scenario. You can still make manual changes to a model generated from UDM by following the steps in my previous post.

|||

Ok...

I limit the Dimension as you mentioned but now I cann't generate the report... The reason is, somehow all the Dimensions need to be selected in the Model...else it is not going to work.... Updating the Model back to original state rectify the problem.

Any help?

Thank You

Imran

|||

Can you provide repro steps with the AdventureWorks cube and include a report definition of a Report Builder report that cannot be generated?

|||Report Builder models generated against an Analysis Services cube cannot be edited using Model Designer. Also, modifying the report-model (.smdl) file directly is not supported.

Source: http://msdn2.microsoft.com/en-us/library/aa964121.aspx

Even if try to modify the report builder model using other way, we canot get the achieved results.

--Imran

|||

I am well aware of the Report Builder-SSAS limitations and the fact that the modifying the report-model is not supported. However, when nothing else helps you don't have much choice unless you take the unsupported road, do you? You should be able to open the smdl file in a Report Builder project, make the changes I mentioned, and update the model back successfully. If something doesn't work, please let us know what it is and provide repro steps if possible.