Creating YTD, PTD provision in Data Model

View previous topic View next topic Go down

Creating YTD, PTD provision in Data Model

Post  ranjitkumars on Fri Jun 08, 2012 2:58 am

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

ranjitkumars

Posts : 7
Join date : 2012-03-15
Age : 37
Location : United Kingdom

View user profile

Back to top Go down

Re: Creating YTD, PTD provision in Data Model

Post  BoxesAndLines on Sun Jun 10, 2012 10:51 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum