Ultimate Long TM1 quiz

[Mark RMBC]

Hi,

I have not used this myself but I believe you enter the relevant directories, separated by a comma in the cfg file, like so,

DatabaseDirectory="c:\tm1dims;c:\tm1cubes"

The documentation stresses that this does the following:

Accesses cubes and dimensions from each of the specified directories. If there is a duplicate object, Cognos TM1 accesses the object from the first directory specified.
Writes changes to the directory where the object is located. When you create a new object, Cognos TM1 writes to the first directory you had specified.

Therefore, you may want to for example, place the dimensions in the tm1dims directory and the cubes in the tm1cubes directory.

I suppose the use case for this is simply for structure and manageability.
I would certainly need to see a stronger use case than the above to actually ever use this.

regards,

Mark

[lotsaram]

You can list multiple data directories (yes, you can: https://www.ibm.com/docs/en/planning-an ... irectory-1) for DataBaseDirectory parameter in tm1s.cfg file. How does it work? How can you use it?

Multiple database directories was great way back when. It was quite useful for segregating common objects like TI libraries or common utility cubes where the definition was shared across multiple instances in a larger corporate TM1 landscape. These days it is just a trivia question. No one uses this anymore now that we have git.

[Elessar]

Correct answer:

In addition to official documentation:

1. Files are created in the 1st directory. After you move them to another directory, they are updated there.
2. Use a separate folder for *.rux and *.pro files in your favorite version control system

There is a great explanation of this by mce here: viewtopic.php?f=3&t=13425&p=66007&hilit ... ion#p66007

Winner of this round is Mark RMBC!

@Lotsaram: Totally agree, but I think <5% companies could beat this Tm1+git integration yet. Approach with a separate "for code" folder and non-git version control still exists in many projects.

Question #33:
Administrator wants to launch a huge 3-hour-long data copy process. He has informed users not to change any data so that they do not interrupt the process, but still there is no guarantee. How can he prevent all users from interrupting the process?

[MarenC]

Hi,

Please tell me you are not thinking of,

EnableBulkLoadMode

I just don't trust this process!

Maren

[Elessar]

Is it your answer?

[MarenC]

Hi,

Is it your answer?

Yes, I guess it is.

Maren

[Elessar]

Any other approaches?

Bulk Load is a nuke

[Emixam]

You can make all users read only using the }ClientProperties and put a 1 under ReadOnlyUser but it will prevent them from doing input on other cubes that are not impacted by this data load.

Another option could be: lock the cube (}CubeProperties) and use CubeLockOverride(1) in your TI and allow writing to a locked cube

[ardi]

Correct answer:

In addition to official documentation:

1. Files are created in the 1st directory. After you move them to another directory, they are updated there.
2. Use a separate folder for *.rux and *.pro files in your favorite version control system

There is a great explanation of this by mce here: viewtopic.php?f=3&t=13425&p=66007&hilit ... ion#p66007

Winner of this round is Mark RMBC!

@Lotsaram: Totally agree, but I think <5% companies could beat this Tm1+git integration yet. Approach with a separate "for code" folder and non-git version control still exists in many projects.

Question #33:
Administrator wants to launch a huge 3-hour-long data copy process. He has informed users not to change any data so that they do not interrupt the process, but still there is no guarantee. How can he prevent all users from interrupting the process?

We have a control cube where we maintain some flags. One of the Flags is to make all users Read Only (A rule in }ClientProperties populates the ReadOnlyUser measure for all users )
The other Flag is to disable the users completely ( A rule in }ClientProperties populates the IsDisabled measure for all users except some special users)

[Elessar]

Correct answer:

1. ReadOnlyUser in the }ClientProperties cube - prevent from changing data
2. Use locks
3. IsDisabled in the }ClientProperties cube.
   !You cannot disable Admin
   !Need to kick current sessions (via tm1py, for example)
4. Bulkloadmode - disable everything. Cannot be cancelled: only by server restart. Cannot monitor it using TM1Top: You can only use tm1server.log (if the process launches other processes - you will see "started-finished).

OMG I do not know how to share this point Maren was 1st, Emixam gave 2 answers and Ardi explained a good solution with control cube.
It's the first time, when winners of this round are MarenC, Emixam and Ardi! All three have got 0,(3) points!

Question #34:
Oh no! I've set ReadOnlyUser in the }ClientProperties cube for all admins also. Now I cannot change it because I'm readonly admin now. What should I do?

[Emixam]

Even if you are ReadOnlyUser, you can still create and execute TI. Simply create and execute a TI with the following command:

Code: Select all

CellPutN(0, '}ClientProperties', 'my_name', 'ReadOnlyUser');

[MarenC]

Hi,

the scoreboard is confusing me somewhat!?

Maren

[Elessar]

Hi,

the scoreboard is confusing me somewhat!?

Maren

0.(3) is periodic decimal. 0.(3) = 0.33333333333333333333333... = 1/3
In your case, 7.8(3) = 7.83333333333333333333... = 7.5 + 1/3

[Elessar]

Correct answer:

No panic, you still can change rules and processes. Create a process to set Readonlyuser=0 for you, or a rule. Thanks Wim for bringing this up: http://www.tm1forum.com/viewtopic.php?f=3&t=14057

Winner of this round is Emixam! Good start!

Question #35:
When should I enable Security Access for TI Process?

Security Access.png (7.65 KiB) Viewed 6625 times

[Adam]

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.

[Emixam]

On which client you took this screenshot?
Adam is right.

[Adam]

On which client you took this screenshot?
Adam is right.

I like the iconography too!

[Elessar]

Correct answer:

You need to enable Security Access when process needs to change security.
BTW, it does not matter if process is launched by admin or non0admin user: it will fail anyway without Security Access enabled.

Winner of this round is Adam!

Screenshot is taken from TM1 Architect. It is depreciated, but still super-useful.

Question #36:
Different formats are set for all dimensions in a cube. Which one will be displayed?
Dimension order in cube is following:

1. Organization
2. EmployeeList
3. Year
4. Version
5. JobType
6. Employee

Image 66.png (53.04 KiB) Viewed 6025 times

[MarenC]

Hi,

I believe the Version Format will be displayed because that is stacked on the column and is the last dimension on the column.

Maren

[ardi]

TM1 applies the formatting of the Most inner Row dimension, in your case it would be the formatting defined in your Version dimension.

Just curious: What you have called as Employee Dimension seems to be your Measures dimension in the cube?