BAE Systems Flashcards
Return a numeric attribute for a specified element of a dimension
ATTRN(dimension, element, attribute)
returns the index number of an element within a dimension.
DIMIX(server_name:dimension, element)
returns the element of a dimension that corresponds to the index argument.
DIMNM(server_name:dimension, index)
returns the number of elements within a specified dimension.
DIMSIZ(dimension)
returns the name of a child of a consolidated element in a specified dimension.
ELCOMP(dimension, element, position)
returns the level of an element within a dimension.
ELLEV(dimension, element)
converts a string to a number
NUMBR(string)
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.
SCAN(substring, string)
returns a substring of a given string.
SUBST(string, beginning, length)
converts a number to a string, using the decimal separator for the current user locale.
NumberToString(Value);
creates a new dimension.
DimensionCreate(DimName);
adds a component (child) to a consolidated element. You can’t use this function in the Epilog procedure of a TurboIntegrator process.
DimensionElementComponentAdd(DimName, ConsolidatedElName,ElName, ElWeight);
adds a component (child) to a consolidated element by directly editing a dimension.
DimensionElementComponentAddDirect(DimName, ConsolidatedElName,ElName, ElWeight);
deletes a component (child) from a consolidated element.
DimensionElementComponentDelete(DimName, ConsolidatedElName,ElName);
deletes a component (child) from a consolidated element by directly editing the dimension.
DimensionElementComponentDeleteDirect(DimName, ConsolidatedElName,ElName);
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.
DimensionElementInsert(DimName, InsertionPoint, ElName,ElType);
adds an element to a dimension by directly editing the dimension. You can use this function to add numeric, string, or consolidated elements.
DimensionElementInsertDirect(DimName, InsertionPoint, ElName,ElType);
returns the principal name of an element or element alias.
DimensionElementPrincipalName( DimName, ElName )
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.
DimensionExists(DimName);
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.
DimensionSortOrder(DimName, CompSortType, CompSortSense, ElSortType , ElSortSense);
creates a new hierarchy in an existing dimension. The hierarchy cannot have the same name as the dimension.
HierarchyCreate(DimName, HierName);
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.
HierarchyElementInsert(DimName, HierName, InsertionPoint, ElName, ElType);
deletes a hierarchy from the TM1® database.
This function is valid in TM1 TurboIntegrator processes only.
HierarchyDestroy(DimName, HierName);
lets you execute a TurboIntegrator process from within another process.
ExecuteProcess(ProcessName, [ParamName1, ParamValue1,ParamName2, ParamValue2]);
forces a process to skip the current data source item.
ItemSkip;
stops processing source data and proceeds to the Epilog portion of a process.
ProcessBreak;
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.
ProcessRollback;
is used in a TurboIntegrator script to force serial execution of a designated set of TurboIntegrator processes.
synchronized (lockName);
statement allows a process to repeat a series of statements when a given condition is true. These statements can be nested
WHILE(logical expression);
statement1;
statement2;
…
statement n;
END;
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.
RuleLoadFromFile(Cube, TextFile);
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.
ServerActiveSandboxSet(SandboxName)
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.
AddClient(ClientName);
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.
AddGroup(GroupName);
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.
AssignClientToGroup(ClientName, GroupName);
reads all the security control cubes and regenerates the internal structures in the server that are used by TM1® API functions.
SecurityRefresh;
saves all TM1® data from server memory to disk and restarts the log file.
This function is valid in TM1 TurboIntegrator processes only
SaveDataAll;
creates an empty public subset of a specified dimension.
SubsetCreate(DimName, SubName, [AsTemporary]);
deletes all elements from a public subset.
SubsetDeleteAllElements(DimName, SubsetName);
deletes a subset from the TM1® database.
SubsetDestroy(DimName, SubName);
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.
SubsetElementExists(DimName, SubsetName, ElementName);
determines whether a specific public subset exists on the server from which a TurboIntegrator process is executed.
SubsetExists(DimName, SubsetName);
creates an empty view of a specified cube.
ViewCreate(Cube, ViewName, );
deletes a view from the TM1® database.
ViewDestroy(Cube, ViewName);
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.
ViewExists(CubeName, ViewName);
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.
ViewExtractSkipCalcsSet (Cube, ViewName, Flag);
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.
ViewExtractSkipConsolidatedStringsSet (Cube, ViewName, Flag);
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.
ViewExtractSkipRuleValuesSet (Cube, ViewName, Flag);
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.
ViewExtractSkipZeroesSet (Cube, ViewName, Flag);
sets all data points in a view to zero.
ViewZeroOut(Cube, ViewName);
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.
DatasourceNameForServer=’Name’;
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.
DatasourceNameForClient=’Name’;
This TM1® specific MDX function returns all the members in of the specified .
TM1FILTERBYLEVEL( , )
This TM1® specific MDX function returns the TM1 subset All of .
TM1SubsetAll([]);
The Proportional spread method distributes a specified value among cells proportional to existing cell values.
P>300
control cube defines user group access to properties for individual clients on the TM1 server
}ClientSecurity
control cube stores security privileges for all cubes, including other control cubes on the TM1 server.
}CubeSecurity
control cube stores security definitions for all dimensions, including control dimensions on the TM1 server.
}DimensionSecurity
control cube stores security definitions for all the elements in the DimensionName dimension.
}ElementSecurity_DimensionName
control cube stores security definitions for all TurboIntegrator processes on the TM1 server.
}ProcessSecurity
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
}ClientsGroups
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.
}ClientProperties
control cube tracks the message count, average message size, total elapsed time, and other measures.
}StatsByClient
control cube tracks memory use, the number of populated string cells, populated numeric cells, stored calculated cells, fed cells, stored views, and other statistics.
}StatsByCube
control cube tracks the connected clients, active threads, and memory used for the server.
}StatsForServer
What is visible in Architect?
Applications Cubes Dimensions Processes Chores Replications
What are the tabs in Maps in TI?
Cube Dimensions Data Consolidations Attributes
