Question:
Hi all,
I am checking, if it is possible to create a query on another query.
E.g.
BW data target has the following 4 records,
A; B; D; 1
A; B; E; 1
A; C; D; 1
A; C; E; -2
The query aggregates on the first two columns
A; B; 2
A;C; -1
Now i would like to run a query on this query result table with a 4th column as a calculated key fig (before aggr) as the absolute value of the 3rd column and a 5th column as the ratio 4th/3rd. This gives the following result
A; B; 2; 2; 1
A; C; -1; 1; -1
or aggregated on the 1st culumn
A; 1; 3; 3
So far the only solution I can think of is to create an extra ODS object to serve the query result and run the 2nd query on the ODS.
The other way that works is to create a pivot table in excel based on the 1st query result which is not so nice either. Also a virtual key figure would work. But the nicest solution was to run a query on a query.
What is your comments?
Thanks for any reply
Answer:
Hi, artshch
I have the same problem: would like to use the result of a BEx query (total amount of customers) in another BEx query, so that the client is able to estimate other ratios in terms of total number of clients.
Id est,
Total( ratio 1) / Total(customers).
where each total is calculated in different querys.
Is this possible or should I build another InfoProvider and run a third query on it?
Thanks.
Answer:
There is a way:
You can create and add a variable in the second query, with type 'replacement path'. As path you enter the first query.
Like that the second query uses only the output of the first query.
Although I'm not sure if that solves your problem as this solution is in fact merely a filter.
W.
Answer:
Hi,
Check the OSS Notes 847592, 560300, 776046, 379832, I think they will be usefull.
Kind Regards,
_________________
Elizabeth Sacknus
BW and SD analyst
Sao Paulo - Brasil
Answer:
Thanks, I will take a look.
We finally decided ourselves for a different way to make our report, but hope that will be useful next time!!