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

Error with bex query in web

Good morning together,

i have trouble again with a BEx Query in our BW landscape.

I have created a query with a lot of key figures. When i call it in BEx (Excel) i get data; everything is ok.

But when i say, execute this query in web, or try to call the query in connection with a web template i get the error message "no data was found".

It is the same selection what i choose in the variable screen. How can i solve this error?

Thanks to all.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 22, 2011 at 08:53 AM

    Hi,

    Check in your Web Template definition for the Query it is binding with....?

    Use Generate Report button for your Query in RSRT t-code. It will refresh the Query from the Database level.

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 23, 2011 at 10:59 AM

    Hi ,

    Just check if any value is getting restricted on any of the characteristics. I mean check if any data level filter is getting assigned .

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      i have the solution.

      It defined a condition on a keyfigure which was not displayed. In Bex it was no problem to show the data. But the web view couldnt get by with this setting.

      Now i set this key figure to "Hide (can be shown" and it is workin fine.

      Thanks to all.

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.