Filtering Task Data in the cube by Summary Tasks

U

uott2know

I have a cube that has been extended using the tool that a few people
on here have recommended. We now have Task data in our OLAP cube that
we can view in Portfolio Analyzer.

I'm trying to create some views based off the task information.
However, when I insert Tasks as a row or column field, I get all the
levels of the tasks in the project. For example, if I have 9 levels
of tasks, I get 9 in my Tasks list in the cube. This makes sense, but
makes the view impossible to use.

I'd like to filter this task list by indicating if it is a summary
task or not. We have TaskIsSummary in the cube, but the filter
doesn't seem to do much of anything. I still get a HUGE list of
tasks. It doesn't eliminate the summary ones from the drop down.

Not sure how many people have experience with this, but I've seen lots
of helpful and informed posts on here, so I thought I would give it a
shot.

Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top