by ·Comments Off on Sort by column

Product:
Microsoft PowerBI desktop

Issue:

A column in a table is not sorted correct, it sorted alphabetical and not by date. Even do the column should show a date format.

 

Solution:

Inside PowerBI Desktop, go to the table view.

Select the column (that you want change the sort order for) and click on icon for “sort by column”.

In the dropdown menu, select the column who have a correct format, in our example the date column.

Now check the table in Report view.

You need to repeat this for all columns, in your report in PowerBI for Desktop.

 

More Information:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

https://www.techrepublic.com/article/how-to-sort-by-column-power-bi/ 

https://help.zebrabi.com/kb/power-bi/add-a-sorting-column/ 

 

by ·Comments Off on The remote server returned an error: (502) Bad Gateway.

Product:
Planning Analytics 2.0.9.19
Pafe version 100 (IBM_PAfE_x86_2.0.100.3.xll)
Planning Analytics Workspace 100, or earlier versions.

Issue:
When you connect in PAX (Planning Analytics for Excel) to a TM1 server, you get a error for some of the TM1 instance you have on your server, but not all.

System.Net.WebException: The remote server returned an error: (502) Bad Gateway.
at System.Net.HttpWebRequest.GetResponse()

Solution:

Check the TM1S.CFG file for differences, between a working TM1 application and none working TM1 application.

If you use the command tlsCipherList in TM1S.CFG file, it must be on ONE line.

Above will give errors, but below line will not.

You need to ensure that all parameters in the file is on one line only.

 

Other possible solution, can be that the firewall is not open the ports needed between the PAW server and the TM1 server.

Check from the PAW server that you have access to the TM1 server on all needed TCP ports.

 

More Information:

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=pa2f82-disable-des-3des-ciphers-in-planning-analytics-mitigate-false-positive-security-scans-1 

 

by ·Comments Off on What is the latest version of Cognos Controller?

Product:
Cognos Controller 11
Microsoft Windows 2022 server

Issue:
I want to upgrade Cognos Controller – what files should i download?

 

Solution:
Check the different IBM web pages, to find out the latest version. As IBM changed the name of IBM Cognos Controller to IBM Controller, old links are not valid.

First you need to download the “base” RTM files from IBM passport portal.

Then you need to find the latest fix pack for the product, check the “what’s new” section to find the latest versions.

https://www.ibm.com/docs/en/announcements/controller-111-introduces-new-look-new-features-providing-benefits 

Or you can check the fix list to find the latest version:  https://www.ibm.com/support/pages/node/7173282 

Issues corrected in IBM Controller 11.1.0

IBM Controller 11.1.0 Fix List

IBM Controller 11.1.0.1 Fix List

Related Information

Then search the IBM Fix central for the latest fix pack to download.

In https://www.ibm.com/support/fixcentral  you can browse for the latest fixes for your product.

Select the product, and click continue to get to a page where you can select “browse for fixes”, then you get a list of all the fixes.

In the list, select the latest fix, and click continue. Select download method, simplest is Download using your browser (HTTPS), and click continue.

Click on the blue file name to download the fix pack for your IBM application.

This date, the file up_cntrl_winx64h_11.1.1002.5_ml.tar.gz (2.38 GB)  is the one you should download. In a few weeks there maybe be a new fix pack.

This page can also help find the latest version of IBM Controller:

https://www.ibm.com/support/pages/ibm-controller-and-ibm-cognos-controller-builds-ccr-name-and-database-version 

Latest fix pack for Cognos Analytics can be:

https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=120x-release-1204-october-2024 

https://www.ibm.com/support/pages/ibm%C2%AE-cognos-analytics-fix-lists 

Search fix central for above fix (interim fix: 12.0.4-BA-CA-Win64-IF002) , for your OS, in case of Microsoft Windows you should download files:

analytics-installer-3.7.38-win.exe (234.48 MB)

casrv-12.0.4-2501300500-winx64h.zip (7.23 GB)

Latest fix pack for Planning Analytics can be:

https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=features-whats-new-in-planning-analytics 

https://www.ibm.com/support/pages/ibm-planning-analytics-21-fix-lists 

 

Search fix central for above, and you should download this planning analytics files for use with Windows 2019 server:

tm1_winx64h_2.1.7.1_ml.tar.gz (1.42 GB) = the planning analytics server (tm1).

IBM_PAfE_x86_2.1.7.2.xll (7.83 MB) = the new tm1 perspective replacement e.g. pax.

tm1web-11.0.100-24120513-2.1.7-winx64h_bundle.zip (706.64 MB) = for the tm1web installation.

ipa_workspace_win_2019_2.1.7.219.zip (4.78 GB)  = for paw installation.

(if you have a Windows 2022 server for PAW, then you need to download this file instead ipa_workspace_win_2022_2.1.7.49.zip (4.69 GB) )

Then check the supported environments, to ensure that your download products can work with each other.

Cognos Controller 11.1 support this version of the other products:

IBM Cognos Analytics 12.0.4 support this version of the other products (as data source) :

Planning analytics 2.1.7 support this version of the other products (this is for authentication):

If you need to import data from a SQL database for Planning Analytics 2.1.7 it supports:

 

Please check that cognos controller and cognos analytics support the version of SQL database you are using.

 

More information:

https://www.ibm.com/support/pages/ibm-planning-analytics-local-217-now-available-download-fix-central-0 

https://www.ibm.com/software/reports/compatibility/clarity/index.html