Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
Hi,There are two query engines in Cognos Analytics currently - the old Compatible Query Engine, and the much newer Dynamic Query. Compatible Query has its roots in the Universal Data Access (UDA) layer that used to sit underneath the old Cognos Impromptu and PowerPlay products, which in turn was developed out of the really old Data Management Services (DMS) layer which underpinned Cognos PowerHouse. Compatible Query is a 32-bit query engine, written in C++. It runs outside of the java servlet containers that you see in the Cognos Analytics architecture, and uses older client connection technologies like database native client libraries and ODBC to connect to data sources. Dynamic Query is the newer query engine, written in java, 64-bit, and which supports more modern data sources and ways to connect, such as jdbc. It offers much enhanced query planning and optimization, and is where IBM is investing resources to add new data connections.It doesn't really help you get any further forward in this particular issue, sadly, but at least you now have an understanding of what they mean.Cheers!
I will start lobbying for my company to try to move our data to a newer model.Thank you for the explanation, Mark Fry. I will use your explanation to make my case to my superiors.
This also solves one more thing that was bugging me. I was not able to use several packages in one report. It cannot be done in Compatible model.
I think there's been a miscommunication and, subsequently, you are under the impression that the FM package's query mode is relevant. It is not.
FM packages imported into a data module are read-only references. The greenish colour of the icons is meant to convey that meaning to users. Because the package is a read-only, none of the properties are editable, which you have discovered.
If you wish to you will need to create views in the data module of the query subjects of the FM package which you wish to use in the data module. You do this by either selecting the module root node in the module tree or selecting the FM package and choosing table from the context menu. You would need to create relationships between these views.
It seems that it is possible to use Compatible Package in a Module. In the properties of the package we can see that the package is in Compatible mode (1). I created a module with that package (2). I can use that module to create a report (3) or dashboard (4).
The image (5) bellow is from the internet. It shows "Break link" option. My Cognos doesn't have that option (6). Probably because it can be hidden, as explained here:Break links in linked data modules
As for my problem, Philipp and Ian, you are right. Problem is that the package is read only.Creating a data module for relative date analysisAfter I created Table View (7), all the properties are now available (8).I am glad we resolve this. Fry, Philipp, Ian, thank you for your help.For performance reasons, I will still try to convince my superiors to try to convert the model to dynamic mode.