TM1 Forum

That is probably why you are an MVP and I am just a regular guy. :-P Could you please shed some light on that. Now I am really curious. Based on IBM documentation: SubsetCreatebyMDX(SubName, MDX_Expression); However, if you add the 'undocumented 3rd argument' which is the Dimension Name, you won't ...

Thanks a lot for the answer guys ! I'll update to the latest version.

What browser do you use? Have you tried another? There was an error with IE years ago: the views didn't save with it. They are using Internet Explorer but I test with Google Chrome and i have the same result. What do you mean by "change the view"? If you just select filters, it's not a trigger to s...

Hello everyone, I start working for a new client today and there is a strange behaviour with the combination of SubsetCreateByMDX/SubseyMDXSet to make a dynamic subset static. The following code return a subset with a MDX, everything is good. https://i.ibb.co/9gBBBmM/MDX-Dynamic.png However, when I ...

Hi, First I suggest you to take a look at this documentation . Second, if you are looking for example of TI to send data in SPSS or vice-versa, you should look at the famous TM1 sample called 24retail. Usually you'll find that sample in: TM1_installation_location \samples\tm1\24Retail Finally, if yo...

1. Are you sure that the user opens the same workflow node? 2. Check the DATE\namespace\User\YouCube}vues\View_Name_With_GUID_and_node_name.vue. Does it exist? If so, is it THAT view made by user (you can open in in Architect or just analyse using notepad)? Yes, I did the following: 1. Open my TM1 ...

1. Why use python with TM1? 2. What are the benefits we get which we are unble to get so far with existing TM1 tools? 3. How to best use python in existing tm1 models? 4. What is the future of TM1 and python integration? 5. Has anyone used ML on top of TM1 so far? If yes, could you please share som...

If you change the default views by reorganizing the layout, and close down the Contributorwindow, in the background the last state of the view is saved as a private view and next time you open up the node, your last state will be opened. I have an issue with one of my client. Whenever user change t...

Indeed. But on IBM SaaS, you have to raise a ticket to get utilities like 7Zip installed. I don't know if anybody's tried, but it is good to know that you can do backups without anything extra. Hello David. I've been able to download 7zip on the server that has Architect and Perspectives on it with...

Bonjour Étienne,

Try reboot TM1Web.
Take a look at this post : https://www.tm1forum.com/viewtopic.php?t=14315

Wim Gielis wrote: ↑

Wed May 27, 2020 1:24 pm

You could have a look at the ExecuteCommand function in a TI process, which then calls 7-zip.

Here's what i'm using.. It works perfectly.

Feel free to change the code if you want a different name for the backup !

Hello, I just had a new CellPutProportionalSpread error and there was no documentation anywhere so I'll share in case anyone else ends up searching for it. Error: Data procedure line (44): Error with spreading, error type unknown = 184 You will get an error if you try to use CellPutProportionalSprea...

You probably already know but if you want to "merge" 2 subsets togheter, you can use Union . Through a TI, this little piece of code can easily do that : sDimName = 'Account'; sSubset1 = 'Subset1'; sSubset2 = 'Subset2'; sNewSubsetName = 'My new subset Name'; sMDX = '{ UNION( [' | sDimName | '].[' | ...

Thanks Wim & Paul !

That's what I thought in the beggining but it's tricky for multi-parameter process. I think i'll just clone the process without the '}'

Hello everyone,

How do I execute a Bedrock TI through an action button ? In other words, how do we see the list of TI starting with a '}' in the Action Button Properties in TM1 Perspectives ?

Thanks and have a good day !

Hello,

I suggest you the Find in File function in Notepad ++

If you search for a specific Dimension or Element in your TM1 data folder, it will tell you exactly where these objects appear in your model. (.RUX, .PRO, .DIM, ...)

Cheers !

Wim Gielis wrote: ↑

Tue Feb 04, 2020 11:35 am

Is it solved ?

Yes.. I made a rookie mistake..

I had a something like this in my code: That's why I only get the first 100 characters..

At least I know for sure there is no string size limit !!

Thanks !

Thanks Guys,

I appreciate it !

Thanks guy, I pass the parameter through an ExecuteProcess in a TI. I have the following code I want to execute in one of my master TI : sMDX = '{TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SORT( {TM1SUBSETALL( [Process Control Element] )}, ASC)}, 0)}, "*User*")}'; ExecuteProcess( 'SYS - Create Subse...

Hello everybody, Based on this link , TurboIntegrator is capable of handling string data in sizes of up to 8000 single-byte characters at a time. I have to execute a process with a 200+ characters in one of my parameter. and it keeps crashing. I wonder what is the string size limit of a parameter va...