Question Re: How to fetch table cell data from analytic application using script and display as text in Technology Q&A

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

rijin_baby61 — Thu, 13 Oct 2022 09:54:59 GMT

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

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

JBARLOW — Thu, 13 Oct 2022 10:18:25 GMT

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?

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

rijin_baby61 — Thu, 13 Oct 2022 10:34:50 GMT

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)

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

JBARLOW — Thu, 13 Oct 2022 10:48:25 GMT

what's actually in your table?

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

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

rijin_baby61 — Thu, 13 Oct 2022 10:50:16 GMT

the value displayed is a calculated measure

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

JBARLOW — Thu, 13 Oct 2022 10:59:11 GMT

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);

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

Bob0001 — Thu, 13 Oct 2022 12:22:24 GMT

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.

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

rijin_baby61 — Thu, 13 Oct 2022 13:16:56 GMT

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

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

rijin_baby61 — Thu, 13 Oct 2022 13:19:06 GMT

Thank you bob.meincke

Can you tell me extactly how this can be done?

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

JBARLOW — Thu, 13 Oct 2022 13:41:37 GMT

use console log

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

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

Marc_Kuipers — Thu, 13 Oct 2022 13:53:50 GMT

rijin_baby

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

on the use of console.log()

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

rijin_baby61 — Thu, 13 Oct 2022 15:09:21 GMT

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

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

rijin_baby61 — Thu, 13 Oct 2022 15:09:39 GMT

Thank You.