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 ?
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
Hi
We used Analytical lag function and able implement the same in Reportnet, even cognos support suggested the same thing.
Thanks a lot.
Plz update the status of the topic.
Srik