Reporting in Mediabin

Stu_english

We have tried to use the existing reporting views, but we're finding that they don't perform as needed. In particular, we need to report on groups of assets where some of the reporting data comes from metadata from one asset, and the rest of the reporting data comes from another asset. The assets are associated with each other within MediaBin, but we've not found a way to query the report views in a way that leverages this association.

We're using the Business Objects reporting tool to create these reports.

It looks like we need to develop custom views into the database to be able to query against them to get the data we're looking for. Can additional views be created in this way? In order to do this, we need to know what tables are used in the existing views, and what other tables might have the data we're looking for. In particular, anything that can help us to leverage the associations we've defined would be of great value.

Are there additional reporting tools that are useful or necessary to provide customized reporting?

Thanks,
Stu

shocklee

I'm having similar problems. Our users have an extensive amount of custom metadata that we need to use for generating reports. In some of the basic reports that I've created so far, the user indicates that the reports contain shortcuts as well as the assets. I'm using a derivitive call from the supplied reporting views - how do I get rid of the shortcuts and only reference the assets?

Mark