Dimension relation Many-many and regular relation
Page 1 of 1
Dimension relation Many-many and regular relation
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.
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)
BiSolution- Posts : 6
Join date : 2013-05-19
Similar topics
» SSAS 'Fact Dimension' v 'Regular Dimension' your views
» Fact with more than one relation to the same dimension in the same role
» Factless Fact table or 1:M Dimension Relation
» Relation between two fact tables having a one to many relation
» Dummy dimension values in the fact table
» Fact with more than one relation to the same dimension in the same role
» Factless Fact table or 1:M Dimension Relation
» Relation between two fact tables having a one to many relation
» Dummy dimension values in the fact table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum