[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Create a Perspective



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Create a Perspective

Applies to:  SQL Server 2008 RC 0.

Once you have created a cube, you may have interest in hiding measure groups and dimensions of your cube to some end users.  In that case, you need to create one or more perspectives.

Here is how you can create them:

1.  To create a perspective, make a click on the Perspectives tab in the Cube Designer

2.  Make a click on the "New Perspective" icon.

3.  You will find there is already a perspective created.  Please assign a name to it.  In the example below, we named "Sales".

4. Scroll a little bit to the left, let's select the measure groups, measures, and dimensions we would like to have in a new perspective, and let's name the perspective "Promotions".




.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.