Search found 3045 matches

by Wim Gielis
Sat May 18, 2024 4:33 am
Forum: Useful code, tips and tricks
Topic: Excel files and blobs in TM1
Replies: 1
Views: 142

Re: Excel files and blobs in TM1

appentries.PNG
appentries.PNG (47.42 KiB) Viewed 121 times
appentries_2.PNG
appentries_2.PNG (62.59 KiB) Viewed 121 times
by Wim Gielis
Sat May 18, 2024 4:09 am
Forum: Useful code, tips and tricks
Topic: Excel files and blobs in TM1
Replies: 1
Views: 142

Excel files and blobs in TM1

Hello all, Some of us are busy packing up and preparing for the upcoming IBM Think conference in Boston, May 20-23. So excited to be there ! In this post I wanted to take you through a custom and generic Turbo Integrator process related to the management of Excel files and blobs in TM1. When authori...
by Wim Gielis
Fri May 10, 2024 7:45 am
Forum: Free And Open Source Tools
Topic: Tree-sitter-tm1: A language grammar for syntax highlighting using tree-sitter
Replies: 1
Views: 130

Re: Tree-sitter-tm1: A language grammar for syntax highlighting using tree-sitter

Wow ! Even understanding only half of the above, I already find it fascinating :D
I would be very much interested in seeing how this evolves and how it opens up new possibilities.
by Wim Gielis
Wed May 08, 2024 8:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Email Alerts with PAW
Replies: 3
Views: 1752

Re: Email Alerts with PAW

Maybe not in real time but near-real time. You could have a chore that looks at the ProcessError files (from a certain day/time period like last 5 minutes), merge the files and send out the email. PowerShell is something I used to retrieve the contents of said files and send a 'summary' email with e...
by Wim Gielis
Thu May 02, 2024 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba
Replies: 2
Views: 1861

Re: Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba

Very nice first post here 👍
Just a pity that the end of Perspectives was announced yesterday.
by Wim Gielis
Thu Apr 25, 2024 4:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Practical experience of PAW AI forecasting / performance
Replies: 5
Views: 1337

Re: Practical experience of PAW AI forecasting / performance

I haven't touched it and from what I am reading above, I should continue that for a little while ;-)
by Wim Gielis
Thu Apr 25, 2024 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: promote workbench from an env to another
Replies: 7
Views: 1251

Re: promote workbench from an env to another

Did you have a look at the Administration part and the Lifecycle manager ?
by Wim Gielis
Wed Apr 24, 2024 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: promote workbench from an env to another
Replies: 7
Views: 1251

Re: promote workbench from an env to another

Ctrl q /
Does this work for you ?
by Wim Gielis
Tue Apr 23, 2024 10:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can MDX work across alt hierarchies from one dim?
Replies: 7
Views: 911

Re: Can MDX work across alt hierarchies from one dim?

macsir wrote: Tue Apr 23, 2024 10:31 am
Wim Gielis wrote: Tue Apr 23, 2024 6:44 am That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?
No, just want to see if it is possible in a MDX set.
Then the answer is no, as what Lotsa also replied.
by Wim Gielis
Tue Apr 23, 2024 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can MDX work across alt hierarchies from one dim?
Replies: 7
Views: 911

Re: Can MDX work across alt hierarchies from one dim?

That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?
by Wim Gielis
Tue Apr 23, 2024 6:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Methods for Inputting Data into TM1 Cube
Replies: 12
Views: 1201

Re: Methods for Inputting Data into TM1 Cube

Python and tm1py (hence REST API) would also be an option.
by Wim Gielis
Sat Apr 20, 2024 4:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Methods for Inputting Data into TM1 Cube
Replies: 12
Views: 1201

Re: Methods for Inputting Data into TM1 Cube

Yes, e.g. what Adam describes: in the past I wrote PowerShell to do just that.
by Wim Gielis
Thu Apr 11, 2024 5:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Process Failed - with No Log
Replies: 6
Views: 1321

Re: Action Button - Process Failed - with No Log

TM1 Perspectives ? PAfE ? A sheet dragged on a PAW dashboard ?

The process exists ? For instance, in case the process name could be retrieved dynamically from a cell.
Process parameters are fine ?
by Wim Gielis
Thu Apr 11, 2024 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button in PAX with parameters
Replies: 1
Views: 851

Re: Action Button in PAX with parameters

Yes. There is no screen the change the parameter values or enter them.
by Wim Gielis
Wed Apr 10, 2024 6:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Code: Records per Second Tracking
Replies: 1
Views: 1628

Re: Code: Records per Second Tracking

Thank you Andrew, it's useful. I reworked a bit to my preferences :-) and delimiters in the numbers. Also, the choice to go really detailed until milliseconds, or not. ####################################### ##### IF NOT USING MILLISECONDS ##### ####################################### ## START of th...
by Wim Gielis
Mon Apr 08, 2024 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX analysis of what you are feeding
Replies: 10
Views: 1379

Re: MDX analysis of what you are feeding

I think that AsciiOutput is still there, but then towards folders relative to the model_upload folder.
by Wim Gielis
Mon Apr 01, 2024 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 83
Views: 14745

Re: Ultimate Long TM1 quiz

gtonkin wrote: Mon Apr 01, 2024 3:27 pmHang on, Wim - Was this you? :shock:
No. Just a TM1 REST API Impersonation of Wim.
by Wim Gielis
Mon Apr 01, 2024 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 83
Views: 14745

Re: Ultimate Long TM1 quiz

Impose your cat to go to the boss and explain what happened.