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

Query not showing any results - Urgent

Hi all,

I am running a query on the project dates (0PS_C05), although there is data in the cube , the query says no applicable data found, although there is no filter for the object ( Origin - 0DATE_SRCE ) in the query definition , but when the query is run , It is shown as filtered by value 1, can there be any hidden filters.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 09:15 AM

    Hi,

    possibly there are some restricted keyfigures or conditions on that field. Check this out.

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 09:41 AM

    Addition to thier checks..

    please check if you have any aggregate on top of this..which is not yet rolledup...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 03, 2005 at 09:51 AM

    Shiva ,

    Also check if the reporting status for the request is active . And is this a business content query or something you defined.

    Check the query in RSRT and you will find the results / data being accessed.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 10:15 AM

    Hi,

    Another way to check is to create a copy of the query. Now on the copied version, simply remove the keyfigures/chars one by one as you execute the query.

    One way or the other, you will see the culprit filter in your query...

    If helpful, please grant points...

    Regards,

    --Jkyle

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 10:15 AM

    Thank you all for your answers.

    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.