cancel
Showing results for 
Search instead for 
Did you mean: 

significant of key field in Info cube table

Former Member
0 Kudos

Hi,

what is significant of key field in Info cube table?

Best regards,

dushyant.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

In Cube combination of all the dimention is a key field.

Regards,

Meiy

Answers (2)

Answers (2)

Former Member
0 Kudos

hi ,

key figures are very important in tables, when it is in cube it act as dimensions

for the reporting purpose see this scenario

the table has following fields

student no

student name

student attendance

student mark

in this scenario when we want report according to student no its normal we would get, but when we want according to attendance,marks we dont get report according to attendance and mark, so we put all those fields in key fields.

So we could say that Key fields are the dimensions and according to this we get reports

thank yu

Former Member
0 Kudos

Hi,

please elaborate your enquiry.

Cube characteristics are organized in dimensions The primary key of an infocube table are all dimensions together; by extension and the extended star schema definition, all characteristics are making the "key" of an Infocube.

hope this helps...

Olivier.