Search results for query: *

Just one last question, in relation SKandrel's post - does anyone know if in version 6, this a single parameter for the pc it's running on or is it a variable for each report?

Thanks to all for your help. I know we can't implement Ties suggestion - we gave that a go before submitting the original post. Just another tick in our column in trying to get our paymasters to upgrade!!!

Ties The Database is actually an Oracle RDB Database rather than a true Oracle DB The Outline has been created within the DB and we're trying to reference this with an OPTIMIZE USING statement at the end of the SQL. Cheers

Afternoon Using BO 5.1.7 on an Oracle DB We are wanting to add an 'optimize using' statement onto the end of a query without having to restrict BO from recreating the SQL eg OPTIMIZE USING 'outlinename' Obviously, we cannot create this as an object and use it in the conditions as it will...

thanks - much appreciated

sorry - i should add that we're using Business Objects 5.1.7 on DB2 version 8.2

I have a date to which I want to add a pre-formulated number of months. The date we're working with is defined in the universe as datestamp converted from a timestamp. We have exhausted all the B.O. pre-defined functions and are stuck! (for example - 01/09/2006 + 5 months to give 01/02/2007)

Thank you very much - worked a treat!

On one of our Universes, the Users are unable to set up user objects. When selecting Tools > Universes and then choosing the "User Object" tab, instead of the User Object Dialogue box appearing, the cursor remains and nothing happens. In each of the other Universes, selecting the User Objects...

Thanks Blom Back to maintaining multiple universes then!!!

On the subject of Linked Universes At the moment, in Version 5.1.7 Universe Linking does not seem to include the Context. Does anybody know if there is any way around this limitation, and if not is there any helpful improvement in Version 6?

My users want a series of reports which will only take into consideration "Working Days" - I have managed to create an object that will remove weekends from the equation, but I need to know how to deal with statutory holidays such as Christmas Day, New Years Day, Bank Holidays etc., etc., can...

I am trying to create an object on our v5.1.7 Universe to show the Users the 'LAST PAYMENT' made by a customer. Each transaction for a customer is given a unique ascending reference number. In a program, I could use: SELECT FT.CUST_NO, FT.TRANSACTION_AMOUNT, FT.TRANSACATION_DATE FROM...

I am trying to create an object on our v5.1.7 Universe to show the Users the 'LAST PAYMENT' made by a customer. Each transaction for a customer is given a unique, ascending reference number. In a Program, I could use SELECT FT.CUST_NO, FT.TRANSACTION_AMOUNT...

thanks again the .bat file idea sounds very promising.

thanks blom. I'm pretty new to all this so I'll give you a bit of background. Basically our powers that be are loathe to buy Broadcast Agent, so I have been asked to look into running BO with scripts through our Job Scheduler. My thinking is that if we can run BO through the command line we...

Morning all. We're running on BO 5.1.7 against an IBM DB2 Database Does anyone know the syntax for running BO from the Command Line?

Thanks Steve I've managed to dissuade our Management from using this option now. You've been most helpful.

Is anybody in a position to be able to advise my as to why this is the case??

Thanks - I have been trying to get a definitive answer to this question all week!!!