Converting Prior() Function in Brio to Reportnet

[Vathi]

we are doing conversion of Brio reports to  Reportnet..................

In Brio Prior function is a function used in the calculated columns, this will give the value of the previous row.

e.g. Prior(Feature) means this will return you the previous row value in Feature column

Vendor Cost_2 =  if ( Prior ( Feature ) == Feature && Prior ( Product_Usage_Type ) != Product_Usage_Type) {0 }  else { Vendor_Cost}

Vendor Cost_2 will be 0 if the value in the Feature column is same as the value in the previous row and Product_Usage_type should not be equal to the previous row value in the Product_Usage_Type column, otherwise Vendor Cost_2 will be the value of Vendor_cost column of the same row.

how to  replicate the same in Reportnet ?

[BIsrik]

I feel there is no direct way of achieving this in crn. I assume that u r using oracle as database. If so, create a query subject with a manual sql in it and use the olap function available. u can check this link

http://www.oracle-base.com/articles/misc/LagLeadAnalyticFunctions.php

and use, the query subject in the report.

Srik

[Vathi]

Hi

We used Analytical lag function and able implement the same in Reportnet, even cognos support suggested the same thing.


Thanks a lot.

[BIsrik]

Plz update the status of the topic.

Srik