Question:
Hi folks
I have a set of 20 queries which I need to test... most of the queries have an overlap in terms of what columns are displayed...now for the first pass of testing I would like to select 5 queries.
I came up with following criteria for selection
Where maximum RKF's and CKF's is used - this will help us to identify if we need and Virtual CKF's or any aggregates for the cube(except for multicube)
Use of Exception and Conditions -
Use of different hierarchies
Use of different variables which was developed as a part of requirement for that query
Any queries using RRI
Can I see all the above technical information in a table for a query or will it be advisable to go into each query and note the above figures so that I can identify a good subset of queries for initial testing
any thoughts
regards
Poonam
Answer:
I was able to identify the following from RSRV <Technical information>
What hierarechies are used,
number of Local RKF's (but cannot find the names)
No of variables(but cannot find the names)
regards
Phemarjani