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

Results mismatch between query and web item

Posted on Jan 10, 2007 at 07:37 PM 12 Views

Hi SDN,

I have a query which produces 12 fiscal quarters for the last three years and the query is working when I run it by itself. The query is based upon a multiprovider.

I use this query as a DP for a checkbox web item. When I run the web-app, the web item (checkbox) generates a lot of values, far more than what the DP query by itself generates.

How is this possible? What is it that I am doing wrong?

Thanks.

Saf.

PS I always award points.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Bhanu Gupta
    Bhanu Gupta
    Posted on Jan 10, 2007 at 07:39 PM
    2

    Hi Saf,

    In the properties for the check box web item, what did you specify in Read Mode? I think you should use Posted Values here.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Arun Varadarajan
    Arun Varadarajan
    Posted on Jan 11, 2007 at 09:13 AM
    0

    Safdar,

    It could be that the web item is retreiving the values frm the master data .. as Bhanu has mentioned - there is a checkbox / dropdown for the properties of the web item for droipdown where you have to change it from master data to posted values or you can also set this in the BeX tab of the particular infoobject. That way it would fetch values from the transaction instead of fetching the same from master data.

    Arun

    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.