Original Message:
Sent: Wed November 09, 2022 04:22 PM
From: Mark Fry
Subject: "Lookup Reference" property disabled (grayed out)
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!
MF.
------------------------------
Mark Fry
Technical Consultant
Original Message:
Sent: Wed November 09, 2022 10:07 AM
From: Milan Milovanovic
Subject: "Lookup Reference" property disabled (grayed out)
I got information why is this happening.
It is because our Cognos model is made in Compatible mode, but it should be made in Dynamic mode for properties to be enabled.
I don't know what Compatible and Dynamic means, but now I know that this is something I can not change.
------------------------------
Milan Milovanovic
Original Message:
Sent: Wed November 09, 2022 03:50 AM
From: Milan Milovanovic
Subject: "Lookup Reference" property disabled (grayed out)
------------------------------
Milan Milovanovic
------------------------------
#CognosAnalyticswithWatson