Category: Education

  • WildCardFileSearch function for IBM Planning Analytics (TM1)

    WildCardFileSearch function for IBM Planning Analytics (TM1)

    WildCardFileSearch function for IBM Planning Analytics (TM1) WildCardFileSearch searches files using wildcard characters in a folder. In this video, WildCardFileSearch is used to search files starting with a P. Where can the WildCardFileSearch function be used? TurboIntegrator Which TM1 Server version is the WildCardFileSearch function available for? Version 11 and 12 What is the syntax…

  • ElementComponent function for IBM Planning Analytics (TM1)

    ElementComponent function for IBM Planning Analytics (TM1)

    ElementComponent function for IBM Planning Analytics (TM1) ElementComponent returns the name of the child of a consolidated element. In the video, ElementComponent will be used to retrieve a child’s name from a consolidated element of the Employee Hierarchies dimension and apply it in the rule to populate the TestS measure in the Employee Salaries cube. Where can the ElementComponent…

  • ElementComponentCount function for IBM Planning Analytics (TM1)

    ElementComponentCount function for IBM Planning Analytics (TM1)

    ElementComponentCount function for IBM Planning Analytics (TM1) ElementComponentCount returns the number of consolidation components. In the video, ElementComponentCount will be used to determine the number of elements of the consolidation of the Employee Hierarchies dimension and apply it in the rule to populate the Employee Salaries cube. Where can the ElementComponentCount function be used? Rules and…

  • ElementCount function for IBM Planning Analytics (TM1)

    ElementCount function for IBM Planning Analytics (TM1)

    ElementCount function for IBM Planning Analytics (TM1) ElementCount returns the number of components of the consolidated element. In the video, ElementCount will be used to return the number of elements from the Employee Hierarchy dimension. Where can the ElementCount function be used? Rules and TurboIntegrator Which TM1 Server version is the ElementCount function available for?…

  • ElementFirst function for IBM Planning Analytics (TM1)

    ElementFirst function for IBM Planning Analytics (TM1)

    ElementFirst function for IBM Planning Analytics (TM1) ElementFirst returns the first element of a specified dimension. In the video, ElementFirst will be used to retrieve the first element of the Employee Hierarchies dimension and apply it in the rule to populate in the Employee Salaries cube.​ Where can the ElementFirst function be used? Rules and TurboIntegrator Which…

  • ElementIsAncestor function for IBM Planning Analytics (TM1)

    ElementIsAncestor function for IBM Planning Analytics (TM1)

    ElementIsAncestor function for IBM Planning Analytics (TM1) ElementIsAncestor determines if the element is an ancestor of another element or not. In the video, ElementIsAncestor will be used to determine if the consolidation element is an ancestor of another element or not and apply it in the rule to populate the Comment measure in the Employee Salaries…

  • Time function for IBM Planning Analytics (TM1)

    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…

  • Monthly Newsletter, April 2024

    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…

  • Automated Testing for TM1 in Arc and Pulse

    Automated Testing for TM1 in Arc and Pulse

    Learn about the importance of testing in TM1 (IBM Planning Analytics) and how our solution, Arc, can revolutionize your testing process. Discover how Arc allows developers to write and execute tests within the same environment, and how it connects to Pulse for monitoring and sharing test results. Don’t miss out on this opportunity to stay…

  • IBM Planning Analytics for Workspace (PAW) 2.0.94 / 2.1.1

    IBM Planning Analytics for Workspace (PAW) 2.0.94 / 2.1.1

    For version 2.0.94, IBM has introduced a range of new features to enhance the user experience and improve system performance. These include improvements in books and reporting, plans and applications, modelling and administration. In addition, there are deprecations that you need to be aware of.