List of Contributions

Elihu El

Contact Details

My Content

1 to 20 of 50+ total

Listing Who and When Reports Were Last Run

Posted By Elihu El Wed March 02, 2022 03:32 PM
Found In Egroup: Cognos Analytics \ view thread
Good Afternoon, I hope that your day is going well. I would like to generate a list of reports along with various attributes such as Last Run Date, Last Run User, etc. Here is the SQL that I have so far: select * from CMOBJECTS as CO inner join CMOBJECTS as CO2 on CO2.PCMID = CO.CMID inner join CMOBJNAMES ...

RE: Creating a Function in a Cognos Report

Posted By Elihu El Wed March 02, 2022 11:26 AM
Found In Egroup: Cognos Analytics \ view thread
...Thanks; I appreciate the engagement. However, I attempted to relay details that hinder the implimentation of those recommendations. If you do not understand anything that I previously wrote, please do not hesitate to ask further. Continued Regards, Eli

RE: Creating a Function in a Cognos Report

Posted By Elihu El Wed March 02, 2022 11:18 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, ...Thanks. Does your solution require that the stored procedure be written in the database? If so, we have a second problem. Our Framework Manager is not importing stored procedures. We have already created an IBM support trouble ticket: https://www.ibm.com/mysupport/s/case/5003p000 ...

RE: Creating a Function in a Cognos Report

Posted By Elihu El Wed March 02, 2022 10:50 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, ...I understand what you are doing. It really helps to minimize code duplication. Thanks. However, I need a parameter passed into the function. Hypothetically simiar to this: [local function].[Cost function]([Quantity]) or Cost_Function([Quantity]) instead of, [local function].[Cost ...

RE: Creating a Function in a Cognos Report

Posted By Elihu El Wed March 02, 2022 10:21 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, ...Thanks. However, I would be using a function within a query calculation. In mathematics, a function from a set X to a set Y assigns to each element of X exactly one element of Y. The set X is called the domain of the function and the set Y is called the codomain of the function. Functions ...

RE: Creating a Function in a Cognos Report

Posted By Elihu El Tue March 01, 2022 04:19 PM
Found In Egroup: Cognos Analytics \ view thread
...The report has a prompt page. Whatever value that is selected by the user, can it be passed to the function?

RE: Creating a Function in a Cognos Report

Posted By Elihu El Tue March 01, 2022 03:45 PM
Found In Egroup: Cognos Analytics \ view thread
...I want to pass one data item value from the data model and two parameter values from the report to produce the result in a calculated query data item. Thanks; However, I am uncertain of what you reference apply to this problem. Warm Regards, Eli

RE: Creating a Function in a Cognos Report

Posted By Elihu El Tue March 01, 2022 03:42 PM
Found In Egroup: Cognos Analytics \ view thread
...I want to pass one data item value from the data model and two parameter values from the report to produce the result in a calculated query data item. Thanks; However, I am uncertain of what you reference apply to this problem. Warm Regards, Eli

Creating a Function in a Cognos Report

Posted By Elihu El Tue March 01, 2022 11:02 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, I hope that you and yours are all doing well. I would like to create a function that will be used by multiple queries within the report. The function should input 3 parameters and generate 1 result. The user defined function would be programmed with built-in functions and constructs. ...

Can Not Import Stored Procedure

Posted By Elihu El Mon February 14, 2022 02:44 PM
Found In Egroup: Cognos Analytics \ view thread
Good Afternoon, I hope that your day is going well. I have created a stored procedure and can not import it using Framework Manager Metadata Wizard. Refer to this tutorial: https://www.youtube.com/watch?v=9RxDg7LIWQI https://www.ibm.com/mysupport/s/case/5003p00002eJ1dgAAC/stored-procedure- ...

Parameterized Arrays

Posted By Elihu El Fri February 11, 2022 09:29 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning Cognos Users, I hope that you and yours remain well. Last month, we upgraded to Cognos version 11.2.1 for the customer. Within reports or dashboards, if you need to store data item values (variables) from one query to be used in other queries and/or rendered multiple places in the report, ...

Parameterized Arrays Attachments

Posted By Elihu El Fri February 11, 2022 09:28 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Upgraded Cognos Reporting

Posted By Elihu El Mon January 31, 2022 05:59 PM
Found In Egroup: Cognos Analytics \ view thread
Good Evening Cognos Users, I hope that you and yours are doing well. In response to the log4j vulnerability, we have upgraded the customer's version of Cognos. Study the attached report. If you possibly need help in upgrading versions, can't get the old reports working with the new version, publishing ...

Upgraded Cognos Reporting Attachments

Posted By Elihu El Mon January 31, 2022 05:58 PM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Corrected: Can Not Import Stored Procedures into Framework Manager

Posted By Elihu El Tue December 14, 2021 10:32 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, I hope that you and yours are all doing well. I need your help. Would you kindly study the two attachments. I need to import and then invoke the stored procedure in Framework Manager to manage the Goals that are depicted in the screenshot of the dashboard. I have already created the ...

Corrected: Can Not Import Stored Procedures into Framework Manager Attachments

Posted By Elihu El Tue December 14, 2021 10:31 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Can Not Import Stored Procedures into Framework Manager

Posted By Elihu El Tue December 14, 2021 10:14 AM
Found In Egroup: Cognos Analytics \ view thread
Good Morning, I hope that you and yours are all doing well. I need your help. Would you kindly study the two attachments. I need to import and then invoke the stored procedure in Framework Manager to manage the Goals that are depicted in the screenshot of the dashboard. I have already created the ...

Can Not Import Stored Procedures into Framework Manager Attachments

Posted By Elihu El Tue December 14, 2021 10:13 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Adding Percentage Calculations to a Target Column Chart

Posted By Elihu El Thu December 02, 2021 03:27 PM
Found In Egroup: Cognos Analytics \ view thread
Good Afternoon, I hope that your day is going well. I am using a Target Column chart and would like to add percentages to the chart. How would I add percentages to the chart or would I have to use a different chart? See the attachment for a more detailed request. Warm Regards, Eli #C ...

Adding Percentage Calculations to a Target Column Chart Attachments

Posted By Elihu El Thu December 02, 2021 03:26 PM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson