Skip to Content
0
Dec 20, 2014 at 05:25 AM

Bex Query without Measures

46 Views

Hi,

I trying to build an requirement in DS 1.3. Attached is the bex query structure i have..there is no measures in bex query

I have one dimension filter Title in my filter Panel and one load button.

- Scenario 1: Whenever i didnt choose any title in my dimension filter

Output Display dyanically in ListBox not in Table/GridLayout:

On startup i wrote:

LISTBOX_1.getSelectedValue(""); // Iam doing something wrong here..

- Scenario 2: Whenever i choose specific/multiple title in my dimension filter

Output Display in ListBox not in Table/GridLayout:

On startup i wrote: to get the selected titles

var kpi1=ds_1.getMembers("Ytitle", 20);

kpi1.foreach(func(element, index)) {

list.additem(kpi1.text);

}); // where in list box display all titles/ rather selected title item..Iam doing something wrong here..

- Scenario 3: Whenever i choose specific/multiple title in my dimension filter

Output Display in ListBox not in Table/GridLayout:

On startup i wrote: to get the selected titles description

var kpi1=ds_1.getMembers("Ydes", 20);

kpi1.foreach(func(element, index)) {

list.additem(kpi1.text);

}); // where in list box display all title desc/ rather selected title's desc..Iam doing something wrong here..

The final Output is:

Desc

Title1

Title2

Expected Output is:row after row filter selected titles and its desc from Bex query as attached.

Title1

Desc1

Title2

Desc2

.

.

.

.

Kindly guys throw some light on this possibly iam doing wrong in coding the list and looping it separately i guess rather everthing in one set of code but not sure i have todo at onstartup as well dimension filter on apply event or button load, i have to frame a format like the expected output with some space in description display..

Thanks,

Dinya.

Attachments