Business View Formulas
Business View (BV) formulas in the Formula Builder allow you to retrieve and run Angles business views in Spreadsheet Server. These formulas are available to customers with the Designer license for Spreadsheet Server and Angles, access to Platform, and the required permissions for business views. Authorized users can then run the GPXD, GPXI, GPXS, and GPXQ formulas to get the required information from the shared data service. This feature is available for Oracle EBS, NetSuite 2, Deltek Vantage Point, and Deltek Vision ERPs.
| Formula | Description |
|---|---|
GPXD |
Displays detailed results of business views in the spreadsheet. |
GPXI |
Displays the expanded details of business views in the Drill Down panel. |
GPXS |
Displays values returned from business views in the Parameter Selector panel. |
GPXQ |
Displays a single value from the summary portion of business views. |
Follow these steps to create and maintain BV formulas:
- Select the cell to insert the formula or the cell containing the formula.
- From the Spreadsheet Server ribbon, select Formula Builder.
- Select the desired formula under BV Formulas. The selected formula panel displays. If you are updating a formula, the panel displays by default.
Use the following links to access BV formula-specific information:
Related Topics:
- To learn more about insightsoftware Platform, see the Platform Experience Guide.
- To manage Platform users, see Application Configurator Setup for Platform.