Search found 1102 matches
- 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: 2
- Views: 23
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: 1297
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: 3486
- 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: 1328
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: 16
- Views: 11243
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: 1328
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: 85
- Views: 15139
- 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: 1429
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: 1429
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: 1429
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: 2049
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: 85
- Views: 15139
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: 1429
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: 1336
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: 3486
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: 109166
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: 109166
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...
- Tue Feb 27, 2024 4:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Drill Throughs not accepting left Joins SQL- but accept where joins
- Replies: 3
- Views: 620
Re: Drill Throughs not accepting left Joins SQL- but accept where joins
Have you enabled the SQL loggers to see if there is any message coming back from SQL?
Could it be a context thing when running from TM1 that the left join does not know the table and schema i.e.
vs
Could it be a context thing when running from TM1 that the left join does not know the table and schema i.e.
Code: Select all
left JOIN [CompassDW].[dbo].[dim_supplier] ON
Code: Select all
left JOIN [dim_supplier] ON
- Tue Feb 27, 2024 3:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15139
Re: Ultimate Long TM1 quiz
Hi Maren, Not sure if you are familiar with this undocumented feature but a picklist can show a description/alias from a set but store the code/principal name. Use the following syntax and set the StoreAlias=F to store the principal name otherwise T for the alias. Subset:Dimension:Subsetname<StoreAl...
- Mon Feb 26, 2024 7:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM and PVU licensing
- Replies: 6
- Views: 1006
Re: RAM and PVU licensing
AFAIK, the 2TB was on-premise - would shudder to think what 2TB would cost on cloud, especially with the new PA aaS offering where you buy memory in 16Gb chunks - 125 of them required at around $10k each. Sure the premium offering would have pricing benefits but cannot see that hosting on cloud with...