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
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.
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