Previous Topic  Next Topic

Working With Dashboards

Similar to reports, dashboards can be created or run directly from your application. JDashboard uses /{context_root}/dashboard/app/entry/run.jsp as the URL entry. Here {context_root} is the servlet's context root when deployed in a WAR or EAR file as a servlet.

Select the following links to view the topics:

• Creating a New Dashboard
• Visiting a Dashboard as the Server Home Page
• Opening Specific Dashboards
• Opening Dashboards and Reports via One URL

Creating a New Dashboard

To create a new dashboard from URL, simply use /{context_root}/dashboard/app/entry/run.jsp.

For example, run the URL http://localhost:8888/dashboard/app/entry/run.jsp, and JDashboard will be opened with a new blank dashboard in it. You can then begin to build your dashboards.

Visiting a Dashboard as the Server Home Page

After a dashboard has been set as the server console home page, you can use a URL to access the home page.

Property: jrd_lastsession
Value: true/false
Examples:

• http://localhost:8888/dashboard/app/entry/run.jsp?jrd_lastsession=true
• http://<IP>:<port>/jreport/dashboard/app/entry/run.jsp?jrd_lastsession=true, here jreport is the servlet context root.

Opening Specific Dashboards

Logi Report provides properties for developer users to run dashboards via URLs. Some properties are encapsulated as JSON (JavaScript Object Notation) objects. Therefore, it will help if you obtain some knowledge on JSON to understand the syntax more clearly. When composing the URL, you need to use URL encoding to avoid errors. To encode URLs by JavaScript, the function encodeURI is recommended.

• jrd_resext={
  "active":0, // The index number of the dashboard that will be active once JDashboard is loaded. 0 means the first dashboard specified in the value list of the property "reslst", 1 the second dashboard, 2 the third, and so on.
  "reslst":[
  // Specifies the dashboards to open. The order of the dashboards specified here reflects the order they are displayed in JDashboard.
  

  {
  "name":"DashboardFileNameWithFullPath", // The dashboard file name with its full path. The path could be a disk path or a server resource tree path. For the latter, it could be either in the Public Reports folder - "/", or in the My Reports folder - "/USERFOLDERPATH/username/" (change username to the real user name with which you log onto Logi Report Server).
  "ver":-1, // Optional. The version number of the dashboard. -1 means the latest version.
  "real":false, // Optional. Value: true/false. "true" means the resource path is a real disk path and "false" means a server resource tree path. When it is a real path, "real":true must be specified.
  "type":40, // Indicates it is a dashboard.
  "param_page":true, // Optional. Value: true/false. It specifies whether to pop up the parameter dialog box if the dashboard uses parameters.
  "dsh_params":[
  // Specifies the parameter values used in the dashboard.

  {
  "lc_names":["lc1","lc2",...], // Optional. lc1 and lc2 can be either of the following:

  • The names of the library components in the dashboard, with full path in the server resource tree, either in the Public Components folder - "/COMPONENT_LIB/", or in the My Components folder - "/USERFOLDERPATH/username/" (change username to the real user name with which you log onto Logi Report Server). For example, /COMPONENT_LIB/SampleReports/Sales Bar.lc, /USERFOLDERPATH/admin/Shipments Table.lc
  • The IDs of the library components. The ID of a library component can be known in the library component's About panel. To access the panel, select on the title bar of the library component and select About from the drop-down list.

  "jrd_params":{"parameter1":"value1","parameter2":["value1","value2",...]} // If lc_names and jrd_params are specified together, the parameters here are applied to the library components given by lc_names, otherwise to the dashboard. When both dashboard level and library component level parameters exist in the URL, the order to apply parameters will be: the dashboard first, and then the library components. When several library components are the same in the dashboard, the parameters specified to one of them will also work on the others. In the case when the URL does not specify parameters for a specific library component but the dashboard level parameters are available, if later a new library component is added into the dashboard, it will use the parameter values in the URL. When a library component is set to use a new connection in the URL, then when adding it into the current dashboard, the library component uses the new connection.

  }

  ],

  "dsh_datasources":[
  // Specifies the data source used in the dashboard.

  {
  "lc_names":["lc1","lc2",...], // Optional.
  "jrd_datasources":[{datasource1},{datasource2},...] // If lc_names and jrd_datasources are specified together, the data sources here are applied to the library components given by lc_names, otherwise to the dashboard. When both dashboard level and library component level data sources exist in the URL, the order to apply data sources will be: the dashboard first, and then the library components. When several library components are the same in the dashboard, the data source specified to one of them will also work on the others. The property "ds" is optional. If "ds" is not specified, the new connection here applies to all involved data sources. If "ds" is specified, the new connection applies only to the same data source as that specified by "ds".

  }

  ],

  "dsh_filters":{

  "osf":[
  // Specifies values of the on-screen filters in the dashboard. There are two ways to designate an on-screen filter. One is by the field that is bound with the filter (recommended) and the other by the instance name of the filter.

  {
  "field":{
  // Specifies a field that is bound with an on-screen filter and the values of the field.

  "type":2, // Indicates that the data resource type is business view.
  "ds":"DataSource 1", // The data source name.
  "bv":"BV 1", // The business view name.
  "name":"Customers.Country" // The qualified display name of the field.

  },
  "reverse":false, // Optional. If true, the values of the field are those not specified in the "values" property below.
  "selectAll":false, // Optional. If true, it means to apply all the values at runtime and ignore the "values" property below.
  "values":["USA","China"] // The values of the field.
  },

  {
  // Specifies an on-screen filter and its values.

  "name":"fc1", // The instance name of an on-screen filter. For a runtime filter control, that is a filter control created in JDashboard, the name is a fixed value "RFC". When there are more than one runtime filter control in the dashboard, you need to specify the "lc_names" property below to avoid empty data components, because runtime filter controls have the same instance name, and if library components are not specified, the values specified by the "values" property below will be applied to all the runtime filter controls in the dashboard and this will result in that the runtime on-screen filters the value lists of which do not contain the specified values retrieve no data to the corresponding data components.
  "reverse":false, // Optional. If true, the values of the on-screen filter are those not specified in the "values" property below.
  "selectAll":false, // Optional. If true, it means to apply all the values at runtime and ignore the "values" property below.
  "lc_names":["lc1","lc2",...], // Optional. Specifies the library components to which the on-screen filter belongs. If the property is not provided, the scope is the dashboard.
  "values":["USA","China"] // The values of the on-screen filter.
  },

  ]

  }

  },

  ... // Specifies more dashboards following the above format.

  ]

  }

