One of the key strengths of a SuperSTAR database is the inclusion of unit record data. The Record View feature lets you view and download the individual unit records that make up the values in the table.
You might want to use this feature for auditing and verification purposes, or you can use it to create a marketing campaign to target specific customers.
When is Record View Available?
Record View is only available if the administrator has enabled Record View access on this database and enabled the Record View feature in the SuperWEB2 configuration, and if you are connecting to an SXV4 database that contains unit record data (Record View will not be available if you are viewing an SXV4 cube, as this only contains aggregated data).
If you have access to the Record View feature you will see the RecordVIEW button at the top of the table area, and when you move the mouse pointer over the table cells it changes to a cross.
Click a cell to select it; click again to clear the selection:
Access Record View
To use Record View:
- Create your table and run the cross tabulation to retrieve data.
Select the cells you are interested in, and then click RecordVIEW:
The Unit Records dialog displays:
Use this dialog to select the fields you want to see in the downloaded records: select from the fact tables and groups in the list on the left to see the available fields, and then select the check boxes for each field you want to download.
When you have finished selecting all the fields you want to download, click Retrieve Records >>
The Unit Records dialog displays the returned records:
- You can now choose to either change the field selection (click << Select Fields) or download the data in CSV format (click Download).