Business intelligence reports with navigable reference indicators

• US 9,697,271 B2
• Filed: 02/18/2014
• Issued: 07/04/2017
• Est. Priority Date: 03/06/2013
• Status: Active Grant

• Current Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Original Assignee: TATA Consultancy Services Limited (Tata Sons Pvt Ltd.)
• Inventors: Riyaz, Malukanparampil Meer Mohammed
• Primary Examiner(s): Alam, Shahid
• Application Number:
  US14/183,017
• Publication Number:
  US 20140258210A1
• Time in Patent Office: 1,232 Days
• Field of Search: 707602, 705 729, 715760
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06Q 10/06393 Score-carding, benchmarking or key performance indicator [KPI] analysis
• CPC Class Codes: G06Q 10/10 Office automation; Time management

Abstract

The present subject matter relates to generation of business intelligence reports with navigable reference indicators. The method comprises obtaining information from an information source for providing in a business intelligence report. Further, report parameters are obtained through a user interface, wherein the report parameters include at least notes and indicator parameters. The notes and indicator parameters indicate a plurality of navigable reference indicators to be included in the business intelligence report. The method further comprises mapping the notes and indicator parameters with the obtained information. Based on the mapping, the business intelligence report is generated with the plurality of navigable reference indicators. Further, the plurality of navigable reference indicators provides a forward and backward link between two or more sections of the business intelligence report.

Claims

1. A computer implemented method for generating business intelligence reports with navigable reference indicators, the method comprising:

obtaining information from an information source for providing in a business intelligence report;

obtaining report parameters through a user interface, wherein the report parameters include at least notes and indicator parameters, wherein the notes and indicator parameters indicate a plurality of navigable reference indicators to be included in the business intelligence report;

mapping the notes and indicator parameters with the obtained information, wherein the mapping further comprises generating database tables based on the report parameters, the database tables comprising at least one of a business intelligence report table, a notes and indicator table, a grain table, and a report note mapping table; and

generating, based on the mapping, the business intelligence report with the plurality of navigable reference indicators, wherein the plurality of navigable reference indicators provide a forward and backward link between two or more sections of the business intelligence report.

2. The method as claimed in claim 1, wherein the notes and indicator parameters are based on a grain defined for the business intelligence report.

3. The method as claimed in claim 1, wherein the notes and indicator parameters include at least one of a unique ID for each note, a unique ID for each navigable reference indicator associated with different notes, note text, indicator text, and language of the text.

4. The method as claimed in claim 1, wherein the report parameters further include grain parameters and report note mapping parameters.

5. The method as claimed in claim 4, wherein the grain parameters are indicative of a grain defined for the business intelligence report.

6. The method as claimed in claim 1, wherein the mapping further comprises obtaining at least one dimension table corresponding to the report parameters, based on the database tables.

7. The method as claimed in claim 6, wherein the at least one dimension table is obtained based on an extraction, transformation, and loading (ETL) process.

8. The method as claimed in claim 1, wherein the mapping further comprises populating at least one fact table with the information obtained from the information source, the populating being based on the report parameters.

9. A business intelligence system for generation of business intelligence reports with navigable reference indicators, the business intelligence system comprising:

a processor; and

a memory coupled to the processor, the memory comprising;

a parameter module configured to, obtain information from an information source, wherein the information is provided in a business intelligence report; and

obtain report parameters, wherein the report parameters include at least notes and indicator parameters, the notes and indicator parameters indicative of a plurality of navigable reference indicators to be included in the business intelligence report, and wherein the notes and indicator parameters are based on a grain defined for the business intelligence report;

a transformation module configured to map the notes and indicator parameters with the obtained information, wherein the transformation module is further configured to generate database tables based on the report parameters, wherein the database tables comprises at least one of a business intelligence report table, a notes and indicator table, a grain table, and a report note mapping table; and

a report generation module configured to generate, based on the mapping, the business intelligence report with the plurality of navigable reference indicators, wherein the plurality of navigable reference indicators provide a forward and backward link between two or more sections of the business intelligence report.

10. The business intelligence system as claimed in claim 9, wherein the transformation module is further configured to obtain at least one dimension table corresponding to the report parameters based on the database tables.

11. The business intelligence system as claimed in claim 10, wherein the transformation module is further configured to obtain the at least one dimension table based on extraction, transformation, and loading (ETL) process.

12. The business intelligence system as claimed in claim 9, wherein the transformation module is further configured to populate the at least one fact table with the information obtained from the information source, the populating being based on the report parameters.

13. A non-transitory computer-readable medium having embodied thereon a computer program for executing a method comprising:

obtaining information from an information source for providing in a business intelligence report;

obtaining report parameters through a user interface, wherein the report parameters include at least notes and indicator parameters, the notes and indicator parameters being based on a grain defined for the business intelligence report and the notes and indicator parameters being indicative of a plurality of navigable reference indicators to be included in the business intelligence report;

mapping the notes and indicator parameters with the obtained information, wherein the mapping further comprises generating database tables based on the report parameters, the database tables comprising at least one of a business intelligence report table, a notes and indicator table, a grain table, and a report note mapping table; and

generating, based on the mapping, the business intelligence report with the plurality of navigable reference indicators, wherein the plurality of navigable reference indicators provides a forward and backward link between two or more sections of the business intelligence report.