Search found 1089 matches

by gtonkin
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: 194

Re: ODBCOutput Delete table error with MS SQL2019

It may be worth enabling the SQL related loggers to see what additional information is available.
by gtonkin
Mon Mar 11, 2024 2:57 pm
Forum: Useful code, tips and tricks
Topic: An Introduction to MDX views
Replies: 2
Views: 220

Re: An Introduction to MDX views

Part 3 added per link on updated original post.
by gtonkin
Tue Mar 05, 2024 3:37 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 19
Views: 103128

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...
by gtonkin
Tue Mar 05, 2024 12:36 pm
Forum: Enhancements
Topic: PickList to show Alias but store Element Name
Replies: 19
Views: 103128

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...
by gtonkin
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: 515

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.

Code: Select all

left JOIN [CompassDW].[dbo].[dim_supplier] ON
vs

Code: Select all

left JOIN [dim_supplier] ON
by gtonkin
Tue Feb 27, 2024 3:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 45
Views: 4796

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...
by gtonkin
Mon Feb 26, 2024 7:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 344

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...
by gtonkin
Sun Feb 25, 2024 3:53 pm
Forum: Useful code, tips and tricks
Topic: An Introduction to MDX views
Replies: 2
Views: 220

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...
by gtonkin
Sat Feb 24, 2024 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM and PVU licensing
Replies: 6
Views: 344

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...
by gtonkin
Mon Feb 12, 2024 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 45
Views: 4796

Re: Ultimate Long TM1 quiz

Do readers also assume that the <StoreAlias=F> modifier was not used on the picklist for JobType?
by gtonkin
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: 2714

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
	)
by gtonkin
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: 2936

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.
by gtonkin
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: 9601

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.
by gtonkin
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: 10323

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?
by gtonkin
Wed Nov 29, 2023 6:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 8195

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 ...
by gtonkin
Sun Nov 19, 2023 7:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW reports error
Replies: 2
Views: 8614

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.
by gtonkin
Fri Nov 17, 2023 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 16472

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…
by gtonkin
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: 8869

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...
by gtonkin
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: 8869

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...