B

backup

AMO for, 410-411

for AnalysisServicesTutorial2005 database, 389-390

auditing and, 389, 419

encryption during, 389

Execute DDL task for (Integration Services), 567-572

file size limitation in AS2000, 390

importance of, 389

restoring from backups using AMO, 410-411

restoring from backups using SSMS, 390-391

SSMS for, 389-390

stored procedure for, 328-330

Backup Database dialog, 389, 390

Batch command, 373

BEGIN TRANSACTION statement, 359

BIDS (Business Intelligence Development Studio)

browsing cubes, 53

creating cubes, 43-50

creating data sources, 35-38, 39

creating DSVs, 38, 40-41

creating projects, 32-33

data source for remote partition, 309

DDLs for dimension writeback, 347-348

deploying projects, 50-52

described, 14, 22

dimension writeback support, 341

Discover requests for schema information, 126

DSV Editor, 41-43

online mode, 399-402

Output pane, 34

Properties pane, 34, 103-105

Solution Explorer pane, 33-34

starting, 31

Visual Studio compared to, 31

XML/A requests, 125-126

bottlenecks. See performance optimization

BottomCount function (MDX), 780-781

BottomPercent function (MDX), 781-782

BottomSum function (MDX), 782

brackets ([])

in MDX syntax, 70

in member names, 65

browsing cubes. See also pivot tables (Excel)

Account intelligence and, 235

Browser pane overview, 53

calculated measures, 172-173

with data mining dimension, 519

KPIs, 276-277

overview, 152-156

perspectives, 176-178

reference dimensions, 162-163

translations, 176-178

URL actions, 285-287

browsing dimensions

changing the All level, 127-128

Dimension Designer Browser pane for, 126-128

reference dimensions, 162-163

viewing member properties, 129-130

XML/A requests for, 125-126

Building the Data Warehouse (Inmon), 3-4

Bulk Insert task (Integration Services), 566

business intelligence

Account intelligence, 230, 231-235

adding to cubes, 294-301

currency conversion, 296-301

as data analysis, 13-14

Dimension intelligence, 230, 239-241

dimension writeback, 246-249

partitions for, 301-316

semi-additive measures, 294-296

terabytes of source data for, 301

Time intelligence, 230, 235-239

Business Intelligence Development Studio. See BIDS

Business Intelligence Wizard

for Account intelligence, 231-232, 233

for currency conversion, 297-301

for Dimension intelligence, 239-240

for dimension writeback, 246-248

for semi-additive measures, 294-295

for Time intelligence, 236-238