This one you’re all going to like….
No really, you’re going to love this… however I cannot take credit for the idea, just this blog post. I love creating customer specific SAP Analytics Cloud
” data-original-title aria-label=”SAC SAPedia “>SAC stories, I use tools to get proper logos, I use ColorPic to make sure the colours I use are exactly what the customer has in his / her logos but now we can take the personalisation one step further.
So you have created your SAP Analytics Cloud (SAP Analytics Cloud
” data-original-title aria-label=”SAC SAPedia “>SAC) story with fully interactive visualisations and feeling proud of yourself. The next step in the process is to do a playback of the solution to the business and wait for those familiar words “That’s great …. but” and you hope and pray to whatever deity is currently available that the sentence after the “but” is close to achievable.
I was recently given one of those “buts” from a client when they asked me if we could include the current live exchange rates between currencies and also their company’s stock value as part of their story. After picking myself off the floor, my initial thoughts were “This is not possible”, however it turns out to be reasonably easy to do and in the remainder of this blog I am going to explain how to go about it.
You may or may not be aware of a website called Trading View.
This website provides an overwhelming amount of information and analytical capability relating to the Stock Market and one very cool feature with the website is its abundance of free widgets that provide this information and these can be embedded into other third-party solutions and this is where SAC comes in.
For the purposes of this blog, let’s assume we want to include a widget that contains a Stock Ticker and Line Chart that tracks the GBP vs EUR performance over time in our Story.
The first thing we need to do is go to the Trading View website and look for the “Widget” section. (This can be found under the “More” option on main menu bar at the top of the webpage). Once in the widget section, scroll down until you find a section titled “Mini Chart Widget”. Select the “Get Widget” option and you will be presented with the screen below. You can use any and all of the widgets in this section but for this blog we’ll just use the “Mini Chart Widget” – the method however is identical for all of them.
You are presented with a number of options and the first thing we want to do is change the symbol field so that it reports GBP vs EUR. Under Symbol field enter the value “GBPEUR” and you will be presented with two options as shown in the screen below. We now select the option that is appropriate for our use case.
Once we have changed the symbol we then click on the “Apply” option and the changes we have made will be reflected through on the chart. As you can see from the screen below, there are a number of options available which allow you to:
- Determine how far back you analyse the exchange rate
- The colour theme you want to use
- The size
The widget is now ready to take into SAP Analytics Cloud