Week 1: Battle For Brooklyn Bridge!

10 Questions

Settings
Please wait...
Battle Quizzes & Trivia

This quiz primarily looks at the Optimising Cube Performance competency and is based on the first chapter of volume 2 of the TM1 10. 1 training course.


Related Topics
Questions and Answers
  • 1. 
    What is the main purpose of the SKIPCHECK statement in TM1?
    • A. 

      For the purposes of efficient cube design where there are no N-level calculates, as it skips the checking of these and assumes there is no calculation.

    • B. 

      Complements the FEEDERS statement by telling TM1 that it can skip the checking of FEEDERS.

    • C. 

      Skips the rule below it in the rule file.

    • D. 

      Skips cell-based checking for blank and non-zero values, significantly increasing the efficiency of cubes.

  • 2. 
    Which of these purposes does the FEEDERS statement fufill?
    • A. 

      It is the actual statement that feeds the rules to TM1, so it knows when to run them

    • B. 

      Tells TM1 that the TM1 cube has subsets and which subsets are associated with that cube

    • C. 

      Donates $1 to the TM1 developers each time the statement is ran so they don't go hungry

    • D. 

      Tells TM1 which calculated cells will receive non-zero values from rules

  • 3. 
    What is the correct way of writing a FEEDER statement? (Syntax)
    • A. 

      ['membername']=>['rulereference']

    • B. 

      FEED=>[membername]=[reference]

    • C. 

      ['membername']=['rule']*['reference']

    • D. 

      There is no syntax, TM1 10.1 handles the creation and removal of all FEEDER statement automatically

  • 4. 
    What does over-feeding mean?
    • A. 

      Feeding too many cells

    • B. 

      Feeding more cells than are necessary, such as cells whose result will be zero anyway

    • C. 

      Feeding cells whose value is equal to something other than zero

    • D. 

      Eating too much

  • 5. 
    Is it better to over-feed or under-feed?
    • A. 

      Over-feed

    • B. 

      Under-feed

    • C. 

      None - they are both equally bad

    • D. 

      It is impossible to under-feed and you should never over-feed

  • 6. 
    When might you need to feed a rule applied to a string cell?
    • A. 

      When the rule pulls the string into another cube

    • B. 

      If the rule is populating a pick list

    • C. 

      When the target is using suppress zeros

    • D. 

      All of the above

  • 7. 
    How do you feed a string cell?
    • A. 

      Use the normal FEEDERS declaration for the cell

    • B. 

      Use the FEEDSTRINGS declaration

    • C. 

      Press the "Feed String" icon in the rule editor

    • D. 

      Create an N-level calculation to perform the string feeding

  • 8. 
    Which business-critical question does TM1 allow you to answer?
    • A. 

      What your organisation should be doing (e.g. planning questions)

    • B. 

      Report on how your organisation is doing (e.g. Scorecarding and dashboarding)

    • C. 

      Perform analysis and reporting (e.g Evaluate why you are doing something in a certain way)

    • D. 

      All of the above

  • 9. 
    What does OLAP stand for?
    • A. 

      Open Learning and Planning

    • B. 

      Online Analytic Processing

    • C. 

      Online Learning and Performance

    • D. 

      Oxford London Analysis and Performance

  • 10. 
    What is the rumored meaning of the acronym "TM1"?
    • A. 

      Trent Matthews 1

    • B. 

      Table Manager 1

    • C. 

      Total Management 1

    • D. 

      TIGERS! MUTANTS!!!!!!!1