SQL Server Business Intelligence Development Studio
Business Intelligence Development Studio offers the first integrated development environment designed for the business intelligence developer. Built on Visual Studio 2005, Business Intelligence Development Studio provides a rich, common design environment for building BI solutions database engines, analysis services, integrations services, and reporting services. Debugging, source control, and script and code development are available for all components of the BI platform. You can also manage multiple projects as a unit and view and modify the properties of objects in projects.
Fig : Business Intelligence Development Studio interface in Visual Studio.
Solution Explorer
Solution Explorer enables you to manage all the different projects in a solution within BI Development Studio from a single window. You can open project items for modification and perform other management tasks directly from this view.
Properties Window
Business Intelligence Development Studio comes with a Properties window that you can use to view and change the properties of objects, such as packages, that are open in editors and designers. You can also use the Properties window to edit and view file, project, and solution properties.
Designer Window
With Business Intelligence Development Studio, you can use the Designer window to create or modify business intelligence objects. The designer provides both a code view and a design view of an object. When you open an object in a project, the object opens within a specialized designer in this window. For example, if you open a data source view in any of the business intelligence projects, the designer window opens using the Data Source View designer.
Customized Environment
Business Intelligence Development Studio can be easily configured to suit your working style. The studio environment comes with a collection of settings customized for SQL Server 2005 BI development. You can also configure the overall development environment and its behavior and make changes to its tools and windows.
Project Templates
Project templates in Business Intelligence Development Studio provide a context for developing specific constructs and functionality for BI applications. You can also develop projects as part of a solution that is independent of any particular server. For example, you can include an Analysis Services project and a Reporting Services project in the same solution. You can deploy the objects to a test server for testing during development, and later you can deploy the output from the projects to one or more staging or production
servers.
=> Analysis Services project includes the templates for cubes, dimensions, mining models, data sources, data source views, and roles, and provides the tools for working with these objects.
=> Integration Services project helps develop ETL solutions. This project type includes templates for packages, data sources, and data source views, and provides the tools for working with these objects.
=> Reporting Services includes the Report Model and Report projects for developing reporting solutions. You get templates for report models, data sources, and data source views, and the tools for working with these objects. The Report project includes templates for working with reports and shared data sources.
No comments:
Post a Comment