List of Contributions

Peter Chan

Contact Details

My Content

1 to 20 of 50+ total

RE: Is there an other way to update data source and signons in cognos analytics using configuration files?

Posted By Peter Chan Wed August 03, 2022 05:51 AM
Found In Egroup: Cognos Analytics \ view thread
Vinay Reddy Guda - here is the Java code snippet: /** * Audit the Cognos data sources * * @author Peter Chan * * VSS Path: $/DEV/sdk/java/DataSourceOverview/src/DataSourceOverview.java - Ver # * */ import java.io.*; import java.util.Hashtable; import javax.xml.namespace.QName; ...

RE: Is there an other way to update data source and signons in cognos analytics using configuration files?

Posted By Peter Chan Fri March 25, 2022 06:02 AM
Found In Egroup: Cognos Analytics \ view thread
Vinay Reddy Guda – I believe the Cognos SDK should be able to change the signon. We have Cognos SDK code that reads the data sources and spits out the details. If you like, we can always post a copy of our code. Peter Chan 613-295--0428

RE: Package Security: Author on package A, Only consumer on package B ?

Posted By Peter Chan Fri February 11, 2022 07:43 AM
Found In Egroup: Cognos Analytics \ view thread
Danny – assuming that I understand what you need: - User A needs Read/Execute/Traverse on Package A to create Reports against Package A - User A only needs Execute/Traverse on Package B to run Reports created on Package B Hope this helps. ...

RE: Creating FORMS to accept input from end user

Posted By Peter Chan Wed February 09, 2022 06:26 AM
Found In Egroup: Cognos Analytics \ view thread
SWAMY THIPPESWAMY – there are several ways you can deal with this, but to stick with the IBM Cognos suite or products, you could use IBM Cognos Planning (TM1) to capture data, write back to database or you could also report directly off of a TM1 Cube. ...

RE: Conditional drill through to externa link/url

Posted By Peter Chan Thu January 20, 2022 01:32 PM
Found In Egroup: Cognos Analytics \ view thread
Mack L – I believe I was incorrect in my first comment. I ended up using a "Hyperlink" object instead. Hope the screen shots and the report spec attachment comes through. I created a sample report using the "Boston 311 Calls" data module (see IBM Samples).

RE: Conditional drill through to externa link/url

