Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

TM1 > BAE Systems > Flashcards

BAE Systems Flashcards

1
Q

Return a numeric attribute for a specified element of a dimension

A

ATTRN(dimension, element, attribute)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

returns the index number of an element within a dimension.

A

DIMIX(server_name:dimension, element)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

returns the element of a dimension that corresponds to the index argument.

A

DIMNM(server_name:dimension, index)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

returns the number of elements within a specified dimension.

A

DIMSIZ(dimension)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

returns the name of a child of a consolidated element in a specified dimension.

A

ELCOMP(dimension, element, position)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

returns the level of an element within a dimension.

A

ELLEV(dimension, element)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

converts a string to a number

A

NUMBR(string)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

returns a number indicating the starting location of the first occurrence of a specified substring within a string. If the substring does not occur in the given string, the function returns 0.

A

SCAN(substring, string)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

returns a substring of a given string.

A

SUBST(string, beginning, length)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

converts a number to a string, using the decimal separator for the current user locale.

A

NumberToString(Value);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

creates a new dimension.

A

DimensionCreate(DimName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

adds a component (child) to a consolidated element. You can’t use this function in the Epilog procedure of a TurboIntegrator process.

A

DimensionElementComponentAdd(DimName, ConsolidatedElName,ElName, ElWeight);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

adds a component (child) to a consolidated element by directly editing a dimension.

A

DimensionElementComponentAddDirect(DimName, ConsolidatedElName,ElName, ElWeight);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

deletes a component (child) from a consolidated element.

A

DimensionElementComponentDelete(DimName, ConsolidatedElName,ElName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

deletes a component (child) from a consolidated element by directly editing the dimension.

A

DimensionElementComponentDeleteDirect(DimName, ConsolidatedElName,ElName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

adds an element to a dimension. You can use this function to add numeric, string, or consolidated elements. You can’t use this function in the Data or Epilog procedures of a TurboIntegrator process.

A

DimensionElementInsert(DimName, InsertionPoint, ElName,ElType);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

adds an element to a dimension by directly editing the dimension. You can use this function to add numeric, string, or consolidated elements.

A

DimensionElementInsertDirect(DimName, InsertionPoint, ElName,ElType);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

returns the principal name of an element or element alias.

A

DimensionElementPrincipalName( DimName, ElName )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

determines whether a specific dimension exists on the server from which a TurboIntegrator process is executed. The function returns 1 if the dimension exists on the server, otherwise it returns 0.

A

DimensionExists(DimName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

sets a sort type and sense for dimension elements and for components of consolidated elements within a dimension. The sort order defined by DimensionSortOrder determines how the subset displays in the Subset Editor.

A

DimensionSortOrder(DimName, CompSortType, CompSortSense, ElSortType , ElSortSense);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

creates a new hierarchy in an existing dimension. The hierarchy cannot have the same name as the dimension.

A

HierarchyCreate(DimName, HierName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

adds an element to a dimension. You can use this function to add numeric, string, or consolidated elements. You can’t use this function in the Data or Epilog procedures of a TurboIntegrator process.

A

HierarchyElementInsert(DimName, HierName, InsertionPoint, ElName, ElType);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

deletes a hierarchy from the TM1® database.

This function is valid in TM1 TurboIntegrator processes only.

A

HierarchyDestroy(DimName, HierName);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

lets you execute a TurboIntegrator process from within another process.

A

ExecuteProcess(ProcessName, [ParamName1, ParamValue1,ParamName2, ParamValue2]);

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

forces a process to skip the current data source item.

A

ItemSkip;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

stops processing source data and proceeds to the Epilog portion of a process.

A

ProcessBreak;

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

initiates a process rollback. When used inside a TurboIntegrator process, this function throws out all pending edits and cancels further processing. An error message appears in the tm1server.log and tm1processorerrorXXX.log files.

A

ProcessRollback;

28
Q

is used in a TurboIntegrator script to force serial execution of a designated set of TurboIntegrator processes.

A

synchronized (lockName);

29
Q

statement allows a process to repeat a series of statements when a given condition is true. These statements can be nested

A

WHILE(logical expression);

statement1;

statement2;

…

statement n;

END;

30
Q

creates a TM1® rule for a specified cube from a text file. Each rule statement must end with a semi-colon (;) and comments must be prefixed with the # character. If a rule already exists for the specified cube, the rule is overwritten by the rule created by RuleLoadFromFile.

A

RuleLoadFromFile(Cube, TextFile);

31
Q

ets the active sandbox of the executing user. An empty string is used to clear the executing user’s active sandbox. This function throws an error if the executing user does not own a sandbox with the passed name.

Because chores run in the context of a special admin user, and can have no active sandbox, this function always throws an error when executed using a chore.

A

ServerActiveSandboxSet(SandboxName)

32
Q

creates a new client on the server. Changes applied through the AddClient functions do not take effect until the Metadata procedure in a process is completed. This function, like all functions that update metadata, should not be used in the Data or Epilog tabs of a process.

A

AddClient(ClientName);

33
Q

creates a new user group on the server. Changes applied through the AddGroup function do not take effect until the Metadata procedure in a process is completed. This function, like all functions that update metadata, should not be used in the Data or Epilog tabs of a process.

A

AddGroup(GroupName);

34
Q

assigns an existing client on a server to an existing user group. This function assigns an existing client on a server to an existing user group.

A

AssignClientToGroup(ClientName, GroupName);

35
Q

reads all the security control cubes and regenerates the internal structures in the server that are used by TM1® API functions.

A

SecurityRefresh;

36
Q

saves all TM1® data from server memory to disk and restarts the log file.

This function is valid in TM1 TurboIntegrator processes only

A

SaveDataAll;

37
Q

creates an empty public subset of a specified dimension.

A

SubsetCreate(DimName, SubName, [AsTemporary]);

38
Q

deletes all elements from a public subset.

A

SubsetDeleteAllElements(DimName, SubsetName);

39
Q

deletes a subset from the TM1® database.

A

SubsetDestroy(DimName, SubName);

40
Q

determines whether a specific element exists within a specific public subset on the server from which a TurboIntegrator process is executed. SubsetElementExists cannot be used to determine if an element exists in a private subset.

A

SubsetElementExists(DimName, SubsetName, ElementName);

41
Q

determines whether a specific public subset exists on the server from which a TurboIntegrator process is executed.

A

SubsetExists(DimName, SubsetName);

42
Q

creates an empty view of a specified cube.

A

ViewCreate(Cube, ViewName, );

43
Q

deletes a view from the TM1® database.

A

ViewDestroy(Cube, ViewName);

44
Q

determines whether a specific public view exists on the server from which a TurboIntegrator process is executed. The function returns 1 if the view exists on the server, otherwise it returns 0. Note that this function cannot be used to determine the existence of private views.

A

ViewExists(CubeName, ViewName);

45
Q

sets an option to include/exclude consolidated values in a view and any associated view extracts. A view extract is a TM1® view exported as an ASCII comma-delimited (.cma) file.

A

ViewExtractSkipCalcsSet (Cube, ViewName, Flag);

46
Q

sets an option to exclude strings on consolidated values that are excluded from a view or any associated view extracts. A view extract is a TM1® view exported as an ASCII comma-delimited (.cma) file.

A

ViewExtractSkipConsolidatedStringsSet (Cube, ViewName, Flag);

47
Q

sets an option to include/exclude rule-calculated values in a view and any associated view extracts. A view extract is a TM1® view exported as an ASCII comma-delimited (.cma) file.

A

ViewExtractSkipRuleValuesSet (Cube, ViewName, Flag);

48
Q

sets an option to include/exclude zero values in a view and any associated view extracts. A view extract is a TM1® view exported as an ASCII comma-delimited (.cma) file.

A

ViewExtractSkipZeroesSet (Cube, ViewName, Flag);

49
Q

sets all data points in a view to zero.

A

ViewZeroOut(Cube, ViewName);

50
Q

This TurboIntegrator local variable sets the name of the data source (.cma file, cube name, ODBC source) used by the server when executing the process.

A

DatasourceNameForServer=’Name’;

51
Q

This TurboIntegrator local variable sets the name of the data source (.cma file, cube name, ODBC source) used by the client when creating or editing the process.

A

DatasourceNameForClient=’Name’;

52
Q

This TM1® specific MDX function returns all the members in of the specified .

A

TM1FILTERBYLEVEL( , )

53
Q

This TM1® specific MDX function returns the TM1 subset All of .

A

TM1SubsetAll([]);

54
Q

The Proportional spread method distributes a specified value among cells proportional to existing cell values.

A

P>300

55
Q

control cube defines user group access to properties for individual clients on the TM1 server

A

}ClientSecurity

56
Q

control cube stores security privileges for all cubes, including other control cubes on the TM1 server.

A

}CubeSecurity

57
Q

control cube stores security definitions for all dimensions, including control dimensions on the TM1 server.

A

}DimensionSecurity

58
Q

control cube stores security definitions for all the elements in the DimensionName dimension.

A

}ElementSecurity_DimensionName

59
Q

control cube stores security definitions for all TurboIntegrator processes on the TM1 server.

A

}ProcessSecurity

60
Q

cube stores group assignments for all clients on the TM1® server.
This control cube is populated with values that reflect the assignments applied in the Clients/Groups window, which you can access by clicking Server, Security, Clients/Groups in Server Explorer. You can also enter values directly in the

A

}ClientsGroups

61
Q

control cube stores property values for all clients on the TM1® server.
You can use client properties to define a client password, the maximum number of connections allowed, client status, and more.

A

}ClientProperties

62
Q

control cube tracks the message count, average message size, total elapsed time, and other measures.

A

}StatsByClient

63
Q

control cube tracks memory use, the number of populated string cells, populated numeric cells, stored calculated cells, fed cells, stored views, and other statistics.

A

}StatsByCube

64
Q

control cube tracks the connected clients, active threads, and memory used for the server.

A

}StatsForServer

65
Q

What is visible in Architect?

A 
Applications
Cubes
Dimensions
Processes
Chores
Replications
66
Q

What are the tabs in Maps in TI?

A 
Cube
Dimensions
Data
Consolidations
Attributes

TM1 (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions