Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Custom SQL query - Data Module

    Posted 10/19/22 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

    Posted 10/19/22 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 10/19/22 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
    ------------------------------

    Original Message


  • 4.  RE: Custom SQL query - Data Module

    Posted 10/28/22 07:23 AM
    What version is this from?  Because my 11.0.13 sub menu is very different.

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

    Original Message


  • 5.  RE: Custom SQL query - Data Module

    Posted 10/28/22 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
    ------------------------------

    Original Message


Related Content