Multi Source Universe _ Performance

[Former Member]

Hi ,

I have created webi report based on multi source using IDT . It working fine in DEV and  but it is working in production .

Both DEv and Prod are same version (BO 4.1 Sp4) .

Could you please let me know where we need to check performance settings related federation services?

Best Regards ,

Reddeppa K.

[amitrathi239]

Hi,

What is the backend database?

What is the records count difference in Dev & Prod?

Are you getting any error message?

Amit

[Former Member]

Hi Amit,

Both are SQL server and same records.

In dev it is taking 10 sec and Prod it is taking infinite time without giving any error message.

Reddeppa.

[amitrathi239]

Hi,

Copy the SQl of the Webi query and run direct on the Data federator Admin tool.You can see the statics of the query there.

Amit

[Former Member]

Thanks for your reply. What is of this tool and can we create any custom SQL from here?

[amitrathi239]

Hi,

It's under the  your BO client installation.Yes you can create custom SQL and see the statics.

See DF admin tool guide.

https://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp2_dfat_guide_en.pdf

Amit