Skip to Content
author's profile photo Former Member
Former Member

Query based on ODS showing connection time out

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2008 at 12:05 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2008 at 12:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 31, 2008 at 12:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.