April 16, 2009 at 11:46 pm
Dear all,
I have created a cube with KPI's, Calculations, Perpectives, Translations, Drill through actions.
I have the following questions:
1. What are the various ways through which all this data can be exposed to the end user?
2. How to provide access to users by Perpectives.
ie. I have a Perspective named "Finance Details" and when any user from the Finance Department accesses the cubes they should see only the "Finance Details" perspective. How to achieve that?
Thanks in advance,
Aravindbaalaaji
April 17, 2009 at 3:22 pm
You can expose the cube by allowing users to connect with items like SSRS or Excel. Perspectives are used to create views of the data and create simplified views for particular groups that only want to see certain items. Lots of people want to use them for security, but that is not what they are setup for.
Here is a link to other tools you can use with SSAS - http://www.ssas-info.com/analysis-services-tools
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply