TM1 Forum

lotsaram wrote: ↑Tue Apr 09, 2024 8:08 am

Steve Rowe wrote: ↑Mon Apr 08, 2024 5:03 pm ...
The loss of the Properties control cubes is also very significant...

Wondering how VMT/VMM is handled and sort order on elements/components.

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.

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

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.

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?

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 may be worth enabling the SQL related loggers to see what additional information is available.

Part 3 added per link on updated original post.

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

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

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

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

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

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

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

Do readers also assume that the <StoreAlias=F> modifier was not used on the picklist for JobType?

Another option for you loosely based on your first example and using INSTR:

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.

For anyone looking to get some more ideas on what logging is available, please have a read through my recent blog post.