cancel
Showing results for 
Search instead for 
Did you mean: 

Query based on ODS showing connection time out

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Thanks Buddy.

I cannot use background processing as it's a business requirement to see the report then and there.

Once i input my country as selection criteria i would be able to see the relevant data then.

That's my problem. Any other solution.

Ashok

Former Member
0 Kudos

Hi,

Then go for less selections and execute it , if you want all the data it will get through background only.

Regards

Pcrao.