Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Multi valued dimension attributes, weighting factor and cognos

Go down

Multi valued dimension attributes, weighting factor and cognos Empty Multi valued dimension attributes, weighting factor and cognos

Post  SCAI_Andre Mon Jan 25, 2010 7:14 am

Hi,

we have several attributes in our product and customer dimension which might by multi valued.

We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein.

Can anybody reference a best practice document to model this in Cognos (or any other BI tool - I hope I can transform it)?

The task is to have Cognos automatically apply the weighting factor on the facts as soon as the respective multi valued dimension attribute is taken into the query or filtered on.

This is a tough one, I guess, and I have found nothing on this, yet.

TIA!

Regards,
Andre

SCAI_Andre

Posts : 7
Join date : 2010-01-25
Location : Leverkusen, Germany

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum