Recent content by maverick00

Definitely not an Oracle wiz. What needs to be done?

The software aborts when the object is parsed. This is the message. Unhandled Exception Code: c0000005 Description: EXCEPTION_ACCESS_VIOLATION Call stack: ------------------------------------------------------------------ Module at 0x60400000: C:\oracle\ora81\bin\ORACLIENT8.DLL v...

here is the code: CASE WHEN (ae_l4_vh.COMPT_OBJ_CD >= '4801' AND ae_l4_vh.COMPT_OBJ_CD <= '4817') OR (ae_l4_vh.COMPT_OBJ_CD >= '4825' AND ae_l4_vh.COMPT_OBJ_CD <= '4857') OR (ae_l4_vh.COMPT_OBJ_CD >= '4920' AND ae_l4_vh.COMPT_OBJ_CD <= '4955') THEN 'IN STATE TRAVEL EXPENSES' WHEN...

Decode behaves the same way and has a limit of around 125 arguments. Of course, one way to do this is to create a table, which will be done. The rush on this assignment prevented that at first. So far my answer has been not to parse the object.

The case statement works fine. We have a 10 year old software tool that allows us to run SQL and the case statement works fine. Right now, my workaround is to not parse the code in BO. It still publishes the Universe to the Repository and works fine in the report.

An object is created using a case statement. It has multiple When statements. The Universe aborts when the object is parsed. The database is Oracle 8. Oddly, if some of the When statements are removed, it will parse, and continue to parse, as the removed When statements are added back in...

What is the proper way to maintain a universe backup? Seems like if it is moved to a different directory and given a new file name, that even if it is moved back and renamed back to the original name, that when it is exported the repository will consider it a different universe and any table...

There is a table mapping not working in my universe. The table to be replaced is a table. I am replacing it with a view of the the table unioned with other tables. The replacement does not take place. What does BO look for to do the replacement? The table and the view have the same column...

How do you set up Business Objects to be able to connect to two different installations of BO? These two groups are entirely separate. Different databases, different data, different ways they use the product, different groups running things.

How does one go about calculating a return on investment for a BI query and report tool that is to be a replacement for a current tool?

Blom, you amaze me. Yes, my sql was incomplete, my fault, was trying to simplify as much as possible. If the CONTRACT_TABLE has CONTRACT = '11111'. (one row of header) with item_codes from the CONTRACT_DETAIL table of '115' and '040' (two rows of detail), then the inner script will pull two...

Thanks to everyone responding, but as I read the responses, maybe I am not clear enough with what is needed (or don't understand what the responses are saying). A distinct list of doc id's is needed in the universe to choose values from other parts of the universe. Ordinarily, the DBA would...

Say there is a 1 to many relationship of table A (1) to table B (Many). A person wants a unique list of document ids from A based on multiple choices in table B. In SQL this would be a simple Select distinct doc_id from A,B where B.item in ('this','that','whatever'). Now, how do I create this...

Thanks Toodle, Do you employ microstrategy as a web tool? How many IT folks work to create the reports for your casual users. As for BO, I thought Cognos employed the cube?

RogerCruse, can you elaborate?