Search found 3048 matches

by Wim Gielis
Thu Jun 20, 2024 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW (MDX?) View Stops Exporting for No Reason
Replies: 1
Views: 134

Re: PAW (MDX?) View Stops Exporting for No Reason

I guess that is one for IBM Support through a ticket.
by Wim Gielis
Sat May 25, 2024 5:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - Filtering members against multiple string values in a reference cube
Replies: 5
Views: 4838

Re: MDX - Filtering members against multiple string values in a reference cube

That was a great help although I admit it took me a while to understand what you had done. I settled on the following (Using the original MDX I posted above). It is interesting that there is nothing similar to the IN clause in SQL as a single value to match = is hardly realistic. I also looked at S...
by Wim Gielis
Wed May 22, 2024 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Very slow performance in TI using ViewZeroOut function
Replies: 7
Views: 4465

Re: Very slow performance in TI using ViewZeroOut function

This is strange behavior. What does the }Stats cubes say about number of data points and similar measures? Did someone inflate the number of cells from data input at very high level ? Stet function in the rules or other things ?
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: 642

Re: Excel files and blobs in TM1

appentries.PNG
appentries.PNG (47.42 KiB) Viewed 621 times
appentries_2.PNG
appentries_2.PNG (62.59 KiB) Viewed 621 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: 642

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: 403

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: 2235

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: 2084

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: 6
Views: 1792

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: 1645

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: 1645

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: 1652

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: 1652

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: 1598

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: 1598

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: 2045

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: 1000

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: 1789

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: 1889

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.