Business Intelligence Studio tutorial
(Projects and Solutions)
Overview
The BIDS paradigm for developing reports is based on the concept of projects and solutions. A project is a container for one type of object such as SSRS reports, web pages, SQL Server Integration Services packages, etc. Projects can be used to organize things in a meaningful way. For instance I could have a project for all reports used by the Accounting department, another project for Human Resource department reports, and another project for the Finance department reports.
A solution is a container for one or more projects. Think of a solution as the complete application that can be made up of a number of different types of projects such as a report project, SQL Server Integration Services project, a web project, etc.
In this section we will walk through creating an empty solution and adding a report project to that solution. In the sections that follow we will add reports to our report project.
Explanation
To begin launch BIDS by selecting SQL Server Business Intelligence Development Studio from the Microsoft SQL Server 2008 program group. Click File, New Project on the top-level menu to display the New Project dialog. Click Visual Studio Solutions under Project Types, Blank Solution under Visual Studio installed templates, and enter the Name and Location as shown below:
Click OK to create a blank solution. Now we want to add a project to our solution. Remember a solution is just a container for one or more projects. By creating a blank solution, we can add multiple projects that make up the complete solution that we are building.
You might also like
|
MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance (Microsoft Press Training Kit) Book (Microsoft Press)
|
IIFL Holdings jumps on receiving Sebi nod for investment advisory services — Business Standard
With this, IIFL Holdings would be offering a wide range of investment and financial advisory services to corporate and institutional clients.
Sarah Oberhofer Joins Brookfield Office of Ameriprise Financial — Brookfield Elm Grove Now
Brokerage, investment and financial advisory services are made available through Ameriprise Financial Services, Inc. Member FINRA and SIPC. © 2014 Ameriprise Financial, Inc. All rights reserved.
|
XeoPOS: Forecast sales using artificial intelligence, keep track of your finances [Download] Digital Software (NOVUCOMP EOOD-140555-140555)
|
Capital Intelligence Raises the Ratings of Gulf Finance House BSC — MENAFN.COM
Being a wholesale entity, the company has no official lender of last resort.
|
SAP BusinessObjects BI 4.0: The Complete Reference Book (McGraw-Hill/Osborne Media)
|
|
Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 (Developer Reference) Book (Microsoft Press)
|
|
Avery Big Tab Write-On Dividers, 8-Tabs, 1 Set (23079) Office Product (Avery)
|
Q&A
Can anyone tell me where the Business Intelligence Project located, in Visual Studio 2003?
Can anyone tell me where the Business Intelligence Project located, in Visual Studio 2003?
You have to install the Business Intelligence version of Visual Studio which is included with SQL Server 2005.
How to get Business Intelligence Development Studio?
If not the free/express version of BIDS is available for download from Microsoft. I do not know if it has a full feature set compared to the full version, anyone care to comment?
