List of Contributions

Mack L

Contact Details

My Content

1 to 20 of 50+ total

RE: Drill through from Crosstab totals not matching

Posted By Mack L Tue March 26, 2024 02:04 PM
Found In Egroup: Cognos Analytics \ view thread
I was able to fix it by setting properties for Crosstab node members. I had to include the Data item in the properties list of some node members of the crosstabs so that the parameter is passed for totals as well (in connection with point 5 above). Now the drill through works as expected. Best ...

RE: Drill through from Crosstab totals not matching

Posted By Mack L Mon March 25, 2024 08:36 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Paul, In answer to your questions: The master detail relationship is defined data item to data item. The data item is Category. Yes the rows in the crosstab are related to the master (repeater table). A column 'Category' has been used in the relationship which has values 'Main' and 'Service'. ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Fri March 22, 2024 03:18 AM
Found In Egroup: Cognos Analytics \ view thread
I finally got it working after switching the url I had been using so far with that of the dispatcher uri for external applications. Thanks all of you. Cheers! ------------------------------ Mack L ------------------------------

Drill through from Crosstab totals not matching

Posted By Mack L Fri March 22, 2024 03:12 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, I have a drill through source and target reports. The source report has crosstabs that have drill throughs on the detail and summary values. The target report contains a list. The crosstabs display single measures and not multiple. Two crosstabs among these are a result of a repeater table with ...

RE: Extracting a list of all Cognos reports having a specific object

Posted By Mack L Tue March 05, 2024 01:31 AM
Found In Egroup: Cognos Analytics \ view thread
@Ilyas Yulyev, I requested the DB admin to run the query on content store and it gave the following errors. The content Store is on MS SQL Server. Msg 195, Level 15, State 10, Line 21 'SYS_CONNECT_BY_PATH' is not a recognized built-in function name. Msg 102, Level 15, State 1, Line 34 Incorrect ...

RE: Extracting a list of all Cognos reports having a specific object

Posted By Mack L Fri March 01, 2024 04:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Ilyas, Thank you. Can I run the query you provided on the Content Store DB as it is or is any modification required? I need to find out where content store DB is located in our Cognos environment and try it. Going back to my first question, can the same thing be done using Motio PI (free version)? ...

Extracting a list of all Cognos reports having a specific object

Posted By Mack L Thu February 29, 2024 01:02 PM
Found In Egroup: Cognos Analytics \ view thread
Hi, I would like to pull a list of all reports that have hyperlink button object used in them. Can this be done using the free version of Motio PI?. On checking the documentation of Motio Pi, I could not find out if this can be done using free version of Motio PI. Please suggest. is there any other ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Thu February 29, 2024 04:51 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mark, I tried what you suggested i.e., setting the 'Allow session information to be shared between client applications? property to true in Cognos Configuration but still have the same problem when I click the plus sign in the right pane, getting prompted again for credentials and on entering the ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Tue February 20, 2024 05:17 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you for the suggestion. I will surely try it out but a question please - does Cognos for microsoft office have its own version that should be compatible with the version of Cognos that is being used?. Please let me know. We are using Cognos 11.1.7 and I am trying out the Cognos for MS office ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Mon February 19, 2024 10:53 AM
Found In Egroup: Cognos Analytics \ view thread
Thank you Mark/Han/Karas, Your Suggestions helped me overcome the above problem i.e., display of cognos content in the IBM Pane on the right. I modified the URL as suggested by you and adjusted the settings in Excel app to Compatibility mode. I am now able to see objects in the pane but I am facing ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Mon February 19, 2024 10:53 AM
Found In Library: Cognos Analytics with Watson

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Thu February 15, 2024 03:07 AM
Found In Library: Cognos Analytics with Watson

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Thu February 15, 2024 03:07 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mark, The authentication process is going ok as evident when using the 'Connection' and 'Open' links in the ribbon above. On authentication from the 'Open' link, I get to enter the credentials but it simply opens up the Cognos portal and if I close the portal the dialog box box appears (second ...

RE: IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Wed February 14, 2024 10:39 AM
Found In Egroup: Cognos Analytics \ view thread
Mark, I did take note of it and installed .net framwork 4.8. It happened inspite of it. Best Regards, ------------------------------ Mack L ------------------------------

IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Wed February 14, 2024 04:48 AM
Found In Egroup: Cognos Analytics \ view thread
I got the Cognos add in for MS Office installed today and on testing it, it is allowing me to create a connection to the Cognos server using the Cognos portal url but the right pane in the XL document which is supposed to show the cognos content (my content, Team Content) is blank. The Cognos version ...

IBM Cognos for Microsoft Office not working as expected

Posted By Mack L Wed February 14, 2024 04:47 AM
Found In Library: Cognos Analytics with Watson

RE: Automate transfer of Cognos report output to another file

Posted By Mack L Sat February 10, 2024 06:28 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Mark, Thanks a lot!. Best Regards,

RE: Automate transfer of Cognos report output to another file

Posted By Mack L Wed February 07, 2024 08:22 AM
Found In Egroup: Cognos Analytics \ view thread
Milan, Thank you so much for the suggestion. Could you please provide details on how I can obtain the software (Add in)? i.e., Cognos add-in for MS office. Best Regards, ------------------------------ Mack L ------------------------------

RE: Automate transfer of Cognos report output to another file

Posted By Mack L Fri February 02, 2024 12:15 PM
Found In Egroup: Cognos Analytics \ view thread
Hi Milan, Thank you but the requirement here includes being able to transfer the data from a Cognos report to an XL file that is already populated with calculations which work on the data that is loaded from the Cognos report. Can this also be made possible?. Should the user who needs this functionality ...

Automate transfer of Cognos report output to another file

Posted By Mack L Fri February 02, 2024 05:40 AM
Found In Egroup: Cognos Analytics \ view thread
Hi, An employee of the client I am working for manually copy pastes part of a Cognos report output (XL) i.e., specific columns and pastes them to an XL file to complete his task. This he does frequently and has requested for automation of this process. The requirement here is automation of transfer ...