The TCM_GCV8 function is the most widely used in reports as it retrieves individual values from the database. There are many other functions that can also be used in reports to retrieve other information to help make your reports even more flexible and dynamic.
The most commonly used functions are:
Function | Description |
---|---|
TCM_MemberDescription | Retrieves the description of a dimension member given its name or index number |
|
=TCM_MemberDescription(Dimension, Index Number or Member Name) |
|
=TCM_MemberDescription(“Entity”,”Aust”) |
TCM_MemberName | Retrieves the name of a dimension member given its index number |
|
=TCM_MemberName(Dimension, Index Number) |
|
=TCM_MemberName(“Entity”,5) |
TCM_MemberIndex | Retrieves the Index number of a dimension member given its name |
|
=TCM_MemberIndex(Dimension, Member Name) |
|
=TCM_MemberIndex(“Entity”,”Aust”) |
TCM_MemberCount | Returns the number of members in a particular dimension |
|
=TCM_MemberCount(Dimension) |
|
=TCM_MemberCount(“Variable”) |
TCM_SetName | Retrieves the name of a dimension set given its index number |
|
=TCM_SetName(Dimension, Index number) |
|
=TCM_SetName(“Variable”,3) |
TCM_SetDescription | Retrieves the description of a dimension set given its name or index number |
|
=TCM_SetDescription(Dimension, Set Name or Index number) |
|
=TCM_SetDescription(“Variable”, “PL”) |
TCM_SetMemberIndex | Retrieves the dimension index number of a member of a set given its set index number |
|
=TCM_SetMemberIndex(Dimension, Set, Member) |
|
=TCM_SetMemberIndex(“Variable”, “PL”, 5) |
Post your comment on this topic.