Union in report using DMR model

[mrcool]

Hi All,

I am using sample DMR model provided by cognos to do a simple union between to queries. I am getting error while testing the union query. Attached report xml for your reference. Could you please point out the problem in the report.

Unable to perform a union on two queries from Dimensionally Modeled Relational sources: RQP-DEF-0537

Cheers,
MC

[MFGF]

The crux of this is that you don't need unions with dimensional queries - these are inherent in the fact that you can add whatever members or sets you like to the rows and columns, and use powerful dimensional functions to manage how these are treated in the report.

Can you tell us what you are trying to achieve?

Regards,

MF.

[mrcool]

Thanks MFGF for your reply..Actually I was just testing a simple union using DMR.Same example with cube as a source worked. So just want to know the reason for the same.

Thanks,
MC

[MFGF]

The reason is you simply don't need to. Whatever you were unioning, just stack as rows or columns in your crosstab - all in a single query.

Regards,

MF.