hierarchies with many attributes for each one
2 posters
Page 1 of 1
hierarchies with many attributes for each one
Hi everybody, I have an issue with modeling a "Project Management" business process.
Tipycally, each sub-task rolls up to a task and each task rolls up to a project.
sub-task have many attributes that need to be constarined by "Team Leaders".tasks and projects also do.
Shall I make a flattened dimension let's say "sub-task_dimension" whith all attributes for sub-tasks, tasks and projects.
Or shall I make separate dimensions(i.e: sub-task_dimension, task_dimension, project_dimension) and if so how can I "slice and dice" along sub-task, task and project attributes ?
Any help will be appriciated.
Tipycally, each sub-task rolls up to a task and each task rolls up to a project.
sub-task have many attributes that need to be constarined by "Team Leaders".tasks and projects also do.
Shall I make a flattened dimension let's say "sub-task_dimension" whith all attributes for sub-tasks, tasks and projects.
Or shall I make separate dimensions(i.e: sub-task_dimension, task_dimension, project_dimension) and if so how can I "slice and dice" along sub-task, task and project attributes ?
Any help will be appriciated.
The_Maestro- Posts : 2
Join date : 2012-03-07
Re: hierarchies with many attributes for each one
You have projects and you have tasks. Sub-tasks are tasks. Facts would reference the project and task. The task hierarchy is supported by a bridge table (exploded hierarchy).
Re: hierarchies with many attributes for each one
Thanks ngalemmo for help. In fact I am planning to use SSAS and SSRS based on my dimensional model. Did they support the bridging technique for handling hierarchies?
The_Maestro- Posts : 2
Join date : 2012-03-07
Re: hierarchies with many attributes for each one
It allows you to access all levels of the hierarchy using simple SQL. Should be fine for SSRS. I haven't worked with SSAS, you may need to build a flattened version of the hierarchy, which is easy enough to do using the bridge. Maybe someone in the forum more familiar with SSAS can comment.
Similar topics
» Attributes from a dimension appearing in other dimensions; multiple-inheritance in hierarchies.
» dimension table design question for around 100 attributes and higher level calculated attributes
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
» Hierarchies
» Hierarchies in dimensions.
» dimension table design question for around 100 attributes and higher level calculated attributes
» Dimension Attributes and Fact attributes storing same data in multiple data marts??
» Hierarchies
» Hierarchies in dimensions.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum