Creating YTD, PTD provision in Data Model
2 posters
Page 1 of 1
Creating YTD, PTD provision in Data Model
Hi,
I would require your advice on Data Modeling front for provision YTD & PTD metrics for Reports.
ETL tool used in Neoview SQL
Reporting Tool is Pentaho (User SQLs, the tool does not generate Queries)
The architecture has no cubes and it is older version of Pentaho.
Give the above constraints, we are required to provide a best fit solution for getting YTD, PTD metrics.
If the solution is completed implemented in report query, then performance of Report takes a major hit.
We do not have YTD, PTD attributes in the Datamodel. As of now Report query is generating these metrics and performance is taking a hit.
I prefer to share the load between ETL and Reporting tool. What changes in the Data model is required to make sure the SQL is split between ETL and Reporting.
If I add YTD, PTD metrics to the tables, will that be the best solution for Reporting.
Please share your thoughts and experience ASAP.
Thanks,
Ranjit
I would require your advice on Data Modeling front for provision YTD & PTD metrics for Reports.
ETL tool used in Neoview SQL
Reporting Tool is Pentaho (User SQLs, the tool does not generate Queries)
The architecture has no cubes and it is older version of Pentaho.
Give the above constraints, we are required to provide a best fit solution for getting YTD, PTD metrics.
If the solution is completed implemented in report query, then performance of Report takes a major hit.
We do not have YTD, PTD attributes in the Datamodel. As of now Report query is generating these metrics and performance is taking a hit.
I prefer to share the load between ETL and Reporting tool. What changes in the Data model is required to make sure the SQL is split between ETL and Reporting.
If I add YTD, PTD metrics to the tables, will that be the best solution for Reporting.
Please share your thoughts and experience ASAP.
Thanks,
Ranjit
ranjitkumars- Posts : 7
Join date : 2012-03-15
Age : 43
Location : United Kingdom
Re: Creating YTD, PTD provision in Data Model
Summarizing metrics by day, month, YTD, MTD, are all a function of filtering on the date dimension. If your date dimension does not support this reporting, add the appropriate columns.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Creating a data model for pregnancy
» creating dimensional model of log data
» Question - creating a dimensional model for facility management
» Question - creating a dimensional model for incident management
» Newbie Creating a Data Mart
» creating dimensional model of log data
» Question - creating a dimensional model for facility management
» Question - creating a dimensional model for incident management
» Newbie Creating a Data Mart
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|