BusinessObjects Board

BO4 - Error description /reason in sampel universe/schema?

other Auditor
#1

Hi,

We have a bo4 report which lists scheduled reports and if succeded or failed. Cannot see any object which shows error reason. Is such an object available either in universe or audit schema?
Also is there no option to see pending jobs.

Thanks

philipo (BOB member since 2005-07-22)

#2

Don’t think so, but there is a utility in BOB downloads that I believe does both.

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Thanks for reply - do you have link to the one concerned?

philipo (BOB member since 2005-07-22)

#4

I believe its this one:-

https://bobj-board.org/t/168709

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Thanks for link

philipo (BOB member since 2005-07-22)

#6

pretty interesting…out of curiosity, which dimensions are you using to get scheduled reports (failed or succeeded)? Thanks.

#7

If you are using the SAP Sample BI 4.x Universe, in your Query Filter, set Event Type In List Run;Deliver and include “Event Detail Type” and “Event Detail Value”. If you look at the Universe (IDT), you’ll notice it converts the CLOB Detail into a VarChar[] and uses that. It plucks the data piece out of that large glob of data based on the Detail Type. Very inefficient especially if you have a large repository like ours. We have to augment this data with Materilaized views to pull specific types like Universe Name and Size.

pcgeekus :us: (BOB member since 2003-10-16)