Skip to content
Tags

,

Description on calculated measures

2011/09/28

To get a description on a calculated measure you either install BIDS helper and follow this little guide http://bidshelper.codeplex.com or you do the following.

In the XML code for the cube find the tag <CalculationProperties>. Inside this tag it should look something like:

        <CalculationProperty dwd:design-time-name="b85f38de-e526-4e67-89ba-8a399e0572b1">
          <CalculationReference>[Measures].[MeasureName]</CalculationReference>
          <CalculationType>Member</CalculationType>
          <Translations>
            <Translation dwd:design-time-name="a2d45a9d-8213-4d44-9db6-511a97efb363">
              <Language>3082</Language>
              <Caption>Porcentaje de Descuento</Caption>
            </Translation>
          </Translations>
          <Description>Measure Description Here</Description>
        </CalculationProperty>

 

If the measure isn’t there you will have to do some magic. Create a translation for the measure; this puts the measure in the XML then when you have made the XML to look like above you remove the translation again.

Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: