BusinessObjects Universe Designer – Sysdate Value Object
| Posted by watashii | Filed under BusinessObjects, Oracle, Software
Creating SYSDATE value objects in a Universe (via Oracle connection) can simply be done as shown above. I have simply created a single-value dimension object, which can be used anywhere within a query (result/condition/sort). Having sysdate values allows the flexibility to create dynamic time-based reports. For example you can schedule a weekly report to extract data from the past 7 days starting from the current time the report was run.
Note, when parsing the object against the database (Oracle), an error will appear. ORA-00903: Invalid table name.
You can just ignore this error and press ok.
Tags: BusinessObjects, oracle, sysdate, universe
