Cognos Analytics with Watson

 View Only
  • 1.  Custom SQL query - Data Module

    Posted Wed October 19, 2022 09:17 AM
    Hello,

    How do I define a custom SQL query within a data module?

    Thanks in advance,
    Elmedin


    ------------------------------
    Elmedin Cancar
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Custom SQL query - Data Module

    IBM Champion
    Posted Wed October 19, 2022 10:54 AM
    Hi Elmedin,

    You can create a table using SQL. You need to right-click on the data module line, then choose Table using SQL.


    then

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 3.  RE: Custom SQL query - Data Module

    Posted Wed October 19, 2022 01:45 PM

    With a SQL table.  

    The question which needs to be asked is why would you want to do that, especially given Cognos proven practices for modelling?   SQL tables should be understood as to be used in the last resort.



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 4.  RE: Custom SQL query - Data Module

    Posted Fri October 28, 2022 07:23 AM
    What version is this from?  Because my 11.0.13 sub menu is very different.

    ------------------------------
    Brian Hobbs
    ------------------------------



  • 5.  RE: Custom SQL query - Data Module

    IBM Champion
    Posted Fri October 28, 2022 08:23 AM
    Hi Brian,

    It is v11.2.1. Current version is v11.2.3.

    v11.0.13 is a very old version, it was released nearly 4 years ago.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------