Skip to main content

Adhoc Reports Chart

  • The main purpose of ad-hoc reporting is to give more power to end-users in retrieving and analyzing the business data. Chart widget will enable users to create customized charts using their own data to create insightful visualizations.

Objective

  • Create Adhoc Report using Chart

Prerequisite

  • Used Sales.cds for this example.

Download adhoc_analysis.zip file from link given adhoc_analysis.zip.

  • After downloading the zip file, add the Sales.cds into the Dataset Section of OPNBI for this example. To add it into OPNBI follow this Link.

Adhoc - Report Chart: This video contains information regarding How to Create Adhoc Report using Chart in OPNBI.

Steps to Create Adhoc Report using Chart

  1. Login to OPNBI using your credentials.

  2. Go to Hamburger Docusaurus Slash Introduction icon > Documents > Adhoc Report

    Docusaurus Slash Introduction

  3. There are two ways in which a user can Create Adhoc Report.

I. Clicking on Adhoc Report located at the bottom-most toolbar.

Docusaurus Slash Introduction

II. By right-clicking the any existing user can also create Adhoc Report.

Docusaurus Slash Introduction

  1. On clicking the Create Adhoc option, from one of the methods mentioned above user will see the window as below:

    Docusaurus Slash Introduction

  2. Drag & Drop Chart component to the empty area as shown below:

    Docusaurus Slash Introduction

info
  • If user wants to add two or more components in report, then they can drop another component in the empty area below the first component as shown below:

    Docusaurus Slash Introduction

  1. As user perform the above step, window will look as per the image below:

    Docusaurus Slash Introduction

  2. Now from the drop-down list of Datasets select the Sales.cds as follows:-

    Docusaurus Slash Introduction

  3. You will see all the columns of the Dataset under Dataset Columns.

  1. Now drag and drop productLine in Category (X) Series and extendedPrice to Values as shown below:

    Docusaurus Slash Introduction

  2. Click on the Docusaurus Slash Introduction icon at right next to Values below dialog box will appear:

    Docusaurus Slash Introduction

  3. Click on SUM from the Function drop-down & Click on Submit button.

  4. Select Bar Chart from the Main Chart drop-down as below:

    Docusaurus Slash Introduction

  5. Select LANDSCAPE VIEW from the Birt Template drop-down as shown.

    Docusaurus Slash Introduction

  6. You can also specify the number of records you want to show on a page from the following widget near the template selector widget:-

    Docusaurus Slash Introduction

  7. User can select format in which they want to run the report from the drop-down near to RUN option.

    Docusaurus Slash Introduction

  8. For this example, we select Run as HTML.

  9. To run the Adhoc Report using Table Component, click on Run in the top most right corner as follows:-

    Docusaurus Slash Introduction

  10. Click on RUN option, which will open the following dialog box:-

    Docusaurus Slash Introduction

  11. As the table has no parameters, just click on SEND button & it will redirect you to another screen of the browser.

  12. The Adhoc Report using Chart component will be generated in HTML.

    Docusaurus Slash Introduction

  13. If you want to save your report you can click on the Save Docusaurus Slash Introduction button at the topmost right corner below admin which will open the following dialog box:-

    Docusaurus Slash Introduction

  14. You can give your own Name in the selected column, and select Save As a Report / Template.

  15. For this example; give Name: Adhoc Chart & Select Save As: Report and click on submit button to perform the save operation.

  16. If you want to change the settings of a widget click on Docusaurus Slash Introduction below Run which will open the following dialog box:-

    Docusaurus Slash Introduction

  17. Here you can change the Name, Width, Height, Visibility and Page Break of your table & click on Submit button to save the changes.

  18. Similarly press Docusaurus Slash Introduction in order to delete the chart widget.

    To know more abour Adhoc Reports features follow below Links:-

Table

Annotation

Image

Annotations

Text

Pivot

Report

Predefined Component