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 ?

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.