TM1 Functions used in IBM Planning Analytics/TM1

A dictionary for end-users and developers

Excel (IBM reference)
Excel Macro (IBM reference)
Rule (IBM reference)
TurboIntegrator (TI) (IBM reference)
MDX (IBM reference)

Functions are not case-sensitive

wdt_ID	Function	Definition	Excel	Rules	TI	Note
1	ABS	Converts a number into an absolute value.		Rules	TI	Refer to Rules for TI syntax
2	ACOS	Returns the angle, in radians, whose cosine is x.		Rules	TI	Refer to Rules for TI syntax
3	AddClient	Create a new client on the server.			TI
4	AddCubeDependency	Establish cube dependency manually.			TI
5	AddGroup	Create a new group on the server.			TI
6	AddInfoCubeRestriction	Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic.			TI
7	ASCIIDelete	Deletes an ASCII file.			TI
8	ASCIIOutput	Exports to an ASCII file. The fields exported must be in string format. To convert a number to string, use NumberToString or STR.			TI
9	ASIN	Returns the angle, in radians, whose sine is x.		Rules	TI	Refer to Rules for TI syntax
10	AssignClientPassword	Change the password for a user.			TI
	Function	Definition	Excel	Rules	TI	Note

See how Cubewise can help you

We would love to show you how a set of applications could help you forecast, budget and plan better.

Book