Need ideas please. iView to show input parameters to BEx query.

[Former Member]

EP6 SP2...

I need an iView that will show entry fields for the input parameters to a BEx query*.

Right now, we have 14 reports.

They all have the same input parameters.

So, I could hardcode the entry fields(but not values) in a JAVA iview.

But, is there a way to query the properties of the BEx query to return what the input parameters are?

I am trying to plan for the future, when - maybe - a BEx query has different input parms than what all of the reports have now.

*I am sure there is a snazzy interface to a BEx query already, but... The end solution is presenting the reports using Crystal Reports, not BW/BEx, etc.

Therefore, I need this parameter entry iview to set the values selected to the EPCM so that another iview (which calls the crystal report *.csp page) can grab these values (and call the report).

Maybe a little confusing, eh???

[IngoH]

Hi Eric,

what was the missing part in the parameter UI ?

We are always interested in enhancements of the product.

Ingo Hilgefort

SAP Program Manager

Business Objects

eMail : Ingo.Hilgefort@businessobjects.com

[IngoH]

Hi Eric,

when I understood you correct you want to have a common parameter UI for a couple of Crystal Reports and depending on the report you want to be able to choose the values ?

You could easily start on the Crystal Enterprise SDK side without the need to ask for a list of variables for a specific query.

Perhaps I got it wrong - if so - perhaps you can explain a little bit more and I am more than happy to help

Ingo Hilgefort

Business Objects

[Former Member]

Ingo -

Thanks for replying.

We have solved this problem.

The problem was that the parameter entry screen in Crystal Enterprise just did not fill our requirements.

We have built our own with a java iview.

[athavanraja]

Hi,

You can use the following BAPI to get the query variables.

BAPI_MDPROVIDER_GET_VARIABLES

pass the cube_name parameter value as

<cubename>/<queryname> and this BAPI will return the variables of this query.

Regards

Raja

[Former Member]

Raja -

Thanks, I will take a look at this BAPI.

However, as I understand it, more than one query can be run against a cube. Will the BAPI return ALL the parameters for ALL the queries?

Thanks

[athavanraja]

Yes more than one query can be run against a cube.

This BAPI will return parameters for each query you pass it as input.

If this has answered your question, please mark this thread as answered.

Regards

Raja