Vlad Didenko

Perspectives Action button – recalculate before running TI process

If you have an action button in your TM1 Prespectives report that runs some TI and that TI uses the entered values in the given Perspectives report, the sheet needs to be recalculated in order those values to be available in the TI process. Simply go to action button properties, open Calculate tab and selectContinue reading “Perspectives Action button – recalculate before running TI process”

Run program as administrator in Windows without credentials or consent prompt

First of all this way is not recommended to implement on machines in a corporate network, but if you just want to disable that prompt on your personal home computer where you have less security requirements and understand programs you are running, this method will work for you. Disable prompting for consent / credentials whenContinue reading “Run program as administrator in Windows without credentials or consent prompt”

Notepad++ plugin manager & handy plugins

If Plugin Manager is missing in Plugin menu, you can install it manually. Download and unzip it. Place PluginManager.dll file in the Notepad++ plugins directory Place gpup.exe file in the updater directory Restart Notepad++ Enjoy! Some useful plugins: JSTool (format JSON data)

TM1 division operator (backwards slash)

In TM1 even though you can use both “” (back slash) and “/” (forward slash) for division, it’s highly recommended to use the first one – “” (back slash). The difference: “/” (forward slash): Division by zero using this operator returns an undefined value. “\” (back slash): Division by zero using this operator returns zero.Continue reading “TM1 division operator (backwards slash)”

TM1 – (TR3117) Unable to retrieve security objects. Please verify credentials.

You may get “(TR3117) Unable to retrieve security objects. Please verify credentials” while connecting from TM1 to for example SAP BW. Basically TM1 uses old good Transformer to get the data/metadata. This error means the username/password are incorrect. Usually it happens when user’s password get changed. To update the password, open your TI process, goContinue reading “TM1 – (TR3117) Unable to retrieve security objects. Please verify credentials.”

TM1 attribute cube rule

If you create any dimension attributes, TM1 will create “}ElementSecurity_” cube to store the attribute values. You can use it cube almost like a regular cube (there are just little restrictions). For example you can create a rule to calculate some attributes. This approach can be used to allow users to edit element attributes inContinue reading “TM1 attribute cube rule”

TM1Web 10.2 + CAM security – Multiple URLs for different TM1 servers.

http://didenko.ca/blog/wp-content/plugins/syntax-highlighter-compress/scripts/shBrushJScript.js In this post I will explain how to enable multiple TM1Web URLs for different TM1 servers. In my example, TM1 is configured to use CAM security (IntegratedSecurityMode=5). But you can follow similar steps for other security modes. The result I needed to achieve was to be able to access TM1ServerName1 using the URL likeContinue reading “TM1Web 10.2 + CAM security – Multiple URLs for different TM1 servers.”

IBM Cognos Framework Manager: Show Object Dependencies and Analyze Publish Impact

You can find objects that depend on other objects, or show the dependencies of a child object. Simply right-click any object and choose Show Object Dependencies. NOTE: if you need to find a query item dependencies you should check it for both the query item and query subject contains that query item. Because if thereContinue reading “IBM Cognos Framework Manager: Show Object Dependencies and Analyze Publish Impact”

TM1 Server does not show up in clients (Architect, Perspectives, TM1Web)

Noticed in TM1 10.2.2 If trying to connect to TM1 Server from network, it does not show up in the list of available servers. However TM1 Server is visible in a local client. Make the next changes in IBM Cognos Configuration where TM1 Admin Server is installed: Support pre-TLS v1.2 clients = True Restart TM1Continue reading “TM1 Server does not show up in clients (Architect, Perspectives, TM1Web)”

IBM Cognos BI Software release life cycle

RTM – Release to manufacturing Software product is ready to be delivered or provided to the customer. GA – General Availability The latest date that a version/release of the product is available to all users, regardless of language or media. A product version/release is not published on the Lifecycle web site until the GA date.Continue reading “IBM Cognos BI Software release life cycle”