Skip to Content

Prompts as Dataproviders


I am trying to change data source for Webi Reports using Prompts. I have Multiple dataproviders in my webi report eg: Universes, Bex, excel..

. How can i create the prompt in webi for dataproviders.

. Can we do both in Input Controls and/ in scheduling prompt as iam going to schdule the reports.

. When user selects dataproviders where universe1 then I am expecting universe1 table block in the report similarly if user selects universe2 then I am expecting universe2 table block in the report Similarly when user selects Bex Query then I am expecting bex query table block in the report etc..

Can anybody help me with an sample or snapshots.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 13, 2015 at 10:48 AM


    If prompts are different in the webi report for all data providers then you can hide the specific tables in the webi report when they are blank.

    Right click on the table and checked the option "Hide when empty".With this if user will enter the prompt value for universe1 prompt then only table from universe1 display.other will be hidden.if user will select the prompt values from two universes then two tables will display.or based on the requirement you can do the conditional hiding also.


    Untitled.png (31.9 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      If this is required for reconciliation only then create one DF and even can keep separate tables without joins. one business layer and separate class for each view or database.this is based on assumption only some technical people will develop the reports on this universe and not going to be use for other reporting.

      instead of doing everything in one tab only ,create separate tab for one one oracle new objects and one for existing one or display data like this.

      source(Oracle(New)) and targets(Oracle(Existing view) 1 (One tab)

      source(Oracle(New)) and targets(Oracle(Existing view) 2 (One tab)

      source(Oracle(New)) and targets MSSQL,1 (one tab)


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.