If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Converting Prior() Function in Brio to Reportnet

Started by navila, 24 May 2006 02:53:09 AM

Previous topic - Next topic

navila

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

navila


Hi

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


Thanks a lot.

BIsrik