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 Mike Lewis 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. SimplyStu

    Database Guard?

    Oh no! Here is the deal: 1) On our new "report" database on Oracle 10g, they have "Database Guard" on. 2) With this on you CANNOT run reports at all. The "Oracle Bug" number on this issue is :4663793. You get "table not found" on every report. Its is an issue in the DB does not contain 2...
  2. SimplyStu

    Report Time Restriction? Report CPU Restriction?

    Ok. This is really two questions: 1) Can you set up CE so users can only schedule reports during a certain time period? 2) Is there a way to force a report to "abort" if if runs for a certain time? For example: 99.99% of all reports 'should' finish in under 10 min. The reports that do not...
  3. SimplyStu

    Audit v Query Builder v APOS KPI in BO XI R2

    Sorry.... Here is what I would like. 1) Want to see what reports are being run. 2) When reports are being run. 3) Who is running the reports. 4) What reports are failing. 5) What reports are set to recur. 6) What is the system load. 7) For the most part I want user and report usage...
  4. SimplyStu

    Audit v Query Builder v APOS KPI in BO XI R2

    I'm finding that I need to "audit" reports and my system. I do not have the "Audit" license with our current system. To add this is on is $$$ but want to know what you all have found is the best investment. My options are (did I miss anything? Are there other options?): Query Builder: I can...
  5. SimplyStu

    Is there a way to avoid massive SQL with poorly written RPTS?

    Let me ask it a different way. The DBAs are "hinting" that CE is the problem and that CE (Crystal) is creating huge hits on the DB. Since the idea is to take pressure off us writing reports CE works well. I was thinking that the DBAs should be able to control a run away SQL on the Oracle...
  6. SimplyStu

    Is there a way to avoid massive SQL with poorly written RPTS?

    My DB folks are starting to blame CE for some massive drag. I think what is happening is some users are writing some "bad" reports that are eating some CPU time. These same reports are also My question is this. In CE is there a way to avoid this with some set of parameters? Limits? I see...
  7. SimplyStu

    Can you force CE not to send a report?

    I have another idea about this. Is there a known way that you can get a report to fail? That seems to be the only other way to get a report NOT to be delivered. I know I have had tons of reports fail and they are not delived. So, what if you check to see if there are 0 records and if so...
  8. SimplyStu

    WebElements 2.0

    I'm sure you are all using this, but for those that are not, I have found some cool things in Web Elements. Since it is free, you can't beat it!
  9. SimplyStu

    Can you force CE not to send a report?

    I have a report that 90% of the time has no data. Can I somehow force the report not to be sent if there is no data? Normally the report goes out via E-Mail even if it is blank. I want nothing to be sent if no records are retrieved. In the past I use Alerts to do the same thing, but this...

Part and Inventory Search

Back
Top