Question:
Hello all,
It is related to BW3.1C on Oracle and UNIX.
If we run the query in Execute + Debug mode in RSRT, we can find that wheather Aggregate was used. It even tells the name of Aggregate used.
I was asked in an interview that what will you do if you do not have authorization to run any of the query transaction except RRMX. Then Later he hinted me that what about BW Stayiscs report.
Well I have used BW Statistics report for query performance but never used for this purpose.
Does anybody have anyidea about how to find wheather aggregate was used with the help BW Statistics report?
Please let me know if anybody know about it.
I will appreciate your help.
AkolaD
Answer:
0BWTC_C04
But, if you don't have any other Transaction than RRMX, what's the interest of the question ?
I would say : in this case, I don't want to hear anything about aggreggates, if I don't have Aggreggate analysis tools.
Or :
And what if statistics are not activated ?
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Thank you.
Well It is already said that Statistics are activated.
Please let me knwo if it is possible to find wheather aggregate are used.
Thank you.
AD
Answer:
if you are not given authorization to basic transactions like RSRT then it is important to inform the project manager that the basis team is a bunch of worthless nazis. if it were me, i would tell the interviewer that i don't work with companies that have their heads up their ... then hang up (or walk out). but thats me, i try to live in the real world.