Check Values of measure in SAP Analytical Designer application

[Former Member]

Hi Experts,

I had a question on how to check value of a measure/dimension in data source.

Example

I have dimension named Flag. Now i need to check on initialization that if Flag value is 1 then hide a chart or if flag value is 2 then show the chart. .

[Former Member]

Hi Bob,

I am checking for dimension value in the chart. For eg I have status field and with value as Active or Closed. Now if Active then I show button 1 as visible and if button 2 as closed. Vice versa for value Closed.

The script that Sanjay mention I tried that but without converting string to number and it gives me error on runtime "failed to run script on initialization"

if( (Chart_1.getDataSource().getData({"DUNSTATUS":'Active'}).formattedValue)) { Button_1.setVisible(true); }

[Bob0001]

You can use getData method on DataSource to read individual data cells.See Sanjay's proposal in https://answers.sap.com/questions/12950115/sac-application-designer-hide-null-values.html.

If the structure is dynamic you may use getResultSet method, which is more complex. See Developer Handbook for some introduction.