List of Contributions

Harun Y

Contact Details

My Content

1 to 20 of 29 total

RE: Cognos 11.1.7 Single Sign on not seamlessly integrating with AD

Posted By Harun Y Sep 2, 2020 10:12 PM
Found In Egroup: Cognos Analytics \ view thread
@Vincent Dsouza Have you configured SSO using IIS or Apache Web Server ? ​ ------------------------------ Harun Y ------------------------------

RE: Cognos Analytics - List Report - Page Number with Total Pages

Posted By Harun Y Aug 30, 2020 10:55 AM
Found In Egroup: Cognos Analytics \ view thread
Thank You @Alaa Eddine KAY for your response. This may not be possible now but I believe IBM can implement this feature. I have submitted an enhancement request for this. Anyone looking for the similar functionality can VOTE for the below enhancement request. https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2894 ...

RE: Dashboard - Red Yellow Green coloring - bar chart

Posted By Harun Y Aug 30, 2020 10:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hello @Torben Noer Do you have idea on when this feature would come? This limitation is causing us to avoid using some Visualizations (Bullet Visualization etc) altogether. This is the basic Color legend feature. Multiple enhancement requests have been submitted and voted by many customers. Couple of ...

RE: Data Module - Restrict Table Column Name Changes

Posted By Harun Y Aug 30, 2020 6:19 AM
Found In Egroup: Cognos Analytics \ view thread
Submitted Enhancement request. Anyone looking for the similar functionality can VOTE for the below enhancement request. https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2893 Thank You ------------------------------ Harun Y ------------------------------

RE: Multiple Drill Through Definitions based on a Parameter Data Item Value ??

Posted By Harun Y Aug 30, 2020 6:15 AM
Found In Egroup: Cognos Analytics \ view thread
This functionality does not exist today. You can VOTE for the below enhancement request if you are looking for the similar functionality. https://ibm-data-and-ai.ideas.aha.io/ideas/CA-I-2901 Thank You ------------------------------ Harun Y ------------------------------

Multiple Drill Through Definitions based on a Parameter Data Item Value ??

Posted By Harun Y Aug 27, 2020 6:48 PM
Found In Egroup: Cognos Analytics \ view thread
Can we define multiple Drill Through Definitions defined based on a passed Parameter Data Item Value within the Cognos Report Visualization. Based on the Data Item value passed I want the Drill Through Definition to be change dynamically like a CASE Statement. Example: If Project Name = "CRM" - Cognos ...

Permission to the Report with no Access (Hide) to the Folder

Posted By Harun Y Aug 19, 2020 9:33 PM
Found In Egroup: Cognos Analytics \ view thread
I am trying not to give access to the Folder where the report exists but want the users to be able to traverse to the Report under the Folder. I did this by not giving the appropriate permissions to the Folder but gave permissions to the Drill Through Definition Report under the Folder (by Overriding ...

RE: Data Module - Restrict Table Column Name Changes

Posted By Harun Y Aug 18, 2020 11:34 PM
Found In Egroup: Cognos Analytics \ view thread
Thank You Buddhi @Buddhi Gupta ​ it helped. I checked both Load Options in Data Server and used Pass through SQL (Select * from Table) which now displays the names as is. I am currently using Data Module and with the Pass through SQL I wouldn't be able to use the Data Module and give users access to ...

RE: Data Module - Restrict Table Column Name Changes

Posted By Harun Y Aug 17, 2020 3:07 AM
Found In Egroup: Cognos Analytics \ view thread
Anyone has any idea ? ------------------------------ Harun Y ------------------------------

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 7, 2020 8:14 PM
Found In Egroup: Cognos Analytics \ view thread
When you say several drill through paths all of them can only go to one single Drill Through Report right (in my case List Report). ------------------------------ Harun Y ------------------------------

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 7, 2020 8:07 PM
Found In Egroup: Cognos Analytics \ view thread
Yes that is correct requirement is to pass a table from one report to another and show the data within the tables with all the columns of this table in a list report. ------------------------------ Harun Y ------------------------------

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 7, 2020 7:46 PM
Found In Egroup: Cognos Analytics \ view thread
Got it. I cannot have static number of Columns as each SQL Statement or the Table Name may have different Column Names with variable number of columns. SQL Statement1/Table 1 can have 10 columns and SQL Statement2/Table2 can have 20 columns totally different Column Names. I cannot have static Column ...

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 7, 2020 2:36 AM
Found In Egroup: Cognos Analytics \ view thread
Hello @JEAM COELHO ​ I am trying to use the Query Macro as you have mentioned passing the SQL Statement as a Parameter but if I do not have the Column Names listed in the List Report I do not see any data in the report. In my case I cannot have the Column Names in the List Report as the Column Names ...

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 6, 2020 2:37 AM
Found In Egroup: Cognos Analytics \ view thread
Thank You @JEAM COELHO I will try this and will let you know.​​​​ ------------------------------ Harun Y ------------------------------

RE: Cognos Analytics - List Report - Page Number with Total Pages

Posted By Harun Y Aug 5, 2020 2:46 PM
Found In Egroup: Cognos Analytics \ view thread
Thank You @JEAM COELHO ​. Wouldn't Cognos know the Total Number of records that it is fetching although it does not fetch all the records. Total Pages can be calculated based on the Total Records and the number of records that it shows per page. This may be an Enhancement request then. Thank You -- ...

RE: Dashboard - Drill Through Details via SQL ?

Posted By Harun Y Aug 5, 2020 1:06 PM
Found In Egroup: Cognos Analytics \ view thread
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 ...

Data Module - Restrict Table Column Name Changes

Posted By Harun Y Aug 2, 2020 5:03 PM
Found In Egroup: Cognos Analytics \ view thread
Hello All, When the Tables are imported into the Data Module Column Names with Characters such as underscore (_), dash (-), or slash (\) are replaced with the space character. Is there a way to stop this behavior and keep the Database Table Column Names as is in the Data Module ? Thank You --------- ...

Cognos Analytics - List Report - Page Number with Total Pages

Posted By Harun Y Aug 2, 2020 3:10 PM
Found In Egroup: Cognos Analytics \ view thread
Hello All, Could you please let me know how can I include a Page Number with Total pages (Page Number of Total Pages) Example : 1 of 10 I have created a "Block" below the List Report using the Class "Guided Layout Margin" and selected the Format (Page No of Total Page No). I can see the Page No but ...

RE: Add/Change Theme in CA Report

Posted By Harun Y Aug 2, 2020 3:05 PM
Found In Egroup: Cognos Analytics \ view thread
Thank You @Buddhi Gupta ​ I see I can apply the Theme from a Template - Style Reference Reports. ------------------------------ Harun Y ------------------------------

RE: Prompt Report with Source Table Name as Parameter

Posted By Harun Y Aug 2, 2020 11:11 AM
Found In Egroup: Cognos Analytics \ view thread
Thank You Nigel @NIGEL CAMPBELL . Do you know if this can be done through Cognos Analytics Data Module ?​ ------------------------------ Harun Y ------------------------------