Can we avoid union for creating reports

[inu]

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

[MFGF]

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.

[inu]

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

[MFGF]

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.

[inu]

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

[MFGF]

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.