-
TAN function for IBM Planning Analytics (TM1)
TAN function for IBM Planning Analytics (TM1) TAN returns the tangent of an angle expressed in radians. In the video, TAN will be used to calculate tangent of an angle of given radians. Where can the TAN function be used? Rules and TurboIntegrator Which TM1 Server version is the TAN function available for? Version 11 and 12…
-
Time function for IBM Planning Analytics (TM1)
Time function for IBM Planning Analytics (TM1) Time returns the current time from the TM1 server in a string format. In this video, the Time function will be used to retrieve the current TM1 server time. Where can the Time function be used? Rules and TurboIntegrator Which TM1 Server version is the Time function available…
-
DNLev function for IBM Planning Analytics (TM1)
DNLev function for IBM Planning Analytics (TM1) DNLev returns the number of levels in a dimension In the video, DNLev will be used to return the number of levels in the Account dimension. Where can the DNLev function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DNLev function available for? Version…
-
TM1RptElLev function for IBM Planning Analytics (TM1)
TM1RptElLev function for IBM Planning Analytics (TM1) TM1RptElLev returns an element’s level relative to the root in the subset. Used for Dynamic Reports (Active Form). In the video, the TM1RptElLev will be used in a Dynamic Report to identify the level for each element on the row set. Where can the TM1RptElLev function be used?…
-
TM1RptFilter function for IBM Planning Analytics (TM1)
TM1RptFilter function for IBM Planning Analytics (TM1) TM1RptFilter is used to apply a filter to the Dynamic Report to sort the row based on a column. Used for Dynamic Reports (Active Form). In the video, the TM1RptElLev will be used in a Dynamic Report to sort the values in descending order for Q1 from the…
-
Monthly Newsletter, April 2024
Welcome to education and inspiration with the April edition of Cubewise’s Educational Departments Newsletter. This month, we have curated a diverse array of topics designed to captivate and enlighten you. Whether you’re a seasoned professional or a curious learner, there’s something special waiting for you within this newsletter. We invite you to delve into this…
-
Hello, My name is Robin Stevens, and I am your TM1 Therapist!
As a career tech person, I have noticed a tendency for discussions to get bogged down in binary definitions of objective and subjective ideas, and, further, that the latter are often dismissed as irrelevant. I would like to change that. While my context is building planning models in TM1, the ideas here are widely applicable…
-
FP&A For Biotechs
Biotech companies care about all of the standard FP&A reporting. But every industry has its own needs and its own standards, all driven by the unique factors in each industry. Biotech companies face unique challenges that require careful financial planning and analysis.
-
TM1RptRow function for IBM Planning Analytics (TM1)
TM1RptRow function for IBM Planning Analytics (TM1) TM1RptRow returns the row set in a Dynamic Report. Use MDX, a set/subset or hardcode a list of elements in Excel to return members to the row. Change how the row appears to users by setting the element’s indentation, whether to expand consolidations above or below, or allow…
-
TM1RptTitle function for IBM Planning Analytics (TM1)
TM1RptTitle function for IBM Planning Analytics (TM1) TM1RptTitle is used to define the title dimensions for a Dynamic Report. TM1RptTitle is used in conjunction with TM1RptView. In the video, you will learn where TM1RptTitle is used in a Dynamic Report. Where can the TM1RptTitle function be used? Excel Which TM1 Server version is the TM1RptTitle…