Managing conformed dimensions
2 posters
Page 1 of 1
Managing conformed dimensions
I have the following scenario
1. there are common/conformed dimensions (like country, currency, date etc) managed by a central group within the organization
2. There are other key dimensions (like project, loans etc) which are owned and managed by respective lines of business (LoBs) and these dimensions are also used for integrating and reporting data across business units. These dimensions can have hundreds of attributes used by the LoBs, but the corporate reporting would need only a subset of them. The proposal is to treat these dimensions as conformed as well though managed by LoBs and expose a view of these dimensions with a subset of attributes for corporate reporting (common bus). Are there any potential issues with this approach? Appreciate any input/guidance.
1. there are common/conformed dimensions (like country, currency, date etc) managed by a central group within the organization
2. There are other key dimensions (like project, loans etc) which are owned and managed by respective lines of business (LoBs) and these dimensions are also used for integrating and reporting data across business units. These dimensions can have hundreds of attributes used by the LoBs, but the corporate reporting would need only a subset of them. The proposal is to treat these dimensions as conformed as well though managed by LoBs and expose a view of these dimensions with a subset of attributes for corporate reporting (common bus). Are there any potential issues with this approach? Appreciate any input/guidance.
karthiksm- Posts : 2
Join date : 2013-10-20
Similar topics
» Technique for managing conformed dimensions with different granularity
» Data Vault vs Kimball
» Design all dimensions as conformed dimensions
» MDM vs Conformed dimensions
» About Conformed dimensions
» Data Vault vs Kimball
» Design all dimensions as conformed dimensions
» MDM vs Conformed dimensions
» About Conformed dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum