How to maintain curent and previous data in report leverl

[Sarayucog]

Hi All,

How to maintain curent and previous data in report leverl.

For Example:
I have 100 records in my report output,   tomarrow   I have updated  50 records , now I  want to see previous 100 records   +   50 updated records separately.



Thanks & Regards
Sarayu

[MFGF]

Hi,

Preserving history like this is typically done by an ETL process delivering data to a data warehouse.  Cognos 8 BI has no real functionality designed to do this - it is a reporting tool not a database.  You could achieve it with Data Manager, though.

Regards,

MF.

[mvjcognos]

Hi Sarayu

1) Let me know ur database for that particular columns have historical data or not if u have then it is possible in the report level.....
2) R u selecting date in the date prompt to extract the required data from measure.....
3) If u r selecting form prompts then it is possible like u need to write a calculation in the particular measure column
for ex: case when days_between(?from date? and ?end date?) then sales quantity else (0) end......
or
case when to_date(date key from measure table,'yyyymmdd') between
?from date? and ?end date?  then sales quantity else (0) end......

try this.................

Regards
mvjcognos@gmail.com