Thank You
@JEAM COELHO for the response. Let me elaborate
I want to build a List Report (which will be used as the target drill thru Report) which should display the results based on certain parameters that I pass from a Parent Report.
I am looking for the options for the List Report to work in either of these ways
1. I want to pass the Database Table Name, Column Names, Date Filter condition as parameters to the List Report via the Parent Report Parameters: Database Table Name, Filter Condition, Database Columns
As an Example : Database Table Name = "Customer"
Filter Condition: "ActiveDate='2020-08-05'
Database Ciolumns: ColumnA, ColumnB, ColumnC
I want the List report to display the results from the Table with a SQL Equivalent of:
SELECT * FROM Customer WHERE ActiveDate='2020-08-05' {OR}SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'2. I can pass the SQL Query and Date Value via Parent Report to the Drill Thru Report (List Report)Parameters: Database_SQL_Statement, Date_Filter_Value
As an Example : Database_SQL_Statement = "
SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate="
Date_Filter_Value="'2020-08-05"
I want the List report to display the results from the Table with a SQL Equivalent of:
SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'3. I can pass the whole SQL Query as Parameter via Parent Report to the Drill Thru Report (List Report)Parameters: Database_SQL_Statement
As an Example : Database_SQL_Statement = "
SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'"
I want the List report to display the results from the Table with a SQL Equivalent of:
SELECT ColumnA, ColumnB, ColumnC FROM Customer WHERE ActiveDate='2020-08-05'It does not have to be a List Report I basically want the users to see the detailed results either through List Report Report or any other way possible.
Hopefully I am clear this time.
Thank You
------------------------------
Harun Y
------------------------------
Original Message:
Sent: Wed August 05, 2020 12:19 PM
From: JEAM COELHO
Subject: Dashboard - Drill Through Details via SQL ?
Hi,
Your question is not clear.
What are you looking for?
Parameters are sent to target drill thru report dynamically, based on user selections.
And drill thru specifications are salved on report spec (XML).
------------------------------
JEAM COELHO
Cognos Solution Architect
Linkedin: https://www.linkedin.com/in/jeamcoelho/
Original Message:
Sent: Sun May 31, 2020 01:09 AM
From: Harun Y
Subject: Dashboard - Drill Through Details via SQL ?
Hello All,
Please let me know if a Dashboard Drill Through be built based on the SQL Query passed as a parameter (or) from a Database Table with Select Table Name, Column Names and Filter conditions passed as parameters?
Thank You
------------------------------
Harun Y
------------------------------
#CognosAnalyticswithWatson