by ·Comments Off on Credentials are required to connect to the SQL source.

Product:
Microsoft Power BI portal / service

Issue:

How move a dataflow gen1 from one workspace to a another workspace?

Solution:

From source workspace, click on the 3 dots … and select export json file.

Save the file on your hard disk.

Change the powerbi workspace to the new workspace where you want to import the dataflow

Click on “new item” and select Dataflow Gen1

Click on “import model”

Select the json file you have saved – and click open.

When the dataflow is imported, you need to update the credentials to connect to the data source.

Click on the 3 dots … and select edit.

Click on the edit table icon for one of the tables in the list.

You may get a message like: Credentials are required to connect to the SQL source.

Click on options.

 

If you use a power bi query gateway to access your SQL database, you need to select it at data load, and click OK.

Click Save and close.

Now it should work to update (refresh) your dataflow.

If it does not help, you may need to go to manage connections, and try to set a different user to access the data source.

 

More Information:

https://forum.enterprisedna.co/t/moving-data-flows-and-report-to-a-new-workspace/22166 

Move dataflows across workspaces with the Power BI REST API

https://www.phdata.io/blog/migrating-queries-from-power-bi-desktop-to-dataflows/ 

by ·Comments Off on HTTP Error 404.0 – Not Found

Product:
IBM Cognos Controller 11.1
Microsoft Windows 2022 server

Issue:

After a new install of IBM Cognos Controller 11.1, the reports give a error inside the client, something like this

Solution:

Even the documentation say, The installation of IBM® Cognos Analytics is needed only for using the Cognos Access Management authentication. You must enable the embedded report system to make it not ask for CA11 support.

Go to the Windows server where you have installed Cognos Controller 11.1

Go to folder C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer

Open file web.config in notepad++

Add the line <add key=”ccrReports” value=”http://myserver.example.com:9082/fcm.reports/report” />

Save the file.

Open file server.env from folder C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer

Add the line JAVA_HOME=C:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

Adjust the paths to your setup, like if you have installed on d: drive it should be JAVA_HOME=D:/Program Files/IBM/cognos/ccr_64/fcmweb/jre

Save the file.

Restart the windows server.

Now the cognos controller client does not need the CA11 services, as long you use NATIVE security mode.

Looks like you can leave this at default values, when you use NATIVE security mode:

Then you need to setup the client distribution server correct.

Next issue you will have is to configure EDGE on the client to open inside the cognos controller program, and not outside as a separate PDF reader.

You can try this (but it may not work):

To make Microsoft Edge open PDFs in an external application instead of the browser, follow these steps:

Method 1: Change Edge PDF Settings

  1. Open Edge and go to edge://settings/content/pdfDocuments
    • You can also navigate manually:
      • Click the three-dot menu (⋯)
      • Select Settings
      • Go to Cookies and Site Permissions → PDF documents
  2. Enable “Always download PDF files”
    • This forces Edge to download PDFs instead of opening them in the browser.
  3. Set a Default PDF Viewer in Windows
    • Right-click any PDF file in File Explorer
    • Click Open with → Choose another app
    • Select your preferred PDF viewer (Adobe Acrobat, Foxit, etc.)
    • Check “Always use this app to open .pdf files”
    • Click OK

Now, when you click on a PDF in Edge, it will download and open in your default PDF viewer.

 

More information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

https://www.ibm.com/docs/en/controller/11.1.0?topic=icclo-installing-configuring-controller-one-computer

https://www.ibm.com/docs/en/controller/11.1.0?topic=environment-cognos-analytics

https://www.ibm.com/docs/en/controller/11.1.0?topic=releases-whats-new-in-1110

by ·Comments Off on Access to the registry key ‘HKEY_LOCAL_MACHINE\Software\VB and VBA Program Settings\FrangoController\Settings’ is denied

Product:
IBM cognos controller 11.1
Microsoft Windows 2022 server

Issue:

When you start the cognos controller client you get a error, like this:

System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Access to the registry key ‘HKEY_LOCAL_MACHINE\Software\VB and VBA Program Settings\FrangoController\Settings’ is denied.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrServerB.LocalConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
— End of inner exception stack trace —
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Direct.ConnectionDirect.SetSelectDb(Boolean bSelectDb)
at CCR.AppContext.SelectDb()
at CCR.AppContext.Login()

Solution:

Change the DefaultAppPool on the IIS server to use localsystem as the user for the service.

Go to IIS manager

Expand the application pool

Select the pool used by controllerservice

Click on advance settings

