Hi Buddhi,
The generation of MDX is done for crosstab-like queries, this could be for a crosstab widgets, but also for charts that are part of the report.
For datasets, the MDX is processed by the Cognos Server.
There is no setting that allows you to disable that.
// Henk
------------------------------
HENK CAZEMIER
------------------------------
Original Message:
Sent: Fri August 21, 2020 12:22 PM
From: Buddhi Gupta
Subject: Dataset based Queries
Hi All
I see Dataset based queries generated both Native SQL and Native MDX on report. Are they both needed for reporting? Is there any property to be able to generate only Native SQL?
Thanks for any inputs!
------------------------------
Buddhi Gupta
------------------------------
#CognosAnalyticswithWatson