TM1 Forum

To elaborate a bit more, all the screens for cube viewer and set editor are webview2 screens from PAW. Without PAW, PAFE is not usable.

I’ve gotten this error in the past for large daisy chained feeders, while not literally this, it’s effectively:
1 => 2
2 => 3
…
999 => 1000

Carefully review the feeders and ensure it’s not a long chain.

With threads like these, no wonder ChatGPT is suggesting CubeNext();

Here are some good readings that will help you build what you need:

https://www.wimgielis.com/tm1_cellchange_EN.htm

https://www.ibm.com/docs/en/planning-an ... ty-overlay

Ok, so thanks for making me feel dumb for even posting this! I am basically learning TM1 on my own and I am studying processes. Hi R, Please don’t take it personally. Compared to some of the legends that are on here, Wim being amongst them, I’m also “new to TM1”. You were spared. It appears the mos...

Elessar wrote: ↑Sun Jan 19, 2025 6:02 am Hello, this was asked many times on this forum: viewtopic.php?t=16766

And the asker always disappears when help is offered.

How about this:

This is a joke right? I didn’t take it as a joke. When it’s possible to construct your TM1 DB so it doesn’t use/uses less IF statements, it will be faster. Sometimes it’s not possible and you deal with the consequences. Often times it’s trivial, but it might add up. Not something that I typically w...

What about adding Hier Name and N: with C: only if relevant? ['Dim Name':'Hier Name':'Y'] = N: MAX(0, ['Dim Name':'Hier Name':'X']); can we rewrite such rule without IF and MAX/MIN? For sake of readability I’m going to leave out the DimName/HierName/N:/C: ['Y'] = (['X'] + ABS(['X'])) / 2; I wound NO...

Question #42: You have TM1 server with sensitive data. You have a well-done security model in TM1: access to sensitive data is granted only to right users. But windows administrator can take DATA folder and launch it on his own TM1 server with his }Clientgrups cube file where he is admin. And thus ...

Glad I could help.

Calling back to the same onboarding to TM1, I was told we should never have to restart the DB except when the OS needs to restart.

Any reason you’re restarting the DB weekly?

Admittedly, there’s a lot going on in your post. What resonated with me the most was input data persisting after a rule is layered on top of it. There is a tm1s.cfg setting that controls this exact behavior. RulesOverwriteCellsOnLoad https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=SSD29G_...

I'm noticing that participants became less active. 2 months left, pull yourselves together guys! This is fun for me and we should keep going even beyond the two month mark. I we all want to play nice in the sandbox (who am I kidding Version dimension) so we’re not all immediately jumping in. Questi...

Just some helpful information for me: - How long does it take to start db without persistent feeders? - How much RAM is being used? - How many numerical cells are populated? I’ve always thought this article is neat, though I’ve never used the approach: https://code.cubewise.com/blog/troubleshooting-...

Question #38: My data load process from csv file to TM1 cube is very slow. What can be the reason? What can I do with this? There’s many many answers to this. I’d like to share the points with others and post just one potential option: I’m going to assume the server is V11. If logging is enabled, t...

Emixam wrote: ↑Mon Sep 02, 2024 2:15 am On which client you took this screenshot?
Adam is right.

I like the iconography too!

It’s for processes that non-admins will be running and the process interacts with security in the db. Examples include creation of a dimension element followed by ElementSecurityPut. Without the security access flag set, the process fails.

I like the first choice the most but would opt for DB against }ElementAttributes vs ATTRS as wiser people than me have said it’s faster. I don’t like the Alias approaches as that doesn’t scale beyond 1 to 1 mapping. Same for DIMIX, that doesn’t scale when element order is different between ABC and A...

(Admins please move to useful code if you find this useful. I can't post there.) The TM1 Transaction Log records the history of changes to cube values in your database. This happens seamlessly in the background. It allows you to answer the question: who changed what and when? It’s an invaluable tool...

The reports have attributes displaying along with measures. Is what you're actually looking for displaying multiple attributes next to element in PAFE? Unfortunately MDX-based views (i.e. Quick Report, Exploration) don't support that. It is quite annoying because you can create a cube view in PAW w...