Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Replacing query source on dataset page

    Posted Tue November 09, 2021 07:15 AM
    I have a dataset and have multiple queries and joins.  The database page is pointing at the 1st query and I need it to point to the last query.  Anyone know how this can be done?

    ------------------------------
    Rick Van Enkevort
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Replacing query source on dataset page
    Best Answer

    Posted Wed November 10, 2021 05:03 AM
    Edited by System Admin Fri January 20, 2023 04:10 PM
    Hi Rick.

    There is a Button under the list to reset the columns. Then you can add data items from a new query.
    The reference changed automatically.

    For deeper editing: You can copy the XML in the clipboard then to a report and then back to the dataset.
    The list will be empty and you can drag and drop the columns from an other query to the list.
    Jens

    ------------------------------
    Jens Bäumler
    Senior Consultant and Trainer
    Apparo Group
    ------------------------------