Cognos Analytics

 View Only
  • 1.  Dataset based Queries

    Posted Fri August 21, 2020 12:23 PM
    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


  • 2.  RE: Dataset based Queries

    Posted Fri August 21, 2020 01:18 PM
    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
    ------------------------------



  • 3.  RE: Dataset based Queries

    Posted Fri August 21, 2020 01:49 PM

    Actually I am using Dataset on prompt queries and still can see both Native SQL and MDX queries.

    ------------------------------
    Buddhi Gupta
    ------------------------------