Introduction to Report DataSet Definition
Report DataSet enables to extract HOPEX raw data and show it in tabular form. The Report DataSet Definition describes how to build the Report DataSet.
Report DataSet Definition is only available with HOPEX Power Studio technical module.To build a Report DataSet Definition you must have Expert MetaModel access.Report DataSet Definition creation is performed in both HOPEX Windows Front-End and Web Front-End for users with HOPEX Customizer profile.
Creation and use of Report DataSet are available in both HOPEX Windows Front-End and Web Front-End for all users.
Once a Report DataSet Definition is created, any user can use it to query HOPEX repository and create a Report DataSet. Data first shown in tabular form can then be handled and shown in graphical format using Instant Report feature.
Creating and Defining a Report DataSet Definition: the Big Picture
To create and define a Report DataSet Definition:
1. Define the Report DataSet source data: a MetaClass.
This MetaClass is the root of the tree that represents the set of data collected from the repository.
2. (if needed) Define input parameters:
Property parameters or Collection parameters are used to define both kind of filters on data extraction.
The user is asked to enter these parameters at Report DataSet creation.
• Property parameters
• Collection parameters
3. Define how to populate the Report DataSet:
Define how the input parameters that feed the Report DataSet are retrieved.
4. Define which data type feeds the data collection:
Define the data you want to be displayed in the Report DataSet.
5. Customize the Report DataSet.
6. Preview the Report DataSet.
Once the Report DataSet Definition is created a new Report DataSet Definition folder is added in Report DataSets folder.
The Report DataSet Definition is available for any user to create a Report DataSet.
See "Creating a Report DataSet", page 344.Report DataSet Definition Best Practices
When you create a Report DataSet Definition you should follow the best practices.
Defining the Report DataSet Definition
Define a Report DataSet Definition to create focused Report DataSets, i.e.:
• The Report DataSet should answer a single issue.
For examples: a report, an export of specific data.
• Do not build Report DataSets with huge amount of data that you would use for different purposes.
Optimizing the Report DataSet Definition for better performance
Retrieving the data
When you create a Report DataSet Definition, use the most efficient way to retrieve data.
For example a macro might be more efficient than an ERQL query.
Time monitoring
To identify the column that may introduce performance issues, use the debug log to find out how long it takes to get each column.
To get the time monitoring tool:
1. Access the megasite.ini file (in the <HOPEX installation folder> > Cfg folder).
2. Add:
[Debug]
ReportDataSetGenerationTimeMonitor=1
Keep the last generated Report DataSet
Select the Keep last generated result option so that at next session, the first Report DataSet display time is shorten.
Checking the Report DataSet row count
The Report DataSet size is limited to:
• 10000 rows
• 50 columns
As this maximum size can be reached quickly, check that the Report DataSet includes all the expected rows, so that it does not miss any data.
Rows are produced by multiplication of the object count of each MetaAssociationEnd.
Advice:
If your Report DataSet Definition does not include more than four levels of MetaAssociationEnds or queries the Report DataSet should include all the data.