Link Dimensions in SAP Analytics Cloud Application Designer

[former_member657582]

Hello together,

In my Analytics Application I want to filter Data in two charts.

These charts get their data from different models (both excel files). Because of that I want to link the models via "link dimension" like its possible in a normal SAC Story.

How do I achieve this via scripting/ other options?

Thanks in advance

Mike

PS: I tried to use the Chart.getDatasource.setDimensionFilter() function but by default I can only choose from the dimensions of the datasource used in the Chart and no other data sources.

[former_member542603]

Hi Mike,

When you say link does that mean you need the view combined data in the chart?

Could you explain the scenario a little more.

- Sathya

[former_member657582]

Thanks for your reply,

I try to specify my problem a little bit more straight forward:
I have two datasources ( lets call them Model 1 and Model 2) and a chart build on top of each Model.

Now I want to link/ join the two Models with a key (number) which is the same in both Model 1 and Model 2. This way I want to filter on a dimension of Model 1 but across both charts.

Primary I dont need to view combined data in the chart.

I hope that makes the scenario a little bit more understandable.

Mike

[former_member542603]

Ahh Okay!!

You Could use something like below. Apply the code when you apply the filter.

Chart_2.getDataSource().copyDimensionFilterFrom(Chart_1.getDataSource(),"USERNAME");

-Sathya