Reading the Value of a Dimension from a Data Source in Javascript

[emrys_tx]

Environment:

     SAP Design Studio 1.6

     SAP BEx 7.40

I have a data set with a multitude of dates which are stored as dimensions. In one screen of my dashboard I need to show 26 of these dates for one row of data. A crosstab scrolls off of the page so I have put listed the dates at the bottom of the page as label/value pairs using text objects. The idea is that when the user clicks on a PO #, the fields at the bottom will be populated for that project.

I was planning on using data binding but I discovered that data binding only works for key figures. I cannot reconfigure the BW data to make all of the dates key figures for a variety of reasons so my question is this: is it possible to extract the value of a dimension from a filtered query with Javascript?

Given a data source of MY_QUERY, is there any MY_QUERY.get* method or combination of methods that will get me the value of a specifically named dimension in the query?

Thanks in advance.

Jeff White

[MustafaBensan]

Hi Jeff,

It is not possible to achieve your requirement with standard functionality.  You can however use the Data Iterator Component from the SCN Design Studio SDK Development Community  to read the data from the relevant row and assign it to text labels via scripting.

Regards,

Mustafa.

PS:  For future reference, you should post questions on the SCN as Questions and not Discussions like this one.

[emrys_tx]

Thanks. I will look in that direction.

Jeff