Skip to Content
Former Member
Dec 12, 2011 at 10:37 PM

Custom Measures



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)