Desktop Intelligence report missing data on Enteprise

[Matt27]

I have a report I've built in Desktop Inelligence which works absolutely fine when run in Desktop Intelligence. I exported it to the repository and scheduled it to run monthly on Enterprise. However, when it ran on Enterprise I found that most of the information on the report was missing. Is there any reason why a report would work fine in Desktop Intelligence but exactly the same report would miss lots of data on Enterprise?

 

[groggle]

One thought is that when you run the report through deski it is connecting to the database from your client pc, whereas when you schedule it, it is connecting to the database via the server upon which BOE XI is installed.

Compare the database connection setups of your client machine and server and see if there is any difference.

 

[Matt27]

I've checked the connection setups of both and they both appear to be the same. I have other deski reports I've created which use the same database connection and have worked absolutely fine on Enterprise when scheduled!

 

[MJRBIM]

If they are scheduled MONTHLY - are the run out-of-hours (eg. middle of the night)...?

Are all the datasources you are using for that DeskI report available at the time the report is SCHEDULED to run...?

 

[Matt27]

The report runs monthly, and will run at whatever time the database is up and running after being updated at month end. So there is only one datasource and the report wont actually run until this datasource is available.