User defined categories in conformed dimension

View previous topic View next topic Go down

User defined categories in conformed dimension

Post  eshtee on Tue Aug 16, 2011 6:43 pm

Hi,
I am creating a conformed product dimension and one of the requirements is to let users create product categories for different reports. The list of products is retrieved from a source system. My initial solution was to just create new columns for each category but I think i will soon run of of columns in that case

Has any one encountered similar issues? Any help will be much appreciated.

Thanks
Syed

eshtee

Posts : 6
Join date : 2011-07-19

View user profile

Back to top Go down

Re: User defined categories in conformed dimension

Post  ngalemmo on Tue Aug 16, 2011 6:52 pm

Use a separate data structure, most likely a parent/child hierarchy would be appropriate. Build an application to maintain it and treat the tables as separate from the DW. Use an ETL process to apply updates to a bridge table after the user has 'released' their changes.
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