If you are unable to create a new account, please email support@bspsoftware.com

 

Cognos 10.2.2 - Query Studio busy error when working with Bridge tables

Started by akshara_a, 19 Jul 2016 09:25:37 AM

Previous topic - Next topic

akshara_a

Hi All,

I am using Cognos 10.2.2 environment. I have used bridge table to join two facts in Framework manager.
Here is my FM model structure : Fact_PO -> Dim_PO -> Bridge_PO_ORD <- Dim_Orders <- Fact_Orders
When I create a report in Query studio by pulling the fields from both Fact_PO and Fact_Orders, I get an error saying query service is busy.
When I open the report in report studio and generate the query and run it on database it gives me the results in seconds.

Can anyone please help me with this issue.
Thanks in advance!!