Skip to Content

How the Drill down functionality works if the source is Bex Query

Dear All,

How the Drill down functionality works if the source is Bex Query through the query browser in Dashboard 4.1

Please let me know process.

Thanks

Regards,

Sai

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jun 10, 2014 at 05:15 AM

    Hi sai,

    Drill down can be done by two ways.

    1. you need to bring all the data in one shot to the spreadsheet and then by using the components you can achieve it. Below given link explains in detailed about that.

    Filtering Through Combo Box

    2. you can use different set of query to pass the value from one set to another to fetch the data using the prompt. please check the below which explain them.

    Difference between "When value Becomes & When value Changes"

    Revert any clarification required on this. 😊

    --SumanT

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 10, 2014 at 05:07 AM

    Hi SaiRam,

    In Dashboards especially when data is coming from BeX queries we can drill the data in 2 ways

    1) Based on the Navigation paths defined at BW level, through the Hierarchy component available in Dashboards 4. It looks like a spreadsheet component.

    2) Based the no.of drilldowns we have to take the queries for example if we have 3 levels then we have to take 3 queries. Lets take an example of Yr >> Qtr>> Mnth.

    Here Selection of Year should be prompt value for the Qtr and Selection of Year and Qtr should be a prompt value for month.

    In this scenario we have to design the queries in the query browser.

    Let me know if you need any other information.

    Regards,

    Anjani Kumar C.A.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 09, 2014 at 11:37 PM

    Hi Sai,

    If you are connecting to BEx via query browser, you would need to create separate queries. First query would bring more aggregated data. When user drill down based on certain parameter, second query should refresh that would bring in more detailed data.

    The selection from Query 1 should be passed as filter value for Query 2, and trigger should be applied on Query 2 so that when the user makes any selection Query 2 should refresh.

    Let me know if you need more help on this.

    Regards,

    Niraj.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 10, 2014 at 09:48 AM

    Dear All,

    Thanks for your prompt response.

    In my scenario I have a pie chart and Column chart.Base on the selection in pie chart the column chart would be reflects. But source for this dashboard is Bex query and the version of BO BI 4.1.

    Please suggest me the suitable solution to overcome the issue.

    Thanks

    Regards,

    Sai

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.