Author Topic: Cognos 10.2.2 - Query Studio busy error when working with Bridge tables  (Read 3982 times)

Offline akshara_a

  • Full Member
  • ***
  • Join Date: Sep 2015
  • Posts: 17
  • Forum Citizenship: +0/-0
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!!