Skip to Content
0
Jul 25, 2016 at 04:05 PM

BEx Input Query Designer

49 Views

Hello BEx Experts,

Our Input Query does not work. The idea of this query is to correct manually the data, which was wrongly added into our BW. For this, we have a Multiprovider and an (Complex) Aggregation Level. The Cube, which we want to save the corrected data by Input Query, is set up as Real Time. The respective fields are set as input ready in the Query Designer.

Just as an example, we would like to have a Input query, which enables changing either the Amount and the Project.

Project Amount A 100 B 200

Our questions are:

1) We would like to have a Input Query to change the Key Figures and Characteristics, showing in a dropdown list, where the user could choose, according to the master data. Is it actually possible to change the characteristics in the input query, as well?

2) Is it necessary to have a Planning function for that or a BEx Input is already enough?

3) Could you help us to find where is the problem?

Many thanks in advance,

Luiz Fiuza