Search found 1089 matches
- 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: 291
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: 2
- Views: 253
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: 105218
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: 105218
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: 532
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: 49
- Views: 5318
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: 386
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...
- Sun Feb 25, 2024 3:53 pm
- Forum: Useful code, tips and tricks
- Topic: An Introduction to MDX views
- Replies: 2
- Views: 253
An Introduction to MDX views
I am posting the links to my article on the IBM TechXChange community here rather than trying to replicate the article. Part 1 - Learning MDX Views in Planning Analytics Part 2 - Using Calculated Members in MDX Part 3 - Aggregate Calculated Members in MDX Would be good to get some feedback and possi...
- Sat Feb 24, 2024 11:34 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM and PVU licensing
- Replies: 6
- Views: 386
Re: RAM and PVU licensing
HI Paul, Some of use were chatting recently and there are servers out there with 2TB of RAM. 128GB of RAM is by no means big. However, saying this, if I were IT I probably would have asked you if you have optimised usage as far as you can. Have you looked at what usage the cubes show using Performan...
- Mon Feb 12, 2024 6:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 49
- Views: 5318
Re: Ultimate Long TM1 quiz
Do readers also assume that the <StoreAlias=F> modifier was not used on the picklist for JobType?
- Sat Jan 13, 2024 12:21 pm
- Forum: Useful code, tips and tricks
- Topic: Transfer private objects from one user to another
- Replies: 7
- Views: 13920
- Wed Dec 13, 2023 10:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX to get User Cubes Names
- Replies: 3
- Views: 3022
Re: MDX to get User Cubes Names
Another option for you loosely based on your first example and using INSTR:
Code: Select all
FILTER(
{ TM1SUBSETALL( [}Cubes] )},
INSTR(1,[}Cubes].[}Cubes].CurrentMember.Name,"}",1)=0
)
- Mon Dec 11, 2023 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Snippets - file location and security
- Replies: 2
- Views: 3330
Re: PAW Snippets - file location and security
AFAIK, they are buried in PAW some place as I asked a question about all DBs on a PAoC instance seeing them and was told that they are global within the PAW instance and not limited by DB.
- Fri Dec 08, 2023 5:00 pm
- Forum: Useful code, tips and tricks
- Topic: Get the most out of Planning Analytics/TM1 Logging
- Replies: 2
- Views: 10901
Get the most out of Planning Analytics/TM1 Logging
For anyone looking to get some more ideas on what logging is available, please have a read through my recent blog post.
- Mon Dec 04, 2023 11:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM usage exploding with CubeUnload and ViewConstruct
- Replies: 5
- Views: 11700
Re: RAM usage exploding with CubeUnload and ViewConstruct
I have noticed similar behaviour when using MTFeeders=T and MTFeeders.AtStartup=T
Are you using these in your TM1s.cfg?
Are you using these in your TM1s.cfg?
- Wed Nov 29, 2023 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Prerequisites and Challenges: PAW installation
- Replies: 6
- Views: 9295
Re: Prerequisites and Challenges: PAW installation
Unfortunately going Linux may not mean you are in the clear wrt antivirus. One of my clients had Defender running creating all sorts of havoc requiring dispensations to exclude to container folders and related programs. May be worthwhile checking what the stack would look like and if you are likely ...
- Sun Nov 19, 2023 7:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW reports error
- Replies: 2
- Views: 9763
Re: PAW reports error
Looks like something failing in the underlying MDX based on that error.
You may want to try open the board specification (Ctrl + / + q) then copy and paste into notepad and do a search to see where Label may be used.
You may want to try open the board specification (Ctrl + / + q) then copy and paste into notepad and do a search to see where Label may be used.
- Fri Nov 17, 2023 6:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18582
Re: REST API Dimension Clone
This series may help you get familiar with some of the commands and then those concepts could be translated to Powershell.
YKud’s article may be very helpful too…
YKud’s article may be very helpful too…
- Tue Nov 14, 2023 9:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10191
Re: Tm1 Model - Limit Overall RAM Usage
More fiddling needed - I have not had time to look at running DebugUtility 125 to clear the cache, unload certain cubes etc. before attempting a shutdown. Still not a perfect solution by any stretch but if this model and others were going to simply crash, limiting to one that may need to be killed m...
- Sun Nov 12, 2023 9:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10191
Re: Tm1 Model - Limit Overall RAM Usage
I had some time to play around a bit more with this parameter. Looks like my initial server crashes were due to too little memory on startup. Bumping this up a bit allowed the server to start as per normal. This parameter appears to be Static - no changes to it whilst running seemed to have any effe...