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

Managing conformed dimensions

2 posters

Go down

Managing conformed dimensions Empty Managing conformed dimensions

Post  karthiksm 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

Back to top Go down

Managing conformed dimensions Empty Re: Managing conformed dimensions

Post  ngalemmo Sun Oct 20, 2013 3:28 pm

Nope. Its a fairly common scenario.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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