hi everyone,

I have an existing FM package and an uploaded excel file with two columns. (ID, GroupDescrip)in a data module without joins defined in it,only exposed to users.
So i have made a report built using this data module and joined two queries ,one using items from package and one using excel items.the performance are terrible even if the excel file contains 1 row!
I have seen that the report query  on native is only made by the 2, there is no join query ,they are separated ,one for query coning from fm package, one coming from imported excel.
instead on cognos sql the two query are joined.
So why this is happening?it is,i suppose ,doing the join on CA server instead of pushing it on the db that i think is more powerful? Why?
It is beacuse i have not joined them directly inside the data module?
I am using a dqm package with CA 11.1.7 fp2.

Thanks




------------------------------
Magnum BI
------------------------------

#CognosAnalyticswithWatson

That's how Cognos has always behaved with heterogeneous data models. There were some model techniques introduced over the years to improve that but requires a conscious model effort.

For FM see https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=mode-optimizing-joins-by-applying-filters
for DM see https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=relationships-join-optimization

------------------------------
Robert Hofstetter
------------------------------

Original Message:
Sent: Thu June 24, 2021 05:15 PM
From: Magnum BI
Subject: Data module with package and excel,performance issue,local processing?

hi everyone,

I have an existing FM package and an uploaded excel file with two columns. (ID, GroupDescrip)in a data module without joins defined in it,only exposed to users.
So i have made a report built using this data module and joined two queries ,one using items from package and one using excel items.the performance are terrible even if the excel file contains 1 row!
I have seen that the report query  on native is only made by the 2, there is no join query ,they are separated ,one for query coning from fm package, one coming from imported excel.
instead on cognos sql the two query are joined.
So why this is happening?it is,i suppose ,doing the join on CA server instead of pushing it on the db that i think is more powerful? Why?
It is beacuse i have not joined them directly inside the data module?
I am using a dqm package with CA 11.1.7 fp2.

Thanks




------------------------------
Magnum BI
------------------------------

#CognosAnalyticswithWatson