Change identity to localsystems

Click ok

Restart the iis from inside IIS manager.

 

More Information:

https://www.ibm.com/support/pages/node/262325

https://www.ibm.com/docs/en/controller/11.1.0?topic=icclo-installing-configuring-controller-one-computer

by ·Comments Off on The resource cannot be found.

Product:
IBM Cognos Controller 11.1
Microsoft Windows 2022 server

Issue:

When you check the controller com+ components, you get a error in the web browser like this:

Server Error in ‘/’ Application.

The resource cannot be found.

Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly.

Requested URL: /ibmcognos/controllerserver/ccrws.asmx

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0

 

Solution:

You may not have created the virtual directory’s correct under the virtual directory IBMCOGNOS, therefor they are not visible.

Create the cognos controller directory’s in correct place.

Then when the test works, it should look similar to this:

http://nameofyourserver/ibmcognos/controllerserver/ccrws.asmx

Other issues, could be, that not all files was installed. Run the installation of IBM Controller again on the server.

 

More Information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=iccoc-configure-web-server

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

https://www.ibm.com/support/pages/node/213339

by ·Comments Off on Cognos.Controller.Proxy.ControllerReportNetService.CCRReportClient.GetCCRReport numberOfDecimals….

Product:
IBM Controller 11.1 (before Cognos Controller 11.0)

Microsoft Windows 2022 server

Issue:

When you run a standard report inside Cognos Controller Client, you get a error, like this:

The PDF report is not shown.

If you check windows application log on the controller server, you see this message:

Error occured at 2025-03-09 15:13:11 in IBM Cognos Controller, Error No=5, Source=FrangoDirect.StandardReportD.GetCCRReportSystem.Web.Services, Description=System.Web.Services.Protocols.SoapException: Server was unable to process request. —> System.ArgumentException: Unable to connect to the remote server
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)…..

Solution:

The report service is not started, start the windows service: IBM Controller Reports   (FCMREPORTS)

 

More information:

https://www.ibm.com/docs/en/controller/11.1.0?topic=options-configuring-controller-embedded-report-library

https://www.ibm.com/docs/en/controller/11.1.0?topic=SS9S6B_11.1.0/com.ibm.swg.ba.cognos.ctrl_inst.doc/t_installfixpacks.htm

https://www.ibm.com/docs/en/controller/11.1.0?topic=icclo-installing-configuring-controller-one-computer

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?

(check the day before you do your installation – there will be newer version available than those listed in this article)

Updater Kit Build FCM Web Client (classic) CCR Version DB Version Comment
11.1.1003.31 11.1.1003.12 11.1.1003.12 11.1.1003.3 11.1.0 FP3 1017 Generally available (Fix Central)

 

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 

by ·Comments Off on How upgrade to PAW 100?

Product:
Planning Analytics version 2.0.9.19 (PAL)
Microsoft Windows 2019 Server

Issue:
How upgrade to Planning Analytics Workspace 100 from version 96 on Microsoft Windows 2019 server?

Solution:

Download the correct file from IBM Fix Pack.  https://www.ibm.com/support/pages/download-ibm-planning-analytics-local-v20-planning-analytics-workspace-release-100-fix-central

ipa_workspace_win_2019_2.0.100.219.zip

Copy the zip file to your Windows server where you run PAW.  Unzip the file to a folder named d:\running\paw100, should look like below (after the installation)

Ensure that the Windows server have 25 GB ram (the new version of PAW demands more memory).
Ensure you have at least 100 GB free disk space on the server, (the installation takes around 12 GB for the new version).

This version use a new Mongo database, before you upgrade you need to backup your content in the existing solution.

Update the anti-virus software on the Windows server to not scan above newly created folder and subfolders.

Start powershell as administrator, and go to the old PAW installation folder.
Run backup.ps1 from the scripts folder.

This will restart the PAW and create backup in a folder with todays date, as below:

Now you in the \paw96\scripts folder enter paw.ps1 stop, to stop the old version from running.

Enter docker ps, to check that there is no containers running, before you start the installation.

Copy the d:/paw96/config/paw.ps1 file from your current installation to the new installation location e.g.  d:\running\paw100\config\.

Copy the d:/paw96/config/certs directory from your current installation to the new installation location.

If you have configured SSL, copy the <paw_install_location>/config/ssl directory from your current installation to the new installation location.

Inside the powershell window, go to the new folder d:\running\paw100 and enter start.ps1

After the check have passed, enter y to start the installation.

Enter yes, to get the installation to continue, after you confirmed that you have made a backup.

