How to fetch table cell data from analytic application using script and display as text

[rijin_baby61]

Hello,

I have the following table in sac analytic application with just 1 cell, all the filter applied are shown in the screenshot.

I am trying to fetch the data from the data cell to a text box using script.

I tried but doesn't work

var value = Table_1.getDataSource().getData({"@MeasureDimension": "[% Prev Infl]"}).formattedValue;
Text_2.applyText(value);

Can you help me to correct the script to access the cell data

Also if there is a way to access cell value using row column index in getDataSource().getData() kindly let me know

Thank You

[JBARLOW]

Hi there,

I've just tested this syntax using the SAP sample data & it works

Text_1.applyText(Table_1.getDataSource().getData({"@MeasureDimension":"[Account_BestRunJ_sold].[parentId].&[Gross_Margin]" }).formattedValue);

Table_1 : containing just the gross margin measure
Textbox = Text_1

Put the above code in a button to run it.

Are you seeing any errors? do you see any output of your code in the Chrome Console?

[rijin_baby61]

Hello jbarlowjb, thank you for your help

I tried the following code

Text_2.applyText(Table_1.getDataSource().getData({"@MeasureDimension":"[% Prev Infl]" }).formattedValue);

I think I am doing wrong in mentioning the measure dimension. I have a single dimension.

what should be my [Account_BestRunJ_sold].[parentId]?

Error on console

Script execution failed for "Text_2.onClick" event<br>  This error appears to have occurred due to a problem in the script that you tried to run. Check the script if possible.<br>Cannot read properties of undefined (reading 'formattedValue') <br> TypeError: Cannot read properties of undefined (reading 'formattedValue')<br>    at Proxy.eval (Text_2.onClick.js:6:5) 

[JBARLOW]

what's actually in your table?

Is it a calculated measure dimension? or a numeric dimension?

[rijin_baby61]

the value displayed is a calculated measure

[JBARLOW]

Possibly not quite right,

But does something like this work?

var DIMKEY = Table_1.getDimensionsOnRows()[0];
var selections = Table_1.getDataSource().getDataSelections();

var member = Table_1.getDataSource().getResultMember(DIMKEY,selections[0]);
 
Text_1.applyText(member.id);

[rijin_baby61]

jbarlowjb

I used the code that you shared, error for me

Cannot read properties of undefined (reading 'id') 
 TypeError: Cannot read properties of undefined (reading 'id')

I also tried in a new table with a numeric dimension. still nor working

[JBARLOW]

use console log

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

[rijin_baby61]

jbarlowjb

Thank you for the help. I fixed it.

the issue was for a calculated measure we don't use the name but the technical code.

In my case it was something like

Table_1.getDataSource().getData({"@MeasureDimension":"65184617-4409-4841-9644-180224944563"}).formattedValue;

Using console.log it is easy. Thank you for all the suggestions. It really helped to learn more

[Bob0001 · Accepted solution]

Try to verify whether your selection is correct. You can do this by logging the output of Table_1.getSelections() from the on select handler of the table.

[rijin_baby61 · Accepted solution]

Thank you bob.meincke

Can you tell me extactly how this can be done?

[Marc_Kuipers · Accepted solution]

rijin_baby

See: https://blogs.sap.com/2020/02/10/debugging-sac-analytic-designer-applications/

on the use of console.log()

[rijin_baby61 · Accepted solution]

Thank You.