Search found 60 matches

by Emixam
Mon Jun 22, 2020 5:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 6283

Re: Is there an easy way to convert a dynamic subset to static?

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 ...
by Emixam
Mon Jun 22, 2020 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 6283

Re: Is there an easy way to convert a dynamic subset to static?

Thanks a lot for the answer guys ! I'll update to the latest version.
by Emixam
Mon Jun 22, 2020 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Views in Contributer
Replies: 8
Views: 1404

Re: Private Views in Contributer

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...
by Emixam
Mon Jun 22, 2020 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there an easy way to convert a dynamic subset to static?
Replies: 15
Views: 6283

Re: Is there an easy way to convert a dynamic subset to static?

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 ...
by Emixam
Thu Jun 18, 2020 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How run a SPSS Modeler stream from Tm1 process
Replies: 11
Views: 369

Re: How run a SPSS Modeler stream from Tm1 process

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...
by Emixam
Mon Jun 15, 2020 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Views in Contributer
Replies: 8
Views: 1404

Re: Private Views in Contributer

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 ...
by Emixam
Mon Jun 15, 2020 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py and python integration with TM1
Replies: 13
Views: 1040

Re: TM1py and python integration with 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...
by Emixam
Mon Jun 15, 2020 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Private Views in Contributer
Replies: 8
Views: 1404

Re: Private Views in Contributer

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...
by Emixam
Sun May 31, 2020 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1082

Re: Local Backup

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...
by Emixam
Wed May 27, 2020 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1082

Re: Local Backup

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 !
by Emixam
Thu May 21, 2020 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: CellPutProportionalSpread Error
Replies: 1
Views: 1376

Re: CellPutProportionalSpread Error

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...
by Emixam
Fri May 08, 2020 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Insert a Subset into a Subset through TI
Replies: 4
Views: 224

Re: Insert a Subset into a Subset through TI

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 | '].[' | ...
by Emixam
Mon Apr 27, 2020 9:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Bedrock TI in Perspectives
Replies: 3
Views: 201

Re: Execute Bedrock TI in Perspectives

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 '}'
by Emixam
Mon Apr 27, 2020 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Bedrock TI in Perspectives
Replies: 3
Views: 201

Execute Bedrock TI in Perspectives

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 !
by Emixam
Tue Feb 18, 2020 4:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cleaning up
Replies: 4
Views: 520

Re: TM1 cleaning up

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 !
by Emixam
Tue Feb 04, 2020 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 751

Re: String size limit of a parameter in a TI

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:

Code: Select all

SUBST( sMDX, 1, 100)
That's why I only get the first 100 characters..

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

Thanks !
by Emixam
Mon Feb 03, 2020 3:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 751

Re: String size limit of a parameter in a TI

Thanks Guys,

I appreciate it !
by Emixam
Mon Feb 03, 2020 12:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 751

Re: String size limit of a parameter in a TI

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...
by Emixam
Sun Feb 02, 2020 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String size limit of a parameter in a TI
Replies: 11
Views: 751

String size limit of a parameter in a TI

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...