December 05, 2012, 06:22 AM
Mike_LombardiPercentage formatting for SSAS Master file
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?
December 05, 2012, 10:18 AM
Alan BMike
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?
December 06, 2012, 05:26 AM
Mike_LombardiHi Alan
I am using the original fields in a new COMPUTE. Just doesn't like it!!