Using Universe query as datasource

[Former Member]

Hi,

Iu2019ve created a Webi report by using 2 different queries from the same universe, those 2 queries have some common dimensions that I can use the u201Cmerge dimensionu201D function on Webi to join those queries together, and this Webi report can be completed running within a minute.

For some reason, I've tried to create the same report on CR format which is using the same universe as the Webi report, and perform the data joining from those 2 queries on the report level. However, after exporting to the BOE server and then schedule to run the CR, it run over few hours without complete.

Can anyone advice whatever this is the limitation of CR, and is it not suggested to use more than one universe query on CR?

Thanks!

James

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with your directly