cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query without Measures

former_member402770
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Dinya,

First of all why do you give "" in LISTBOX_1.getSelectedValue("") ?

Can you provide me a clear picture (preferably with some screenshots) of the exact requirements.

Regards,

Fazith Ali Z

former_member402770
Participant
0 Kudos

Hi Mohammad,

   I have forgot to comment the  LISTBOX_1.getSelectedValue("") . Pls ignore that...


But hope you understood the scenarios, ok iam repeating anyway, i have two characteristic variable list in my bex query named Ytext1, Ytext2 in rows. Each holds 60 characters of text length, i want to concatenate both columns in Design Studio

For this tried looping the characteristics variable list separately like below

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

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

     list.additem(kpi1.text);

    });

var kpi2=ds_1.getMembers("Ytext2", 20);

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

     list.additem(kpi2.text);

    });

.

which display in list box with both Ytext1 row list and Ytext2 row list. But i want this text to be concatenated and show like eg: text1+text2 = text1text2.

How do i make in one arraylist loop and concatenate the both rowlist.to show as one texts like below expected output..

Ytext1   Ytext2           Expected Output

a           b             =>  ab

c           d            =>   cd

e            f            =>   ef

Hope i have made as simple as i can  for everybody to understand and provide me an ways of solution..

Thanks,

Dinya

Former Member
0 Kudos

Hi Dinya,

You should write a loop within a loop to make it work, instead of  the line gives,

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

var kpi2=ds_1.getMembers("Ytext2", 20);



     kpi1.foreach(func(element, indexa))

{

    kpi2.foreach(func(element, indexb)) {

if(indexa==indexb)

{

     list.additem(kpi1.text+kpi2.text);

}   });

});

Regards,

Fazith Ali Z

former_member402770
Participant
0 Kudos

Hi Fazith,

   It works but i was trying to get to format like my first post which i was looking for like below in List Box:

Title1

  text1text2   <= script code as you provide above placed in title dimension filter concats as expected

Title2

  text3text4

.

.

Here above Title is my dimension filter which can be an All scenario or Multiple Selection scenario based on this, Title displayed dynamically in List Box for Titles Selected specific concatenated texts as row by row display.

The final Output after filtering Title1 and Title2 in my dimension filter.

Title1

Title2

text1text2

text3text4

Thanks,

Dinya

.

.

Former Member
0 Kudos

Hi Dinya,

I am still not able to clearly get the what you are trying to acheive here.

Can you put an image of what you are trying to acheive?

What is the target Component of the list?

Regards,

Fazith Ali Z

former_member402770
Participant
0 Kudos

Hi Fazith,

  Ok. I share the image possibly some time later..

Bex Query:

i have two characteristic variable list in my bex query named Ytext1, Ytext2 and one Title Characteristics in rows.

Let me brief what was expected:

Dimension Filter I have named "Title". So whenever I select multiple items like Title1 and Title2 in Title Dimension Filter, I have to show the below

In List Box which is my output Component is currently displaying like below:

Title1

Title2

text1text2

text3text4

Expected Output like below format:

Title1

  text1text2   <= script code as you provide above placed in Title dimension filter works fine

Title2

  text3text4  <= script code as you provide above placed in Title dimension filter works fine

Hope it is understandable..i shall share the image some time later..

Thanks,

Dinya.

Former Member
0 Kudos

So this Text1 and Text 2 are activated when you select Title right?

Try something like this then

Title=DROPDOWN_1.getSelectedMember();

list.additem(Title,Title);

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

var kpi2=ds_1.getMembers("Ytext2", 20);



     kpi1.foreach(func(element, indexa))

{

    kpi2.foreach(func(element, indexb)) {

if(indexa==indexb)

{

     list.additem(kpi1.text+kpi2.text);

}   });

});

This should work,

let me know if you have doubt

Regards,

Fazith Ali Z

former_member402770
Participant
0 Kudos


Fazith,

My output:

Title1

Title2

text1text2

text3text4

Expected Output like below format:

Title1

  text1text2   <= script code as you provide above placed in Title dimension filter works fine

Title2

  text3text4  <= script code as you provide above placed in Title dimension filter works fine

Thanks,

Dinya

Former Member
0 Kudos

Try this code,

Title=DROPDOWN_1.getSelectedMember();

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

var kpi2=ds_1.getMembers("Ytext2", 20);



     kpi1.foreach(func(element, indexa))

{

    kpi2.foreach(func(element, indexb)) {

if(indexa==indexb)

{

list.additem(Title,Title);

     list.additem(kpi1.text+kpi2.text);

}   });

});

former_member402770
Participant
0 Kudos

Hi Fazith,

Tried below code as iam using dimension filter for Title as mentioned above

vTitle = DS_1.getFilterExt("YTitle"); // Iam using Dimension Filter not dropdown.

My Output is:

  Title1;Title2

Expected Output like below format:

Title1

  text1text2   <= script code as you provide above placed in Title dimension filter works fine

Title2

  text3text4  <= script code as you provide above placed in Title dimension filter works fine

Thanks,

Dinya.

Former Member
0 Kudos

Instead of this,

Title=DROPDOWN_1.getSelectedMember();

Try this in the above code

Title = DS_1.getFilterExt("YTitle");

former_member402770
Participant
0 Kudos

Fazith,




Your code on Ytext1, Ytext2 concatenation is working good...


Bex Query:

i have two characteristic variable list in my bex query named Ytext1, Ytext2 and one Title Characteristics in rows.

Filter Panel:

Only one selection as Dimension Filter named Title which have items like Title1, Title2..

Wrote like In Dimension Filter above On Apply Event below:

vTitle = DS_1.getFilterExt("YTitle"); // Iam using Dimension Filter not dropdown.

 

My Output in List Box Output Component is:

 

  Title1;Title2

 

 

Expected Output like below format:

Title1

  text1text2  

Title2

  text3text4

Hope u got what i wanted the above is my expected output in List Box.

Thanks,

Dinya

former_member402770
Participant
0 Kudos

Hi All,

  Hope everyone understand the expected my above posts and what i tried so far with help and support.

  Attaching the image.

Here Target Component is List Box.

Title1 is Plug-in Content under that some texts say text 1 and Title 2 Extension/extension Point Content under that text2.

Bex Query:

i have two characteristic variable list in my bex query named Ytext1, Ytext2 and one Title Characteristics in rows.

Filter Panel:

Only one selection as Dimension Filter named Title which have items like Title1, Title2..

Wrote like In Dimension Filter above On Apply Event below:

vTitle = DS_1.getFilterExt("YTitle"); // Iam using Dimension Filter not dropdown.

 

My Output in List Box Output Component Currently is:

 

  Title1;Title2  // Member Array

 

 

Expected Output like below format: // Shown in image for your reference

Title1

  text1text2  

Title2

  text3text4

Thanks,

Dinya.

former_member402770
Participant
0 Kudos

Any ideas?

Thanks,

- Dinya.

IngoH
Active Contributor
0 Kudos

Hello Dinya,

it is not very clear on what you are trying to achieve here so I would suggest you describe:

- the BEx query with screenshots

- the BEx variables with screenshots

- your dashboard with screenshots

and in more details what you are trying to achieve and which values you are trying to show where and when.

regards

Ingo Hilgefort

TammyPowlas
Active Contributor
0 Kudos

In addition to what Ingo said, this thread is showing as being answered.

So please create a new discussion and include more details as Ingo suggested.

Answers (0)