You can now make changes to the data model within Analyzer, such as updating the name of a measure or adding a calculated measure to the model. When you save these changes, they become part of the data source for other users to access. We classify these types of changes to the data model within Analyzer as inline modeling. Inline modeling allows you to add annotations to the data model, primarily through modifying existing measures or by adding calculated measures to a data model. Both of these activities require the 'Manage Data Sources' permission.
Updating the properties on a measure within Analyzer
While creating a report in Analyzer, you may want to make changes to a measure to benefit your team, such as renaming a measure to a more familiar name, adjusting the aggregation type to use an average instead of a sum, or modifying how the measure will display in the report. For example, if you wanted to rename the measure 'QTY' to 'Quantity', you can leverage inline modeling capabilities rather than opening another tool or submitting an IT request. After you save these changes, they now become annotations on the model and will be available to other users who access the data source for reports in Analyzer. For more information on updating measures within Analyzer, see Updating Measure Properties.
When you make updates to measures in Analyzer, these inline modeling changes will be supported by the Streamlined Data Refinery (SDR) process when the model is republished. When creating a data source using the SDR process, from the Build Model job entry, select the Auto Model option for the modeling method. For more information, see Build Model Job Entry.
Save your calculated measure to the data model
You can save your calculated measure to the data source while creating or editing your report in Analyzer so other users can benefit immediately from your work. For example, while editing a report, you create the calculated measure 'Adjusted Sales'. When you add a calculated measure to your 'Market' data source, it now becomes an annotation on the model and it will be available to other users who access 'Market' to create or edit reports in Analyzer. For example, other users can see and use the calculated measure you saved to the data model like any other measure. For more information on creating and editing calculated measures in Analyzer, see Working with Measures in Analyzer and Using Calculated Measures in an Analyzer Report.
Calculated measures may also be added to the model in Pentaho Data Integration (PDI) as part of the SDR process. If a PDI developer is updating the transformation which creates the 'Market' model, she can add annotations in the Annotate Stream step, including calculated measures. After the SDR job is run, the 'Market' model is published to the Pentaho Server and contains the newly added calculated measures which display as measures in Analyzer. For more information on adding calculated measures as annotations in a transformation, see Annotate Stream Step.
Inline modeling changes are changes to the data model and not just the report. As a result, when you save your report after making inline modeling changes, the Undo button is not available. Therefore, it is recommended that you complete all your inline modeling changes, including undoing or redoing those changes, prior to saving the report.