Criteria that allows custom enterprise fields to be in pivot tableexported from Data Analysis Cube

[caz4562000]

Hi all,
I really like using the pivot table that you can export from Data
Analysis to create reports from Project Server 2007.
I can't write database reports myself and the pivot table is a great
way to get to the data you need.
However, it seems to be that not all my custom enterprise fields are
in the pivot table.
I suspect that any field that is allowed to have more than one item
selected in the list is not appearing in the pivot table field list.
This is a real pain as we are using the fields to categorise all our
projects, and some projects do fall into more than one category. But
then I want to create reports showing how much time / money was spent
in certain periods using the pivot table.

Any suggestions or advice?

Thanks

Caroline

 

[Mark Everett | PMP]

Hi all,
I really like using the pivot table that you can export from Data
Analysis to create reports from Project Server 2007.
I can't write database reports myself and the pivot table is a great
way to get to the data you need.
However, it seems to be that not all my custom enterprise fields are
in the pivot table.
I suspect that any field that is allowed to have more than one item
selected in the list is not appearing in the pivot table field list.
This is a real pain as we are using the fields to categorise all  our
projects, and some projects do fall into more than one category. But
then I want to create reports showing how much time / money was spent
in certain periods using the pivot table.

Any suggestions or advice?

Thanks

Caroline

Caroline -

You are correct in that multivalue fieds are not available in the OLAP
cube. This will be fixed in Project 15 (Project Server 2007 is
Project 12, there is no Project 13, so Project 14 will be the next
release and the fix will come in the release after that). Yes, I know
that sucks.

1. You can use SRS and the Reporting Database for this.
2. “Explode” the MVCF definition - combining options so that leaf
nodes indicate MV selections, A, AB, AC, ABC, B, BC, C – this solution
is kinda lame but works for smaller domains, the MDX query then needs
to select all elements containing the attribute.

Hope This Helps,
Mark Everett PMP, MCITP
www.catapultsystems.com

 

[caz4562000]

Caroline -

You are correct in that multivalue fieds are not available in the OLAP
cube.  This will be fixed in Project 15 (Project Server 2007 is
Project 12, there is no Project 13, so Project 14 will be the next
release and the fix will come in the release after that).  Yes, I know
that sucks.

1. You can use SRS and the Reporting Database for this.
2. “Explode” the MVCF definition - combining options so that leaf
nodes indicate MV selections, A, AB, AC, ABC, B, BC, C – this solution
is kinda lame but works for smaller domains, the MDX query then needs
to select all elements containing the attribute.

Hope This Helps,
Mark Everett PMP, MCITPwww.catapultsystems.com- Hide quoted text -

- Show quoted text -

OK thanks. Unfortunately I don't know how to use SRS, I have to rely
on our IT dept for that and they have alot on their plate ;-)
It's good to know it's coming later anyway.

Caroline