Managing conformed dimensions

View previous topic View next topic Go down

Managing conformed dimensions

Post  karthiksm on Sun Oct 20, 2013 12:57 pm

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.



karthiksm

Posts : 2
Join date : 2013-10-20

View user profile

Back to top Go down

Re: Managing conformed dimensions

Post  ngalemmo on Sun Oct 20, 2013 3:28 pm

Nope. Its a fairly common scenario.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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