SAC - Analytic Applications getResultSet Issue

[#1]

Hi all,

I have a problem when using a "Hide Measures" in SAC Analytic Applications. If i don't hide a measure the operation getResultSet work fine (see the image ResultSet_work.png). But, if i hide the measure (image HideMeasures.png) the operation getResultSet not work in others words, obatained a empty array (see image ResultSet_issue.png). How can this problem be solved? Is it a bug or are there problems with these features?

hidemeasures.png

resultset-issue.png

resultset-work.png

[N1kh1l · Accepted solution]

pwc_bo_90

pwc_bo_90This is Not a bug but expected behaviour.

For tables, getDataSource.getData(), getDataSource.getDataSelections(), getDataSource.getResultMember() and getDataSource.getResultSet() APIs only retrieve data from displayed cells, which are by default an upper limit of 500 rows and 60 columns.

Some changes made by end users at runtime will affect data returned by the result set API as well, including:

• Adding rows or columns to a table

• Hiding or excluding rows or column in a table.

  Only data of visible rows or columns will be returned.

• Collapsing parent node in a table.

  All its children won't be returned.

• Showing total value in a chart

• Showing parent in a chart

• Getting the new dimension or measure added by smart grouping and new forecast data in a predictive scenario

• Adding or removing comments in a chart or table

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/834786949212459caabe3...

Hope this helps !!

Nikhil

[pwc_bo_90 · Accepted solution]

Thanks for the answer.. it's all normal. But, how can hide a measure and obtained the correct list of fields?

Dino