i run the query on multiprover, which are based on 3 ods 2005, 2006, 2007, and also based on employe and employe subgroup characteristic, that query does not given any response after 6h runing.
The first question to ask I think is how many records are in this ODS? 6h could be reasonable, or it could be awful. WIthout knowing data volumes, what you are selecting, and what indexes exist, there is no way to know.
Can you use SM50 to see if you have the queries are actually running?
If the result set is large (more than 30,000 rows I believe is what the system considers large in this case)? MultiProvider queries are normally, unless configured not to, going to start in parallel. So it is probably starting to run a query for 2005, another for 2006, and another for 2007. If these quereis begin to return too much data, the BW cancels all three queries, the begins to execute them sequentially.
So I think you need to do a little leg work in order to get much help beyond guesses.
Have you reviewed teh Explain Plan? That should tell you a lot. If you are not familiar with an Explain Plan, ask your DBA to review it. It provides a lot of information on how the DB intends to execute the query.
i used one characteristic employee subgroup, when i right click on chara. and than click on restirc,it is taking loag time and given not responding error, i
I dont think you have indexed on the chars that you are passing as variables to the ODS's. So indentify the chars and create indexes appropriately on the ODS's in question. And make sure the result set is small. Cant you run the same query on a cube which would have data of the underlying ODS's even though with less granularity and further do RRI to the ODS for line items.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.