Skip to Content

Prompts as Dataproviders

Hi,

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.

Thanks

Dinya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

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

    Hi,

    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.

    Amit

    Add 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 each.like 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)


      Amit