If the record count = 0 report will fail

[system]

I need to run a schedule in BO 4.0 which is created in Oracle DB.
If the record count > 0. it will be deliver to my Email else it will fail.
I don’t want to receive empty excel in my email. is there any option available in BO 4.0 oracle and teradata DB.

I tried to create measure object as CAST(CASE count() WHEN 0 THEN ‘0rows’ ELSE count() END AS int) in universe and I got “parse failed: Exception: DBA. ORA-00932: inconsistent datatype: expected CHAR got NUMBER state : N/A” error . Its oracle DB.

Please help me to implement this requirement in universe and report level.

---

sureshmohan (BOB member since 2010-03-04)

[system]

You’re trying to cast the character string ‘0rows’ into an int; that’s a compile error, not a runtime error. You probably just want something like “1/count(*)”.

Joe

---

joepeters (BOB member since 2002-08-29)

[system]

We implemented step by step the process described in this BOB post. We have multiple reports using it and it works fine.

Avoid sending email if report is blank

Hi, I have scheduled a report that send out mail on daily basis with an attachment. Problem is even if there is no data, email goes out with blank attachment. I am using BO XI R2, is there any way to do this. While searching on this forum, I came across similar topic suggesting a object to be built in universe. I am not interested to do this. Please let me know if there is any work around. Regards, Girish girishoak (BOB member since 2007-02-14)

---

IBN (BOB member since 2007-05-29)