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!!