Posted By Peter Chan Thu January 20, 2022 07:00 AM
Found In Egroup: Cognos Analytics \ view thread
Mack L – my comments, on the assumption that you are using Report: - To control the rendering of the link, you could use Variables to conditionally display an object (e.g link, text) - To generate the URL and add additional parameters, pending on how you render (for example, in a list or just a one ...

RE: How to monitor Cognos up and running

Posted By Peter Chan Thu December 02, 2021 07:52 AM
Found In Egroup: Cognos Analytics \ view thread
Brenda – you could develop a script that hits the following URL: - http://Server:Port/bi/v1/disp You will need to replace "Server" and "Port". Hope this helps. Peter Chan 613-295--0428

RE: FM: aggregate on attribute

Posted By Peter Chan Tue September 14, 2021 05:50 AM
Found In Egroup: Cognos Analytics \ view thread
Sandeep Dhirad – a question: 1. Is your model Relational or DMR? Why I ask is I believe the aggregate only works on measures that are related to dimensional objects. Peter Chan 613-295--0428

RE: Exporting to excel

Posted By Peter Chan Tue August 03, 2021 05:53 AM
Found In Egroup: Cognos Analytics \ view thread
Harold Dieter – could you elaborate on the field in questions if possible? Possibly tell us the value and the exported value. Peter Chan 613-295--0428

RE: Cognos Audit report for users and groups

Posted By Peter Chan Thu May 20, 2021 07:09 AM
Found In Egroup: Cognos Analytics \ view thread
Suraj Neupane – to answer this question and get the user creation date, you may have to audit your Active Directory server, assuming you are using an Active Directory server for access/security. Peter Chan 613-295--0428

RE: report->transformation program->cognos email link

Posted By Peter Chan Thu May 20, 2021 07:07 AM
Found In Egroup: Cognos Analytics \ view thread
Philip Copeland – a couple of options: 1. Create a 1 column report with and concatenate in a custom delimiter, you can then schedule and email report from Cognos server, then you do not need Python at all for post processing. 2. Use the Cognos SDK to run the report, then process with custom delimiter, ...

RE: Group Mail-Box within Schedules

Posted By Peter Chan Tue April 27, 2021 07:59 AM
Found In Egroup: Cognos Analytics \ view thread
@Chris Bos – this is how we do it at our shop, but there are many other ways you can do this: 1. Is there a way to create a schedule and add a group-mailbox / team-mailbox instead of a personal mail-box ? a. Yes. We use Outlook distribution emails and enter in the email address in the "To" field ...

RE: Add comment to a (saved) Report

Posted By Peter Chan Mon April 26, 2021 06:44 AM
Found In Egroup: Cognos Analytics \ view thread
@Chris Bos – as far as I know it only supports Slack right now. I wish they would allow for other vendors and/or bring back the legacy tool. Peter Chan 613-295--0428

RE: Add comment to a (saved) Report

Posted By Peter Chan Mon April 19, 2021 06:26 AM
Found In Egroup: Cognos Analytics \ view thread
Chris Bos – in versions of IBM Cognos 11.x.x, they have decided to allow the client to set up their own Collaboration tools, to set this, you will have to go to: - Manage > Collaboration > Add Peter Chan 613-295--0428

RE: Sorting Numbers in Visualisation categories

Posted By Peter Chan Mon April 19, 2021 06:13 AM
Found In Egroup: Cognos Analytics \ view thread
Mauro Santos Otero – a couple of things to look into: - Ensure that the field that populates the x-axis is a numeric data type and not a character datatype - You could also perform a manual sort on the x-axis values, but not ideal if there are too many values or when new values are added to the ...

RE: developerworks Cognos articles

Posted By Peter Chan Wed April 14, 2021 06:57 AM
Found In Egroup: Cognos Analytics \ view thread
Magnum BI – so what we have done in the past is to augment our Date Dimension in our mart to add additional fields, I have cut and pasted a snippet of our Date Dimension, the following are some notes: - Assuming today is April 1, 2021 - Our date dim in this case is at the month grain. We have it ...

RE: developerworks Cognos articles

Posted By Peter Chan Tue April 13, 2021 06:27 AM
Found In Egroup: Cognos Analytics \ view thread
Magnum BI – I have played with Relative Time quite a bit and from experience, the best solution we have found is to add relative time fields into a conformed date dimension in the mart. Please advise if you like to see a further elaboration of our implementation.

RE: Disposable prompt values

Posted By Peter Chan Fri April 09, 2021 02:08 PM
Found In Egroup: Cognos Analytics \ view thread
Jeanie Krieger – I agree with Thomas in the previous post and possibly simplify your logic by just making the prompts optional. In general, Report does offer enough flexibility that will allow you to do what you want to do. Peter Chan 613- ...

RE: Design Language in Framework Manager

Posted By Peter Chan Fri March 19, 2021 08:51 AM
Found In Egroup: Cognos Analytics \ view thread
Eyitayo Adara – a couple of points: 1. The Design Language chosen will also be one of the Project Languages by default 2. If you decided to use a Design Language like en-zw and assuming that this is not one of languages and locales in your region, it is also best to have the setting "Use Design Locale ...

RE: Data Module metadata information from cognos content store database

Posted By Peter Chan Fri March 05, 2021 06:37 AM
Found In Egroup: Cognos Analytics \ view thread
Federico Balsa – for FM, you could use the Cognos SDK to recreate the model.xml file. Additionally, Motio can also be used to recreate the model.xml. Some notes: - In general, I try not to use the content store to retrieve any metadata as it is unreliable from version to version - SDK is the best ...