Product:
IBM Controller 11.1.1003
Issue:
When start Cognos Controller client after a upgrade – you get a error:
System.TypeinitialzationException… create a exception..
System.NullReferenceException…have not been found…
CCR.CCRApplicationsettings.cctor….
Solution:
Check that you start IBM Controller client and not IBM Cognos Controller client, the older version.
The new software should be installed to C:\Program Files\IBM\IBM Controller Local Client\
More information:
Product:
Planning Analytics 2.0.9.19
TM1_version=TM1-AW64-ML-RTM-11.0.919.10-0
TM1_name=IBM Cognos TM1
Issue:
How export dim values to SQL?
Solution:
Create a TM1 TI process that have the dimension as a data source. Set the variable name to account, and as string. On the TM1 server create a ODBC connection to the SQL database.
Enter code similar to this:
#Section Prolog
sDimension = 'plan_chart_of_accounts' ;
sSource = 'OdbcDatabasename' ;
sClient = 'sql login user' ;
sPassword = 'sql login password' ;
sUseUnicodeODBC = 1 ;
ODBCOpenEx(sSource, sClient, sPassword, sUseUnicodeODBC) ;
#Section Metadata
#Section Data
sSQL = '';
CountofParent = ElParN( sDimension , Account);
ElementLevel = ElLev( sDimension , Account);
ParentCounter = 0;
WHILE (ParentCounter <= CountofParent);
ParentElement = ElPar( sDimension, Account ,ParentCounter);
sSQL = Expand('INSERT INTO dbo.AccountTable (Account, parentelement, countofparent, elementlevel) VALUES (''%Account%'',''%ParentElement%'',''%CountofParent%'', ''%ElementLevel%'')');
ODBCOutPut( sSource , sSQL );
ASCIIOutput( 'd:\temp\debug.txt', Account, ParentElement , NumberToString( CountofParent ) , NumberToString( ElementLevel ) );
ParentCounter = ParentCounter+1;
END;
#Section Epilog
You need to adjust the TM1 code to be working for you.
More Information:
https://github.com/cubewise-code/bedrock
https://cubewise.com/blog/mastering-hierarchies-in-ibm-tm1-and-planning-analytics/
https://exploringtm1.com/unwinding-removing-the-structure-from-a-dimension/
https://lodestarsolutions.com/level-0-not-leaf-planning-analytics-tm1-set-editor/
https://cubewise.com/functions-library/tm1-function-for-rules-ellev/
https://cubewise.com/functions-library/tm1-function-for-ti-odbcopenex/
https://quebit.com/askquebit/how-to-speed-up-tm1-odbc-output/
https://jpbi.blogspot.com/2007/05/sql-trick-for-flattening-parent-child.html
https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists
Product:
Microsoft Azure
Dataflow in Workspace
Issue:
The dataflow update have failed, and you get a message like “Error: We encountered an error while performing the refresh. Please try again. If the issue persists contact Support”
Solution:
Please try to refresh the dataflow again.
It looks like when you use the “free” or “pro” license for the workspace, the resource to update dataset or dataflow are shared by all the other users.
License limits:
More Information:
Power BI Pro is a paid license extending Free with collaboration and sharing features in the cloud, suitable for business users. It is intended for business users who need to share reports and collaborate within a team or across the organization.
Pro includes:
Price: $14 per user/month
It is worth noting that Power BI Pro is included in the Microsoft 365 E5 license, so no additional cost is required if you’re already covered by it.
https://www.microsoft.com/en-us/power-platform/products/power-bi/pricing
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-license
https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-subscribe?tabs=creator
https://antdata.eu/power-bi-license-and-subscription-types-what-to-choose/
https://www.metisbi.co.uk/blog/navigating-powerbi-and-fabric-licensing
https://www.syskit.com/blog/power-bi-license-types/
https://www.ccslearningacademy.com/power-bi-pro-vs-premium/
https://www.phdata.io/blog/implementing-power-bi-premium-capacity/
Product:
Planning Analytics Workspace 2.1.10 ( = 2.0.103)
Issue:
Comments and code in rule editor are the same color. Make it hard to read.
Solution:
Upgrade to PAW 2.1.11
More Information:
https://www.ibm.com/support/pages/ibm-planning-analytics-21-fix-lists
https://www.ibm.com/support/pages/ibm-planning-analytics-20-fix-lists
Product:
Cognos Controller 11.1.1003.12
Microsoft Windows 2022 server
Issue:
How change from non-production to production in the header of the cognos controller client program?
Solution:
In later versions of Cognos Controller this is controlled from a file on the controller server.
Login to the cognos controller server as administrator.
Go to folder D:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer
Open file web.config in notepad
Change from 0 to 1 at:
<add key="OptimizeDefineAccountQuery" value="true" /> <!-- Indicate Production or Non-Production, Levels: 0=Non-Production, 1=Production" --> <add key="InstallerType" value="1" /> <add key="OptimizeJournalCopyQuery" value="false" />
Save the file.
Try again in Cognos Controller client.
You control if the users should see the database and user in the toolbar inside cognos controller from user settings:
Go to Maintain – User – Personal Defaults.
Select Layout tab.
Mark Display Data source and User ID.
Click OK.
More Information:
Product:
Planning Analytics 2.1.10
Microsoft Windows 2022 server
Planning analytics for excel ( IBM_PAfE_x86_2.0.100.3.xll )
Issue:
How do i work with a old TM1 perspective report in PAFE (PAX)?
Solution:
Create a common file share e.g \\server\pax\master (where all users that should update xlsm files should have access)
To take a existing TM1 perspective websheet to work with it in pafe (pax) you need to convert it.
Open PAFE in excel.
Ensure that you have a open blank workbook in Excel.
Ensure that you have “trust access to the VBA project object model” set.
In IBM Planning Analytics ribbon in Excel click on Options.
Scroll down to “upgrade action buttons”
Click upgrade action buttons.
Fill in a local folder and click OK.
Select you TM1 server connection – and login.
Go down to the folder where you have your report you want to convert, select it and click upgrade.
This will change the report.
Click OK
Close Excel.
Start TM1 perspective.
Login to your TM1 instance.
Explore you websheet under applications.
Open your websheet into excel, by click on it.
Inside Excel, go to Save As, and save the fil in your folder \pax\master as a .xlsm file.
Name the file to same name as your report show in TM1 applications.
Close Excel.
Start PAFE in Excel again.
Go to file – open – and open the .xlsm file you have saved above.
Click on Connect button in the IBM Planning Analytics Ribbon.
Select you TM1 server and your TM1 instance to connect.
Now you should have the report in PAFE, and on the right side you have a workbook tab. Here you can expand “action buttons” and change the existing buttons in your old Tm1 Perspective report.
After you have done any changes in the spread sheet, save it to the shared folder or a temporary local folder.
Use Excel format settings to change the text size in buttons etc.
When you are done, click on the Publish icon.
Then select under what folder you want to store the websheet.
This websheet will be visible in both TM1WEB and PAW.
Exit Excel.
When you work with PAFE (PAX) reports, you need to start from a xlsm file you have stored yourself.
(There are other ways to work with websheet in PAFE, above is a suggestion).
More Information:
https://exploringtm1.com/how-to-upgrade-install-planning-analytics-for-excel-pax/
https://quebit.com/askquebit/ibm-planning-analytics-for-excel-quick-start/
Product:
Cognos Controller 11.1
Microsoft Windows 2022 server
Issue:
When you login to Controller Web you see only planning analytics.
Solution:
Go to folder d:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\usr\servers\fcm.glass
Open server.env in notepad++
Normally you only need to change the c: to d: if you have installed the cognos controller program to the d: drive with default paths.
If this point to wrong folder, the controller web does not work after login.
You need to restart windows service IBM Controller UI (FCMGLASS) for the change to take affect.
More Information:
https://www.ibm.com/docs/en/controller/11.1.0?topic=only-configuring-controller-web
Product:
Cognos Controller web 11.1
Microsoft Windows 2022 server
Issue:
What IBM service should be running on the server?
Solution:
When uninstalling the old version of Cognos Controller, reboot the server and ensure that the IBM Cognos Controller Web service is unregistered. That is FCMWEB.
Go to the Command prompt (CMD). Manually unregister windows service with command:
sc delete FCMWEB
replacing FCMWEB with the exact name of the service you want to delete, if there are others.
After the reboot of the windows server, install the new version of Cognos Controller.
The anti-virus software can make the installation very slow – please consider to exclude the install folder from the anti-virus protection.
Now you should have a IBM Controller Web service.
Above is the windows service you should have if you install all Cognos Controller selections.
More Information:
https://www.ibm.com/docs/en/controller/11.1.0?topic=only-configuring-controller-web
https://www.ibm.com/support/pages/download-ibm-controller-1110-fp2-fix-central
https://www.ninjaone.com/blog/delete-windows-service-from-command-line/
https://www.action1.com/blog/how-to-delete-windows-service-in-command-line-or-registry/
Product:
Cognos Controller 11.1.1003.12
Cognos Analytics Build: 12.0.4.46
Object Model version: 202406
Microsoft Windows 2022 server
Problem:
The PDF report is totally black.
Solution:
This is a feature of the new reports in CA 2.0.4.
In IIS Manager select the virtual directory (ibmcognos if using the default) and double-click Mime Types.
Add the following mime types to your IIS configuration if they are not already present.
Try to run a CA report to PDF format.
Cognos Controller 11.1 only supports CA 12.0.3 and not CA 12.0.4
Above changes may not work in Cognos Controller 11.1, you can either install CA 12.0.3
from file ca_instl_win_3.7.29.exe and ca_srv_win64_12.0.3.zip,
or use Controller embedded reporting, with this setting on the Controller server:
Open C:\Program Files\IBM\cognos\ccr_64\ControllerProxyServe\Web.config file
Add this line to the file:
<add key=”ccrReports” value=”http://servername.domain.com:9082/fcm.reports/report” />
Browse to the folder C:\Program Files\ibm\cognos\ccr_64\fcmweb\wlp\etc\
Edit the file server.env:
Add the following line:
JAVA_HOME=C:/Program Files/IBM/cognos/ccr_64/fcmweb/jre
Save the file and restart the server.
More information:
Product:
IBM DB2 Data Studio
Microsoft Windows 2022 server
Issue:
Error when starting DS4.1.2 client
An error has occurred, See the log file d:\program files\ibm\ds4.1.2\configuration\1747225616665.log
org.osgi.framework.BundleException: Unable to acquire the state change lock for the module: osgi.identity; osgi.identity=”org.eclipse.core.runtime”
Solution:
Before starting the DB2 studio client program
Then start the program as “administrator”, right click on icon and select “run as administrator”.
and select the path to the folder to be something like d:\IBM\rationalsdp\workspace
Then you should be inside DB2 Data Studio, and see the list of database on the side.
More Information:
https://www.eclipse.org/forums/index.php/t/823236/
https://www.ibm.com/docs/en/db2/11.5.x?topic=objects-retrieving-data-from-tables-views
https://www.raghu-on-tech.com/2020/02/29/db2-finding-top-10-most-active-tables/