Cognos Analytics

 View Only
  • 1.  Prompt Report with Source Table Name as Parameter

    Posted Thu June 04, 2020 07:58 AM
    Hello All,

    Can I be able to build a Prompt Report in Cognos Analytics passing Source Table Name as the Parameter ?

    ------------------------------
    Harun Y
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Prompt Report with Source Table Name as Parameter

    Posted Sat August 01, 2020 08:59 PM
    Please let me know if anyone has any idea or if my question is not clear enough. I am further breaking down my question below.

    1. I want to build a prompt report that shows all the records from a Database Table with all the columns.
    2.Database Table will not be a static Table Name but can be any name which I want to pass as a Parameter. (Ex: pDatabaseTableName)
    3.Report should display the results based on the Database Table Name passed through a Parameter value (pDatabaseTableName).

    Appreciate your response.

    ------------------------------
    Harun Y
    ------------------------------



  • 3.  RE: Prompt Report with Source Table Name as Parameter

    Posted Sun August 02, 2020 08:51 AM

    In Framework Manager the logical query could be defined using a macro expression.

    In this example, the macro expression is using a parameter map which  is referenced using a value defined by a session variable.

    Should you want to use a prompt only then use the prompt macro etc.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 4.  RE: Prompt Report with Source Table Name as Parameter

    Posted Sun August 02, 2020 11:11 AM
    Thank You Nigel @NIGEL CAMPBELL. Do you know if this can be done through Cognos Analytics Data Module ?​

    ------------------------------
    Harun Y
    ------------------------------