Technical Articles
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.
Thanks a lot, Saurabh, that was exaxtly what I was looking for!
All the best,
Roland
How did you find out about it? Trial and error?
Yes, lot of trial and error. 🙂
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
Is there a way to set the Feed.Color options 'Pattern' (Solid/Outlined/Hatched), 'ShowAs' (Front/Back) and 'Color'?
in which chart you looking into?
Hi Jef,
this is not possible with the current set of APIs offered for the Chart.
Too bad! It's really needed to set correct (IBCS compliant) bar charts.
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.
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.
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
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.
Hi,
example script is link to another model (import). The name of dimension is right (CostElement).
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