Skip to Content
author's profile photo Former Member
Former Member

Dashboard Designer 4.0 with Bex Query.

Hello..

I Am using the following as follows:

(1). Dashboard Designer 4.0.

(2). Created the Query by using the Olap Connection of Bex Query.

Data Source: Bex Query Directly (not the Spread Sheet Data).

Please let me know the Following as follows:

a). For any component to be used on the Canvas, for the Data Insertion we have the 2 Options:

i). Source (we have the Spread sheet to invoke), But I can map the data to this source from the Bex Query.

ii). Destination (we have the Spread sheet mapping and Query Data).

For Example:

I had used the Pie Chart,to retrieve the Data Values on it we had the following ways only:

a). Data --> Values --> Data in Columns.

Column Chart:

For the Data Insertion, the position of value can be taken from the Excel as the "source data".But there is no option of choosing the Query Data.How I can able to map the data to source and map to Destination by using the Bex Query as the Data Source.

Please let me know..

Thanks in Advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 04, 2013 at 04:41 PM

    While the Query Panel component is convenient for quick uses, it has some drawbacks.

    For scenarios, such as yours where the Query Panel data is not an option for properties such as Source Data for Data Insertion, you may have better luck by placing the BEx Query resultset that acts as the Source Data into a contiguous Excel Range using one of the Data Connection methods versus the Query Panel component. Since the data then is in the intermediary Excel layer, you will be able to bind the source data to that range accordingly.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thats what I explained.

      You can bind the trigger cell only to a spreadsheet cell. So you must have the a value changing for the query to refresh with each new selection. Usually the same value is used as the prompt to trigger the query.

      There is no other way of triggering the query.

      You may be able to bind the display components like charts/scorecard only to query as long as you are not drill down on them.

      Runali

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.