cancel
Showing results for 
Search instead for 
Did you mean: 

Merge prompts - BEx Query + ODBC Universe

Former Member
0 Kudos

Hi,

I working on a webi-report containing a set of different BEx-Queries (BICS Connection) and a query based on an universe (Excel / ODBC-Connection).

While BEx-Query prompts merge easily - this doesn't apply to the universe parameters.

I do have 2 prompts - one for year and one for month, both, bex-query and universe-query parameters are named the same and are of equal type.

Any idea what to do? I don't want the user to ask 2 times for month and 2 times for year.

Thanks!

Christian

p.s. BW 7 / BI 4 SP04 Patch 5

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Advisor
Advisor

Hello Chistian,

you can not merge variables / prompts from the BICS connection with prompts from the Universe.

regards

Ingo Hilgefort, SAP

Former Member
0 Kudos

Hello Ingo,

thank you for your input. Will this be a feature in future releases?

I used the mix of BICS  + Universe to combine BEx-Query with comments.

regards,

Christian

IngoH
Advisor
0 Kudos

Hello Christian,

to my knowledge that is not on the feature list yet. Best would be to add it to the Semantic Layer and Web Intelligence area in IdeaPlace.

regards

Ingo Hilgefort, SAP

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Christian,

Please let me know if you have got a solution/work around for the prompt issue... I'm in a similar situation now - prompts appearing twice(from Bex and universe)..As far i know there is no way to merge them like the Bex prompts...

Thanks,

A.Zacharia Chacko

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Prompts with differernt technical names cannot be merged in WebI and I don't see any work around for that.

What is your universe based on?. BEx or ODBC datasources?.

Thanks,

Jothi

Former Member
0 Kudos

Hi Jothi,

Thanks for the response..

My report is a union of two different datasources..One source uses BICS connection to connect to the Bex Query and the second query is on universe connecting to SQL server database/ ODBC..

They both have common filters and i dont want the prompts to appear twice to the end user instead, i would like it to be merged into one and when the query is triggered it should pass the prompt value to the respective query/data federator and fetch back the desired results....

Just checking - how reliable is the option "Result of another query (ALL)" ...? I was thinking of passing the o/p of one query to the other it instead of prompting it twice to users...

Thanks,

Anil Zacharia Chacko.

Message was edited by: Anil Chacko

Former Member
0 Kudos

Hi Arun,

I was able to merge or combine prompts from Universe created on Bex and Universe created on Excel where as was unable to combine with query created on Bex and query created on Excel Universe.

I think its something specific to BICS queries not being able to combine with other types if queries.

Please use the universe layer on top of BEx and try, it should work.

Thanks

Mallik

Former Member
0 Kudos

Hi Mallikarjun,

We dont have an option to create universes on Bex queries...We are in BOBJ 4.0 SP06...4.0 doesnot support creating universes on Bex queries..

Thanks,

Anil Zacharia Chacko.

Former Member
0 Kudos

Hi Anil,

You can create universes on Bex using Universe design tool even with BO 4.0 SP6, you cannot do it through IDT only.

Thanks

Mallik

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

You cannot merge prompts from BICS and Universe 'coz of different technical names.

There is no such work around other than dumping the data into excel and creating filters on query level in webI.

Thanks,

Jothi

Former Member
0 Kudos

Hi,

Check whether you have Merged Dimensions and the data type of the objects are same

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

Did you tried "Extended Merged Dimensions" under Document properties and also try the "Merge" opetion from the toolbar.

Thanks,

Jothi