Hello All,

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

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

#CognosAnalyticswithWatson

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
------------------------------

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
------------------------------

Original Message:
Sent: Sat August 01, 2020 08:58 PM
From: Harun Y
Subject: Prompt Report with Source Table Name as Parameter

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
------------------------------

Thank You Nigel @NIGEL CAMPBELL. Do you know if this can be done through Cognos Analytics Data Module ?​

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

Original Message:
Sent: Sun August 02, 2020 08:50 AM
From: NIGEL CAMPBELL
Subject: Prompt Report with Source Table Name as Parameter

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
------------------------------


Original Message:
Sent: Sat August 01, 2020 08:58 PM
From: Harun Y
Subject: Prompt Report with Source Table Name as Parameter

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