Hi Team,
The requirement is FTD, MTD, PMTD, PYTD , need to created.
I created a separate query for each report item and combined them by using "union".
Like this two reports are there, so total no. of queries are 8, executing at a time. so performance issue.
Can you please suggest me to avoid union and make it one query.
Regards,
Inam
Quote from: inu on 11 Oct 2016 09:05:17 AM
Hi Team,
The requirement is FTD, MTD, PMTD, PYTD , need to created.
I created a separate query for each report item and combined them by using "union".
Like this two reports are there, so total no. of queries are 8, executing at a time. so performance issue.
Can you please suggest me to avoid union and make it one query.
Regards,
Inam
Use a dimensional model?
MF.
Quote from: MFGF on 11 Oct 2016 09:07:42 AM
Use a dimensional model?
MF.
Thanks MF. Can you please kindly tell me how to accomplish this.
As far as i know , in DMR we create hierarchies, what should i do at report level.
Appreciate your response.
Regards,
Inam
Quote from: inu on 11 Oct 2016 09:52:28 AM
Thanks MF. Can you please kindly tell me how to accomplish this.
As far as i know , in DMR we create hierarchies, what should i do at report level.
Appreciate your response.
Regards,
Inam
If you have created calculations for FTD, MTD, PMTD, PYTD in your DMR, then you simply need to drag these in.
Otherwise, create these calculations in your report.
MF.
Quote from: MFGF on 14 Oct 2016 06:13:07 AM
If you have created calculations for FTD, MTD, PMTD, PYTD in your DMR, then you simply need to drag these in.
Otherwise, create these calculations in your report.
MF.
I m using Relational model...
Quote from: inu on 14 Oct 2016 10:44:34 AM
I m using Relational model...
If you are using a relational model you need to use multiple queries with unions. If you are using a dimensional model you do not - that's the point I was making. You should look into building a dimensional model if your requirement is other than a one-off.
MF.