Question:
Hello,
I'm trying to ad the "Construct Database Statistics" in my process chains but I'm encountering some problems.
We have to load data into an Infocube via several process chains.
SAP BW3.10
1) I have created the Infopackages
2) I have included the load process in the process chains
3) The "delete index" and "create index" process are automatically created for each Process Chain
4) then I have to add manually the "Construct Database Statistics" :
Insert Construct Database Statistics --> Create a variant (= stat)
--> then I have to choose the execution of an Infopackage !!!
I don't understand , I thought that Construct Database Statistics would be added directly.
Do I have to create an Infopackage in the Technical Contents (BW
statistics ) and assign it in the Process Chain ?
Could you explain me how can i do that ?
Thank you very much for your help.
Regards.
Answer:
Hi,
Did You consider letting BRCONNNECT handle Your DB stat update?
Answer:
Hi,
riisberg : By BRCONNECT , do you mean using the "Check and update optimizer statistics" ?
I think it would be more recommanded, in order to optimize the query performance, to use the BW database statistics.
I would like to automatically recalculate the database statistics after each load in the Infocube.
In the process chain planning there is a standard process for building
database statistics. This calculates the statistics for all tables that
belong to an InfoCube or infopackage.
Is there anyone who could explain me how I can recalculate the statistics
by using the process chain ?
Answer:
Hi,
When I have to add such a process, I just go to Data targets, select my InfoCube and drag it into the process chain. Then the system asks which steps I want to include in the chain. Just select 'Construct Dbase stats', and everything should be fine.
Regards,
Frank
Answer:
Thank you Franck, it works.