Question on dimension types in a cube

Hi, all experts here,

Thanks a lot for your kind attention.

I am wondering dose it really matter if the dimension types we set for each dimension will really affect anything wihin a cube?(like normally the default dimension type is regular, but there are many other dimension types like promotion, product etc. ), so do these dimension types will really affect anything for the cube data? If so, like what would be affected and changed?

I am looking forward to hearing from you shortly and thank you very much in advance for your help and advances.

With best regards,

Yours sincerely,

The only two types which affect semantics are:

1. Time - for MDX functions such as YTD and for semiadditive measures

2. Account - for Account Intelligence

Everything else are metadata that client applications can use for UI and other purposes.

|||

Hi,

Thanks a lot.

With best regards,

Yours sincerely,

|||

Dear Helen

Pleasae help me.. How can I create an attribute dateoforder in Sales dimension ...

Please help ..