PS07 - Formulas to show in OLAP cube?

[TroyS]

I see how to get Lookup Tables into the OLAP Cube via Server Settings,
Configuration.

Anyone been able to figure a way to get Formulas (Whether Project or Task)
to show in OLAP?
They show up fine in PWA Views; You'd thinks MSFT would have formulas (eg
Budget Variance RYG based on internal determined thresholds) in the OLAP
Cube...

thx.

 

[Ben Howard]

Would you? MS took a design decision to put look up tables in the OLAP cube;
that's what we live with.

 

[Ray McCoppin]

You can create Calculated Measures in the OLAP cube. But these have to be
MDX Expressions. I have used these to create things like FTE and %Complete.

Hope this Helps
--
Ray McCoppin

http://www.randsmanagement.com
SRS gantt charts
Project Server 2007 Archive Tool