Search results for query: *

I'm looking for business objects report migration vba script examples. The main requirement is to move reports between development and report domains within the same repository using a GUI interface. Any suggestions and/or sample code is appreciated.

Please provide input on the best development vs production environment implementation. The two main possibilities usually presented are a) dev and prod repositories vs b) dev and prod doc and univ domains. How is the above implemented in your organization?

Try this. 1. Create an object in the universe for the database system date. In the select box for the object definition enter sysdate. 2. In your query add a condition for your date object, i.e. Deployment Date = Database System Date Object

The following will return the Oracle database system date in a date object's list of values: 1. Edit object properties in Designer. 2. Press 'edit' button on properties tab. 3. In the query panel press the sql button and overwrite the existing sql with the following: select sysdate from dual...

I would like to embed a calendar control in a report cell (not a vba form) and process user interaction with the control via vba. For example, change a table date filter based on the value selected in the control. Any ideas?

It was not an editable property ... ended up using MS ADO.

The security features were a major selling point. No other product offered the depth of environment control, i.e. module access, data access, etc.. For example, in Business Objects data access can be set at the user level, i.e. for Jane Doe always generate the 'sales.state = California' where...

There is a Business Objects universe included on the installation CD that details an Oracle based Business Objects repository database. If your repository is in Oracle it might be all that you need. Even if your repository is in a different database, i.e. Sybase, it gives a good head start on...

Trying to modify free hand sql via vba ... receive error DA0011 Cannot find universe. Any hints? Thx. Code ===== Application.ActiveDocument.DataProviders.Item(1).SQL = "select order_item_id from ptel_po where order_item_id IN ('OI000176')"