MDX formula

[David Blair]

Hello,
Using Project Server 2007 with SQL and Analysis Server 2005.
I am using a calculated total in several Data Analysis views to show
Quarterly FTE for Work and Capacity. I'm not sure, but indications are,
manipulating the views with this calculated total hangs IE. I thought I
would try to use an MDX so these totals are built into the cubes. The
Calculated Total I am using for Quarterly FTE Capacity is:
[measures].[capacity]/520 since there are 520 available hours in a
standard Quarter. This works great when it works. Can anyone tell me what to
put in the MDX area of the Cube Configuration page to duplicate this?
Thanks, David

 

[Ben Howard]

You already have the MDX query, so just add this into the cube configuration
area - make sure you have selected the correct cube for the MDX query
(PortfolioAnalyser).
Name the dimension Quaterly Capacity or similiar.

 

[David Blair]

Thanks Ben - I gave it a try and it worked fine. I guess I thought it should
be more complex than that!

David

You already have the MDX query, so just add this into the cube configuration
area - make sure you have selected the correct cube for the MDX query
(PortfolioAnalyser).
Name the dimension Quaterly Capacity or similiar.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Hello,
Using Project Server 2007 with SQL and Analysis Server 2005.
I am using a calculated total in several Data Analysis views to show
Quarterly FTE for Work and Capacity. I'm not sure, but indications are,
manipulating the views with this calculated total hangs IE. I thought I
would try to use an MDX so these totals are built into the cubes. The
Calculated Total I am using for Quarterly FTE Capacity is:
[measures].[capacity]/520 since there are 520 available hours in a
standard Quarter. This works great when it works. Can anyone tell me what to
put in the MDX area of the Cube Configuration page to duplicate this?
Thanks, David

 

[Ben Howard]

Once you have the MDX query the rest is easy...
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Thanks Ben - I gave it a try and it worked fine. I guess I thought it should
be more complex than that!

David

You already have the MDX query, so just add this into the cube configuration
area - make sure you have selected the correct cube for the MDX query
(PortfolioAnalyser).
Name the dimension Quaterly Capacity or similiar.
--
Thanks, Ben.

Please rate this post if it helped.
http://appleparkltd.spaces.live.com/

Hello,
Using Project Server 2007 with SQL and Analysis Server 2005.
I am using a calculated total in several Data Analysis views to show
Quarterly FTE for Work and Capacity. I'm not sure, but indications are,
manipulating the views with this calculated total hangs IE. I thought I
would try to use an MDX so these totals are built into the cubes. The
Calculated Total I am using for Quarterly FTE Capacity is:
[measures].[capacity]/520 since there are 520 available hours in a
standard Quarter. This works great when it works. Can anyone tell me what to
put in the MDX area of the Cube Configuration page to duplicate this?
Thanks, David