Skip to Content
Technical Articles
Author's profile photo Saurabh Suresh Sonawane

Chart and Feed in SAP Analytics Cloud, Analytics Designer

Hi Friends,

Writing the blog because lot of question is ask on the chart and there feeds.

So the below table will be use full to the identify the feed for different chart so we can easily use in the application designer

 

Below table represent all the Comparison chart feed.

Comparison Chart To add/remove dimension To add/remove  measure  
Bar/Column

Feed.CategoryAxis

 

Color

Feed.Color

Feed.ValueAxis
Combination column and line

Feed.CategoryAxis

 

Color

Feed.Color

Column axis

Feed.ValueAxis

 

Line axis

Feed.ValueAxis2

Combination stacked column and line

Feed.CategoryAxis

 

Color

Feed.Color

Column axis

Feed.ValueAxis

 

Line axis

Feed.ValueAxis2

Stack bar/column

Feed.CategoryAxis

 

Color

Feed.Color

Feed.ValueAxis

 

Waterfall

Feed.CategoryAxis

 

Color

Feed.Color

Feed.ValueAxis

 

 

Below table represent all the Trend chart feed.

Trend chart To add/remove dimension To add/remove  measure  
Stacked Area

Feed.CategoryAxis

 

Color

Feed.Color

Feed.ValueAxis

 

Line

Feed.CategoryAxis

 

Color

Feed.Color

Left Y-axis

Feed.ValueAxis

 

Right Y-axis

Feed.ValueAxis2

Time

Feed.CategoryAxis

 

Color

Feed.Color

Feed.ValueAxis

 

 

Below table represent all the Distribution chart feed.

Distribution chart To add/remove dimension To add/remove  measure  
BOX plot

Dimension =

Feed.CategoryAxis

 

Aggregation dimension =

Feed.DataContext

 

Color

Feed.Color

Feed.ValueAxis

 

 

 

Heat Map

 

X-axis = Feed.CategoryAxis

 

Y-axis = Feed.CategoryAxis2

 

Trellis =

Feed.Trellis

Color

Feed.color

Histogram

Aggregation Dimension =

Feed.DataContext2

 

Color =

Feed.color

 

 

Feed.ValueAxis
Radar

Dimension =

Feed.CategoryAxis

 

Color=

Feed.color

 

Feed.ValueAxis
Tree

Dimension(label)=

FEED.TITLE

 

Color =

Feed.color

 

Measure(size)=

 

Feed.Weight

 

Below table represent all the Correlation chart feed.

Correlation Chart To add/remove dimension To add/remove  measure  
Bubble Feed.CategoryAxis

X-axis

Feed.ValueAxis

 

Y-axis

Feed.ValueAxis2

 

Size

Feed.BubbleWidth

 

Cluster Bubble

Feed.CategoryAxis

 

Color =

Feed.color

 

Feed.ValueAxis
ScatterPlot

Feed.CategoryAxis

 

Color =

Feed.color

 

X-axis

Feed.ValueAxis

 

Y-axis

Feed.ValueAxis2

 

 

Below table represent all the Indicator chart feed.

Indicator Chart To add/remove dimension To add/remove  measure  
Bullet

Feed.CategoryAxis

 

Color = ?

Feed.ValueAxis

 

Numeric Point

Trellis

Feed.Trellis

 

Color = ?

 

Primary value =

Feed.ValueAxis

 

Secondary value =

Feed.ValueAxis2

 

Below table represent all the More chart feed.

More Chart To add/remove dimension To add/remove  measure

Donut

 

Color =

Feed.color

 

Trellis

Feed.Trellis

 

Feed.Size
Marimekko

Feed.CategoryAxis

 

Color =

Feed.color

 

Trellis

Feed.Trellis

Height =

Feed.ValueAxis

 

Width =

Feed.ValueAxis2

 

Pie

Color =

Feed.color

 

Trellis

Feed.Trellis

 

