TM1 Forum

Correct answer:
I'll just put a link to MarenC's answer: viewtopic.php?p=83284#p83284
And yes, PAX is also capable to read DBRWs.

So, winner of this week is MarenC again and he takes the first place!

Question #10:
What does each font and fill mean (assume we are using TM1Web/PASS)?

1. Blue font
2. Green font
3. Black font
4. Bold font
5. White fill
6. Grey fill

UPD: Bonus from George Tonkin: What is red font here in Architect?

1. Blue font - input data in space of user but not confirmed in TM1 server (another user will see another data)
2 Green font - first input data (it is even not in space of user yet)
3 Black font - confirmed data in TM1 sever (not changed in the Tm1Web)
4 Bold font - consolidation
5 White fill - fields available for input by user
6 Grey fill - fields unavailable for input by user (rules, rights restrictions, etc.)

Good! And what about red?

Correct answer:

1. Blue font - means that value in your selected sandbox is different from [Base] sandbox. This is true both for input cells and calculated cells.
2. Green font - this value is still in your browser cache and is not send to TM1 server. Usually values remain green when you fill cells and press arrow buttons to navigate to other cells.
3. Black font - Just data on server.
4. Bold font - consolidation.
5. White fill - available for editing.
6. Grey fill - read-only (rule-delivered or security-based)
7. Red font - this appears in Architect's attribute editor, in Alias. It shows duplicate aliases.

Winner of this week is EP_explorer!

Question #11:
What will happen when data is entered to consolidated zero cell? For example:

I'll say it depends, but the default behavior since 9.5.2 is that the value inputted at 0 value consolidation will be spread evenly amongst the leaves. Since there are 3 leaf children, there will be a value of 3 in each month. If the TM1 admins have been bit one too many times by users spreading on zero at a very high level and they're on a version >= 10.2.2, they may have set the ProportionSpreadToZeroCells cfg setting to False which will cause an error popup when the user tries to spread on zero.

Am I the only one who has made this the law!

Correct answer:
I'll give a link to ascheevel's answer: viewtopic.php?p=83320#p83320
Nothing to add


Winner of this week is ascheevel!

Question #12:
What will happen when data is entered to consolidated non-zero cell? For example:

Data will be spread to leaf cells proportionally with existing values.

In this Case:
Value of January will change from 2 to 3, and value of February will change from 4 to 6. Value of March will remain zero

Assuming Consolidation TypeIn Spreading is not set to Deny then what ardi says (assuming the user wasn't an Admin)!

I'm on vacation, so next question will be on Monday. Stay tuned

Correct answer:

Value will be spread to non-leaf cells proportionally if a user has admin rights or if Consolidation TypeIn Spreading is not set to Deny.

Winners of this week are ardi and MarenC! Both are getting 0.5 points

Question #13:
You are looking at a screen showing the entire budget for you company in Architect. All data is written and stored in this cube. You are copying the company sales total to an email when you realize your finger slipped on the control key and you entered "C" not "Ctrl -C", and then your cat is pressing Enter twice. Moment later, SaveDataAll chore is running. You are trying to undo your operation, but nothing happens. You are checking }Cubeproperties: logging is set to "NO". You are frantically searching for backups, but the last backup is 2 months old: backup disk space has run out.
What are your next steps?

Impose your cat to go to the boss and explain what happened.

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?

gtonkin wrote: ↑Mon Apr 01, 2024 3:27 pmHang on, Wim - Was this you?

No. Just a TM1 REST API Impersonation of Wim.

Send an email to entire company that they have to resubmit their budget due to a catastrophic failure. That and pray to Manny that I don’t lose my job.

Couple options, you can try to claim that your boss's view just isn't set up right, but that only gives you enough time to get out of the building. I'd try to say it's the budget planners' faults if there's nothing there and they must not have correctly submitted their forecasts either by forgetting to hit F9 in TM1web or click Commit in PAX. "It's a shame really, all this time and money we invest teaching end users how to use simple tools or be able to work in the excel they know and love and they still forget the simplest steps costing us real money and making me the TM1 admin and you as my boss look bad in the process. Hopefully you get a chance to explain to your boss how dumb the planners are before their boss complains to yours."

1. Denial - it can't have happened I would have set logging/ backups

2. Anger - who has switched off logging on the cube. Why do we budget like this anyway. I really should have put my foot down in the last Budget review meeting

3. Bargaining - I'll email my business partner and blame them. No, I'll log it as an IBM bug. Wait I can blame it on the users...

4. Depression - I'm going to lose my job. They are going to make me do everything manually in excel again.

5. Acceptance - I think I'll just eat the last Easter egg and also switch to Jedox

Correct answer:

As you have (hopefully) guessed, it was April fool question. There is no correct question here and it will not score I'll just put here my answer:

"I've learned very much after this case. And this education was very expensive for Company. So I'm now super-puper experienced guy, and you cannot fire me after spending so much money on my education. And you need to raise my salary."

Question #14:

Where can MDX be used in TM1?

Nice last question ))
Especially about the cat

MDX
- in subsets (MDX subset you can create in Subset Editor - expression window or during the TI process - SubsetCreatebyMDX)
- in MDX views (in PAW and PAX - Edit MDX in menu)

UPD: Thanks John Hobson For the 1st April question idea: viewtopic.php?p=5688#p5688. I've amended it to be more catastrophic.