on 10-31-2008 12:00 PM
Hi,
I have a query based on an ODS. The selection criteria for the query is Country which is a navigational attribute of the ODS. When i exceute the query using a country with lesser volume of data the query runs fine. But when i choose a country that has more number of records the query shows 500 connection timeout error sometimes and sometimes it runs fine for the same country.
I tried to execute the report using country as input variable - First i executed the report using a country with lesser volume of data it worked fine as usual and then i added another country with larger volume of data in the filter criteria and the old problem cropped up.
Could you please suggest a solution?
Appreciate your response.
Thanks
Ashok
Thanks Ajit.
Also Thanks to PCRao.
Ajit, i think whatever you are saying makes sense to me. I have only few thousand records in my ODS but now due to some requirements i had to change the ODS to carry some more info. Due to that the size has grown to a million records.
I will try to evaluate pros and cons then will go ahead.
Appreciate your response.
Ashok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Its not recommneded to have a query on DSO which gives huge amount of data as output.
For small amount it should not be a problem.
Shift your queries to a multicube as recommended by SAP and build the multicube over the cube which loads from the DSO.
SAP recommends to create queries only on multiproviders.
If not possible then you can try to create indexes on DSO on the characteristics field which are used in filter and global selections in the query.This can improve the query performace.
But this will create performance issue while loading data to the DSO.
So you need to do a trade off.
Thanks
Ajeet
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Execute it in Background. it will come.For more selections in front end execution ,some times you may get like that messages. better way is execute it in background with your required selections.
Regards
Pcrao.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.