Chart and Feed in SAP Analytics Cloud, Analytics Designer

[saurabh_sonawane]

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.

[roland_barfus]

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

All the best,

Roland

[roland_barfus]

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

[saurabh_sonawane]

Yes, lot of trial and error. 🙂

 

 

[JefB]

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

[dperika]

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

[saurabh_sonawane]

in which chart you looking into?

[Bob0001]

Hi Jef,

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

[JefB]

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

[Bob0001]

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.

[JefB]

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.

[vera_ju]

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

[saurabh_sonawane]

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.

[vera_ju]

Hi,

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

 

[vera_ju]

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

[Oleks_Master]

Hi Saurabh,

I am working with Tree map. The line

console.log(Chart_2.getMembers(Feed.Weight));

returns Account ID instead of Measure.

I have tried Feed.Size but it returns empty, as all other Feed.*

Could you suggest anything here, please?

Best regards,

Oleksandr