Custom Measures

[Former Member]

Hi,

I have several questions for everyone:

1. It is possible to create custom measures permanent and store the information in the underlying tables (MeasureFormula & MeasureFormulaApp). Is it possible to create a custom script command (as with BIDS) permanent?

2. Viewing the default custom measures (e.g. YTD, Periodic), the first command is 'CALCULATE'. Is it possible to permanently move that command from the first position to the 3rd? You can move it down with BIDS, but if you reprocess the model, the CALCULATE reverts to the 1st position.

3. Are there any repercussions to increasing the size of a column in the table MeasureFormula? i.e. increase the Statement column from 1024 to say nvarchar(max)

Thanks,

Edward

[Former Member]

Hi,

Thanks for your reply. To clarify:

1. Within BIDS, in addition to creating a new custom measure, you can create a 'Script Command' This is basicailly a bit of MDX code that will be executed in a similar fashion to a custom measure's MDX formula.

2. The first step in the processing of a Model is its calculation. This is done by a 'Script Command' which initiates the Calculate MDX command. If you enter BIDS and open a model, then select the 'Calculations' tab, you will see the list of BPC measures (YTD, QTD etc.) along with the 'CALCULATE' scipt command. Typically the CALCULATE is first in the list.

3. Thanks for confirming that increasing the size of that field would be okay.

Edward

[Former Member]

Hi,

1. What do you mean by creating a custom script command? Do you want to create a command similar to SELECT statement, which can be used in BPC script logics? If yes, then this is not possible.

2. Which calculate command are you referring to?

3. I dont think there should be any problem in increasing the length of the Statement field.

Hope this helps.