Hi,
I have created a custome infocube in which I hace created some update rule routines.There around six Routines in the cube.
All these routines have Some "select single" statements to read one field from our custom Ztables which i have created in the Bi server.
But When I run the extractor for the cube,While updating the rules The process takes lot of time and it gives a Time_out dump.Also I checked in Sm50 while the process was on that all the update routines which I had written were running in Dialog Mode.So the maximum time limit for a dialog mode program is 600 sec in our system.
So these are my questions below for the above Problem
1.Why the Update routines run in Dialog mode since the shdules of the extarction is in Background
2.Would the select single statement hampers the Performance of an update routine.If yes then what should be the best solution to read the dat from the ZTABLES.
Please help me on these questions.
Thanks
Umang