Category: Slice

  • Building Fast Excel Reports with Slice

    Building Fast Excel Reports with Slice

    Many companies transitioning from an on-premise TM1 installation to IBM Planning Analytics (PA) on the cloud can face performance challenges. A common issue is the noticeable difference in refresh times for excel reports between their previous setup using Perspectives and the new PA on the cloud with PAfE (Planning Analytics for Excel). A recent case…

  • Arc and Slice v5.0 is now available

    Arc and Slice v5.0 is now available

    New Report Audit feature in Slice Slice introduces a new Report Audit feature to help you highlight best practices violations in your Excel reports #3126 Transaction Log in Arc Arc now includes a Transaction Log feature that allows you to browse and restore transaction logs. This feature is useful for auditing and recovering data in…

  • Finding the Right Tool

    Finding the Right Tool

    Transitioning away from Perspectives can be challenging, but with the right tool and partner, it can be a smooth and beneficial process. As we move forward, it’s important to set the right expectations and understand the benefits of this transition. Finding the Right Alternatives The main question is what to do with your TM1 Excel…

  • Override selected user preferences

    Override selected user preferences

    Starting with v4.6.1, it is now possible to set the default values for user preferences. the list of properties exported by the User Preference dialog to include a wider variety of preferences supported by Arc. This now includes toolbar visibility preferences and code formatter options. When Arc Server is run or re-started, a new folder…

  • DBSW function behavior with Slice

    DBSW function behavior with Slice

    Slice supports the native TM1 functions DBS and DBSW to send data into your IBM Planning Analytics (TM1) cube. DBSW is much faster than DBS, it is highly recommended to use DBSW instead of DBS. Default behaviour of DBS and DBSW Slice offers a convenient feature with the DBS Send button located in the Slice…

  • 5 Ways to Aggregate Data in DBRW with Slice

    5 Ways to Aggregate Data in DBRW with Slice

    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 aggregate data using the DBRW function in TM1 with Slice: 1. Natural Consolidations You can easily select any consolidation in your dimensions by clicking in any cell with a SUBNM…

  • Arc and Slice v4.6 is now available

    Arc and Slice v4.6 is now available

    The Arc Assistant is now powered by WatsonX Arc Assistant is now powered by Watson X or any OpenAI compatible service. This new feature allows you to use any OpenAI compatible service to power the Arc Assistant. This feature is great to use the Arc Assistant with your own AI service or with any other…

  • Arc and Slice v4.5.2 is now available

    Arc and Slice v4.5.2 is now available

    With IBM announcing the sunsetting of Perspectives, Slice is getting some serious attention. And with that, we’re getting some great feedback from customers.  Now is a perfect time to suggest Slice to new & existing customers. Remember Slice’s mission statement is to correctly open all legacy Perspectives reports, so if you find an edge case with…

  • Arc and Slice v4.5 is now available

    Arc and Slice v4.5 is now available

    Highlight unsupported TM1 functions in v12 In the Process Editor, a new button has been added to underline in red unsupported TM1 functions in v12 Generate Pulse flow diagram From a cube view, process editor and a rule editor, a new button has been added to generate the Pulse flow diagram for the selected object.…

  • Dynamic Planning Template with Slice: A Simple Practical Guide

    Dynamic Planning Template with Slice: A Simple Practical Guide

    In this article, we explored how to create dynamic asynchronous views using MDX. This approach enhances data visibility by allowing unique element combinations in each row and column. Now, we’ll expand on this by demonstrating a practical example. The value of MDX Forms MDX Forms, available through the Slice add-on in Excel, provide a powerful…