
Power BI has Decomposition Tree Graph. It is very good for helping business users to do their Data Analysis.
How's in SAC?
This article is to describe the using of Collapsible Tree having close functionality to Decomposition Tree Graph in SAC.
Table Contents:
Introduction
Power BI has Decomposition Tree Graph. It is very good for helping business users to do their Data Analysis. SAC has R-Visualization. Collapsible Tree has a close functionality for Decomposition Tree.
R Visualization is an integrated suite of software that includes packages for advanced visualizations and statistics. SAP Analytic Cloud allow us to create and edit visualizations based on R Script.
This article use Analytic Application and to describe how to integrate between Analytic Application and R Visualization SAC Widget. This article describes only Collapsible Tree summary.
I use this collapsible tree to show the relationship between Sender & Receiver in Cost Object Allocation data. Business will have visualization in interactive collapsible tree Diagram.
Setup Collapsible Tree R-Visualization in Analytic Application
This article use Analytic Application.
R Visualization widget is found at Insert Tab -> Add -> More Widgets -> R Visualization.
setup Dimensions & Measures at Input Data.
library('collapsibleTree')
library(RColorBrewer)
df<-ZMODEL_ALLOCATION
lnodesize <- as.character(ZMODEL_ALLOCATION$`Node Size`)
df$Color <- df$zxpcforlc
collapsibleTreeSummary(
df,
inputId = NULL,
root = "Total Cost",
fontSize = 9,
attribute="ZMeasureLC",
hierarchy = c(dims),
maxPercent = 10,
fillFun = colorspace::rainbow_hcl,
zoomable = TRUE,
tooltip = TRUE,
collapsed = TRUE
)
Appendix/Reference
Collapsible Tree arguments. Link
Setup R-Visualization in Analytic Design. Link
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
21 | |
19 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |