I have the following calculation in my SSAS cube

([Measures].[Sales] / [Measures].[Quotes])
The format Sting is set to "Percentage"

When using this in Excel or Proclarity this is displayed as a percentage and is automatically multiplied by 100. In webfocus it simple shows the value.

Ie
Quote = 250
Sale = 100
NCR = 0.4
Excel and proclarity show this as 40% where as webfocus simply shows 0.4

The SSAS adaptor is not considering the "Percentage" set within the cube as the master file generates the following...

FIELDNAME=A_NCR, ALIAS='A NCR', USAGE=D21.18, ACTUAL=D8,
MISSING=ON,
TITLE='A NCR', MEASURE_GROUP=Undefined,
PROPERTY=MEASURE, $

Changing the USAGE to D21.18% simply places a % to the value, but does not multiply by 100.

Normally in a Master I would create a COMPUTE to apply the multiplication. However I cannot do this on a SSAS master file. If I try, Dev Studio crashes.

This means I am left with the following 2 options
1. Apply the multiplication as COMPUTES witin all my reports
2. Amend the calculation in the cube to "standard" and apply the multiplication there

Have I missed something or is this really the only 2 options I have?

Mike

A COMPUTE within the SSAS mfd should not cause DS to crash. Are you using the original fields, (Sales/Quotes)*100 or A_NCR*100?

Hi Alan

I am using the original fields in a new COMPUTE. Just doesn't like it!!