Question on attribute with more than one column

Hi,all experts here,

Thank you very much for your kind attention.

I am having a question on attribute with more than one column in a cube. What is the benefitial to have a attribute with more than one column? I am confused for this conception. And could please any experts here shed me any light on that.

Thanks a lot in advance for your help and I am looking forward to hearing from you.

With best regards,

Yours sincerely,

I'm not sure if this is the question that you are asking, but, here's a stab at the answer...

Often multiple columns in a relational table can be used to uniquely identify each member in an attribute. For example - months are repeated in years. If you have a Month column in your table that lists all the months by their names - Jan, Feb and so on - you won't be able to distinguish between months belonging to year 2003 and months belonging to year 2004. Now if you have another column (say Year) that lists the year, then, you could have a single attribute that has a composite key made up of the columns Year and Month.

|||

Hi, Bala,

Thanks a lot.

With best regards,

Yours sincerely,