• jrd_dashboard_mode
  // Optional. Specifies which mode is available in JDashboard. The value could be:
  • view - Opens JDashboard in the view mode. Execute permission is required.
  • edit - Opens JDashboard in the edit mode. Edit permission is required.
  If you do not have the corresponding permission on the dashboard, the dashboard will fail to run. When this property is not provided in the URL, the default mode of JDashboard specified in the server profile will be applied.
• catalog_security=[
  // Optional. Specifies the security file you want to apply to a catalog when running dashoard.

  {

  "catalog_name":"resource path of the catalog",
  "security_file_name":"name of the security file"

  }

  ]

Examples:

• http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/SampleReports/Dashboard - Sales by Country.dsh","ver":-1}]}
• http://<IP>:<port>/jreport/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","ver":-1}]}, here jreport is the servlet context root.
• http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh"},{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh"}]}

  In this case, JDashboard displays Dashboard 2.dsh and Dashboard 1.dsh following the order from left to right, and Dashboard 1.dsh is active by default.

• http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh"},{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh"}]}&jrd_dashboard_mode=view

  The difference between this example and the second one above is that this URL runs JDashboard in the view mode while the above example runs JDashboard in the mode set in the server preference.

• Set parameters for dashboard only:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","dsh_params":[{"jrd_params":{"P_StartDate":"01/01/2006","P_EndDate":"12/31/2007"}}]}]}

• Set parameters for library components only:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","dsh_params":[{"lc_names":["/COMPONENT_LIB/SampleReports/Country Sales by Category.lc","/COMPONENT_LIB/SampleReports/Sales Bar.lc"],"jrd_params":{"P_StartDate":"01/01/2006","P_EndDate":"12/31/2007"}}]}]}

