Dimension relation Many-many and regular relation

View previous topic View next topic Go down

Dimension relation Many-many and regular relation

Post  BiSolution on Tue May 28, 2013 4:18 am

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.

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


Posts : 6
Join date : 2013-05-19

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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