Subnm formulas define the context members. View view is primarily used for compatibility with ibm tm1 perspectives worksheets. If the optional alias parameter is included, the function returns the alias for the element.
MYTH's LOVE FOR POKIMANE GETS EXPOSED! Fortnite Funny Fails & Epic
You can use tm1 worksheet functions anywhere in an ibm planning analytics for microsoft excel or tm1. If you include the optional alias parameter to this function, the function returns the alias for the. Subnm returns an element from a dimension set.
It can allow you to use a subset from a tm1 dimension for selection purposes in an excel report, tm1web or planning analytics workspace analysis.
You can add formulas that use ibm tm1 functions to reports. Ibm planning analytics worksheet functions return a numeric or string value. Subnm returns the element of a dimension subset corresponding to the indexorname argument. When working in excel with ibm planning analytics (tm1), efficient data aggregation is essential for building dynamic reports so here are five powerful ways to.
For example, you may build an income statement to filter by department or year (assuming. Click the down arrow to select a different member from the set. You can also convert exploration views that use tm1 data to formulas. The subnm function can be used in dynamic reports to create parameters that filter the results.
Subnm returns an element from a dimension set.
For example, when you create a slice from a tm1 perspectives worksheet and open it in ibm. If the optional alias parameter is included, the function returns the alias for the element.
