B

Back Up Database task, 163, 164

banded reports, 569

Basic tab (Dimension Data page), 410

BatchInfo.csv file, 278, 279

BI (business intelligence)

about, 11–12

coping with information overload, 458–462

data mining and, 16

data-led discovery for, 15

defined, 11

designing to meet needs, 100–101

Excel features for use in, 745

latency in, 18, 19

layout-led discovery for, 14–15

levels of organization and, 16–19

measures and, 32

new capabilities and opportunities of, 745–746

OLTP systems for, 27–29

providing comparative yearly data, 414–418

Reporting Services role in delivering, 718

SQL Server support of, 12

transactional data as source of, 26–29

usefulness of, 718

Boolean literals, 247

borders for reports, 601

BOTTOMCOUNT function, 441–443

breakpoints, 260–261

Browse window (SQL Server Management Studio), 327–328

Browser page (Role Design tab), 411, 412, 414, 418

Browser role, 643

browsing folder contents with URL access, 687

BUILTIN/Administrators role, 641

Bulk Insert task, 179, 180

business intelligence. See BI

Business Intelligence Development Studio, 129–138

about, 62–63

advantages in data mart creation, 129

auto hide for windows, 78

Business Intelligence Wizard, 341–342

creating solution and Analysis Services project, 64–66, 67

cube creation in Cube Wizard, 130–135

cube definition with linked objects in, 340–341

deploying project from, 324–326

Designer window, 73–75

developing database with SQL Server Management Studio, 131

dockable windows, 77

Error List window, 72

extracting cube information with Browser, 411, 412, 414, 418

features of Report Designer, 657

Find Results window, 73

finding and opening solution, 63–64

floating windows, 75–76

hide state for windows, 78–79

Integration Services package design layout in, 143–144

opening windows not visible, 70–71

Output window, 72–73

Properties window, 68–69

sample project deployment in, 326–330

selecting MDI environment in, 79–82

setting window states in, 75, 76

Solution Explorer window, 66–68, 76, 77–78, 79

source code management for projects, 63

Task List window, 71–72

toolbar buttons for, 71

Toolbox window, 69–70

windows as tabbed document, 77–78

Business Intelligence Wizard, 341–342

business needs

analyzing sales information, 130–131

manufacturing automation system, 107–109

buttons

Analysis Services query, 90

Business Intelligence Development Studio toolbar, 71

New Calculated Member toolbar, 298

New Project Toolbar, 65

New Query Toolbar, 90

Test, 86