BOE-XI "Auditor" universe : Force CURRENT-DATE value use in WebI Query 1

[MJRBIM]

Trying to create a WebIntelligence report against the BOE-XI "Auditor" universe, that I can schedule to refresh every day.

I want to pass the Current-Date value to be compared to the "Action YYYY-MM-DD" dimension in the "Action Time" class, whenever the report runs.

Any advice would be appreciated...Thanks in advance!

 

[skrandel]

You will have to modify the universe. You'll need to turn the silly date format that BO provides (which is a text string) to a correct date.

You'll do this using whatever date syntax you need for your specific database.

Steve Krandel
Intuit

 

[MJRBIM]

Thanks for the advice, Steve.