SAP BW-BO-SAP Analytics Cloud

SAP Analytics Cloud R-Visualization Gauge Chart library(plotly) library(ggplot2) fig <- plot_ly( domain = list(x = c(0,100000), y = c(0,100000)), value =  select model$ 'variable', title = list(text="Give your Title"), type = "indicator", mode = "gauge+number+delta", delta= list(reference=80000), gauge= list( axis = list(range= list(NULL,100000), tickwidth=1, tickcolor="darkblue"), bar = list(color= "limegreen"), steps = list(                    list(range = c(0,40000), color="darkslategrey"),                    list(range =c(40000,80000), color= "cadetblue"),                    list(range =c(40000,95000), color= "darkturquoise")),                    threshold=list(                    line= list(color= "red" , width =4),                    thickness=0.75,                    value=95000))) fig <- fig%>% layout( margin =list(l=50,r=50), font = list(color="Black", family =&

SAP Analytics Cloud R-Visualizations#1 #Guage library(googleVis) gvisGuage(BestRunJuice_SampleModel,options=list(min=0, max=800, greenFrom=0, greenTo=100,  yellowFrom=101, yellowTo=500, redFrom=501, redTo=800, width=400, height=300)) #Guage$html$footer<- NULL #Guage$html$jsfooter<- NULL #Guage$html$caption<- NULL plot(Guage)

SAP BO Performance Tuning @ Various levels: Connection Level: Use 64 bit connection types @64 bit Operating System rather 32 bit connection type. Database Level/OLAP cubes/BEx Queries: Healthy DWH or well design of Database, its tables with Indexes built. Semantic/Universe Level: Formulas, Aggregate functions, Aggregate_Awareness, LOVs, Group by, Prompts based on Year, Quarter, Month, Weeks, Day at Database level, Aggregated/Pre-calculated Tables. Array fetch size:  Increase Array fetch size at Universe Designer Level. Suppose if we have a report with 5000 Rows, if the Array Fetch size is 100 then BO server connect with the back-end database 50 times. Each Time BO server fetches 100 records. Client Tools/Report Level: Web Report: Crystal Report: Dashboards: As part of Maintenance activities, clear caches,GC With scheduled restart on production on Non-Business Hours. Server Level: Split APS for Webi, Crystal, Dashboard services. Configure DSL Bridge.  Clone m

1. Linganalysis Configurations: I. Basic II.Stems III.Full 2. Extraction Configurations: I. Core II.Core VoiceOfCustomer

SAP HANA-HWC-AP Intel Processors: Nehalem, Westmere, Ivy. PAM: http://service.sap.com/~sapidb/011000358700000701932011E  SAPS:SAP Application Benchmark Performance Standard (throughput unit for HW sizing)

ODBO:OLE DB for OLAP ODBC:Open Database Connectivity JDBC:Java Database Connectivity BICS: BI Consumer Services.