Custom Dashboard and Reports in Logi Info Studio
This section applies only if you use the Dashboard using operational data store. Use Logi Info Studio to create custom Dashboard panels based on default KPIs or custom KPIs.
In Logi Info Studio, you create a report and add SQL queries that retrieve numeric event attributes from the operational data store. You then configure a Dashboard panel to display the custom report and deploy the custom Dashboard in Data Integration Hub.
You cannot create custom Dashboard panels based on the following reports:
- •Unresolved Error Events by Partner (eventsbypartnerErrorRepository.lgx)
- •Unresolved Error Events by Account (eventsbyaccountErrorRepository.lgx)
- •Unresolved Error Events by Event Type (eventsbyeventstatusErrorRepository.lgx)
- •Unresolved Error Events by Event Status (eventsbyeventstatusErrorRepository.lgx)
- •Tasks (dxtasks.lgx)
When you create custom reports in Logi Info Studio, you can copy the SQL constants from the default Dashboard and modify them based on the KPIs that you want to display in the Dashboard panels.
You can use the SQL constants with the LogiXML constant token. When Logi Info Studio processes the custom reports, the constant token expands the SQL constants. For example, you use the following SQL query:
select facts.ACCOUNT_ID, sum(EVENT_COUNT) as SUM_COUNT from DX_ODS_EVENT_FACTS facts
where @Constant.DX_ODS_FILTER_TIME_ORACLE~
The LogiXML constant token expands the SQL query to the following SQL query:
select facts.ACCOUNT_ID, sum(EVENT_COUNT) as SUM_COUNT from DX_ODS_EVENT_FACTS facts
where to_timestamp(:requestDateBegin || :requestTimeBegin,'YYYY-MM-DD HH24:MI:SS') <= facts.TIMESLICE
and facts.TIMESLICE <= to_timestamp(:requestDateEnd || :requestTimeEnd,'YYYY-MM-DD HH24:MI:SS')
If you create new parameters for your custom report, you must specify a unique name for each parameter. Otherwise, the Dashboard overrides the existing parameters with the same name or processes the parameter values incorrectly. If you create data layer links, you must specify a unique name for each data layer link in all of the reports. Otherwise, the Dashboard may display incorrect data in the Dashboard panel that you create, such as the wrong date or status.
Installing and Configuring Logi Info Studio
This section applies only if you use the Dashboard using operational data store. You install Logi Info Studio to enhance and create Dashboard panels for Data Integration Hub.
Before you install Logi Info Studio, verify that the Data Integration Hub Dashboard and Reports component is installed on the Data Integration Hub machine and that your system meets the minimum requirements for Logi Info Studio. For more information about the system requirements for Logi Info Studio, refer to Logi Analytics documentation.
1. In the Logi Info Studio installer, choose a custom installation and select to install only the Studio component.
2. Contact Informatica shipping to receive the Logi Info Studio license file.
3. Copy the Logi Info Studio license file to the following folder: <LogiXMLInstallationDir>\LogiStudio
Setting Up the Custom Dashboard
This section applies only if you use the Dashboard using operational data store. You create the custom Dashboard as an application in Logi Info Studio and import the default Dashboard files to Logi Info Studio.
1. In Logi Info Studio, create a Java application.
2. In the Prepare New Application wizard, configure the name and location for the Dashboard application:
3. Skip the remaining Prepare a New Application wizard screens.
4. Copy the contents of the <DIHInstallationDir>\DataIntegrationHub\tomcat\webapps\DIH-dashboard folder to the newly created <DIHInstallationDir>\DataIntegrationHub\tomcat\webapps\<custom_dashboard> folder.
5. Copy the LogiXML license file from the <DIHInstallationDir>\DataIntegrationHub\tomcat\webapps\DIH-dashboard folder to the <DIHInstallationDir>\DataIntegrationHub\tomcat\webapps\<custom_dashboard> folder.
6. In the LogiXML _Settings.lgx file, modify the properties according to the name and location of the custom Dashboard.
7. In the Data Integration Hub server, replace the value of the dx.dashboard.url system property with the value of the URL for the custom dashboard in the following format: http://<host>:<port>/<custom_dashboard>
Creating a Report in the Custom Dashboard Application
This section applies only if you use the Dashboard using operational data store. After you set up the custom Dashboard in Logi Info Studio, you create and configure a report to use in a custom Dashboard panel. You can copy an existing report and modify it as needed.
1. In Logi Info Studio, create a report definition.
2. Select the report filters that you want to provide to the users.
3. Define the SQL parameters for the SQL query to run in the operational data store. You must define the name and type of each parameter.
Adding a Dashboard Panel to the Custom Dashboard
This section applies only if you use the Dashboard using operational data store. After you create a report in Logi Info Studio, you add the custom Dashboard panel and its elements to the main Dashboard report file.
1. In Logi Info Studio, open the custom Dashboard report file.
2. In the dxdashboard element, add a new Panel element with a caption and a unique identifier.
3. In the Panel element, add a Panel Content element.
4. In the Panel Content element, add a SubReport element with a unique identifier and set the property Frame Border to false.
5. In the SubReport element, add a Target.Report element with a unique identifier and enter the name of the new report in the Report Definition File property.
6. Copy the Link Parameters element from an existing SubReport element to the new SubReport element.
7. Save the dxdashboard report file.
Deploying and Testing the Custom Dashboard in B2B Data Exchange
This section applies only if you use the Dashboard using operational data store. After you modify or create a custom Dashboard in Logi Info Studio, you copy the custom Dashboard application folder contents to Data Integration Hub. You then test that the custom Dashboard appears correctly.
1. Copy the entire custom Dashboard application folder to the following location: <DIHInstallationDir>\DataIntegrationHub\tomcat\webapps.
2. Back up the _Setting.lgx file and modify the following settings:
- - Delete the value of the Redirect Error URL property to allow access to the LogiXML error report.
- - Set the value of the Debugger Style property to DebuggerLinks to add links to the LogiXML progress report. The Dashboard panel layout may display differently.
3. Log on to the Operation Console and test that the new Dashboard panels open and populate correctly.
4. After you test the custom Dashboard, restore the properties in the _Setting.lgx file.