MSBI # 56 – SSAS # 14 – How to Defining Perspectives and Translations in SSAS

Hi folks

Continuing from my last post on SSAS

In this article we are covering aspect of Defining Perspectives and Translations with following key points

  • Defining and Browsing Perspectives
  • How to Define perspective
  • To browse the cube through each perspective
  • Defining and Browsing Translations

In this article , we are going learn to define perspectives and translations.Also we can define perspectives to reduce the apparent complexity of a cube, and define translations that let users view the cube metadata in the language of their choice.

Defining and Browsing Perspectives 

A perspective can simplify the view of a cube for specific purposes. By default, users can see all elements in a cube to which they have permissions. What users are viewing when they view an entire Microsoft SQL Server 2005 Analysis Services (SSAS) cube is the default perspective for the cube. A view of the whole cube can be very complex for users to navigate through, especially for users who only need to interact with a small part of the cube to satisfy their business intelligence and reporting requirements. To reduce the apparent complexity of a cube, you can create viewable subsets of the cube, called perspectives, which show to users only a defined part of the measure groups, measures, dimensions, attributes, hierarchies, Key Performance Indicators (KPIs), actions, and calculated members in the cube. This can be particularly useful for working with client applications that were not written for a previous release of Analysis Services. These clients have no concept of display folders or perspectives, for example, but a perspective appears to older clients as if it were a cube.

When you define a new perspective in SQL Server Analysis Services, you first click New Perspective on the toolbar of the Perspectives tab in Cube Designer, and then define a name for the perspective. When you create a new perspective, all Analysis Services objects in the cube that appear in the Cube Objects list initially appear in the perspective. To remove these objects, you just clear the check box for the object that you want to remove from the perspective.

In the tasks in this topic, you will define several different perspectives and then browse the cube through each of these new perspectives.

How to Define perspective

To define an Internet Sales perspective

1.Open Cube Designer for the Analysis Services Tutorial cube, and then click the Perspectives tab.

All the objects and their object types appear in the Perspectives pane, as shown in the following image.

clip_image002

2.On the toolbar of the Perspectives tab, click New Perspective.

A new perspective appears in the Perspective Name column with a default perspective name of Perspective, as shown in the following image. Notice that the check box for every object is selected; until you clear the check box for an object, this perspective is identical to the default perspective of this cube.

clip_image004

3.Change the perspective name to Internet Sales.

4.Set Internet Sales-Sales Amount as the default measure.

When users browse the cube by using this perspective, this measure will be the measure that the users will see unless they specify some other measure.

Clear the check box for the following objects:

  • Reseller Sales measure group
  • Sales Quotas measure group
  • Sales Quotas1 measure group
  • Reseller cube dimension
  • Reseller Geography cube dimension
  • Sales Territory cube dimension
  • Employee cube dimension
  • Promotion cube dimension
  • Reseller Revenue KPI
  • Large Resellers named set
  • Total Sales Amount calculated member
  • Total Product Cost calculated member
  • Reseller GPM calculated member
  • Total GPM calculated member
  • Reseller Sales Ratio to All Products calculated member
  • Total Sales Ratio to All Products calculated member

These objects do not relate to Internet sales.

To define a Reseller Sales perspective

1.On the toolbar of the Perspectives tab, click New Perspective.

2.Change the name of the new perspective to Reseller Sales.

3.Set Reseller Sales-Sales Amount as the default measure.

When users browse the cube by using this perspective, this measure will be the measure that the users will see unless they specify some other measure.

4.Clear the check box for the following objects:

  • Internet Sales measure group
  • Internet Sales Reason measure group
  • Customer cube dimension
  • Internet Sales Order Details cube dimension
  • Sales Reason cube dimension
  • Internet Sales Details Drillthrough Action drillthrough action
  • Total Sales Amount calculated member
  • Total Product Cost calculated member
  • Internet GPM calculated member
  • Total GPM calculated member
  • Internet Sales Ratio to All Products calculated member
  • Total Sales Ratio to All Products calculated member

