Search found 306 matches
- Fri Sep 05, 2025 7:55 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX IIF to check if Element Exists
- Replies: 4
- Views: 4130
Re: MDX IIF to check if Element Exists
Can't help on the MDX I'm afraid, but you could consider changing the process: when a new client is added, add the "UserAdded_clientname" consolidation to the dimension with one element underneath of "NoElementsAdded_clientname", and then when they add one or more elements (I'm a...
- Tue Sep 02, 2025 9:53 am
- Forum: General
- Topic: Retirement of the Forum
- Replies: 6
- Views: 5810
Re: Retirement of the Forum
Fair enough. It's been a blast - and thanks to all the admins for all their work over the years.
- Fri Feb 28, 2025 10:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: system process to create dimension period
- Replies: 2
- Views: 6443
Re: system process to create dimension period
You could also give https://code.cubewise.com/software/products/arc/ a try, which has a Time Management module (I think there's still a three month free trial period).
- Mon Nov 25, 2024 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Py sslv3 handshake error
- Replies: 1
- Views: 3078
Re: TM1Py sslv3 handshake error
I expect Marius will be along, but this is probably better raised in the TM1py issues git page https://github.com/cubewise-code/tm1py/issues
- Thu Nov 21, 2024 9:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Filter on multiple values using virtual hierarchies
- Replies: 3
- Views: 3995
Re: Filter on multiple values using virtual hierarchies
You can do this. See below for results from creating a hierarchy from a string attribute and applying filters. I think this is what you're trying to do? I've added an attribute for each sales rep and then an All attribute which puts them together (I've just done this manually for this, but it could ...
- Fri Nov 15, 2024 8:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migrate Application folder structure to PAW or Excel?
- Replies: 7
- Views: 6386
Re: Migrate Application folder structure to PAW or Excel?
What ascheevel said, particularly on Python and TM1py - Python can act as an excellent controller and ETL to TM1, and depending on use case you can package it up as an executable using pyinstaller so the machine running it doesn't even have to have Python installed.
- Sat Nov 09, 2024 11:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Which platform do you use to write TI and Rules ?
- Replies: 8
- Views: 14729
Re: Which platform do you use to write TI and Rules ?
Rules: Arc.
TI: Arc and Python with TM1py.
Data: Mixture of PaFE, PAW and Slice (mostly Slice: how hard is it for IBM to understand that I mostly just want cell-based hierarchy-aware DBRW formulas?)
TI: Arc and Python with TM1py.
Data: Mixture of PaFE, PAW and Slice (mostly Slice: how hard is it for IBM to understand that I mostly just want cell-based hierarchy-aware DBRW formulas?)
- Tue Jul 30, 2024 6:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM Planning Analytics 2.0 vs 2.1
- Replies: 5
- Views: 8876
Re: IBM Planning Analytics 2.0 vs 2.1
It’s about support - IBM will stop supporting 2.0 from May 1 2025. You can still use 2.0 from then, but IBM will ask you to upgrade if you have any support issues. So effectively any issues with Perspectives or Architect won’t be dealt with. You may be able to buy extended support, but the direction...
- Mon Nov 06, 2023 10:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to create new Version in QUBEdocs
- Replies: 2
- Views: 8402
- Wed Oct 18, 2023 3:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on training in Planning Analytics between jobs
- Replies: 7
- Views: 8796
- Wed Oct 18, 2023 10:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Advice on training in Planning Analytics between jobs
- Replies: 7
- Views: 8796
Re: Advice on training in Planning Analytics between jobs
Hi John, Yes, I agree it's a pain. Having said that, the trial won't cost you money - it just lets you know after 30 days that your time is up and would you like to throw some money at IBM? No credit card details are asked for. If you're still a bit hesitant, I have 16 days of a trial still to go an...
- Fri Sep 08, 2023 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 51433
Re: Bedrock And Github vs Other Options
I'm with lotsaram and Ian here. Should there be a bedrock or something like it? Yes, and use it or not as you like. It's presence on a model would at the least be a marker that the developer had thought through his or her options. Is it a pain that Cubewise is advertised in the code? Well, maybe yes...
- Thu Aug 24, 2023 9:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 11133
Re: Cube Transfer TI Process
This is a very old thread. I suggest reading this and trying again: https://www.tm1forum.com/viewtopic.php?t=1037
Regards
Regards
- Fri Aug 04, 2023 6:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hold, Release Hold via Rest API or TI Process?
- Replies: 3
- Views: 2903
Re: Hold, Release Hold via Rest API or TI Process?
Yes, see https://www.tm1forum.com/viewtopic.php?t=14399 , where Wim describes how for a TI. It should be possible to do the same using the REST API as it's basically creating a control cube if it doesn't exist and then applying strings to one or more cells. See also https://www.ibm.com/docs/en/plann...
- Mon Mar 21, 2022 9:47 am
- Forum: General
- Topic: Commercial and Events sub-forum has gone walkabout?
- Replies: 10
- Views: 55385
Re: Commercial and Events sub-forum has gone walkabout?
Yup, good for me too.
Thanks!
Paul
Thanks!
Paul
- Thu Mar 17, 2022 9:14 am
- Forum: General
- Topic: Commercial and Events sub-forum has gone walkabout?
- Replies: 10
- Views: 55385
Re: Commercial and Events sub-forum has gone walkabout?
Hi Martin,
I'm getting the same on Firefox, Edge and Chrome. I've cleared the cache on Edge, but no joy.
Thanks
I'm getting the same on Firefox, Edge and Chrome. I've cleared the cache on Edge, but no joy.
Thanks
- Tue Mar 15, 2022 10:08 am
- Forum: General
- Topic: Commercial and Events sub-forum has gone walkabout?
- Replies: 10
- Views: 55385
Commercial and Events sub-forum has gone walkabout?
It may be just me, but the Commercial and Events link on the main page doesn't seem to be going anywhere.
Regards
Regards
- Wed Dec 15, 2021 12:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remote desktop to IBM cloud with credentials
- Replies: 5
- Views: 22031
Re: Remote desktop to IBM cloud with credentials
Yanking this one up from the grave: if you use an RDP manager like mRemoteNG then you can store the password as well as the username. Trick is to put the cloud url in the gateway parameter as well as the Hostname/IP parameter.
- Tue Nov 09, 2021 10:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX RefreshAllData()
- Replies: 8
- Views: 17716
Re: PAX RefreshAllData()
Although if you read the whole link, this shouldn't be necessary. I'd be more concerned with getting the install right rather than amending the VBA code to partially fix something that's broken (and might fix itself in future, then giving you an issue with the VBA code that now no longer works).
- Wed Sep 29, 2021 8:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX Addin not displaying correctly
- Replies: 3
- Views: 5295
Re: PAX Addin not displaying correctly
Yes. I had the same issue and this is what IBM Support told me: Just talked to development, they said that the ribbon name issue is a known issue by them and they're trying to fix it ASAP. It's caused by a missing language folder that doesn't get extracted properly during the install. You can either...