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

Dimension relation Many-many and regular relation

Go down

Dimension relation Many-many and regular relation Empty Dimension relation Many-many and regular relation

Post  BiSolution Tue May 28, 2013 4:18 am

Hi,
I'm working with dimensional model for health care domain. Attached the relationship b/w fact table and dimension relation. Its working as expected in SSAS cube. But i want show the many-many relation between provider ->provider identifier and aggreagate the amount to respective identifier. But its not working as expected. As fact claim grain as been already defined in OLTP i.e, Provider id and provider Identifier id has regular relation with fact claim. Provider and provider identifier has many-many relation via bridge table. Am i missing something in my model. kindly assist. Thanks in advance.

Dimension relation Many-many and regular relation View


Last edited by BiSolution on Tue May 28, 2013 4:45 am; edited 2 times in total (Reason for editing : Image not attached)

BiSolution

Posts : 6
Join date : 2013-05-19

Back to top Go down

Back to top

- Similar topics

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