Additional Advanced Reporting Procedures
This section provides additional procedures related to advanced reporting configuration in Desigo CC .
Configure Reporting Templates
Perform the following to add new or configured report templates back to the respective library.
- You have customized the respective library to which you want to add the report templates as per your customization levels.
- (Optional and required only when you want to add the templates to a different library) You have created an Advanced Reporting templates folder in that library.
- In System Browser, select Management View.
- Select Project > System Settings > Libraries.
- Proceed as follows:
- To add the templates to the Advanced Reporting or Energy Reporting libraries: Select the Advanced Reporting Design folder in the Advanced Reporting or Energy Reporting libraries, if you want to add the templates to the Advanced Reporting or Energy Reporting libraries.
- To add the templates to a different library: Select the Advanced Reporting templates folder in the respective library.
- In the Template Configuration tab, open the Import expander.
- Click Browse.
- In the Browse for Folder dialog box, select the folder where the zipped files of the Advanced Reporting templates are located.
- The Advanced Reporting templates from the selected folder are listed in the Import expander.
- In the Import expander, select the files to be imported and click Import.
- On import, the imported files are listed in the Templates expander.
- The zipped files of the report templates are listed in the library.
NOTE:
If an XLS file is used in report templates, it must be equipped with sufficient access rights to prevent unauthorized access.
Create a New Advanced Reporting Templates Folder
- You have customized the library to which you want to add the reporting templates as per your customization levels.
- In System Browser, select Management View.
- Select Project > System Settings > Libraries.
- Select the respective library to which you want to add the report templates and add a new library block.
When adding the library block, ensure that you select the New Advanced Reporting Templates option from the list that displays when you click New .
You can only add one Advanced Reporting templates folder below a libraries folder.
- Enter values into the following fields: Version, Revision, Date, Notes.
- Click Save .
- The Create New Object dialog box displays.
- Enter a name and description for the folder and click OK.
- The Advanced Reporting Templates folder is added to the library.
Change Layout Settings
- Select Applications > Advanced Reporting.
- In the Application Viewer tab, click the Configuration Page.
- The Advanced Reporting Configuration Page displays.
- In the Configuration section, next to Layout Settings, click Edit.
- The Parameter dialog box displays.
- Specify the values for the position of the page number, the current page number with the total number of pages in the report or just the current page number, date/time when the report is generated, display user name, display system name and ID, name of the customer, name of the site, the logo to be displayed on the report, and the page format for the output.
- Click Execute.
- The layout settings for your report are now configured.
Change Data Caching Settings
- Select Applications > Advanced Reporting.
- In the Application Viewer tab, click the Configuration Page.
- The Advanced Reporting Configuration Page displays.
- In the Configuration section, next to Data Caching, click Edit.
- The Parameter dialog box displays.
- Select the Allow Caching check box to allow caching.
- Retain the default values for the default maximum age of cached data, the minimum time before renewal of cache, and the timeout value for concurrent requests.
- Click Execute.
- The Data Caching status is set to
ON
.
Change Caching Settings
- The dependent extension (for example, Energy Reports) for which the caching settings must be configured is added to the Server project along with the Advanced Reporting extension.
- Select Applications > Advanced Reporting.
- In the Application Viewer tab, click the Configuration Page.
- The Advanced Reporting Configuration Page displays.
- In the Configuration section, next to Caching Settings, click Edit.
- The Parameter dialog box displays.
- Specify the values for the maximum resolution of aggregated consumption reports, and the date from when the consumption data is stored.
- Click Execute.
- The caching settings are applied.
Additional Trend Calculation Procedures
Modify a Trend Calculation Object
- Trend Logs are available.
- System Manager is in Engineering mode.
- The default View is set to Show Description.
- Select Applications > Advanced Reporting > Trend Calculations.
- Select a trend calculation object you want to modify, and thereafter click Trend Calculation tab.
- To modify description in the Main expander, enter a new name in the Description field.
- To modify the associated properties, in the List of Trends and Formulas expander, do one or more of the following:
- To add a new Trend Object, select Applications > Trends > Offline Log Objects > [network name] > Hardware > [automation station] > [offline trendlog object].
NOTE: You can also select either an offline trend log multiple object from Offline Log Objects folder or an online trend log object from Online Log Objects folder.
Drag-and-drop the selected trend log object on the empty text box that displays below Trend Object
- To replace an existing Trend Object, select another trend log object and thereafter drag-and-drop it to the text box that displays below Trend Object containing, an existing one.
- To modify an existing Trended Object for each individual Trend Object, click the drop-down list that displays below Trended Object, and thereafter select the appropriate trended object.
NOTE: You can also drag-and-drop the same offline trend log multiple object, multiple times in the Trend Object text box, so that different trended objects of the same offline trend log multiple object can be configured, in a single trend calculation object.
- To modify an existing selection of Table, Graphics, and Right Axis for each individual Trend Object, select the corresponding checkbox that displays below Table, Graphics and Right Axis.
- To modify an existing formula and the selection of Table, Graphics, and Right Axis, specify a new formula in the Formula field. Thereafter select the corresponding checkbox that displays below Table, Graphics and Right Axis.
- To modify the associated properties, in the Properties expander, do one or more of the following:
- To modify an existing time interval for Time Aggregation, enter a value in the Time field, and thereafter select one of the time units: Minutes, Hours or Days from the drop-down list.
- To modify an existing property of Display in Report, select the corresponding checkbox that displays next to Legend (List of trend and formula), Display graphics, Display table, and Display summary table.
- To modify an existing property of Additional Display for Report and Export, select the corresponding checkbox that displays next to Average, Summation, Minimum, and Maximum.
- To delete a Trend Object, right-click on the text box that displays below Trend Object, and thereafter click Delete.
- Click Save or Save As .
- (Only for Save As) In the Save Object As dialog-box, select the main Trend Calculations folder or any subfolder under it. Enter a new name and description, and thereafter click OK.
- The modified properties are saved.
NOTE: To create, modify, view and delete trend calculation folders and objects, you must have application rights (Show and Configure) on Advanced Reporting Trend Calculation, and also have Create and Delete scope rights.
Create and Delete a Trend Calculation Folder
- System Manager is in Engineering mode.
- The default View is set to Show Description.
- Select Applications > Advanced Reporting > Trend Calculations.
- Select the Trend Calculation tab.
- Do one of the following:
- To create a new trend calculation folder:
a. Click New trend calculation folder .
b. In the New object dialog box, enter a name and description.
c. Click OK.
- The new trend calculation folder is saved. You can create additional sub-folders as needed.
- To delete a trend calculation folder:
a. Select the folder you want to delete.
b. Click Delete , and thereafter click Yes to confirm.
- The trend calculations folder is deleted.
NOTE: To create, modify, view and delete trend calculation folders and objects, you must have application rights (Show and Configure) on Advanced Reporting Trend Calculation, and also have Create and Delete scope rights.
View Trend Calculation Reports from Related Items
- System Manager is in Engineering mode.
- The default View is set to Show Description.
- Select Applications > Advanced Reporting > Trend Calculations.
- Select a trend calculation object, and thereafter click Trend Calculation tab.
- Navigate to the Related Items tab.
- Click Web Apps, and thereafter select either of the following reports:
- Trend Calculation
- Trend Calculation For XLS
- The report displays in the Secondary pane.
NOTE: To create, modify, view and delete trend calculation folders and objects, you must have application rights (Show and Configure) on Advanced Reporting Trend Calculation, and also have Create and Delete scope rights.