• Set parameters for both dashboard and library components:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","dsh_params":[{"jrd_params":{"P_StartDate":"01/01/2006","P_EndDate":"12/31/2007"}},{"lc_names":["/COMPONENT_LIB/SampleReports/Country Sales by Category.lc","/COMPONENT_LIB/SampleReports/Sales Bar.lc"],"jrd_params":{"P_StartDate":"01/01/2006","P_EndDate":"12/31/2007"}}]}]}

• Set on-screen filter values:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","dsh_filters":{"osf":[{"field":{"type":2,"ds":"DataSource 1","bv":"BV 1","name":"Customers.Country"},"values":["USA","China"]}]}}]}

• Run a dashboard from the real path:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/home/admin/Jinfonet/Server/history/1/admin959238972/demo1.dsh","ver":-1,"real":true}]}&jrs.authorization=YWRtaW46YWRtaW4%3D

• Run a dashboard with a security file:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh"}]}&catalog_security=[{"catalog_name":"/USERFOLDERPATH/admin/demo.cat","security_file_name":"demo.xml"}]

• Run a dashboard using another data source connection:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 1.dsh","dsh_datasources":[{"jrd_datasources":[{"ds":"Data Source 1","uid":"test","pwd":"1234","type":0,"url":"jdbc:oracle:thin:@127.0.0.1:1521:ora8i","driver":"oracle.jdbc.driver.OracleDriver"}]},{"lc_names":["/COMPONENT_LIB/SampleReports/Country Sales by Category.lc","/COMPONENT_LIB/SampleReports/Sales Bar.lc"],"jrd_datasources":[{"ds":"Data Source 1","uid":"test","pwd":"1234","type":0, "url":"jdbc:oracle:thin:@127.0.0.1:1521:ora8i","driver":"oracle.jdbc.driver.OracleDriver"}]}]}]}

  Note: In the case when the URL does not specify a data source connection for a specific library component but a dashboard level connection is available, if later a new library component is added into the dashboard, it will use the connection in the URL.

Opening Dashboards and Reports via One URL

It is similar to opening multiple dashboards.

jrd_resext={

"active":0, // The index number of the dashboard/report that will be active once JDashboard is loaded. 0 means the first dashboard/report specified in the value list of the property "reslst", 1 the second, 2 the third, and so on.
"reslst":[

// Specifies the dashboards and reports to open. The order of them specified here reflects the order they are displayed in JDashboard.

{

"name":"ResourceFileNameWithFullPath", // The dashboard/report file name with its full path. The path could be a disk path or a server resource tree path. For the latter, it could be either in the My Reports folder (/USERFOLDERPATH/admin/) or in the Public Reports folder (/).
"ver":-1, // Optional: The version number of the dashboard/report. -1 means the latest version.
"real":false, // Optional. Value: true/false. true means the resource path is a real disk path and false means a server resource tree path. When it is a real path, "real":true must be specified.
"type":xx, // Indicates the type of the resource. Value: 40/44/45. 40 means it is a dashboard, 44 a web report, and 45 a page report.
"param_page":true, // Optional. Value: true/false. It specifies whether to pop up the parameter dialog box if the report uses parameters.
"dependence":{ // For reports only.

"catalog":{ // Specifies the catalog of the report.

"name":"ResourcePath/CatalogName", // The resource path of the catalog used by the report. It could be a disk path or a server resource tree path.
"ver":-1, // Optional. The version number of the catalog. -1 means the latest version.
"real":false // Optional. "true" means the resource path is a real disk path and "false" means a server resource tree path.

}

},
"dsh_datasources":[
// Specifies the data source used in the dashboard/report. For a dashboard, one or more groups can be specified. For a report, only one can be specified.

{

"lc_names":["lc1","lc2",...], // Optional. Only for dashboards.
"jrd_datasources":[{datasource1},{datasource2},...] // See Opening Web Reports in Web Report Studio Via JSONfor more information about using the property for web report.

}

],

"dsh_params":[
// Specifies the parameter values used in the dashboard/report. For a dashboard, one or more groups can be specified. For a report, only one can be specified.

{

"lc_names":["lc1","lc2",...], // Optional. Only for dashboards.
"jrd_params":{"parameter1":"value1","parameter2":["value1","value2",...]}

}

]

},

...

// Another way to specify a report to open.

{

"name":"a part of running report URL", // Specifies a part of a URL as the value. The URL should be the one used for running the report via the tryView.jsp or runReport.jsp. The value extracts the URL part started with "tryView.jsp" or "runReport.jsp" and encodes the URL reserved words such as "?" and "&". For example, the extracted original URL is "tryView.jsp?jrs.cmd=jrs.try_vw&jrs.report=%2fSampleReports%2fShipment Status Report.wls&jrs.catalog=%2fSampleReports%2fSampleReports.cat&jrs.result_type=8", the encoded URL that can be set as the value will be "tryView.jsp%3Fjrs.cmd%3Djrs.try_vw%26jrs.report%3D%2FSampleReports%2FShipment Status Report.wls%26jrs.catalog%3D%2FSampleReports%2FSampleReports.cat%26jrs.result_type%3D8".
"type":46/47 // The type of the report. Value: 46/47. 46 means it is a web report, 47 a page report.

}

]

}

