Ultimate Long TM1 quiz

User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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
clip_image004.jpg
clip_image004.jpg (3.2 KiB) Viewed 7491 times


UPD: Bonus from George Tonkin: What is red font here in Architect?
image.png
image.png (9.37 KiB) Viewed 7483 times
Last edited by Elessar on Fri May 10, 2024 3:27 pm, edited 2 times in total.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
EP_explorer
Regular Participant
Posts: 213
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: Ultimate Long TM1 quiz

Post by EP_explorer »

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.)
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

Good! And what about red?
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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:

Image 49.png
Image 49.png (8.55 KiB) Viewed 7317 times
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
ascheevel
Community Contributor
Posts: 291
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Ultimate Long TM1 quiz

Post by ascheevel »

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.
MarenC
Regular Participant
Posts: 364
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Ultimate Long TM1 quiz

Post by MarenC »

Code: Select all

they may have set the ProportionSpreadToZeroCells cfg setting to False
Am I the only one who has made this the law!
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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:

Image 50.png
Image 50.png (8.9 KiB) Viewed 7203 times
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
ardi
Community Contributor
Posts: 159
Joined: Tue Apr 02, 2013 1:41 pm
OLAP Product: tm1, cognos bi
Version: from TM1 9.4 to PA 2.0.9.6
Excel Version: 2010
Location: Toronto, ON

Re: Ultimate Long TM1 quiz

Post by ardi »

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
Ardian Alikaj
MarenC
Regular Participant
Posts: 364
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

Re: Ultimate Long TM1 quiz

Post by MarenC »

Assuming Consolidation TypeIn Spreading is not set to Deny then what ardi says (assuming the user wasn't an Admin)!
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

I'm on vacation, so next question will be on Monday. Stay tuned
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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?

1april.png
1april.png (15.18 KiB) Viewed 6910 times
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Ultimate Long TM1 quiz

Post by Wim Gielis »

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

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
gtonkin
MVP
Posts: 1214
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Ultimate Long TM1 quiz

Post by gtonkin »

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? :shock:
Wim Gielis
MVP
Posts: 3140
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Ultimate Long TM1 quiz

Post by Wim Gielis »

gtonkin wrote: Mon Apr 01, 2024 3:27 pmHang on, Wim - Was this you? :shock:
No. Just a TM1 REST API Impersonation of Wim.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Adam
Posts: 107
Joined: Wed Apr 03, 2019 12:10 am
OLAP Product: IBM PA
Version: 2.0.9.x
Excel Version: Microsoft 365 x64

Re: Ultimate Long TM1 quiz

Post by Adam »

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.
I've started blogging about TM1, check it out: www.havaslabs.com

Take care,
Adam
ascheevel
Community Contributor
Posts: 291
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Ultimate Long TM1 quiz

Post by ascheevel »

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."
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: Ultimate Long TM1 quiz

Post by Edward Stuart »

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
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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?
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 7th article - Development requirements.
EP_explorer
Regular Participant
Posts: 213
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: Ultimate Long TM1 quiz

Post by EP_explorer »

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)
User avatar
Elessar
Community Contributor
Posts: 363
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: Ultimate Long TM1 quiz

Post by Elessar »

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

TM1 and Data Science blog: 7th article - Development requirements.
Post Reply