Previous revision

[Former Member]

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

http://www.forumtopics.com/busobj/viewtopic.php?p=523361#523361

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

[amrsalem1983 · Accepted solution]

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

good luck

[Former Member · Accepted solution]

Hi Amr.

That is correct. I need to show only the items which appear on the current PO revision which, may or may not appear on the previous revision. If they are a new item then the previous quantity will be zero. If they appeared on the previous revision but have subsequently been removed then they simply won't appear on the report.

The thread you mentioned is similar to what I'm trying to achieve. The main difference though is I can't use prompts as users will not know what the current version of a PO is. Also the report will be returning hundreds of PO's which could be at any revision. The report needs to find the current revision and the revision previous to this dynamically.

Do you know where I can get information on creating views? I can't do this myself but I can pass the information onto our IT department.

[amrsalem1983 · Accepted solution]

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