When you disable the Auto Refresh Report feature in Analyze, you can design your report layout first, including calculations and filtering, without querying the database until you are done. Once the report layout is complete, you can re-enable Auto Refresh Report. Data retrieval will occur once and your report will display the requested data.
Follow the instructions below to disable auto refresh and build a report.
| 1. | In the BDNA User Console User Console, go to the Create Reports drop-down and select Analyze Report. BDNA User Console opens. |
| 2. | Select your Data Source, (schema and cube), Technopedia: Hardware from the list. |
| 3. | Uncheck the Auto Refresh Report box. |
Note • Auto Refresh Report is enabled by default.
Select Data Source Screen
| 4. | Click OK. The Analyze workspace appears. |
| 5. | To begin creating your report layout, select a field and drag it to the Layout panel at the left of the workspace. |
Layout Screen
A message appears when you place the first field allowing you to refresh the report. Right-click menus are available for each of the fields you have dragged to the field layout area. You can continue to build your report and only query the database when the layout is complete. You will build your report in the field layout area exclusively while Auto Refresh is disabled. The blue carpenter square icons denote Measure items and the yellow steps icons denote Level items. They also indicate the position of the fields once they are placed in the report. Notice that the Analyze workspace is disabled (greyed out) if you are not in live query mode
Note • Click the enable/disable Auto Refresh button in the toolbar to toggle between the two modes.
| 6. | When your report is complete, click Refresh in the pink band of the field layout area. Alternatively, use the toggle button. |
The Analyzer report updates based on the report definition and displays the results. You can continue to edit the report as needed and click Refresh, or enable the Auto Refresh ability to run the query again.
BDNA Data Platform 5.5 User Console Help Library02 August 2016 |
Copyright Information | Flexera |