Enter y to start the Administrative console.  If you have chrome on the server, it will start up and you have to accept the license requirements for all 3 parties components.

You can see the version number above, to ensure you are installing version 100.

When you get to the configuration page, click validate, to ensure that all ports are still open. The config URL should be the same as they are read from the paw file you copied before.

 

TM1 application server gateway URI is not used anymore, so this error is OK.  Click on update, to restart the PAW containers.

On the status page, can you see what process take the most CPU at the moment. The start of PAW take time, you have to wait.

If you get a lot of errors, you may need faster CPU and more MEMORY on the server.

When the server settles, and you have check that you can browse to your planning analytics workspace from you chrome web browser, it is time to restore the databases.

Inside Powershell window on server, copy the path to you backup folder, and then go to the new script folder at d:\running\paw100\scripts and enter restore.ps1 “path to you backup folder” as picture show below:

This will stop PAW and restore the database, so you have all your books and reports back into PAW.

When all is running, you should have this containers on your PAW server:

Now you need to go to your administrator page in PAW, and click on agent, to come to the page where you can download the new PAA agent file to install on your TM1 servers.

Download the file paa-agent-pkg-2.0.100.1800.zip

Copy the file to the TM1 server, and unzip it to a folder like d:\temp\paa

Check the path to your existing PAA agent – D:\Program Files\ibm\cognos\tm1_64\paa_agent..
Make a backup of file D:\Program Files\ibm\cognos\tm1_64\paa_agent\wlp\usr\servers\kate-agent\bootstrap.properties

Start a command prompt as administrator, and go to the folder where you have unzip the paa agent files.  Enter  updatepaaagent.bat “d:\program files\ibm\cognos\tm1_64”

When it is done, start your web browser on your laptop and go to the PAW site, and go to administration, agent, to test the mail function, click on Test email.

Email will only work if you have it configured.

 

Check that you have your folders and books back in PAW. If all works, then the upgrade was a success.

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=2wnj12-enable-email-notifications-in-planning-analytics-workspace-local-1

 

More Information:

https://exploringtm1.com/planning-analytics-workspace-scripts/ 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=local-upgrade-planning-analytics-workspace 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=ipawl-install-planning-analytics-workspace-local-windows-server-2019-2022 

https://www.ibm.com/support/pages/important-upgrade-requirement-planning-analytics-workspace-local-20100-and-217 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=local-backup-restore-planning-analytics-workspace 

https://www.ibm.com/support/pages/after-each-reboot-some-planning-analytics-workspace-containers-are-failing-start 

 

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=components-planning-analytics-administration-agent-local-only

https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=integrations-configure-integration-watsonxai-support-decision-optimization 

https://cloud.ibm.com/apidocs/watson-data-api#creating-an-iam-bearer-token 

https://cubewise.com/blog/ibm-planning-analytics-workspace-paw-2-0-100-2-1-7/

by ·Comments Off on The value for ‘Date’ cannot be determined. Either the column doesn’t exist, or there is no current row for this column.

Product:

Microsoft Power BI desktop
Microsoft Windows

Issue:

Error when you try to add a measure in the visualizations list of data.

 

Solution:

Try to add a new column instead. The icons tell what type of value it is.

More Information:

Another important difference between measures and calculated columns is that measures are evaluated in the filter context of the visual in which they are applied. The filter context is defined by the filters applied in the report such as row selection, column selection, report filters and slicers applied. Measures are only evaluated at the level of granularity they are plotted at. As calculated columns are computed when you first define them/ when you refresh your dataset, they do not have access to the filter context. Calculated columns are calculated outside of the filter context and do not depend on user interaction in the report.

When you write a calculated column, you need to rely only on the row context. The row context, is simply the notion of a current row. It specifies which row we are calculating the values for, so that DAX can look at other values in the same row. In a calculated column, the row context is implied. When you write an expression in a calculated column, the expression is evaluated for each row of the table. The calculated column has knowledge of the current row.

By contrast, measures implicitly do not have a row context. This is because, by default, they work at the aggregate level. So, you cannot refer to columns directly in a DAX measure, you will get an error because no row context exists. This is because the measure will not know which row to choose in the table

https://endjin.com/blog/2022/04/measures-vs-calculated-columns-in-dax

Measures vs. Calculated Columns in Power BI

https://www.thedataschool.com.au/mipadmin/the-differences-between-new-measure-and-new-column-in-power-bi/ 

https://biinsight.com/define-measure-table-power-bi-desktop/ 

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/