These objects do not relate to resellers sales.

To define a Sales Summary perspective

1.On the toolbar of the Perspectives tab, click New Perspective.

2.Change the name of the new perspective to Sales Summary.

3. Clear the check box for the following objects:

  • Internet Sales measure group
  • Reseller Sales measure group
  • Internet Sales Reason measure group
  • Sales Quotas measure group
  • Sales Quotas1 measure group
  • Internet Sales Order Details cube dimension
  • Sales Reason cube dimension
  • Internet Sales Details Drill through Action drill through action

4.Select the check box for the following objects:

  • Internet Sales Count measure
  • Reseller Sales Count measure

To browse the cube through each perspective

1.On the Build menu, click Deploy Analysis Services Tutorial.

2.When deployment has successfully completed, switch to the Browser tab, and then click Reconnect.

3.Clear all measures and hierarchies from the Data pane and all dimensions from the Filter pane.

4.Review the measures and dimensions in the Metadata pane.

Notice that all the defined measures and measure groups appear.

5.On the toolbar of the Browser tab, select Internet Sales in the Perspective list and then review the measures and dimensions in the Metadata pane.

Notice that only those objects that are specified for the Internet Sales perspective appear, as shown in the following image.

clip_image005

6.In the Metadata pane, expand Measures.

Notice that only the Internet Sales measure group appears, together with the Internet GPM and Internet Sales Ratio to All Products calculated members.

7.Expand Internet Sales, right-click Internet Sales-Sales Amount, and then select Add to Data Area.

This measure appears in the Data pane.

8.In the Perspective list of the toolbar of the Browser tab, select Reseller Sales.

Notice that the Internet Sales-Sales Amount measure no longer appears in the Data pane.

9.In the Metadata pane, expand Measures.

Notice that the Internet Sales measure group no longer appears in the measures list.

10. In the Perspectives list on the toolbar of the Browser tab, select Sales Summary.

11. In the Metadata pane, expand Measures, expand Internet Sales and expand Reseller Sales.

Notice that in each of these measure groups, only a single measure appears, as shown in the following image.

clip_image006

Defining and Browsing Translations 

A translation is a representation of the names of Microsoft SQL Server 2005 Analysis Services (SSAS) objects (such as measure groups, measures, dimensions, attributes, hierarchies, KPIs, actions, and calculated members) in a specific language. Translations provide server support for client applications that can support multiple languages. With such a client, the client passes the locale identifier (LCID) to the instance of Analysis Services, which uses the LCID to determine which set of translations to use when providing metadata for Analysis Services objects. If an Analysis Services object does not contain a translation for that language or does not contain a translation for a specified object, the default language is used in returning the object metadata back to the client. For example, if a business user in France accesses a cube from a workstation that has a French locale setting, the business user sees the member captions and member property values in French if a French translation exists. However, if a business user in Germany accesses the same cube from a workstation that has a German locale setting, the business user sees the captions names and member property values in German.

You define translations for dimension metadata on the Translations tab in Dimension Designer for the appropriate dimension and on the Translations tab in Cube Designer. You can use the Translations tab of Dimension Designer to define translations not just for the caption of an attribute, but also for the captions of members that are represented by that attribute.

In the tasks in this topic, you define metadata translations for a limited set of dimension objects in the Time dimension and cube objects in the Analysis Services Tutorial cube. You will then browse these dimension and cube objects to examine the metadata translations.

To specify translations for the Time dimension metadata

1.Open Dimension Designer for the Time dimension, and then click the Translations tab.

The metadata in the default language for each dimension object appears, as shown in the following image. The default language in the Analysis Services Tutorial cube is English.

clip_image008

2.On the toolbar of the Translations tab, click New Translation.

A list of languages appears in the Select Language dialog box.

3.Click Spanish (Spain), and then click OK.

A new column appears in which you will define the Spanish translations for the metadata objects you want to translate. In this tutorial, we will only translate a small number of objects just to illustrate the process.

4.On the toolbar of the Translations tab, click New Translation, click French (France) in the Select Language dialog box, and then click OK.