Examples:

• Open a dashboard and a report:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh","ver":-1},{"name":"/SampleReports/Shipment Status Report.wls","ver":-1,"type":44,"param_page":true,"dependence":{"catalog":{"name":"/SampleReports/SampleReports.cat","ver":-1}}}]}&jrs.authorization=YWRtaW46YWRtaW4%3D

• Open a dashboard, a web report, and a page report:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh","ver":-1},{"name":"/SampleReports/Sales Detail Report.wls","ver":-1,"type":44,"dependence":{"catalog":{"name":"/SampleReports/SampleReports.cat","ver":-1}}},{"name":"/SampleReports/Payroll Report.cls","ver":-1,"type":45,"dependence":{"catalog":{"name":"/SampleReports/SampleReports.cat","ver":-1}}}]}&jrs.authorization=YWRtaW46YWRtaW4%3D

• Open two dashboards and a report in the view mode of JDashboard:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":0,"reslst":[{"name":"%2fSampleReports%2fPayroll Report.cls","ver":-1,"real":false,"type":45},{"name":"/SampleReports/Dashboard - Medicare.dsh","ver":-1},{"name":"%2fSampleReports%2fCoffee%20Sales.wls","ver":-1,"real":false,"type":44}]}&jrd_dashboard_mode=view&jrs.authorization=YWRtaW46YWRtaW4%3D

• Open a dashboard by specifying the name and path and two reports by specifying the URL:

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh","ver":-1},{"name":"tryView.jsp%3Fjrs.cmd%3Djrs.try_vw%26jrs.report%3D%2FSampleReports%2FShipment Status Report.wls%26jrs.catalog%3D%2FSampleReports%2FSampleReports.cat%26jrs.result_type%3D8","type":46},{"name":"tryView.jsp%3Fjrs.cmd%3Djrs.try_vw%26jrs.report%3D%2fSampleReports%2fCorporate+Overview.cls%26jrs.catalog%3D%2fSampleReports%2fSampleReports.cat%26jrs.result_type=8","type":47}]}&jrs.authorization=YWRtaW46YWRtaW4%3D

  http://localhost:8888/dashboard/app/entry/run.jsp?jrd_resext={"active":1,"reslst":[{"name":"/USERFOLDERPATH/admin/Dashboard 2.dsh","ver":-1},{"name":"runReport.jsp%3Fjrs.cmd%3Djrs.try_vw%26jrs.report%3D%2FSampleReports%2FShipment Status Report.wls%26jrs.catalog%3D%2FSampleReports%2FSampleReports.cat%26jrs.result_type%3D8","type":46},{"name":"runReport.jsp%3Fjrs.cmd%3Djrs.try_vw%26jrs.report%3D%2fSampleReports%2fCorporate+Overview.cls%26jrs.catalog%3D%2fSampleReports%2fSampleReports.cat%26jrs.result_type=8","type":47}]}&jrs.authorization=YWRtaW46YWRtaW4%3D

Previous Topic  Next Topic