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

Previous revision

We need a report to show the quantities for the current Purchase Order (PO), and the quantities for the previous revision. This way we can see at a glance how the quantities have changed.

You can see a screen shot at the foot of this page

which should hopefully make things a bit clearer. What I need to end up with is the data in the red rectangle. This shows the data for the current revision (3) of the PO, but it also shows the quantities for each of these items from the previous PO revision (2).

I can't see how I can get WEBi to look at data from the previous revision. I can hard code it to look at revision 2, but I need this to be dynamic as the current PO revision could be anything

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 14, 2008 at 10:24 AM

    may be the previous PO has items more than or less than or different than the current one,

    so you need only to compare the itmes exist in the current one,

    why not you make a view at the universe level to handle this.

    and it will all dynamic,

    you can see this post, maybe its similar to yours

    Year Handle

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

    • the best way to perform you issue is to create a view or alias from the PO table in the unviserse and put it in some context in the universe

      so when you inquiry the PO from the Webi it can give you automatically the Previous PO with the same item in the Current one and also you can calculate the variance and the growth of the Itmes between the 2 POs

      talk to your IT Departement about this issue and discuss it with them.

      if you want to make it in Webi, you can handle it too, but it will be more compliacted and it will take much of time.

      you can use the multiple queries concept with some restrictions and subqueries.

      i wish you the best and i wish you success with ur IT to let it be done at the universe level.

      good luck

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.