List of Contributions

Jens Bäumler

Apparo Group

Contact Details

Apparo Group

My Content

1 to 20 of 50+ total

RE: Planning Analytics cube as a data source in Cognos Analytics

Posted By Jens Bäumler Fri April 12, 2024 03:13 AM
Found In Egroup: Cognos Analytics \ view thread
Hi all. We are currently having the same discussions. The current status would be: (Depending on the licence) Planning Analytics Users are allowed to: - use and create Dashboards - use the AI Assistant - use Data Modules (but only on TM1 Data?) - use and run (burst) Reports (are not allowed to create ...

RE: What would "perfect" Cognos Analytics?

Posted By Jens Bäumler Wed April 03, 2024 03:18 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Austin. Three wishes are not enough ;-) 1) DMR in Data Modules (A few dimensional functions are already fine. But a 'proper' cube with all dimensional functions would be great) 2) Display of members in the source view in reporting (if DMR is not possible). 3) a powerful assistant that understands ...

RE: Creating Cognos report where total of one column is start for another column.

Posted By Jens Bäumler Tue March 12, 2024 07:16 AM
Found In Egroup: Cognos Analytics \ view thread
Relational XML is added: Kreuztabelle mit einer Start- und Endsumme der vorherigen Zeilen und Spalten (Cognos Reporting) - cognoise.de ------------------------------ Jens Bäumler Senior Consultant and Trainer Apparo Group ------------------------------

RE: Creating Cognos report where total of one column is start for another column.

