You can grant or restrict access to a model by user or by user group. See Secure a model.
SAS Profitability Management automation allows you to run SAS Profitability Management in batch mode without opening the rich client. You can
- export a model
- import a model
- import an assignment rules table
- import a rule association table
- calculate a model.
See SAS Profitability Management Automation (Run in Batch Mode).
In addition to SAS data sets, Profitability Management now supports the following relational databases for its model data library:
- MySQL 5.0
- ORACLE 11g
- SQL SERVER 2005
Note: You can import the following tables into the model data library. These tables can be any type for which you can create a libref.
Input and Output Tables
Input and output tables can be any type for which you can create a libref.
Input tables Output tables
For more information on supported libraries, see Identify Input and Output Directories to SAS Profitability Management, and the SAS Profitability Management installation instructions.
A report hierarchy defines the dimension hierarchy for drilling into a profit and loss report. A report layout specifies what levels from the report hierarchy will appear on the initial display, and It defines the calculation formula for the profit-and-loss report.
Starting with this release, a model can have multiple report hierarchies, and each report hierarchy can have one or more report layouts so that you can create different reports from the same data.
When calculating a model, you can specify a relatively small number of transaction rows to calculate in order to discover errors in the model such as table schema errors or rule syntax errors. This allows you to validate a model without taking the time to calculate the entire model. See Calculate a Model.
During model calculation, you can request generation of the following exception reports:
- Transaction exception report—lists transaction rows that did not receive an assignment during the calculation.
- Behaviors exception report—lists behaviors that were not assigned to any transaction during the calculation.
See Exceptions Reports.
When you specify formatting in a report for a numeric field, you can now choose the format from a drop-down list of common formats rather than typing it in. Or, you can type the format if it is not offered on the drop-down list. See Define the Display Format for Numbers.
You can change the location of the metadata folder for a model's information maps and cube metadata.
SAS provides a suggested metadata folder of Products/SAS Profitability Management/Models. You can change the default metadata folder, or you can change it with every new model. See Metadata Folder and Folders Tab and Metadata Tab - Server Configuration.
Integrated Windows Authentication allows you to use your Windows password to log onto the Profitability Management rich client. This gives you one less password to remember and means that your Profitability Management password changes along with your Windows password because it is the same.