Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Repeating Prompt order in WebI

Hi Team

SAP BusinessObjects
Version: 4.1 SP3
Oracle Version: 11
Number of Dataproviders for report: 6
3DPs are from Derived tables from same universe

When I use Derived Table's Objects by taking as a one of the Data Provider and Other objects from Database as another Data provider

Pulled necessary Objects into condition pane with Optional prompts in DPs(one from DT and DB) with same Name, operator and properties.

If I run the report the order getting repeated even though I followed below points

The below mandatory options are set to make the single prompt across the DPs when using same name of the prompt input.
1)Prompt Text should be same across DPs (without any extra spaces)
2)Operand should be same across DPs
3)Prompt Options should be Same

I thoroughly tested the prompt text, applied same conditions and options, all are same. still facing the same.

I tested with following options of using Data Provides

Scenario 1 --- No Issue

Data Provider 1 : Derived Table(DT) Columns

Data Provider 2  :  Derived Table(DT) Columns

Using the Same Name Prompt in two DPs with same column type

Status of running the report with single Input Parameter

Scenario 2 --- No Issue

Data Provider 1 : DB Columns

Data Provider 2  :  DB Columns

Using the Same Name Prompt in two DPs with same column type

Status of refreshing the report with single Input Parameter

Scenario 3 -- Issue

Data Provider 1 : DB Columns

Data Provider 2  :  DT Columns

Using the Same Name Prompt in two DPs with same column type

Status of refreshing the report with TWO Input Parameters

Use the data providers with DB (Database) table columns with same condition are working fine,

However the problem is when using DT (Derived Table) and DB(database) columns with prompt conditions then then giving two input parameters for i/p

I'm not able to find the solution for repeated prompt order.
Please help on this.

Tags:
Not what you were looking for? View more on this topic or Ask a question