Skip to Content
Technical Articles

SAC Analytic Designer Case Studies

Hello Everyone,

I want to share some use case study based on SAP Analytics Cloud Analytic Designer, which is we face generally in our business requirements or which we can use to fulfill our customer requirements. So I will share a few cases in this blog and it will continue for upcoming blogs.

 

Cases :

Weblink widgets : 

Embedding is work with both story and application, usually, we can make a choice between open in new tab or open in the same widget. Even if you choose open in the same widget still it not work/look what exactly we are expecting to do as it open with a broad SAC Analytics designer header which is kind of meaningless and occupied huge space in case if you are populating it in Popup widgets.  we can remove such extra header by using an embedded method, just add the embed parameter: ?mode=embed”. You can always look up the correct URL by going to the Share option of your application or story and copy the provided link into your web widget. we can embed videos from youtube, other applications, stories, etc.

To get the embedded function choose the correct URL is very important.

Word Cloud: 

Yes, We can build Word Cloud Chard by in  SAC by creating Custom widgets in R Visualization Widgets. Visualization helps us a lot to get the decision based on our data. Based on the data choose the right visualization is also important we have a lot of data visualizations (like charts, graphs, infographics, and more) that give businesses a valuable way to make the decision.

If you want a stunning visualization format to highlight important textual data points, using a word cloud can make dull data sizzle and immediately convey crucial information.

Word cloud generators can help simplify this process.

R Script

# load package

library(wordcloud)

# get words

words <-Dimention

# get frequency

frequency <- Measure

# generate word cloud

wordcloud(words, frequency, scale = c(4, 1), rot.per=0.2, colors=brewer.pal(8, “Blues”))

Progress Bar :

You will not find any such widget in SAP Analytics Cloud but still, we can achieve this by using Slider widget. Usually, Slider widget is used for user input and get calculated value based on the slider values. here we will discuss how to use it as a progress bar like our other chart for visualization.

The Progress Bar widget is essential for long forms, helping your users in checking whether they have completed the target, and also providing feedback on how far they have to go.

The widget is easy to configure; with intuitive settings and a few themes that are easy on the eye.

Steps to get Progress Bar :

We need to create a numeric chart which will give us the progress value. Now the question comes what the progress bar range can be fixed or it can be dynamic as well. In cased of fixed value, you can use slider direct properties as shown in the below image.

In case of dynamic, you can fix the value by using scripts. In the below codes, you can see how we can put the max, min and set value from the numeric chart by reading the measure value. To get the measure name we can use the console log.

Code : 

console.log(Bck_Pr.getDataSource().getMeasures());

BCK_Process.setMaxValue(ConvertUtils.stringToNumber(Bck_Pr.getDataSource().getData({“@MeasureDimension”:”35535223-8334-4717-a487-324737206791″}).formattedValue));

BCK_Process.setValue(ConvertUtils.stringToNumber(Bck_Pr.getDataSource().getData({“@MeasureDimension”:”17388095-1038-4428-8726-165738425233″}).formattedValue));

 

Please note that once we read the value we get the result back as a string. Now our task is to convert the string to Number. To perform this task we will use ConverUtils function method StringTo Number.You can use formated data or raw data depend on the requirement.

 

These are the few above techniques that we can use in SAP Analytics Cloud Analytics designer to get some custom functionality. Analytics designer provide a lot of custom features which we can achieve using scripts. After Q4 2019 release now we can create custom widgets also. Very soon I will come back with such new feature implementation.

 

Thanks and Regards,

Sanjay Guha

2 Comments
You must be Logged on to comment or reply to a post.
  • interesting case study – however i think this blog would definitely benefit from some screenshots. after all, you are describing how to build a visualisation, and yet you don’t show it? remember,  a picture paints a thouzand words 😉