or, The End of the World as We Know It (Part 2)
In Desktop Intelligence, it’s possible to display “yesterday” on a report using the following formula:
CurrentDate()-1
The Report Conversion Tool will convert the formula; however, Web Intelligence will not understand it, displaying the following error:
#DATATYPE
The formula can usually be corrected in either the converted Web Intelligence document or the original Desktop Intelligence document. However, today I encountered the formula in the document header and was unable to modify the Web Intelligence cell (in Web Intelligence XI R2 – sigh – not sure if 3.x handles this item better). So I corrected it first in Desktop Intelligence and re-ran the Report Conversion Tool. The corrected formula should be:
RelativeDate(CurrentDate(), -1)
On a related note, I frequently find CurrentDate() displayed on a scheduled report to indicate when the report was generated. Both CurrentDate() and LastExecutionDate() return the same date/time at the time of scheduling. So either one can be used to schedule and distribute an Adobe PDF, for example. However, if a user views the document instance in the InfoView portal, the CurrentDate() no longer reflects when the data was generated. Therefore, it is recommended to always use LastExecutionDate() to display the age of the data, because it will always be correct.
In my next post, I’ll look at migration strategies Desktop Intelligence documents that use Free Hand SQL and “do not regenerate SQL” as we consider a world without Desktop Intelligence.
Believe me for conversion you want to use the latest version!
And I did a conversion project of 100s of Full Client Reporter 5.1 Freehand-SQL reports to WebIntelligence, and we faced quite a few issues: Large universes (every single freehand-Sql data provider turned into a separate derived table), which are really not easily maintenable. Personal connections, which are used for Freehand-SQL. Length of column names/object names from Freehand-SQL data providers and their generated derived tables in the universe. Formatatting of resulting Webi documents, etc.