Skip to Content
avatar image
Former Member

BEx query in the dashboard

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 17, 2012 at 10:23 AM

    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.

    19992000200120022003

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • avatar image
    Former Member
    Jul 16, 2012 at 04:19 PM

    Can i have any updates gurus?

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 21, 2012 at 04:52 AM

    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. 😊

    Add comment
    10|10000 characters needed characters exceeded