Tuples & Sets

Today i read some more about tuples and how to create one using reference members. To reference a member by name you use syntax: [Dimension].[Hierarcy].[Member Name] eg. [Product].[Category].[Bikes]

To reference a member by key use syntax: [Dimension].[Hierarchy].&[Member Key] eg. [Product].[Category].&[1].

To reference a member by name within a level of a user-hierarcy use syntax: [Dimension].[Hierarchy].[Level].[Member Name].

To reference a cell using a tuple use a “[]” with a comma-seperated list of member references eg. ([Product].[Category].[Bikes] , [Date].[Calendar].[CY 2004].

A set is a collection of tuples, which you use to retrieve multiple cells. You can write a set like this:
([Date].[Calendar].[CY 2002], [Geography].[Country].[United States]),
([Date].[Calendar].[CY 2003], [Geography].[Country].[United States]),
([Date].[Calendar].[CY 2004], [Geography].[Country].[United States])
The tuples must have shared hierarchy to be part of the same set.

Advertisements
Tagged with: ,
Posted in MDX

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

Archive
Categories

Blogstatistics
  • 3,870 hits
Boyan Penev on Microsoft BI

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Sherry's BI Corner

All about Microsoft’s BI Platform (SQL Server, Reporting Services, Analysis Services, Integration Services)

Sherry's BI Corner

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Comments for CALUMO

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

True Tiger Recordings

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Data Inspirations

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

%d bloggers like this: