Queries

[system]

Hi All,

I am new to reporting as till now i worked on administration.Can you please answer below queries

1.How we test reports in real time?

2.How to tune reports for better performance?

3.How to resolve #divide by zero error?

Thanks in advance.

-Krish…

---

gokul_bobj (BOB member since 2008-03-28)

[system]

Hi,

Interview questions?

@gokul_bobj

2.How to tune reports for better performance?

See this Reporter FAQ:

120×120 10.4 KB

Why is my report so slow? Submitted by kmahler, additional comments by Andreas (July 2009). What makes up the total time a report runs from hitting the Refresh button to being displayed: Query execution time (database side) Transferring results across the network to the client/web browser (network bandwidth & latency) Computing local report variables, formulas, local report filters, alerters, etc. within the report (BOE server/ DesktopIntelligence workstation) Rendering the page (pag…

@gokul_bobj

3.How to resolve #divide by zero error?

Instead of

=[A]/[B]

use

=If([B]<>0;[A]/[B])

---

Marek Chladny (BOB member since 2003-11-27)

[system]

First tip. Search!

To get rid of divide by zero error, you also also use IsError() function.

---

Jansi (BOB member since 2008-05-12)

[system]

@gokul_bobj

1.How we test reports in real time?

Gokul,We can test the report depend upon the report type we generate.
Like formats,drill,look and feel…so on
Basically,we should test the records retrived by the report.

---

Arjun (BOB member since 2008-07-28)