Abstract Generic Dimension - Help Needed

View previous topic View next topic Go down

Abstract Generic Dimension - Help Needed

Post  tfm on Wed Dec 09, 2015 2:16 pm

Hi users,
We are evaluating the model of a new solution in our DW and we are having some trouble with our Contract Dimension. Actually we have one Contract Dimension for each product of the company, so if we have the products A, B and C we also have the dimensions DIM_CONTRACT_A, DIM_CONTRACT_B and DIM_CONTRACT_C.
One member of my team suggested to create a single Contract Dimension (Abstract Dimension) and use a super type attribute to define what product the contract is. Doing so, we will have the super types A, B and C. The problem is, we have a lot of particularity for each product contract, for example, A super type contracts have the proposal number attribute, but B and C don’t, so we should set this attribute to ‘Not Applicable’ on these cases. This happens to many other attributes, because of the particularity of each contract.




To avoid business users to see many ‘Not Applicable’ attributes we would like to control their view by the semantic layer, allowing the user to see only the attributes Applicable to each kind of contract.
Do you think this is a good approach? Any suggestion? Thanks in advance.  

tfm

Posts : 2
Join date : 2015-12-09

View user profile

Back to top Go down

Re: Abstract Generic Dimension - Help Needed

Post  ngalemmo on Wed Dec 09, 2015 2:55 pm

What does the business need to know about a contract?

One mistake that is too easy to make is to over-engineer things. Attributes that seem important turn out to be of no importance to analytics.

What would be wrong with a flat contract dimension with sparsely populated attributes?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Abstract Generic Dimension - Help Needed

Post  nick_white on Thu Dec 10, 2015 5:09 am

or use super/subtype dimensions where only the common attributes sit in the supertype dimension

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Abstract Generic Dimension - Help Needed

Post  tfm on Thu Dec 10, 2015 8:02 am

ngalemmo wrote:What does the business need to know about a contract?

One mistake that is too easy to make is to over-engineer things.  Attributes that seem important turn out to be of no importance to analytics.  

What would be wrong with a flat contract dimension with sparsely populated attributes?  

Each specific attribute is necessary because our areas have some different attributes for their contracts (The product contracts are controlled by different areas).
We want a flat contract dimension with sparsely populated attributes, that’s an usual approach?  We don’t have any dimension with so sparse populated attributes today.
Our main concern is about the business user reaction with blank or ‘Not Applicable’ attributes, that’s why we want to control the user view by a semantic layer.
Do you think this is the best solution?

tfm

Posts : 2
Join date : 2015-12-09

View user profile

Back to top Go down

Re: Abstract Generic Dimension - Help Needed

Post  zoom on Thu Dec 10, 2015 9:24 am

My suggestion is not to create a super/subtype dimension but to create a flat abstract dim with all of the attributes from all sources. Common attribute like contract_name is going to be the same for all the source, but unique attributes per source can be named differently. You can have "source name" column to identify a specific contract source in the dim. Using that source name you can hide  ‘Not Applicable’ attributes in the view. BTW You need a View if you have educated super user who can drag and drop attributes from a dim to create their own report. If you have canned reports, then you do not need different views, you need different report per a source... just show specific attributes in the report according to a user from a specific source.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Abstract Generic Dimension - Help Needed

Post  Sponsored content


Sponsored content


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