-
Building the Next Generation of Active Forms with Slice
Slice is an Excel add-in for IBM Planning Analytics. It allows users to build Excel reports with hierarchy capabilities while connected to the TM1 Server. In this presentation, you’ll learn tips on how to use the cube viewer, how to use MDX forms, what MDX labs are, how to create on-the-fly calculations and how to…
-
Monthly Newsletter, March 2024
Welcome to education and inspiration with the March 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…
-
IBM Planning Analytics for Workspace (PAW) 2.0.93
IBM has recently introduced a range of new features that are designed to enhance 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.
-
ChoreAttrNL function for IBM Planning Analytics (TM1)
ChoreAttrNL function for IBM Planning Analytics (TM1) ChoreAttrNL retrieves a numeric attribute for a Chore, based on a language locale. In this video, ChoreAttrNL is used to retrieve the numeric attribute, Frequency, for the ChoreFunction_Test chore using language locale fr. Where can the ChoreAttrNL function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrNL function available for? Version 11…
-
ChoreAttrPutS function for IBM Planning Analytics (TM1)
ChoreAttrPutS function for IBM Planning Analytics (TM1) ChoreAttrPutS uploads data to a string attribute for a Chore. In this video, ChoreAttrPutS is used to retrieve data from the string attribute, Description, for the ChoreFunction_Test chore, using language locale fr. Where can the ChoreAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ChoreAttrPutS function available for? Version 11…
-
ChoreRollback function for IBM Planning Analytics (TM1)
ChoreRollback function for IBM Planning Analytics (TM1) ChoreRollback terminates the chore and begins a rollback. In this video, ChoreRollback is used to terminate the chore and rollback data. Where can the AsciiDelete function be used? TurboIntegrator Which TM1 Server version is the ChoreRollback function available for? Version 11 and 12 What is the syntax for ChoreRollback?…
-
ConsolidateChildren function for IBM Planning Analytics (TM1)
ConsolidateChildren function for IBM Planning Analytics (TM1) ConsolidateChildren forces consolidate value to be calculated by summing immediate children. In this video, ConsolidateChildren is used to calculate consolidated values by summing immediate children’s values and applying them in the rule to populate the Product Scorecard cube. Where can the ConsolidateChildren function be used? Rules Which TM1…
-
ConsolidatedAvg function for IBM Planning Analytics (TM1)
ConsolidatedAvg function for IBM Planning Analytics (TM1) ConsolidatedAvg returns the average value in a consolidation. In this video, ConsolidatedAvg is used to calculate average value in a consolidation and apply it in the rule to populate the Avg_Value measure in the Product Scorecard cube. Where can the ConsolidatedAvg function be used? Rules and TurboIntegrator Which TM1 Server version…
-
ConsolidatedCountUnique function for IBM Planning Analytics (TM1)
ConsolidatedCountUnique function for IBM Planning Analytics (TM1) ConsolidatedCountUnique counts the unique elements of the consolidated cell in one dimension. In this video, ConsolidatedCountUnique is used to count the unique elements in the consolidation and apply it in the rule to populate in the Product Scorecard cube. Where can the ConsolidatedCountUnique function be used? Rules and TurboIntegrator Which…
-
CubeAttrS function for IBM Planning Analytics (TM1)
CubeAttrS function for IBM Planning Analytics (TM1) CubeAttrS returns a string attribute for a specified cube. In the video, CubeAttrS will be used to retrieve string attribute value of the cube and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the CubeAttrS function be used? Rules and…