Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maverick00

    Limits to Case Statement

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

    Limits to Case Statement

    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...
  3. maverick00

    Limits to Case Statement

    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...
  4. maverick00

    Limits to Case Statement

    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.
  5. maverick00

    Limits to Case Statement

    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.
  6. maverick00

    Limits to Case Statement

    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...
  7. maverick00

    Creating Universe backups

    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...
  8. maverick00

    How does table mapping work?

    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...
  9. maverick00

    2 different installations of BO

    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.
  10. maverick00

    Return on Investment

    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?
  11. maverick00

    table of unique values

    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...
  12. maverick00

    table of unique values

    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...
  13. maverick00

    table of unique values

    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...
  14. maverick00

    Power Users vs Casual Users

    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?
  15. maverick00

    Power Users vs Casual Users

    RogerCruse, can you elaborate?
  16. maverick00

    Business Objects - GAP Analysis

    I have been comparing several products. BO has the metadata layer that makes the product easier for end user use. The reporting end is more spreadsheet like and treats the spreadsheet like an object. Crystal uses the band style report writer like Microsoft Access.
  17. maverick00

    Power Users vs Casual Users

    What end user reporting tool most satifies both power users and casual end users? We currently use a SQL writing tool and are looking for new software that is friendlier to most end users. We do not want to alienate the power users.
  18. maverick00

    Power Users

    Thank you Blom034. I have a couple hundred of these power users. Many of them will have the same attitude as your power user. Are there any major restrictions that BO has that will take power away from them? I do not want to restrict them and do not want to babysit them ( with Designer changes).
  19. maverick00

    Power Users

    My company is thinking of moving to Business Objects. Our current tool is a SQL writer. The power users love it, because they can write complex SQL. Unfortunately the casual users are left to find a power user to get anything done. By moving to Business Objects it appears that the casual...

Part and Inventory Search

Back
Top