Question:
Hi all ,
query 1 :
JAN FEB MAR
No. of orders 30 40 50
---------------------------------------------
Query 2 :
JAN FEB MAR
No. of orders 60 120 200
---------------------------------------------
Query 3 : should contain query2/query1
JAN FEB MAR
% orders .5 .33 .25
.5 = 30/60 .33 = 40/120 .25 = 50/200
is this possible to calculate a query based on results of other queries
Answer:
its possible using query variables... (query within another query)
Answer:
not easily. the response about query variables (either result set or value set) won't work because they only returns master data values not key figure values.
it is a bit difficult to answer you question completely since you do not tell the source of the first 2 queries. if they are form 2 different infoproviders it would probably work by creating a multiprovider and used the provider name in a RKF to distinguish the different orders (then create a CKF to get the percent). if they are in the same provider with different data slices create RKFs with those slices followed by the CKF for the percent; or if the slice is too difficult you might investigate combining the values in the cell editor.
2 final solutions, if you have to get it as the result of 2 queries you could create feeds from both of the queries into a transactional ODS in the analysis process designer (which allows you to carry over the key figures). then query from that datastore (toggle it to a standard ODS). or you can send the results of the queries to tables using RSCRM_BAPI build extractors against those files; read them into a new infoprovider and query against that. i don't really reccomend this alternative unless you are paid by the hour.