I have created one webi report based on the BEx query and in the webi report i have used two webi query based on the single BEx query.
When i insert same Object in the Query filter of both webi queries with same prompt definition it is coming twice in the prompt list.Ideally it should be come as once as object and prompt definition is same.
Same case when Profit center hierarchy is as prompt in the BEx query.if i create webi report based on the two webi query on single BEx query.again Profit center hierarchy is prompting twice in the prompts instead of single time.
Bo Version : BI 4.0 SP02 Patch 11
Any one faced this issue in the webi via BICS connection.