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!

  • Congratulations Chriss Miller 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: *

  • Users: PruSQLer
  • Content: Threads
  • Order by date
  1. PruSQLer

    DB2 Version 9 vs Version 8

    We're trying to quantify the performance gains we'll see in 2008 when we convert to Version 9. To those of you who have already gone to V.9, have you seen significant performance improvements? If so, would you say it's as much as 25 or 30% ? Any feedback is greatly appreciated. We're using...
  2. PruSQLer

    Help with 2 levels of aggregation

    I did a Search but didn't find a topic specific to what I'm encountering so here goes: I'm using BO V 6.1 I have a report with 2 Measures that need to be grouped by the same 2 parameters (Business and Company). The first measure is Total Sales - no problem. The 2nd measure is Total Sales GT...
  3. PruSQLer

    V 6.1 vs V 6.5 - Big Improvement

    Are there vast differences (i.e. improvements) between Version 6.1 and Version 6.5 of Business Objects. I've heard rumors that is the case. Thanks in advance for any feedback.
  4. PruSQLer

    DB2 Version 8 incompatible with BO V5?

    We just received word from our systems people that there may be a problem with the compatability of DB2 V.8 and BO V.5. Does anyone know if such a problem does exist? This would be a major problem for us if true!
  5. PruSQLer

    Question about Multiple Data Providers

    I'm still trying to get the hang of BO and am confused about Multiple Data Providers. What exactly are they - does it simply mean using multiple universes for a report? If so, how does one bring them together when creating a report? Thanks for any info.
  6. PruSQLer

    Problem With Outer Joins in BO

    I can create a left outer join using my two common ID fields in the Join Properties box. However, I need more criteria included for the Null Supplying table (e.g. end_date is null, money_type = 1). But when I create that using the Self Restricting Join, this additional logic gets put in the...
  7. PruSQLer

    How to get New Connection in a Universe

    I have a universe in Designer which is assigned a particular connection. I want to have that Universe use a different connection but can't do it via the CONNECTIONS selection on the TOOLS menu. Is there a way to do this? (I would think so but...)
  8. PruSQLer

    Triggering a VB exe on shutdown

    Is there a relatively easy way to have a VB program executed when Windows is shutting down?
  9. PruSQLer

    How can I establish a Variable

    I'm new to BO and here's my problem: I need to make calculations based on a date passed to the query by the person creating the report. Is there a way to establish a Variable right at the start? I know @Prompt can be used to elicit user criteria but I need to use the date many times in the...
  10. PruSQLer

    Anyone know how to do this?

    I have a query doing this: Select product, count(*), sum(amount), sum(Portion) From Event_Table et, Money_Table mt Where et.ID = mt.ID and mt.Num in (1,500,510) Group by product My count gets inflated because an event can have more than one mt.Num associated with it, based on whether...
  11. PruSQLer

    Can you convert table from verticfal to horizontal using SQL?

    Here's the situation: ID1 Event1 ID1 Event2 ID1 Event3 ID2 Event1 ID2 Event2 I want to convert the table to this: ID1 Event1 Event2 Event3 ID2 Event1 Event2 I know I can pull the table in to my PC and write a VB app to do this but I'm dealing with huge tables so I'd like to do it...

Part and Inventory Search

Back
Top