Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.
DESCRIPTION:
When performing Integrity manager comparison test on reports/documents using dynamic dates, Integrity manager result may report SQL and data failure between the base and target reports if base and target tests were done on different calendar dates. Here is an example:
STEPS TO REPRODUCE:
Dynamic date filter definition:
Report definition:
CAUSE:
Running the above report on different dates will produce different SQL and may produce different data as well. This is an expected behavior. If the dynamic date is used in a filter of a report/document, it will always generate different SQL for different dates.
ACTION:
Integrity manager will report SQL and may also report data failure between base and target reports for report/document/dossier with dynamic dates during integrity manager comparison test. However, this failure can be ignored if the user confirms it's caused by the dynamic date usage.
Strategy reference numbers for this technical note are KB442245 and US116457.