Posted By Jens Bäumler Tue March 12, 2024 03:46 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Sachin. At the moment I can only think of one solution for a dimensional model. Maybe we should convince IBM to better support dimensional functions in data modules as well ;-) start: total( [Menge] within set periodsToDate( [Absatz (Analyse)].[Zeitangabe].[Zeitangabe].[Zeitangabe] ; prevMe ...

IBM TechXchange 2024: Highlights in Cognos 12.0.x - (secret) practical tips for data modules - Conference Session 1567

Posted By Jens Bäumler Fri December 15, 2023 09:03 AM
Found In Group: Cognos Analytics Blogs
Workshop Title: Unleashing the Power of Data Modules in IBM Cognos Analytics In my workshop, I will share practical examples of the latest developments in data modeling tools in IBM Cognos Analytics. Since the release of version 11.0, the development in this area has been monumental, and with the ...

CUG Talk - 23.03.2023 - 12:30 Uhr

Posted By Jens Bäumler Sun February 26, 2023 06:43 AM
Found In Group: Cognos User Group - Germany Switzerland Austria Events
Im März CUG Talk werden wir nochmal das Thema Datenmodellierung in den Fokus nehmen. Welche Tools nutzt ihr? Was wird gerade abgelõst? Wo steigt ihr neu ein?

RE: Cognos Analytics Cloud

Posted By Jens Bäumler Mon January 16, 2023 03:08 AM
Found In Egroup: IBM Business Analytics \ view thread
Hi Marcel. Framework Manager Packages are not supportet on Cognos Analytics On-Demand-Cloud environments. A number of restrictions exist there. The most important ones: - no packages (framework manager / powercubes / dynamic cubes) - no output to file system - no burst reports- no jobs Jens ...

RE: Alternate row colors in Cognos Dashboard - List object

Posted By Jens Bäumler Wed December 28, 2022 05:39 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Madhava, there are no conditional formatting features for the List Widgets. In Table Widgets (I assume you mean the table widgets) you have a conditional format property for Measures. If you want to have a long list with detail data (with alternating colors in the rows), it will be better to ...

RE: Release 11.2.4 of Cognos Analytics Webinar

Posted By Jens Bäumler Fri December 16, 2022 12:24 PM
Found In Egroup: Cognos Analytics \ view thread
FYI: Cognos Analytics 11.2.4 4 is out and ready for download. A great new LTS version. Jens ------------------------------ Jens Bäumler Senior Consultant and Trainer Apparo Group ------------------------------

RE: Write Back to DB using SP in Cognos

Posted By Jens Bäumler Mon September 26, 2022 06:58 AM
Found In Egroup: Cognos Analytics \ view thread
Hi All. Do you know that there is a free Cognos add in for this requirement in Accelerator Catalog? https://community.ibm.com/accelerators/catalog/content/Apparo-Fast-Edit Apparo Fast Edit allows Write back to a relational database Comment function for reports and dashboards Workflow ...

RE: Cognos 11.0.7 How to drill thru to a different page in same report

Posted By Jens Bäumler Wed September 21, 2022 04:43 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Jen. There is no target tag or something to jump to a specific page. Here is an idea: You can use output variables (or a conditional block) and send a prompt parameter (e.g. p_PageNumber) in the drill through definition. So all other pages will be hidden and the user see directly the page ...

RE: Cloudera Impala Driver / Datasource for Cognos Analytics 11.2.

Posted By Jens Bäumler Thu September 01, 2022 06:07 AM
Found In Egroup: Cognos Analytics \ view thread
Succsess: Now it is working with following configuration (we had to copy an additional file for the java keystore): Connection String jdbc:impala:// : / ConnectionProperties SSL=1;AuthMech=3;SSLTrustStore=C:\ \cacerts.jks ------------------------------ Jens Bäumler Senior Consultant and ...

RE: Cloudera Impala Driver / Datasource for Cognos Analytics 11.2.

Posted By Jens Bäumler Thu September 01, 2022 03:28 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Patrick. We have Cognos Analytics running in Version 11.2.1. The Data Source is a Impala Version 3.2.0 on Cloudera CDH 6.3.2. Should we try other JDBC drivers? Or do we have to add connection properties? (we only use a connection string like this jdbc:impala:// : / ) Thanks Jens ...

Cloudera Impala Driver / Datasource for Cognos Analytics 11.2.

Posted By Jens Bäumler Tue August 30, 2022 08:28 AM
Found In Egroup: Cognos Analytics \ view thread
Hi all. We are trying to connect to a Cloudera Impala data source but can't logon to the datasource. Driver (downloaded from Cloudera Homepage): ClouderaImpala_JDBC-2.6.15.1017 (copied to cognos/drivers folder) While testing the data source, we get following error message: XQE-DS-0006 ...

RE: Cognos on Demand - Change user's email address

Posted By Jens Bäumler Mon May 30, 2022 03:29 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Heather, for Cognos Analytics On Demand Cloud from my point of view the user is directly linked to the email address (is linked to the IBM Id). You would have to create a new user and delete the old one. Jens ------------------------------ Jens Bäumler Senior Consultant and Trainer Apparo ...

Cognos Analytics Tips and Experts Slack Channel of the AIDAUG

Posted By Jens Bäumler Wed April 20, 2022 01:05 PM
Found In Egroup: Cognos Analytics \ view thread
FYI: The new newsletter "Forecaster #7" of the AIDA User Group has been published. It contains tips on the new functions of Cognos Analytics 11.2.2. The AIDAUG runs its own "Cognos Slack Channel" to quickly exchange information with Cognos experts. Who is already a member? AIDAUG is the worldwide ...

RE: Can't edit/delete SQL table in Data Module (11.1.7)

Posted By Jens Bäumler Fri March 11, 2022 03:17 AM
Found In Egroup: Cognos Analytics \ view thread
From my point of view editing as well as renaming etc. should be possible. The question is why your table is displayed in green. This actually means that it is not editable at this point. For me it looks like this (11.1.7 FP3):): Jens ------------------------------ Jens Bäumler Senior ...

RE: Upgrade from Cognos Analytics 11.1.7 FP7 to Cognos Analytics with Watson

Posted By Jens Bäumler Wed February 09, 2022 03:19 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Arnulfo. 1) Yes, it is the same " over the top installation" procedure. https://www.ibm.com/support/pages/how-upgrade-your-version-cognos-analytics Here are some problems from my installations: ApacheDS does not start anymore - error 1067 / ApacheDS files are missing / wrapper.exe --> copy ...

RE: Dataset specification

Posted By Jens Bäumler Fri December 10, 2021 03:59 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Alex. I think that it is not possible to get a JSON specification for dataset. The base is the same technique as a report. But you can get the XML specification in the top right menu via "Copy To Clipboard". Jens ------------------------------ Jens Bäumler Senior Consultant and Trainer ...

RE: Replacing query source on dataset page

Posted By Jens Bäumler Wed November 10, 2021 05:03 AM
Found In Egroup: Cognos Analytics \ view thread
Hi Rick. There is a Button under the list to reset the columns. Then you can add data items from a new query. The reference changed automatically. For deeper editing: You can copy the XML in the clipboard then to a report and then back to the dataset. The list will be empty and you can drag ...