by Roger·Comments Off on How add the TM1 name instance to the toolbar
Product:
Planning Analytics 2.1.14 Tm1web
Microsoft Windows 2022 server
Issue:
In TM1WEB how see what application i have logged in to?
Solution:
Add the TM1 instance name in the toolbar with you name.
Go to Tm1 web server
Go to folder D:\Program files\ibm\cognos\tm1web\webapps\tm1web\WEB-INF\configuration
Open file tm1web_config.xml
Change <add key=”TM1DatabaseLabel” value=”Y” />
Save the file
You do not need to restart the TM1WEB service (IBM Planning Analytics Spreadsheet Services) to see the effect.
Only logout and in to TM1WEB.
http://servername.domain.com:9510/tm1web
More Information:
<!– If “Y” or “1” is specified, then the name of the logged in Database will appear next to the logged in user name in the top right of TM1 Web. –>
<add key=”TM1DatabaseLabel” value=”Y” />
Planning Analytics 2.1.11
Microsoft Windows 2022 server
Issue:
How many element in a dimension subset?
Solution:
Use the function SubsetMDXSet to get the number of elements in the selection, it will also convert the MDX subset to a static subset.
SubsetMDXSet applies a specified MDX expression to a public or temporary subset.
If the passed MDX expression is valid, the specified subset is saved as a dynamic subset defined by the MDX expression.
If the passed MDX expression is an empty string, the subset is converted to a static subset that contains the elements that are in place when SubsetMDXSet is executed.
The SubsetMDXSet returns the number of elements that the subset contains.
In below example the subset becomes static as we use ” as parameter.
We can use the number of elements, to count them and add them to a new dimension, with a total element first.
DimensionElementInsertDirect( tDim, '', 'Total', 'C');
sSubset = 'temp_Account';
sMDX = '{TM1FILTERBYLEVEL(TM1SUBSETALL([Account]) , 0)}';
SubsetCreatebyMDX(sSubset, sMDX, 1 );
vNumElems = SubsetMDXSet( tDim, sSubset, '' );
i = 1;
while (i<=vNumElems);
vElem = SubsetGetElementName( tDim,sSubset, i );
DimensionElementComponentAdd( tDim, 'Total',vElem, 1 );
i = i +1;
end;
Sometimes we can not login, but it work if we start a different web browser on your computer. Try EDGE instead of CROME.
Note that PAW and TM1WEB looks like it use different whys to handle cookies at login.
CA may time out and throw one of the following errors:
Unexpected Server Response
HTTP Error 431
Unable to Load Requested View
Cannot read properties of undefined (reading ‘perspective’)
DPR-ERR-2107 The User Capabilities Cache cookie cannot be decoded.
Solution:
Clear cache and cookies from the affected browser. See KB 15 (Michigan State University) for details.
Close completely out of all browser windows.
Open an incognito/InPrivate browsing window and use that to access Cognos. See KB 1203 (Michigan State University) for details.
Check you go to correct start page ( https://XXXXX.planning-analytics.cloud.ibm.com ) – exchange with your local server name.
Check that your local network is working – try a different physical location for your laptop.
There can be other solutions or explanations of this errors – hopefully you can find them at IBM site.
How to retrieve the content of the CAM_passport and userSessionID from cookie?
In Browser window after you log in to the Cognos Connection Portal type any of the following in the address bar of the browser:
Or maybe have a look in your user directory under “C:\Users\yourname\AppData\Local\Microsoft\Edge\User Data\Default” or “C:\Users\yourname\AppData\Local\Google\Chrome\User Data\Default” .. or where the files are stored in modern browsers.
Easier to view cookies in Chrome, perform the following steps:
Open Chrome settings. Right-click on your browser window.
Choose Inspect to enter the Chrome Developer Tools.
Choose the Applications tab. Depending on the size of your screen, you may need to expand your tab options at the top by clicking on the >> symbol:
Open application.
Under the Storage tab, select Cookies to view cookies in Chrome.
You will see all the available websites. Select the website you want to see cookies in Chrome.
Check the domain column, if you have different values here for same cam_passport (cookie) then you can get above errors. Should only be ONE domain name for the same cookie name.
Name. The cookie’s name.
Value. The cookie’s value.
Domain. If the domain name corresponds with the website you are browsing, it means that these cookies are First-party cookies. If the domain name is different- these cookies are third-party cookies.
Path. The URL that must exist in the requested URL in order to send the Cookie header.
Expires / Max-Age. The cookie’s expiration date or maximum age. This field shows which are session cookies and which are persistent cookies, that operate for a certain duration of time.
Size. The cookie’s size, in bytes.
HttpOnly. If true, this means that it is a HTTP cookie. JavaScript modification is not allowed.
Secure. If true, this means that the cookie is sent to the server only over a secure, HTTPS connection.
SameSite. The SameSite cookie attribute is used by browsers to allow or block cookies based on attribute. It could contain Strict or Lax SameSite attributes.
Partition Key. A cookie’s partition key is the scheme and registrable domain of the top-level URL the browser was visiting at the start of the request to the endpoint that set the cookie.
Priority. It is used with deprecated cookie priority attribute. Could contain Low, Medium (default), or High priority.
Issue:
What anti-virus software should i use on my old laptop?
Suggested solution:
Windows Defender is good, but when there are no more updates, you can consider to use a separate Anti-Virus software product.
You have to yourself decide what to use (and if you need it) as the software market for anti-virus program is lucrative, program that was good for 10 years ago is maybe not the best today.
Consider:
Is the software easy to understand for me? Can i setup schedule scans in a easy way?
What is the price the second year? Most software will give you a 50% discount the first year. Check if you can get a family price for 3-5 computers. Review sites have often links to good offers.
Does the software take a lot of CPU when running or does it do the scan in the “cloud” ? Check more than one review to see if the program will slow down your PC.
Check more than one review of the software – most top teen listings are only trying to sell you a special anti-virus software where they get most money from.
Do you trust the company behind the program? Check WIKI pages about what country the software comes from.
As of January 2006, ZoneAlarm was reportedly[6] sending data to the company’s servers in a covert fashion. A developer dismissed allegations that ZoneAlarm was spying on its clients, saying that it was an issue related to software updates and that it would be fixed.[7]
In December 2007, a browser toolbar was shipped with ZoneAlarm as an opt-out, which was not well received.[8] This was removed in later versions of the software.
On September 2, 2010, the free version of ZoneAlarm started showing a “Global Virus Alert” popup as a scareware tactic to get users to switch to their paid security suite.[9] The popup was turned off by ZoneAlarm marketing team after an uproar from disgruntled users, many of whom uninstalled the software.[10][11]
These program have a free version (that you can test):
We tested the Bitdefender windows version on Windows 10.
We run a deep scan, and it found things in old TM1 files, version 2.1.5, Trojan.GenericKD is Windows-only malware, as far as I know, so it’s highly likely that these detection’s are false positives, as it looks like many anti-virus software can find them in different files.
If there where issues, this are solved now. IBM sends out updates regularly. We checked the latest version PAL 2.1.14, and there where no issues there.
(It looks like the Bit-defender can not scan ZIP files larger than 2 GB)
We upgrade Bitdefender to PLUS version in hope the firewall should be part of that deal.
But firewall was not part of the PLUS version. We got the VPN function, but you can not choose what country you will be using. We need to upgrade again to get firewall…
The company change the offering every year, so the package you have the first year may be something different the next year. If you stop your automatic subscription, then the bitdefender program stops working when the subscription ends. Malwarebytes have a different solution.
Passwords manager is better to use separate program like:
by Roger·Comments Off on The refresh token has expired due to inactivity
Product:
Microsoft Power BI service Issue:
When click on refresh for a dataset (sematic model) in https://app.powerbi.com/ you get a error like:
Data source error: {“error”:{“code”:”DMTS_OAuthTokenRefreshFailedError”,”pbi.error”:{“code”:”DMTS_OAuthTokenRefreshFailedError”,”details”:[{“code”:”DM_ErrorDetailNameCode_UnderlyingErrorMessage”,”detail”:{“type”:1,”value”:”AADSTS700082: The refresh token has expired due to inactivity. The token was issued on 2024-11-19T10:55:36.9381120Z and was inactive for 90.00:00:00.
Solution:
Wait and try again later or go into your PowerBI report and update all credentials to different data sources you have used in your report.
In the dataset – go to settings – take over as owner – go to data source credentials
click on edit the credentials and update with your account information. This should refresh the token.
This issue can happen when the OAuth refresh token used by Power BI Service to authenticate with the data source has expired. The error message shows that your token has been inactive for 90 days, which is the default expiration period for Azure Active Directory (AAD) refresh tokens.
Here are a few suggestions you can check:
Re-authenticate the Data Source in Power BI Service
Go to Power BI Service (app.powerbi.com).
Navigate to Settings > Manage Connections and Gateways.
Locate the data source for your dataset.
Click Edit Credentials and sign in again using your credentials.
Choose the correct authentication method (usually OAuth2 for Analysis Services).
Save and retry the refresh.
Check and Update Permissions
If your credentials were updated or your permissions changed, you may need to reassign them.
Ensure that your account has read permissions on the Analysis Services data source.
If your organization uses Conditional Access Policies, check with your IT team to ensure Power BI can maintain an active connection.
Remove and Reconnect the Dataset
If the issue persists, try removing the dataset from Power BI Service and republishing it from Power BI Desktop.
Ensure Your Token Doesn’t Expire Again
If you’re using service accounts, consider setting up a refresh schedule to keep the token active.
Work with your IT admin to adjust AAD token lifetime policies to extend the refresh token validity.
Try a Personal Gateway (If Applicable)
If you’re using a Personal Mode gateway, restarting or reinstalling it might help.
by Roger·Comments Off on kate-agent does not respond after upgrade
Product:
Planning Analytics version 2.1.14
Microsoft Windows 2022 server
Issue:
After upgrade from previous version of TM1, you do not get the PAA_Agent to work. It does not respond on port 9012.
In power shell you test with: tnc servername.domain.com -port 9012
Suggested solution:
The path to the bin folder have changed for TM1, to D:\Program Files\ibm\tm1_64\bin64
Therefor when you have updated the PAA Agent, run the following scripts from a Command Prompt.
<install_dir>\paa_agent\bin\PAAAgentSetJavaHome.bat
This should update the server.env file with the correct path to the JAVA JRE
The configuration is done in the D:\Program Files\ibm\tm1_64\paa_agent\wlp\usr\servers\kate-agent\bootstrap.properties file.
This file need to be updated manually every time you upgrade, as it is overwritten with default values.
If you have more TM1 tools installed on the server, it can point to the other folder and still work.
Then after that file is updated, you can start the PAA_Agent service.
If above does not work;
You may need to uninstall PAL totally and start over.
Stop all TM1 services.
To remove the TM1 Admin Server service, run the tm1admsd.exe -remove command.
To remove the Planning Analytics Administration agent service, run the <install_dir>\paa\bin\PAAAgentDelete.bat script.
Run Uninstall_IBM_Planning_Analytics.exe in the <install_dir>\uninstall directory.
Ensure that the PAA Agent is uninstalled from the Windows service list.
Then run the installation again of TM1/PAL from analytics-installer-4.0.27-win.exe
Create the ADMIN service again.
Update the bootstrap.properties file with SMTP information
by Roger·Comments Off on Unable to register subset
Product:
Planning Analytics 2.1.11
Microsoft Windows 2022 server
Issue:
You get random Unable to register subset when you run the Tm1 TI process, can be that the subset is not correct deleted, and therefor already exist when the TI process try to create it.
Error contain: Unable to register subset
Suggested solution:
Instead of using the TI process name, create a random subset name with a code similar to below:
For TM1® Server version 11.2.0 and earlier, temporary views were visible and usable only by the process that created it and any of its child processes. Temporary views were not visible to the ancestor and sibling processes. You could create same-named views in sibling child processes with the same parent process.
For TM1 Server version 11.3.0 and later, these temporary views are visible to the ancestor and sibling processes. If a parent TurboIntegrator process A invokes two child TurboIntegrator processes A1 and A2, and the child TurboIntegrator process A1 creates a temporary view S, the temporary view S exists for the duration of the parent TurboIntegrator process A. You cannot create a temporary view with the same name S in the sibling TurboIntegrator process A2 since the view is visible and usable by siblings A1 and A2.
Planning Analytics 2.0.7 – April 29, 2019 IBM Planning Analytics Local version 2.0.7 and the cloud release of IBM Planning Analytics version 2.0.7 includes updates and new features for IBM TM1 Server version 11.5.0.
Planning Analytics 2.0.6 – October 11, 2018 IBM Planning Analytics Local version 2.0.6 and the cloud release of IBM Planning Analytics version 2.0.6 includes updates and new features for IBM TM1 Server version 11.4.0.
Planning Analytics 2.0.5 – June 25, 2018 IBM Planning Analytics Local version 2.0.5 and the cloud release of IBM Planning Analytics version 2.0.5 includes updates and new features for IBM TM1 Server version 11.3.0.
Planning Analytics 2.0.4 – February 16, 2018 IBM Planning Analytics Local version 2.0.4 and the cloud release of IBM Planning Analytics version 2.0.4 includes updates and new features for IBM TM1 Server version 11.2.0.
Before you decide, search the internet for zonealarm issues…
