Focal Point
[CASE-OPENED] OLAP date

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8607093006

March 16, 2011, 11:37 AM
RichaKulkarni
[CASE-OPENED] OLAP date
Hi,
I have some OLAP reports which are saved in "My Reports". Later when i go and run this saved report it shows me the date i saved the report. I want it to show the date i ran the report. Suppose i saved the report on 1/Mar/2011 and ran it on 16/Mar/2011 ir should show me 16/Mar/2011 as Report ran on....

I'm using @DATEMDYY parameter in heading and this parameter saves the value in the saved report.
Is there any workaround for this??
Please help!!

Thanks
Richa

This message has been edited. Last edited by: Kerry,


Thanks,
Richa

WebFOCUS 7.6
Windows, All Outputs
March 23, 2011, 01:47 PM
Kerry
Hi all,

FYI, it looks like Richa already has a case opened regarding this issue.

Richa, when you have a solution/answer from the case, can you please post it here? Thank you in advance for sharing with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
March 24, 2011, 04:25 PM
RichaKulkarni
Sure will post it Smiler


Thanks,
Richa

WebFOCUS 7.6
Windows, All Outputs
April 06, 2011, 02:17 PM
RichaKulkarni
The workaround provided by IBI

The way around this is to use a database field instead of a &var:
  DEFINE FILE ...
RUNDATE/A10=TODAY('A10');
END
TABLE FILE ...
HEADING
"run on <RUNDATE "

This workaround works perfectly fine for our reports Thanks
Richa
  



Thanks,
Richa

WebFOCUS 7.6
Windows, All Outputs