TM1 Forum

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

I have collected a huge amount of TM1 questions while interviewing people. I want to share them with the community, and I want to make this in a form of a quiz. After all this ends, everybody will be able to use all questions for interviewing or for interview preparation. I don't know about you guy...

[‘a’] = [‘b’] + 4; For this one, ['a'] will need to be fed when ['b'] is not -4. You can't feed from ['b'] because if it's 0, there's no feeding, therefore ['a'] will be an unfed 4. Assuming the model already has a "Config" cube, I would add an element called "Feed Static Addends&quo...

MarenC wrote: ↑Fri May 03, 2024 4:16 pm How did ascheevel overtake Admin in the lead, given he was in the lead the previous week?

Was thinking along the same lines, that next week you’re in the lead. Hahaha!

Try repeating CellPutN function, once with ‘1’ AND once with ‘3’.

Google (or ChatGPT) will help as .xlsx to .csv isn’t exactly a tm1-specific problem to solve.

If you have access to Excel and access to TI, why not “save as” in Excel to CSV? If multiple files, I suggest writing a VBA that automates this within a chosen folder. You may be able to build a VBScript (or other solution) and then trigger the .xlsx to .csv within TI using ExecuteProcess.