ProjectServer 2003 / OLAP Measures / Calculated members / ConditionalFormat

[Thomas Bräutigam]

Hi all,

can someone help me with 2 easy questions or betten answers?

-------------------------------------------------------------------------------------
1) Calculated Members in OLAP - Zero Error
-------------------------------------------------------------------------------------
When I perform the following calculation for a new calculated member
in the Project Server OLAP Cube (Web Access) I get errors for division
by '0'...of course.

[Measures].[Work]/[Measures].[Availability]

Can someone tell me how to create an if statement for this?
Like in Excel "IF([Measures].[Work]/[Measures].[Availability]<=0;"0";
[Measures].[Work]/[Measures].[Availability]
)

-------------------------------------------------------------------------------------
2) Conditional Format in OLAP Pivot Table?
-------------------------------------------------------------------------------------
Is it possible to use a conditional format in an OLAP pivot table?



HELP!

Regards
Thomas

PS: We're using Project Server 2003 incl. SP3

 

[Jackson T. Cole]

I can answer the second question about formatting in OLAP, at least if you
mean in the PWA views. No, those views cannot have conditional formatting,
only limited absolute formatting. If you export them to Excel, then you can.

A word of caution, though, linked Excel spreadsheets are subject to data
"shifting" if the source OLAP cube data changes relative to rows, but
conditional formatting remains fixed in the cell it was created in.

Hope this helps ...

JTC

 

[Thomas Bräutigam]

Jackson,

thanks for your response...at least I know more, unfortunately it is
not possible. Thanks anyway!

Does anyone else know the answer for my first question?

Regards
Thomas