Feed.Size

 

Thanks,

Saurabh S.

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Roland Barfus
      Roland Barfus

      Thanks a lot, Saurabh, that was exaxtly what I was looking for!

      All the best,

      Roland

      Author's profile photo Roland Barfus
      Roland Barfus

      How did you find out about it? Trial and error?

      Author's profile photo Saurabh Suresh Sonawane
      Saurabh Suresh Sonawane
      Blog Post Author

      Yes, lot of trial and error. 🙂

       

       

      Author's profile photo Devadas Perika
      Devadas Perika

      Hi Saurav,

       

      Can you please drop me a blank email at madedo@outlook.com. I am new to SAC, have few doubts to clarify.

      Thanks in advance

      Dev

      Author's profile photo Jef Baeyens
      Jef Baeyens

      Is there a way to set the Feed.Color options 'Pattern' (Solid/Outlined/Hatched), 'ShowAs' (Front/Back) and 'Color'?

      Author's profile photo Saurabh Suresh Sonawane
      Saurabh Suresh Sonawane
      Blog Post Author

      in which chart you looking into?

      Author's profile photo Bob Pfeiffer
      Bob Pfeiffer

      Hi Jef,

      this is not possible with the current set of APIs offered for the Chart.

      Author's profile photo Jef Baeyens
      Jef Baeyens

      Too bad! It's really needed to set correct (IBCS compliant) bar charts.

      Author's profile photo Bob Pfeiffer
      Bob Pfeiffer

      Not sure whether it helps in your concrete case, but there will be fix coming up which preserves existing pattern, stacking and color settings for the version dimension, which got lost earlier e.g. when setting a filter on this dimension on a chart. Also newly added versions get the more useful default settings similar as if you would do it through Builder panel in edit mode.

      Author's profile photo Jef Baeyens
      Jef Baeyens

      Yes, indeed, we also learned through an incident there's a fix for that coming.
      It already helps, although would be better if it can be controlled fully by a designer.

      Author's profile photo Maren Junghanß
      Maren Junghanß

      Hi Friends,

      I try to use the script for selection from a dropdown for measures.

      I buildt it similar as the application from SAP "Feature - Select measures via a dropdown box" runs on the model BestRun_advanced.

      For table it works fine. But in case of chart the measures are added and not removed. But I need only the selected measure in the chart, same as in the table.

      script for Function setMeasureFilter:

      Table_1.getDataSource().removeDimensionFilter("CostElement");
      if (CurrentMeasureFilterSelection !== "") {
      Chart_1.removeMeasure(CurrentMeasureFilterSelection, Feed.ValueAxis);
      }
      Table_1.getDataSource().setDimensionFilter("CostElement",selectedId);
      Chart_1.addMeasure(selectedId, Feed.ValueAxis); 

      And one more question: we use a live model. I'm not really sure is the name of the measure-Dimension right in t his case? "Measures"

      Thanks in advance

      Maren

      Author's profile photo Saurabh Suresh Sonawane
      Saurabh Suresh Sonawane
      Blog Post Author

      Hi,

      And one more question: we use a live model. I'm not really sure is the name of the measure-Dimension right in t his case? "Measures"

       

      I would suggest please check all the naming of your measure and dimension in the live model and that will help you to create a dropdown, make sure to use ID always in the measure.

       

      Thanks,

      Saurabh S.

      Author's profile photo Maren Junghanß
      Maren Junghanß

      Hi,

      example script is link to another model (import). The name of dimension is right (CostElement).

       

      Author's profile photo Maren Junghanß
      Maren Junghanß

      Hi,

      sometimes later!

      We have a Bar/Colum chart with one measure and variance too. But the variance should be changed dependence form the selection.

      We would use the script:

      removeMember(Feed.????      "measure1";

      addMember(Feed. ????, "measure2"),

      but I can't find a script for variance. It seems, it isn't possible?

      Do you know a solution?

      Best Regards,

      Maren