Calculated field in OLAP PWA

[LeneG]

Hi
can anyone direct my to a place where I can learn more about
calculated fields in OLAP PWA???
I´d like to know what calculations I can make
i would like to have the deficit between Baseline 10 work and actual
work shown in % and the export it to Excel.
How can i do that?
Actual work/baseline 10 work *100???? Is that possible????

 

[Marc Soester [MVP]]

He Leneg,

The caluclataion is based on MDX which is the OLAP cube query language. You
will probably need to create a formula looking like this

[Actual Work] * 100 / [Baseline 10 work]

That will give you the percentage of actual work in comparison the your
baseline
Otherwise google MDX statements and I am sure you will find lots of useful
things
Hope this helps

 

[Jonathan Sofer]

If you want to get more information on MDX you can look at this link:

http://msdn.microsoft.com/en-us/library/aa216781(SQL.80).aspx

The function you wanted happens to be fairly simple but FYI, I have found
MDX to be very difficult to use when you start trying to pull more complex
data out of OLAP.

Jonathan

He Leneg,

The caluclataion is based on MDX which is the OLAP cube query language.
You
will probably need to create a formula looking like this

[Actual Work] * 100 / [Baseline 10 work]

That will give you the percentage of actual work in comparison the your
baseline
Otherwise google MDX statements and I am sure you will find lots of useful
things
Hope this helps
--
Marc Soester [MVP]
National Manager: EPM
http://marcsoester.blogspot.com

Hi
can anyone direct my to a place where I can learn more about
calculated fields in OLAP PWA???
I´d like to know what calculations I can make
i would like to have the deficit between Baseline 10 work and actual
work shown in % and the export it to Excel.
How can i do that?
Actual work/baseline 10 work *100???? Is that possible????