Query Execution during Data Loads (extarction)

[Shamscharma]

I think BI 7.0 permitts that but I would still like to confirm from Gurus.

Can we/users continue to access data or execute queries while extraction is going on?? Can we load data during query execution?

What are the pros and cons of doing that??

Always appreciative of your help.

Suresh

[Former Member · Accepted solution]

You can do that very well. But it will not show the data which is being loaded and that will be shown only after the request is green and avilable for reporting. Remaining data from other requests which are ready for reporting will feed data to the queries.

[Former Member]

Hi,

Query execution will not really hamper data loading or vice versa. But freshly loaded data would not be available for reporting before it gets activated in the infoprovider. Also in case of a cube, if the 'delete overlapping requests' step is to be performed, there could be erroneous looking data in the report till the time this step runs - that is, between the time when the new load has come in and the old request is deleted. That is why loads are best scheduled when users are not working on the system.

[Shamscharma]

Thanks both of you!

Points given.