TM1 Forum

Confirmed. Not really intuitive. Why would someone upload users to PAW and not wanting to invite them ?

In response to the original question, I have a new user base which is entirely on 64 bit Excel and some of them are pining for TM1 Tools so yes, I am working on a 64 bit version but I'm looking at converting over to the Rest API since some of the functionality in the existing one is based on ye old...

As I am not really happy with my solutions in TI and the REST API, I loaded an idea / request for assistance.

https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-1340

Feel free to give it your vote.

I tried using TM1py and the TM1 REST API to achieve the same result. We all know that the file system and ExecuteCommand will be out soon. The solution suffers from being slow as well as that I cannot retrieve private application entries for a user. Also, impersonation is also out in V12 I think so ...

You can do without a cube. You use alternate hierarchies and use PAfE.

You’re welcome Jim

What you try to do is exactly alternate hierarchies. Do you have PAW and PAfE as well ? It will be much easier. If not, is A through D a real dimension in the cube of data ?

An example output would be useful too ?

Can you show a picture of the dimension ? Only the relevant part and no alias for exanple. Then we see better the element names and what is at play.

How is it set up in the dimension, more precisely, a hierarchy might better suit your purposes although Perspectives is out then and PAfE will be better. Do you have your rollups to aggregate in a cube ?

Updated version below.

Hello all, I am in the last steps of a migration from an on-premise TM1 model to the IBM cloud. The majority of my time was spent changing TI process data sources of Cognos Framework Manager packages to plain text files. "Thank you" IBM for removing the good old TM1 Package Connector :evil...

Or, use the Descendants function with an easier syntax.

Thank you. Happy new year to all

Thank you Ardian. Good additions. Maybe useful to post a sample file for 'config.ini' (though probably standard and not too difficult to do it ourselves) ? Of course without sensitive information but just the structure and some examples of entries. I would also skip the If test for the PRO extension...

Thanks Dan.Kelleher. After some modifications, this works fine for me: #.\hot_promote_process.ps1 my_process_name DEV PRD PATCH $processName = $args[0] $sourceEnv = $args[1] $targetEnv = $args[2] $method = $args[3] function Set-Header { param ( $EncodedText ) $header = @{ "Content-Type"=&q...

Informative as always

Very sad

What is unfortunate, is that subsets for the picklists all have to exist. It is not possible to inject an MDX for a subset (combining several inputs in a string for the MDX) and have the server execute it at run-time. That would be much neater. You can work around with a button and a simple TI proce...

Hi all, I thought this TI process might be useful to others as well. I have been writing this over the past couple of days, so if anyone wants to further test it, much appreciated ! The idea is that users in a TM1 model can have private objects: - subsets (*.sub files) - classic views (*.vue files) ...

I clearly need some help, so if someone can share a powershell script that does something similar, i would really appreciate it Hello, I do hope that someone can post code here. Until then, I would advise to start yourself because if no one does, you still have nothing. Build it gradually, hardcode...