Sap Analytics cloud (SAC) - Application Designer: linked dimensions

[nicola_boschetti]

Hi all, I've some questions about the new tool Application Designer. In particular, it can create a table with linked dimension like it's done with "Stories"? For each table or chart it can add one model, but I have to filter my table with dimension of another model. Let's me explain with an example:

I have a table which contain data of a single Order with only its code and its description and I have to filter these data only by a Date field of another model, that shows me the order for that date.

These two models are imported by csv files. I can't link these two models, can you help me?

Kind regards!

[Thorsten3]

Hi all,

I have the same question like Nicola ...

[former_member411491]

Hi Nicola,

I assume here Friday is also one of dimension as you want to apply filter over it without selecting it.

You can use below 2 technques

// Filter Year
var year_id = ArrayUtils.create(Type.string);
year_id.push('K4' + Dropdown_Year.getSelectedKey());
TablePandL.getDataSource().setDimensionFilter("0FISCYEAR", year_id);

// Filter Posting Period
var period_ids = ArrayUtils.create(Type.string);
period_ids.push('002');
TablePandL.getDataSource().setDimensionFilter("0FISCPER3", period_ids);

or

Table_2.getDataSource().getData({"@MeasureDimension":"00O2TPKEZLPN2IM172LP7B13O","XX000245":" 4"}).formattedValue);

Measure id you will get from consol log

console.log(Table_1.getDataSource().getMeasures());

run the application and press F12 to see the log.

Thanks and Regards,

Sanjay Guha

[Former Member]

Hi

Linked analysis is not used in app design - if you want to filter across viz- you have to apply the filtering by script (java)

1) pick up you dimension member (what you clicked) on

2) pass this selection to the other data source and filter on the selected dimension member

In Lumira designer:

Get selected member from ds_1

Set filter on ds_2

[nicola_boschetti]

Hi Renè, what you say is correct, I was already using JavaScript functions. My goal now is to take the filtered cells of a specific dimension, without select them. Example: I have one table reporting day of week (Monday....Sunday). I would like to apply a filter which select only Friday and then add it as a new item of a Dropdown.

I tried to use Table_1.getDataSource().getMembers("Day") (with filter applied), but it retrieves all days, not the filtered one. Any suggestion?