List of Contributions

Mauro Santos Otero

Contact Details

My Content

1 to 20 of 50+ total

RE: Ask Me Anything: Cognos Analytics - April. Edition Webinar

Posted By Mauro Santos Otero Mon March 27, 2023 07:51 PM
Found In Egroup: Cognos Analytics \ view thread
Without the ability to incorporate existing report components into dashboards, there is no viable alternative to Workspaces. This feature is essential for our organization to effectively create and manage dashboards. Is there a plan in the roadmap to enable users to create dashboards/reports by incorporating ...

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Fri October 07, 2022 12:32 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks, It's a framework package in my case. I am still surprised by IBM response indicating the x-axis of the line chart is for categorical data and the suggestion to use Scatter or Bubble visualisations instead !!!! Appalling support in this case. ------------------------------ Mauro Santos Otero ...

RE: Modify a data module source from file to a dataset table

Posted By Mauro Santos Otero Wed September 28, 2022 12:44 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks for this useful guide. This provides a way forward Is there any improvement to this process in 11.2.3 by using aliases or some of the new features? Our usual approach to data modules is to rely on spreadsheets and packages as a starting point, but then the plan is to replace the spreadsheets ...

RE: Modify a data module source from file to a dataset table

Posted By Mauro Santos Otero Tue September 27, 2022 04:31 AM
Found In Egroup: Cognos Analytics \ view thread
The date module is already created. I need to replace in the data module a manual data source (spreadsheet) with an automated dataset. The idea is to replace the data module source from a spreadsheet with a dataset without having to rebuild the whole data module just for replacing one table ----- ...

Modify a data module source from file to a dataset table

Posted By Mauro Santos Otero Mon September 26, 2022 09:40 PM
Found In Egroup: Cognos Analytics \ view thread
We created a complex Data Module which relied on uploading an excel file (limited data) and creating a data module out of it. We used the data module and created some reports We now want to modify the data module so that it can use a dataset that could be automated. Can we replace the manual excel and ...

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Mon September 26, 2022 08:02 PM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Mon September 26, 2022 08:02 PM
Found In Egroup: Cognos Analytics \ view thread
I raised the issue with IBM and the official response was that the x-axis on Line visualisations (Dashboards) cannot be filtered as an integer, which seems unintuitive since a common use could be to put "Year" in the x-axis of a line chart. IBM proposed as a solution to use Scatter or Bubble visualisation ...

RE: Reporting from Multiple Packages

Posted By Mauro Santos Otero Thu September 22, 2022 08:41 PM
Found In Egroup: Cognos Analytics \ view thread
@Patrick Neveu many thanks for pointing me to the correct information. It's useful to know exactly how it works. @Kiran Passumarthi thanks for the workaround !! ------------------------------ Mauro Santos Otero ------------------------------

Reporting from Multiple Packages

Posted By Mauro Santos Otero Wed September 21, 2022 01:59 AM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

Reporting from Multiple Packages

Posted By Mauro Santos Otero Wed September 21, 2022 01:59 AM
Found In Egroup: Cognos Analytics \ view thread
I have a question when reporting from multiple packages (CA 11.2.2). I tried to create a JOIN from queries from different packages and it wasn't allowed. Not sure if this is due to security, a bug, or if it's intended to prevent joining data from different packages. Thanks, ----- ...

RE: Rename Data Module

Posted By Mauro Santos Otero Wed September 21, 2022 01:50 AM
Found In Egroup: Cognos Analytics \ view thread
Updating the report specifications is a suitable solution for a few reports. If we use Data Modules as a replacement for FWM then updating report specs won't be a suitable option. I found a lot of similar issues when using data modules derived from the naming that I've never experienced with the FWM. ...

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Mon September 19, 2022 07:58 PM
Found In Egroup: Cognos Analytics \ view thread
Thanks. The data is sourced from an FWM package which I cannot change. Anyway, this is a good trick in the event of using a Data Module. ------------------------------ Mauro Santos Otero ------------------------------

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Thu September 15, 2022 09:48 PM
Found In Egroup: Cognos Analytics \ view thread
While the sorting issue was resolved after updating to 11.2.2, the filtering conditions in Dashboards don't allow me to enter numeric data type conditions (the data field is an integer) ------------------------------ Mauro Santos Otero ------------------------------

RE: Sorting Numbers in Visualisation categories

Posted By Mauro Santos Otero Thu September 15, 2022 09:47 PM
Found In Library: Cognos Analytics with Watson
#CognosAnalyticswithWatson

RE: Rename Data Module

Posted By Mauro Santos Otero Wed September 14, 2022 12:51 AM
Found In Egroup: Cognos Analytics \ view thread
Yes, I experienced a similar issue before with Data Modules. Changing names creates huge issues. That's the reason Framework Manager is still better. ------------------------------ Mauro Santos Otero ------------------------------

RE: How to disable Welcome Banner in 11.2.2 for all the users

Posted By Mauro Santos Otero Mon May 09, 2022 03:31 AM
Found In Egroup: Cognos Analytics \ view thread
Thanks everyone for the advice. #CognosAnalyticswithWatson

How to disable Welcome Banner in 11.2.2 for all the users

Posted By Mauro Santos Otero Fri May 06, 2022 01:43 AM
Found In Egroup: Cognos Analytics \ view thread
Hello, We have just upgraded to Cognos 11.2.2 and we cannot find the global setting to disable the welcome banner for all the users. Is there anyone who can assist with this ? Many thanks, ------------------------------ Mauro Santos Otero ------------------------------ #CognosAnal ...

RE: Cognos 11.2.2 - When it comes?

Posted By Mauro Santos Otero Fri March 25, 2022 12:27 AM
Found In Egroup: Cognos Analytics \ view thread
Is there any information about the new features of Cognos 11.2.2 ? I'm about to upgrade to 11.2.1 and I would like to know if it's worth to delay the project 2 weeks and upgrade to 11.2.2 . Given 11.2.2 release is coming in a week's time it would be useful for current customers to have some informaiton ...

RE: CA 11.1.7 - Options on Emailing Report run in background

Posted By Mauro Santos Otero Mon January 17, 2022 08:21 PM
Found In Egroup: Cognos Analytics \ view thread
What about #2 ? Is there a setting to default to send attachment instead of sending link ?​​ ------------------------------ Mauro Santos Otero ------------------------------

RE: Data Module Metadata Processing Cognos 11.1 and 11.2

Posted By Mauro Santos Otero Tue December 07, 2021 11:55 PM
Found In Egroup: Cognos Analytics \ view thread
How do you find Data Modules? I still found them sub-par when compared to Framework Manager packages. I think they are useful to support one or two ad-hoc reports or for data preparation tasks replacing excel. On the other hand, a well-designed framework package can be used to source hundreds of reports. ...