webi throws error for multisource universe used derived table

[Ganesha]

Hi Expert,

I have created unx universe which uses two oracle conenction, and derived table used in the universe of each caonnection

If I query on this universe in IDT, it works fine.

Same universe published to platform and created webi report, when refreshing it throws error.

if I created single source universe with derived table for each connection, universe works fine in webi reporting, but only problem with combined connection.

please refer the attachment.

we are using BO4.1 SP5 patch3 platform.

I have checked the 1790312 , this is not the cause.

Anybody has faced this problem before?, any suggestion.

thanks in advance.

Regards,

Ganesha

[amitrathi239]

check in the IDT to run some test query and see if it is working there.

[Ganesha]

checked sample query in IDT, it works perfectly, same doesn't work in Webi

[amitrathi239]

try to restart the BO services and see if it will work.

[Former Member]

Hi Ganesha,

Try importing Universe from repository and then export it back again and see if this works.

A similar thread worked with this approach.

Regards

Niraj

[Ganesha]

Hi Niraj,

thanks for quick reply

I tried import and export again, even I have created new universe and tried but doesn't worked.

Regards,

Ganesha