Microsoft Azure Data Factory


How do i start a pipeline to run now and not wait for the scheduled run?


Go to and select you Azure Data Factory resource.

Click on button “Launch Studio”.

Click on pencil icon (author) on the left.

Expand Pipeline, so you see a list of your pipeline.

Double click on the one you want to start.

Then on top you click on Trigger to run that job.

Select “Trigger Now”

Click OK on Pipeline Run dialog.

Click on the monitor icon – and see if it is started under pipeline runs.



More Information:


Planning Analytics Workspace 73


When starting EXCEL and login to TM1 with PAFE you get a error after you have logged in.

The remote server returned an error: (404) Not Found.

Cognos.Office.Tm1.Connections.Tm1WebException: The remote server returned an error: (404) Not Found. —> System.Net.WebException: The remote server returned an error: (404) Not Found.
at System.Net.HttpWebRequest.GetResponse()
at Cognos.Office.Tm1.Connections.Tm1Request.GetResponse()
— End of inner exception stack trace —
at Cognos.Office.Tm1.Connections.Tm1Connection.HandleWebException(Tm1WebException x, Uri path)
at Cognos.Office.Tm1.Connections.Tm1Connection.GetResponse(Tm1Request request)
at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(Tm1Request webRequest, AcceptReturnEnum returns)
at Cognos.Office.Tm1.Connections.Tm1Connection.SendRequest(String method, String path, String postData, AcceptReturnEnum returns, Int32 timeout)
at Cognos.Office.Tm1.Connections.Tm1Connection.Get(String path, AcceptReturnEnum file, Int32 timeout)
at Cognos.Office.Tm1.Rest.Tm1RestCapabilities..ctor(Tm1Connection connection, String server, Int32 timeout)
at Cognos.Office.Tm1.Rest.Tm1RestConnection.RefreshCapabilities(String server, String path)
at Cognos.Office.Tm1.Tm1DataSource.On_LogOn(String server)
at Cognos.Office.Tm1.Tm1DataSource.Logon(LogonType logonType, DataSourcePropertiesCollection properties)
at Cognos.Office.Framework.Communications.DataSourceManager.LogOn(String dsType, String connectionString, String serverName, IDataSource& source

In the background can Internet Explorer be open and show:

The webpage cannot be found
HTTP 404
Most likely causes:
•There might be a typing error in the address.
•If you clicked on a link, it may be out of date.


Suggested solution:

Check that you have a version of PAFE that is close to PAW version. 

Inside excel on the IBM Planning Analytics ribbon select help – about. It should list version in lower right corner – like 2.0.73

If the help drop down menu show more than “using IBM Planning Analytics for Microsoft Excel” then you can have a old version.

Close excel.

Download a later version of PAFE from IBM.

Check your version of excel – if it is 64 bit – click on the 64 bit xll file to start pafe ( IBM_PAfE_x64_2.0.73.3.xll ).

Select the IBM Planning Analytic ribbon and try to connect again.

Under options – IBM connections – you should point to the PAW servers URL.

More Information:

To add the xll to excel, do this:

  1. Download the Planning Analytics for Microsoft Excel .xll file from IBM Support Fix Central.
  2.  Rename the file to PAFEexcel.xll and move the .xll file to your desired directory. ( like c:\install ) (when you upgrade PAFE file in future you only need to replace the file on the computer – as the name is the same, the excel connection should stay working).
  3. Launch Microsoft Excel.

    When you install the Planning Analytics for Microsoft Excel .xll as an add-in to Excel, do not double-click the .xll file to open Planning Analytics for Microsoft Excel. This causes Excel to crash.

  4. Click the Developer tab.
  5. Click Excel Addins in the ribbon.
  6. Click Browse….
  7. Select the Planning Analytics for Microsoft Excel .xll file.
  8. Click OK.
  9. Go to file – options – trust center
  10. Click on Trust Locations
  11. Click on Add new location button
  12. Add the path to where you have saved your xll file.


Cognos Analytics


What are the tables for in CA11 database?


This is a old list for Cognos 8, maybe it is still valid.

CMSYSPROPS This table has the Content Store Version.
CMOBJNAMES This table has the names of all the objects in the content store.
CMOBJPROPS1 Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table
CMOBJPROPS2 Report scheduling information is stored. This table has fields like hour, day week etc
CMOBJPROPS3 Stores Screen Tip and Object description provided while creating the objects are stored here
CMOBJPROPS4 Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations
CMOBJPROPS6 Has the details of the all packages which were published using the FM.
CMOBJPROPS7 This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models.
CMOBJPROPS10 Contact information is stored in this table. This table has columns like Contact Email and Contact.
CMOBJPROPS11 This table stores the data sources configuration details like connect string, the cube location etc.
CMOBJPROPS13 It stores the names of parameter passed to the range prompts
CMOBJPROPS14 Has details regarding the versions, creation time etc of the objects in the content store.
CMOBJPROPS16 This table provides the status of the multiple services of Cognos like LogService, MonitorService, ReportService, SystemService, JobService
CMOBJPROPS17 Stores performance details of each component like “query Studio, Analysis Studio, Event Studio” etc
CMOBJPROPS18 This table stores the drill path from the source to the final target report.
CMOBJPROPS20 Stores details regarding which are all the reports for which prompting has been enabled. And also has the details of which are the reports which has the default report options overridden.
CMOBJPROPS24 Stores the printer configuration details
CMOBJPROPS25 Stores the data regarding the objects deployed, like the deployed folder, the reports, the number of folders present in the deployment archive, etc
CMOBJPROPS26 This table stores the data about all the packages imported / exported in C8, with the properties selected during the process.
CMOBJPROPS27 Has the details regarding the data source created in the content store using Cubes.
CMOBJPROPS30 Stores the registration , service description etc details about portlets in this table
CMOBJPROPS31 Has the custom logging level for each of the Cognos services, CMID can be be linked to CMOBJNAMES for the names of each of the services
CMOBJPROPS32 Has the details of the stored procedures used as the query items in the FM model.
CMOBJPROPS33 Detail related to users, user groups user roles.
CMOBJPROPS34 Has the details regarding the drill through parameters of the drill through reports. The parameter assign values are present in coded format
CMOBJPROPS36 Has the list of all the Models published using framework manager
CMOBJPROPS37 This table has the details of the routing sets configured for server / load balancing for each package published in the content store
CMOBJPROPS38 Configuration details about number of items to retrieve in studios, for a package are saved under this table.
CMOBJPROPS39 Has values for properties of reports and views. PROPID can be linked to CMPROPERTIES for property names
CMOBJPROPS52 Contains the properties for the connections
CMOBJPROPS55 Has the URI for icons for each entry in Cognos Connection
CMLOCALES Has the locale ids associated with each language supported by Cognos 8


More Information:

Below will list all reports

With CognosContent AS (
Select a.CMID, a.PCMID, b.NAME, b.Name as Parent, as Content
,Cast(b.NAme as varchar(max)) as path
, 0 as level
from cmObjects a
inner join CMOBJNAMES b on a.CMID = b.CMID
inner join CMCLASSES c on a.CLASSID = c.CLASSID
Where b.ISDEFAULT = 1
and a.PCMID =0
and a.CMID = 2
Select a.CMID, a.PCMID, b.NAME as parent, d.NAME, c.NAME
, d.path + '\' + CAST (b.Name as varchar(Max)) as path
, d.level + 1 as level
from cmObjects a
inner join CMOBJNAMES b on a.CMID = b.CMID
inner join CMCLASSES c on a.CLASSID = c.CLASSID
inner join CognosContent d on a.PCMID = d.CMID
Where b.ISDEFAULT = 1
Select NAME as ReportName, path, level, content from CognosContent
Content = 'report' or Content = 'dashboard' or content = 'analysis'
order by path




Cognos Analytics 11
Microsoft Windows 2019 server
Microsoft SQL server


How can i see in a report the schedules that are active in CA11?


The information is in the CA11 Content Store database. You have to make a SQL query like this:

Where ACTIVE = 1


To list all objects name use:

select ob2.cmid, as className, as objectName
from [dbo].[CMOBJPROPS2] p
inner join CMOBJPROPS26 o on p.cmid=o.cmid
inner join CMOBJECTS ob on ob.cmid=o.cmid
inner join CMOBJECTS ob2 on ob.pcmid=ob2.cmid
inner join CMOBJNAMES n on n.cmid=ob2.cmid
inner join CMCLASSES c on ob2.classid=c.classid


More Information: 


Microsoft Azure SQL


Error when try to create a user in AZURE SQL from a Managed Identity Object ID.

Principal ‘xyz’ could not be found or this principal type is not supported.

Cannot add the principal ‘xyz’, because it does not exist or you do not have permission.


Use the managed resource name instead of the object id.  Managed Identity can be replaced with the resource name, when referring to the object.


To make Azure Data Factory to connect to a Azure SQL resource with Managed Identity, you need to create a Managed identity for the ADF resource.

Then you can add the resource to AZURE SQL with below command to give it access to the database.

Login to the AZURE SQL server with SSMS, use the Azure SQL server name to connect.
Select the database and click New Query:


ALTER ROLE [db_owner] ADD MEMBER [adf_name]

By adding a USER direct to the database, and not create a login in SQL, the user must provided the database name when it connects to AZURE SQL.


If you are Owner of the Azure database, then you do not need to be AAD Admin to be able to perform the change in SSMS.

“Azure Active Directory authentication allows you to centrally manage identity and access to your Azure SQL Database.”


More Information:

Connect Azure SQL from Data Factory using Managed Identity


Planning Analytics

Microsoft Windows 2019 server


A few users can not see views in TM1WEB. They get a blank screen. If they become ADMIN, then the view works.

The issue is only for a few cubes. Other cubes work well.

Inside TM1WEB log you find this error:

[Default Executor-thread-9556] ERROR ([]) – [] Exception Error: null Stack Trace: java.lang.reflect.InvocationTargetException

Caused by: java.lang.ArrayIndexOutOfBoundsException
at com.applix.tm1.TM1Val.getArrayVal(

Log files are found at D:\Program Files\ibm\cognos\tm1web\wlp\usr\servers\tm1web\logs\messages.log and

D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\logs\tm1web.log


The user that have issues, does not have READ rights to the picklist in the cube where the view is. They have access rights to the cube and dimensions, but not to the picklist cube that is used by the rule in the cube.

Turn on “display control objects” in TM1 Architect.

Go to Cube – Security Assignments.

Check that, the group the users are part of, have READ for the hidden picklist for the cubes they have problems with.

They start with }PickList_

Increase of memory for JAVA did not solve the issue.

More Information: 


Planning Analytics

Microsoft Windows 2019 server


How keep settings cube values in test, when you copy the production tm1 data folder over?


Use two data folders – one for the cube you do not want to copy and the other folder for the rest.

Setup your TM1 instance, and create the data folder.

Create your sys.settings cube and other you need in your application.

Inside TM1 Architect click on Save Data.

Stop the TM1 instance.

Create a new data folder called: data_syssettings

Move the sys.settings cube to the new folder.

Update the TM1S.CFG file for the new data folder.

# Example:
# DataBaseDirectory=C:\Program Files\Cognos\TM1\Custom\TM1Data\PlanSamp\
LoggingDirectory=D:\TM1 data\FAP\Logs

Save the TM1S.CFG file and start the TM1 instance.

Changes to the cube in the other folder will only be written to that folder.


A other way is to store the environment values in a text file on the server, and then have a TI process that you run that will update the sys.settings with the correct values for this server. Run that TI process every time after you have copied over the data folder from PROD to TEST server.


More Information: 

You can specify that you want IBM TM1 Server to use multiple data directories by separating the directory names with semicolons. When you specify multiple data directories, TM1 does the following.
  • Accesses cubes and dimensions from each of the specified directories. If there is a duplicate object, TM1 accesses the object from the first directory specified.
  • Writes changes to the directory where the object is located. When you create a new object, TM1 writes to the first directory you had specified. 

The ASCIIOutput and TextOutput TurboIntegrator functions do not work with the output path of \\data\s on the Planning Analytics system. Instead, use ./ to indicate a relative path to the TM1® data directory and shared folder on your Planning Analytics system in the cloud. 



Planning Analytics

Microsoft Windows 2019 server


Can i change the background picture in tm1web?


There is no guide for this – but the images used are found in folder like D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\scripts\tm1web\themes\carbon\planning\images

SVG images are dynamic in size and should be edit with a software that can save in SVG format.

D:\Program Files\ibm\cognos\tm1web\webapps\tm1web\scripts\tm1web\themes\carbon\standalone\images\login\PA_Header.svg is the file that create the background in the TM1WEB.

You can edit the file at

The change to the pa_header.svg file is direct visible in tm1web.

You can download inkscape to edit the SVG file, and add some text to it.

When you add some text, it will look similar to this, last in the SVG file if you edit it in Notepad++

id="tspan3">chrome </tspan></tspan><tspan


You maybe can find out how to edit the SVG file direct in notepad.

Chrome may not show the text, but Internet Explorer will do it – depends on the font you select to use. Also space in the font name can give you trouble in chrome. 

Take a backup of your SVG file before you start edit it.


More Information:

Using a custom web fonts in *.svg


Planning Analytics TM1_version=TM1-AW64-ML-RTM-11.0.913.10-0

Cognos Analytics 11.1.7 FP6 kit_version=11.1.7-2210041400

Microsoft Windows 2019 server


A new setup of PAL and CA11 on the same windows server, where you have configured SSO and CAM security.

Login to IBMCOGNOS works fine, also login to TM1 Architect is working.

When a user try to login to TM1WEB, they get a error after selecting the TM1 instance to use.

The webpage cannot be found
HTTP 404
Most likely causes:
•There might be a typing error in the address.
•If you clicked on a link, it may be out of date.

The url say something like:


The tm1web.html file is missing from folder D:\Program Files\ibm\cognos\analytics\webcontent\bi\tm1\web.

Copy the folder D:\Program Files\ibm\cognos\analytics\webcontent\tm1 to D:\Program Files\ibm\cognos\analytics\webcontent\bi\tm1.


If you get error PRS-PRH-0221 The file “portal/variables_TM1.xml” could not be opened.  Rename the file variables_TM1.xml.sample to variables_TM1.xml in folder D:\Program Files\ibm\cognos\analytics\templates\ps\portal.

The url in IBMCOGNOS is something like:….

D:\Program Files\ibm\cognos\analytics\templates\ps\portal\variables_TM1.xml file does not need to be edit any longer. The default variables_TM1.xml needs to stay as is. It is still required (if configured in the tm1s.cfg), but the application will be using the specified tm1web.html file, instead, to redirect the user from the BI (after being authenticated by CAM) to the tm1web server.  Looks like the CA11 in some configurations require this file.

More Information:


Planning Analytics

Microsoft Windows 2022 server


In a setup where TM1 authenticates with Cognos Analytics 11.2.4 (CAM login) and have a working SSO login. After adding SSL (HTTPS) to the CA11 gateway, you get a warning message when you login to TM1WEB.

The information you’re about to submit is not secure – this is from the web browser that warns that you switch between HTTPS and HTTP websites.

You click Send Anyway and you are logged into tm1web.


Ensure that you also use HTTPS on your TM1WEB site.

Set it up from this instructions:

Ensure that all DNS names and alias for you Cognos/Tm1 servers are part of your certificate.


More Information: