Awesome! Glad it worked out for you.
So much to learn on MDX still but it is really powerful stuff.
Search found 1105 matches
- Sat May 25, 2024 9:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - Filtering members against multiple string values in a reference cube
- Replies: 4
- Views: 642
- Thu May 23, 2024 6:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBC Connections and locked / stalled threads
- Replies: 3
- Views: 365
Re: ODBC Connections and locked / stalled threads
In days gone by when I had SQL doing something and we could not kill the process I set IdleConnectionTimeOutSeconds=5 in the TM1s.cfg and this more often than not released it. I have not looked at this one yet but may be of use: ODBCTimeoutInSeconds Not sure on the failure but I may have an undocume...
- Thu May 23, 2024 6:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX - Filtering members against multiple string values in a reference cube
- Replies: 4
- Views: 642
Re: MDX - Filtering members against multiple string values in a reference cube
Hi John, You could do this using the Generate() function by using the 3rd parameter to concatenate the members into a string. Once we have a string we can then use INSTR() to test if the member's attribute/lookup value matches to something in the string and keep if it does. My example is using Produ...
- Tue May 21, 2024 4:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Very slow performance in TI using ViewZeroOut function
- Replies: 7
- Views: 928
Re: Very slow performance in TI using ViewZeroOut function
Hi, Cannot see any need to use any of the ViewExtractSkip functions on a zero out. Making the sets static as you explained is always a good idea where the view is a datasource. Have you turned off logging or do you need it on? Anything that could be causing this like intercube feeders and other rules?
- Wed May 15, 2024 6:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Is it possible to open a PAW report in PAX?
- Replies: 6
- Views: 1647
Re: Is it possible to open a PAW report in PAX?
You could conceivably take the MDX from the exploration widgets and reuse within PAfE but that is likely all. Attributes may need to be added separately or derived as calculated members, depending on what you were doing. No action buttons, selectors etc. You would need to redo in PAfE. These article...
- Tue May 14, 2024 3:52 am
- Forum: Useful code, tips and tricks
- Topic: An Introduction to MDX views
- Replies: 3
- Views: 3668
- Fri Apr 26, 2024 12:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: promote workbench from an env to another
- Replies: 7
- Views: 1398
Re: promote workbench from an env to another
Apparently supported from 2.0.87
https://www.ibm.com/docs/en/planning-an ... -snapshots
https://www.ibm.com/docs/en/planning-an ... -snapshots
- Thu Apr 25, 2024 5:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculated Zero Cells and Feeders
- Replies: 19
- Views: 11704
Re: Calculated Zero Cells and Feeders
It would not make sense doing your DB() read on the same measure that you are feeding from as the left side of the feeder statement would always be non-zero cells (or previously valued which triggered a feeder but now zero). Testing via the DB() read would impact performance but the severity would b...
- Thu Apr 25, 2024 11:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: promote workbench from an env to another
- Replies: 7
- Views: 1398
Re: promote workbench from an env to another
Hi SYPA,
On PAW 2.0.94 onwards you can migrate workbenches between Dev and Prod for example.
What version are you using?
On PAW 2.0.94 onwards you can migrate workbenches between Dev and Prod for example.
What version are you using?
- Fri Apr 19, 2024 1:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 16985
- Tue Apr 09, 2024 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1532
Re: MDX analysis of what you are feeding
Wondering how VMT/VMM is handled and sort order on elements/components.lotsaram wrote: ↑Tue Apr 09, 2024 8:08 amSteve Rowe wrote: ↑Mon Apr 08, 2024 5:03 pm ...
The loss of the Properties control cubes is also very significant...
- Mon Apr 08, 2024 12:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1532
Re: MDX analysis of what you are feeding
They were pretty clear when asked that v12 on premise would not re-introduce any of the functionality that v12 containerised was removing... I hear you but cannot fathom right now how we would not need to save cubes back to the filesystem to commit changes to disk in a non-containerised environment.
- Mon Apr 08, 2024 10:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1532
Re: MDX analysis of what you are feeding
Unfortunately not, but with the announcement of V12 for on-premise, I do wonder what we were told would not be available, will now be available again as we would not be running containerized, would have access to the filesystem etc. SaveDataAll, AsciiOutput, possibly logging remains? Some further qu...
- Tue Apr 02, 2024 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA Replace to alter DBRW references in PAfE
- Replies: 7
- Views: 2270
Re: Using VBA Replace to alter DBRW references in PAfE
In your VBA code, could you not set the cells you are updating to Dirty using the .Dirty method?
This should force a recalculation of the cells next time the sheet is calculated.
This should force a recalculation of the cells next time the sheet is calculated.
- Mon Apr 01, 2024 3:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 86
- Views: 16985
Re: Ultimate Long TM1 quiz
I think it would be a good time to get your resume and LinkedIn profile in order. Time to switch jobs.
Hang on, Wim - Was this you?
Hang on, Wim - Was this you?
- Mon Apr 01, 2024 6:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1532
MDX analysis of what you are feeding
For those looking to get something more out of MDX, please have a look at the article I just posted on the IBM Community
It also contains links to my other articles on using MDX views.
It also contains links to my other articles on using MDX views.
- Sat Mar 16, 2024 9:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ODBCOutput Delete table error with MS SQL2019
- Replies: 7
- Views: 1418
Re: ODBCOutput Delete table error with MS SQL2019
It may be worth enabling the SQL related loggers to see what additional information is available.
- Mon Mar 11, 2024 2:57 pm
- Forum: Useful code, tips and tricks
- Topic: An Introduction to MDX views
- Replies: 3
- Views: 3668
Re: An Introduction to MDX views
Part 3 added per link on updated original post.
- Tue Mar 05, 2024 3:37 pm
- Forum: Enhancements
- Topic: PickList to show Alias but store Element Name
- Replies: 19
- Views: 109466
Re: PickList to show Alias but store Element Name
That missing "r" is literally something I encountered previously and no one could work out why the rule had broken. Previously input selection was incorrectly spelled and then corrected causing lots of head scratching as everyone's auto-correct just looked right over the issue. So now we s...
- Tue Mar 05, 2024 12:36 pm
- Forum: Enhancements
- Topic: PickList to show Alias but store Element Name
- Replies: 19
- Views: 109466
Re: PickList to show Alias but store Element Name
The joy manifests when someone updates the master data rendering the values you stored in the cube invalid requiring you to find and fix them. e.g. 1234-Desciption vs 1234-Description A simple correction to spelling will cause untold issues where the value in the picklist is relied on elsewhere in t...