Filtering out summary tasks from OLAP cube reports

R

Riso

I know it was discussed here, however I'm trying to refresh the
discussion on this topic to find out if anyone came to a fix for it.

My problem is that I am having a report in the cube showing project
tasks. Some of them are at 4th or 5th level under summary tasks and in
that case all of those summary tasks show up in the report which makes
it very complicated to comprehend.

Is there a way to filter out all summary tasks and display only
"bottom level" tasks which have their resources assigned? I was
playing around but couldn't find good trick to remedy this. There is
even a "TaskIsSummary (True/False)" dimension in the cube but it
doesn't seem to be working.

Any ideas?

Thanks,
Risiak
 

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

Similar Threads

Filtering Task Data in the cube by Summary Tasks 0
Add new dimensions to (timesheet) OLAP cube? 1
2003 Cube Refresh Error 0
OLAP cube 1
problems getting summary tasks to display in Project Web Access "Tasks" page 2
OLAP cube isn't generate from actual information 1
Averaging Subtotal for Excel OLAP Pivot from the Project Server Cube 2
Reports in OLAP vs. Excel downloads 1

Top