List of Contributions

Betina Stapleton

Contact Details

My Content

1 to 17 of 17 total
Posted By Betina Stapleton Thu June 04, 2020 12:42 PM
Found In Egroup: Cognos Analytics
\ view thread
Thanks Albert - I had already give that a try. Was my first attempt but still shows detail rows and not totaled when using the FOR clause. ​ ------------------------------ Betina Stapleton ------------------------------
Posted By Betina Stapleton Wed June 03, 2020 02:20 PM
Found In Egroup: Cognos Analytics
\ view thread
​I have a report that includes several grouped columns and calculated columns to return a count of customers based on a category type for current month -1, etc. I haven't been able to get the count to aggregate for the category types; instead the report displays the counts on multiple rows. The number ...
Posted By Betina Stapleton Fri May 22, 2020 01:43 PM
Found In Egroup: Cognos Analytics
\ view thread
​I have a report in which I've created 13 calculated columns that return current month -1, current month -2, current month -3, etc. This report includes rolling 13 months. How can I change the column headings so instead of current month - 1 it displays the actual Month and Year. So, for example, current ...
Posted By Betina Stapleton Thu May 14, 2020 09:38 AM
Found In Egroup: Cognos Analytics
\ view thread
​We have been running 11.0.10 for a little over a year. The majority of our users still run reports out of Query Studio and some of the more current web browsers are not supported for use with Query Studio and we want to train users to start using the new Reporter interface. Can anyone tell me what level ...
Posted By Betina Stapleton Thu March 26, 2020 11:21 AM
Found In Egroup: Cognos Analytics
\ view thread
Sorry I forgot to include that! Cognos Analytics 11.0.10. The numbers that are coming back seem to be higher than we expected.​ ------------------------------ Betina Stapleton ------------------------------
Posted By Betina Stapleton Wed March 25, 2020 12:59 PM
Found In Egroup: Cognos Analytics
\ view thread
​I need to create a report to capture the number of reports run by month. I've created such a report in the past, but not sure if I recall correctly how to use the COGIPF_TARGET_TYPE. When I run a report for this column the values returned are: Report type Report promptback reportservice ...
Posted By Betina Stapleton Mon March 16, 2020 10:24 AM
Found In Egroup: Cognos Analytics
\ view thread
​I have a report scheduled to be delivered to users each Thursday evening in Analytics 11.0.10. The scheduled report recipients receive email successfully but report owner receives message 'We were unable to send message to one or more recipients. I've confirmed with users the report was received and ...
Posted By Betina Stapleton Tue February 18, 2020 09:25 AM
Found In Egroup: Cognos Analytics
\ view thread
Thanks so much for your reply, Jeam. If changes are made for this and we currently have reports with shortcuts using http instead of https will this cause an issue with http shortcuts?​ ------------------------------ Betina Stapleton ------------------------------
Posted By Betina Stapleton Mon February 17, 2020 09:54 AM
Found In Egroup: Cognos Analytics
\ view thread
​We have been requested to redirect port 80 to port 443. Was told it was setup this way prior to out last upgrade to Cognos 11. Does anyone know what (if anything) could potentially break when this change is made? For example, report short cuts, etc. Is the change needed in IIS as well as Cognos Configuration? ...
Posted By Betina Stapleton Fri January 24, 2020 01:55 PM
Found In Egroup: Cognos Analytics
\ view thread
​Does anyone have experience with ILMT (IBM License Metric Tool)? If so, could you share your experience? Do you know if the scan is a full scan across all VM Hosts or is the software configured for just Cognos servers? ------------------------------ Betina Stapleton ------------------------------ ...
Posted By Betina Stapleton Thu January 16, 2020 02:33 PM
Found In Egroup: Cognos Analytics
\ view thread
​Does anyone know if there is a way to disable all Cognos users from being able to log into the Cognos Analytics 11.0.10 environment but have the Cognos services/servers still up and running? Would disabling the Cognos 'Everyone' group accomplish this? We are upgrading our data warehouse server environment ...
Posted By Betina Stapleton Thu January 16, 2020 02:26 PM
Found In Egroup: Cognos Analytics
\ view thread
​Thank you for all of the suggestions. I'm going to just run several jobs containing multiple reports that run at the same time. Sometimes I just overthink how to do things! :) ------------------------------ Betina Stapleton ------------------------------
Posted By Betina Stapleton Wed January 15, 2020 03:44 PM
Found In Egroup: Cognos Analytics
\ view thread
​We are on Cognos Analytics 11.0.10 We are in the process of upgrading our SQL severs. I need to test 20 or so reports to see how performance is, etc. I'd like to be able to run these one after another without having to manually complete the report prompts for each report one at a time and then run the ...
Posted By Betina Stapleton Tue December 17, 2019 03:07 PM
Found In Egroup: Cognos Analytics
\ view thread
Thank you for your response, Ian. I'm familiar with the steps to create the shortcut in Cognos 11.0.10. I was just looking for a way to browse to the users 'My Content' (prior to Cognos 11 this was My Folders) to see what content she has in her My Content folder area. I did that in Cognos 10.x through ...
Posted By Betina Stapleton Tue December 17, 2019 08:12 AM
Found In Egroup: Cognos Analytics
\ view thread
​I have a user that is trying to create a shortcut in her My Content that points to a report in Team Content (she has access to the location in Team Content). I wanted to go to her My Content area (similar to accessing My Folders in 10.x Cognos) to see what content she has in this area. I assume I'd ...
Posted By Betina Stapleton Mon December 02, 2019 03:49 PM
Found In Egroup: Cognos Analytics
\ view thread
We are currently running Cognos Analytics 11.0.10 but I'm not sure what fix packs (if any) have been installed. Is there a way for me to tell if fix packs have been implemented in our environment? ------------------------------ Betina Stapleton ------------------------------ #Cognos ...