cancel
Showing results for 
Search instead for 
Did you mean: 

Key for a Cube

Former Member
0 Kudos
63

Can I consider the characteristics that I add to a cube as a representation of the unique key value? Thanks

Accepted Solutions (1)

Accepted Solutions (1)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

<i>

Lets say I add the following characteristics to my cube:

Storage Location

Plant

Material

Sold To

For each record that is represented in the Fact table is the key here the four characteristics or does it vary on how I store them at the dimension level i.e.

If I have four dimensions representing each characteristic than 4 key combination, whereas a 3 dimension say Location (which contains Storage Location, Plant) and Material, Sold To is this a different key value?</i>

Hi, in this case, Dimension has nothing to do with Unique Records, its based on individual characteristics.

Example:

IF you have two (2) records coming into Cube from Source.

Storage Location; Plant; Material; Sold To; kf

TX; PLT1; MAT001; ABC; $1000

TX; PLT1; MAT001; CDF; $3000

Here, these are seperate records in CUBE no matter which Dimensions the CHaracteristics fall in.

Chamarthy

Message was edited by:

U.P. Chamarthy

Former Member
0 Kudos

Thanks very much for that have awarded points

Answers (2)

Answers (2)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

YES, you are correct.

<i>Can I consider the characteristics that I add to a cube as a representation of the unique key value? Thanks</i>

I meant this statement is correct.

Chamarthy

Message was edited by:

U.P. Chamarthy

Former Member
0 Kudos

Thanks for that, what I am trying to clear up is the following. Lets say I add the following characteristics to my cube:

Storage Location

Plant

Material

Sold To

For each record that is represented in the Fact table is the key here the four characteristics or does it vary on how I store them at the dimension level i.e.

If I have four dimensions representing each characteristic than 4 key combination, whereas a 3 dimension say Location (which contains Storage Location, Plant) and Material, Sold To is this a different key value?

Former Member
0 Kudos

Niten,

If i understand you correctly, not really.

The cube is a multidimensional structure comprised from dimensions and a fact table.

The combination of the characteristics in a single dimension determines its granularity, and can be regarded as a sort of "key" of that dimension.

In fact tables the number of records is determined by the combination of Dimension Ids or Surrogate IDs (in case the dimension is a line item dimension).

In Data Store objects, the situation is more intuitive. The Data Store key is determined by a combination of up to 16 characteristics or time chars.

Hope it helps,

Gili