1 / 4

Configuring the CheckBox feature in Analytics Designer_ SAP Analytics Cloud - TekLink

With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is becoming one of the most sort after tools in the SAP BI Space. SAC is more of a self-service solution on the cloud, hence, there was a constant business need for a professionally authored dash-boarding tool on the cloud.

TEK3
Download Presentation

Configuring the CheckBox feature in Analytics Designer_ SAP Analytics Cloud - TekLink

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 20/12/2022, 17:50 Configuring the CheckBox feature in Analytics Designer: SAP Analytics Cloud - TekLink June 01, 2021 Configuring the CheckBox feature in Analytics Designer: SAP Analytics Cloud With SAP focusing on cloud-based analytics, SAP Analytics Cloud (SAC) is Recent Posts becoming one of the most sort after tools in the SAP BI Space. SAC is more of a self-service solution on the cloud, hence, there was a constant business Collecting failed records from… need for a professionally authored dash-boarding tool on the cloud. SAP now has a solution for this in the form of Analytics Designer. 9th June, 2022 Analytics Designer has many features that makes it very interactive. For this Using Calculation Groups in AAS… purpose, it uses, tables, charts, various widgets and script logic to bind all these together. 22nd June 2022 In this blog, we will see the use of script logic for enabling the checkbox Correcting the column name… feature in Analytics Designer. We will be using the checkbox to select the account dimension member and the table output will change dynamically as 5th July 2022 per the selection. Create a new Analytic Designer Application. Add the below objects in the canvas Mandatory Widgets: A. Table: Rows – Any Dimension Column – Account (Filtered on a member) B. Buttons: 1. Set Measure 2. Remove Measure 3. Set All Measures C. Checkbox Group Once the structure is ready, we can include the script logic. https://teklink.com/knowledge-center/configuring-the-checkbox-feature-in-analytics-designer-sap-analytics-cloud/ 1/4

  2. 20/12/2022, 17:50 Configuring the CheckBox feature in Analytics Designer: SAP Analytics Cloud - TekLink Create two script variables of type String and set as array. It will be required to capture and store the checkbox selections. Create a Class and function (Argument: String[set as array], Return Type: Void) in the script objects panel Add the below logic in the script function to modify the table dimension as per the checkbox selection. Note: Replace the function argument as per the dimension name of the model. Go to edit script on the canvas and include the below logic in ‘onInitialization’ function to retrieve the Account Dimension Members of the model: Note: Replace the table name as per the configuration https://teklink.com/knowledge-center/configuring-the-checkbox-feature-in-analytics-designer-sap-analytics-cloud/ 2/4

  3. 20/12/2022, 17:50 Configuring the CheckBox feature in Analytics Designer: SAP Analytics Cloud - TekLink Edit the scripts of the buttons to execute the Checkbox functionality. Button – Set All Measures Button – Remove All Measures Button – Set Measure Filter To run the application, save it and click on Run Analytic Application Button. Output: Table Dimension will change as per the Checkbox selection. Mukund Parihar Sr. Director - Planning Other Articles from TekLink https://teklink.com/knowledge-center/configuring-the-checkbox-feature-in-analytics-designer-sap-analytics-cloud/ 3/4

  4. 20/12/2022, 17:50 Configuring the CheckBox feature in Analytics Designer: SAP Analytics Cloud - TekLink Aligning IT Processes to Business Building an industry standard BI Needs Architecture Contact Us “TekLink provided worry free BEx to AO Migration by analyzing and converting o 500+ BEx workbooks to Analysis for Off while also increasing adoption by runni power user workshops.” Full Name * Email * Phone Number * Company Your Message Lakshmi Thota Sr. Manager, Rust-Oleum Company I'm not a robot reCAPTCHA Privacy - Terms SUBMIT Follow 5,022        TekLink International Inc. 4320 Winfield Rd, Suite 215, Warrenville, IL 60555, USA. Telephone: +1 630-791-9760 / +1 630-791-9767 Fax: +1 (866) 535 5169 Email: info@teklink.com Copyright © 2021 TekLink International Inc. All rights reserved. Data Science and Advanced Data Analytics Consulting Services SERVICES Enterprise Data Lake and Data Warehouse Data Engineering and Data Integration TECHNOLOGIES Data Visualization and Storytelling INSIGHTS DevOps for Analytics Cloud Infrastructure and Migration Services CLOUD NUCLEUS Extended Planning and consolidation Trade Management Applications COMPANY Supply Chain Management TIDE Technical Services Innovation Labs Roadmaps and Advisory Services https://teklink.com/knowledge-center/configuring-the-checkbox-feature-in-analytics-designer-sap-analytics-cloud/ 4/4

More Related