get value with getResultSet if measure not in 'table structure': rows/columns

[eeddggaarr]

Hi,
I am struggeling to get measure values with 'getResultSet' if this measure is not placed in rows or columns:
table (live BW conn.) with one dimension in rows and one measure in 'Filters':

this will lead to the table below:

with:

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

I get result set below - measure value seems not to be available. How do I have to change syntax to get values too?

br
edgar

[William_Yu · Accepted solution]

That's not possible at the moment with SAC. All table related API relies on data fetched to table. You can create another table with the measure you want and hide that table for display.

[eeddggaarr · Accepted solution]

Thank you William.

[rohitchouhan]

You can use Selection() & getData() function to get this.

[eeddggaarr]

Hi Rohit,
thank you for your answer. in my usecase end users do not select table contents, that is why I will implement William's idea.
br
edgar