Currently MAS 500 allows you to create an XML file of custom Business Insights Explorer views for the purpose of deploying them to another system. However, this ability to do so is somewhat limited as it only scripts information particular to a simple BIE (e.g. associated view, appropriate table entries, etc.).

If the new BIE uses a custom Entity or the underlying view is dependent on other T-SQL objects such as functions or custom tables that do not exist on the target system, the current functionality does not have the capability to script these to the XML file so they can be created when deployed.

Having the option to script the BIE task as T-SQL will allow developers to modify this script to add any associated T-SQL objects required by the new BIE to run correctly. As a T-SQL script, developers will be able to test the deployment of the new BIE on a test system before attempting to deploy to a production site.

by: Louis D. | over a year ago | 4 - Reports / BI