Another language column appears in which you will define French translations, as shown in the following image.

clip_image010

5.In the row for the Caption object for the Time dimension, type Tiempo in the Spanish (Spain) translation column and Temps in the French (France) translation column.

6.In the row for the All Periods object for the Time dimension, type Todos los Períodos in the Spanish (Spain) translation column and Toutes les Périodes in the French (France) translation column.

7.In the row for the Caption object for the Month Name attribute, type Mes del Año in the Spanish (Spain) translation column and Mois d’Année in the French (France) translation column.

Notice that when you enter these translations, an ellipsis () appears, as shown in the following image. Clicking this ellipsis will let you specify a column in the underlying table that provides translations for each member of the attribute hierarchy.

clip_image012

8.Click the ellipsis () for the Spanish (Spain) translation for the Month Name attribute.

The Attribute Data Translation dialog box appears.

9.In the Translation columns list, select SpanishMonthName, as shown in the following image.

clip_image013

10. Click OK, and then click the ellipsis () for the French (France) translation for the Month Name attribute.

11. In the Translation columns list, select FrenchMonthName, and then click OK.

The steps in this procedure illustrate the process of defining metadata translations for dimension objects and members.

To specify translations for the Analysis Services Tutorial Cube metadata

1.Switch to Cube Designer for the Analysis Services Tutorial cube, and then switch to the Translations tab.

The metadata in the default language for each cube object appears, as shown in the following image. The default language in the Analysis Services Tutorial cube is English.

clip_image015

2.On the toolbar of the Translations tab, click New Translation.

A list of languages appears in the Select Language dialog box.

3.Select Spanish (Spain), and then click OK.

A new column appears in which you will define the Spanish translations for the metadata objects you want to translate. In this tutorial, we will only translate a small number of objects just to illustrate the process.

4.On the toolbar of the Translations tab, click New Translation, select French (France) in the Select Language dialog box, and then click OK.

Another language column appears in which you will define French translations.

5.In the row for the Caption object for the Internet Sales measure group, type Ventas del lnternet in the Spanish (Spain) translation column and Ventes D’Internet in the French (France) translation column.

6.In the row for the Caption object for the Internet Sales-Sales Amount measure, type Cantidad de las Ventas del Internet in the Spanish (Spain) translation column and Quantité de Ventes d’Internet in the French (France) translation column.

The steps in this procedure illustrate the process of defining metadata translations for cube objects.

To browse the cube by using translations

1.On the Build menu, click Deploy Analysis Services Tutorial.

2.When deployment has successfully completed, switch to the Browser tab, and then click Reconnect.

3.Remove all hierarchies and measures from the Data pane, select Analysis Services Tutorial in the Perspectives list, and then verify that Analysis Services Tutorial appears in the Language list.

4.In the Metadata pane, expand Measures and then expand Internet Sales.

Notice that the Internet Sales-Sales Amount measure appears in English in this measure group.

5.On the toolbar, select Spanish (Spain) in the Language list.

Notice that the items in the Metadata pane are repopulated. After the items in the Metadata pane are repopulated, notice that the Internet Sales-Sales Amount measure no longer appears in the Internet Sales display folder. Instead, it appears in Spanish in a new display folder named Ventas del lnternet, as shown in the following image.

clip_image016

6.In the Metadata pane, right-click Cantidad de las Ventas del Internet and then select Add to Data Area.

7.In the Metadata pane, expand Date, expand Calendar, right-click Date.Calendar Time, and then select Add to Row Area.

8.In the Data pane, expand CY 2004, expand H1 CY 2004, and then expand Q1 CY 2004.

Notice that the month names appear in Spanish, as shown in the following image.

clip_image017

9.On the toolbar, select French (France) in the Language list.

Notice that the month names now appear in French and that the measure name now also appears in French.

Hope this helps !!

Hope you have understood Perspectives and Translations in SSAS and ready to use every aspects for same

If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog

If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog

Where todays links are

Link Resource Website>> Dactylonomy of Web Resource

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: