BEx query in the dashboard

[Former Member]

Hi,

I need to use a Bex query in the dashboard.

The bex query is created above the infocube.

The Infocube contains one year data.

i.e it contains 365 records and they are date wise (from 1-jan-2011 till 31st-dec-2011)

The bex query has one input variable Zcalday(interval type). It is created over the infoobject calday.

User has to enter the value for the variable Zcalday, after which the output of the report would be

****************************************

calday  number_of_employees_joined

*****************************************

now coming to the dashboard. In the dashboard, i want the user to input "from date" and "to date". This value must be passed to my variable in the BEx query and the result rows must be presented in the dashboard via the components of the dashboard (listview, charts etc).

Is this possible gurus?

I am using dashboard designer SP4(including FP3) and my edge server is also at the same level SP4(including FP3).

[former_member184839 · Accepted solution]

Hi Raghavendraprasad,

It can be done,

1.Create the Bex query, in the query designer, create a variable , assign interval mandatory characteristic  to the variable. go to query properties and change result rows property to "always show". Save query.

2.Go to dashboard design  , Add this query through the Sap NW connection  , bind the cross tab data to some range (this ll be your output)

3. Write the labels(user selection) in a column suppose the below are the labels.

1999

2000

2001

2002

2003

4.Take two combo boxes make it as the labels. let the destination to the first combo box be cell "a1"

and for the second be "a2" . now the cell "c2" enter the concatenation formula. viz. c2= concatenate ( a1 , " - " , a2 ), make sure you leave spaces before and after the hyphen(-). else it ll show you an error.

5. Now this ll be the trigger cell of the query . Click on the refresh on when the value changes, n link the formula cell i.e "C2".Link the variable input too to this cell"c2".

Put a list view or Scorecard component to view the output.

Save this, Publish the dashboard ,and launch it.

Thanks And Regards,

Sara G

[Former Member · Accepted solution]

Dear Sara,

I have a bex query with mandatory variable on Cal.Year then how to assigning these variable to spred sheet by using SAP Netweaver connection .if make any formula that particular cell at spred sheet level .plz can u explaine me.

Thanks,

Venkat.

[former_member192430]

Hi Raghavendra,

Try this:

1. Use BICS(sap nw bw connection), identify your query and map it as Sara has told you above.

2. Once you have done that you'll see in the input section of the data connection there is a variable drop-down where you can find an option for Zcalday from and Zcalday to.

3. You can map these variables in the excel sheet and let the values there be populated by the user using calender function in the dashboard.[You might find that the format of the calendar and the input format for the query input might not match for that you can right click on that excel cell and format it into the required format so that the query accepts it.]

4. To refresh the query you can use a data connection refresh button which the users need to click on when they have put in the requisite values into the dashboard.

Abhishek

You're only given a little spark of madness. You mustn't lose it.

[Former Member]

Can i have any updates gurus?

[Former Member]

Dear Gurus, any updates from your end ? please..

[Former Member]

Hi Raghavendra,

Yes it is possible.

You can go with BICS(sap nw bw connection) and pass the user selection to the bex query.

you can also use "add query" option which is the new option provided in FP3 and connect to BEx.

Thanks,

Raj

[Former Member]

I find the "add query" option to be more helpful.

Is there any difference between the "add query" & the "SAP NW BW connection"?

[Former Member]

Query Browser ("add query") : publish to BOE and It can use Hierarchy table(FP3 New function)...

SAP NW BW connection : publish to EP ( Enterprise Portal )...

[former_member184839]

Hi Raghavendraprasad,

Go to Dashboard Design

Data-> Data Manager ->SAP Net Weaver BW connection-> Add the BEx query(through browse query) . That's how it is usually done.

Thanks And Regards,

Sara G

[Former Member]

Dear  Sara,

bex  variable user entry default values how to pass in dashboard level .can you post report with detailed explanation

Regards,

Venkat.