MDX Query Editor & Tuples

Today i started to write my first MDX-code and read about tuples. Some important things:
– Each attribute-hierarchy within a dimension of the cube forms an axis. Along each axis the associated attribute-hierarchy + (All) Member occupies a position.

– Points within the cube can be referenced using a tuple. Tuples in cube spaces use member references for coordinate values such as: (a1, a2, … an) where a is the member reference.

– Points within cube spaces are occupied by cells which are objects and have their own properties. The default properties when accessing a cell is VALUE & FORMATTED_VALUE.

– When accessing parital tuples, that is only having some axis-coordinates then SSAS will fill in the blanks. When omitting a member reference SSAS uses three rules:
1. Use the default Member.
2. Use the (All) Member.
3. Use the first Member.

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,777 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: