Repeating Prompt order in WebI

[former_member254926]

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.

[abdellatif_astito]

Hi Amar,

From what you describe, your prompts should have been be marged in WebI. The only additional criteria I am not sure you have mentioned, is the object type in universe:

Do the two objects, you are creating prompts on, have the same type ?  does the object created from the DB column(s), have the same object type as the object created from DT column(s).

Regards

Abdellatif

[former_member254926]

Hi Abdellatif ASTITO,

The data types are the same.

Warm Regards

Amar

[abdellatif_astito]

And what about the behavior in IDT when you run the same or similar query using Query Editor in IDT ? do you have the same behavior ?

[jyothirmayee_s]

Hi,

Did you check if repeating prompt order has different technical names or any spaces in the description?.

WebI doesn't merge if prompts has 2 different technical names coming from different sources.

Thanks,

Jothi

[former_member254926]

Hi

The report is from one Data source i.e. IDT universe.

Warm Regards

Amar

[jyothirmayee_s]

Hi,

And also one WebI query?. No merging of dimensions is it?.

What happens when you run Oracle query in backend though?.

Thanks,

Jothi

[former_member254926]

Hi Experts

Did anyone got the work around...Please help on this.

Warm Regards

Amar

[Former Member]

Hi,

Can you try pushing prompt itself in DT creation ,by using @Variable?

Thanks,

Guna

[former_member254926]

Hi Guna,

I tried with this no luck..

Warm Regards

Amar

[Former Member]

Hi Amarnatha,

Can u please send the screen shots of the issue and prompts of DT and DB?

Thanks,

Guna

[former_member254926]

Hi

Please find the screenshot  .

Warm Regards

Amar

[Former Member]

Hi,

If I correctly understood your problem---

1.You have created 4 prompts in IDT ?

2.If its true you have pulled all 4 prompts into the report and expecting one prompt?

In the above scenario we have to use &Variable("Prompt text which wanted one time") in 3 other places.

Steps:

1.Create one @prompt .

2.Create @variable for remaining 3 prompts.

Problem you will face is placing @variable in DT and DB.

Let me know if I provided some hint.

Thanks,

Guna

[former_member254926]

Hi Guna,

1.You have created 4 prompts in IDT ? -- No

2. Two Prompts are crated at IDT that are mandatory (start date and end date), rest two are crated at WebI level with same name.

As I can use @Variable only for mandatory prompt reference. This also been tried too... before posting this concern.

Even rest of two optional prompts pushed to IDT  also facing same issue when I refresh the report.

if you try try create one sample DT in IDT and try this process you will land into the same situation,but you should be in SAP 4.1 SP3 (server and Client)

Warm Regards

Aamr

[former_member198611]

Hi,

I have few questions

Are you using UDT or IDT? because UDT does not supports multiple databases.

Are you getting expected output if you are able to select from two input prompts parameters?OR if you are getting getting any error msg? if so, could u plz share error msg?

Regards,

Bansi

[former_member254926]

Hi

Yes... I too agree that UDT not supports multiple DBs.

Currently using IDT.

Created one Derived Table in IDT and used Database tables in IDT

Using Derived table columns in Dataprovider1 and Data Base table columns in Dataprovider2 from one universe which is crated in IDT.

When I create one Prompt in DP1 and the same type of prompt in DP2 then it is asking for two prompts I/P when I refresh the report; Name of the prompt in two DPs is same along with it’s operands and properties. But the same name prompt getting repeated in WEBI when refresh the report.

Warm Regards

Amar

[former_member254926]

Hi Experts

Please help on this.

Warm Regards

Amar