INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Unchecked cube perspective dimensions displaying in Report Builder

Unchecked cube perspective dimensions displaying in Report Builder

(OP)
I created a cube perspective, and unchecked 3 dimensions, so that the parent dimension and child attributes are all unchecked.  I saved the solution, reprocessed the SSAS database, and regenerated the SSAS report model.  When I open a Report Builder report based off this report model, and select the cube perspective I created, the 3 dimensions are displaying within the 'Entities' section.  I can click each dimension and all the attributes display as well.

Can anyone tell me why the dimensions in this perspective are displaying in Report Builder?

Thank you.

...Phillip

RE: Unchecked cube perspective dimensions displaying in Report Builder

Can you confirm its just report builder?

Have you tried anything else... excel, proc-clarity etc?

A

RE: Unchecked cube perspective dimensions displaying in Report Builder

(OP)
I confirmed that it's Report Builder.  I can open an MDX query window in SQL Server Management Studio, select the perspective and see only the dimensions that were included in the perspective.  The dimensions that were not checked in the perspective are not displaying.  

RE: Unchecked cube perspective dimensions displaying in Report Builder

I thought that might be the case. I wouldn't be surprised if you can never get them to work. I am finding that SSRS, Report Builder and *models based on SSAS* are a little disjointed from the MS product set. I guess we have to remember that report builder was another companies product that was bundled in.

In any case I had a similar requirement to yourself but I could not attempt the perspectives option as I don't have Enterprise Etd. The users wanted a full model which by default is everything in the cube when you generate the model from the data source and they wanted several 'cut down' models with perhaps 2-3 dimensions and 1 measure group.

Ok I thought I'd edit the model like you do with SQL based models. I won't go into details here but that's a non runner with *models based on SSAS*. I then tried the roles/permissions route which works in a sense but still initially displays all the dimensions and measures to everyone and just brings back blanks for any disallowed items. Users threw that back at me as you can imagine.

I then found the following article which enabled me to do exactly what I wanted.

http://codebetter.com/blogs/brendan.tompkins/archive/2007/02/28/SQL-2005-Report-Models-from-an-Analysis-Server-OLAP-Cube.aspx

It really works a treat. Just one point though, the author suggest models can be 'edited'. I initially deleted and renamed things and it didn't work. I then just edited the properties of entities to visible = false and it works fine. You also have to hide the dimension roles within a measure group otherwise when they navigate to a measure group the dimensions related to the measure group are visible again even though you have hidden them.

Regards

Alan
 

RE: Unchecked cube perspective dimensions displaying in Report Builder

(OP)
Thanks, Alan!  The suggestion you provided worked wonderfully.

Phillip

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close