Index
A
AddNode Method, 237
ATOM, 11
Authentication layer, 10
Average Length of Stay, 436
B
BIDS and Visual Studio 2012. See Report
deployment
Bookmark link, 147–149
Building reports, 125
chart addition, 171–174
configuration and group variables, 177–178
Employee Service Cost report, 125–126
filter application, 170–171
final touches, 181–183
from Scratch, 129–133
gauge control, 179–181
interactivity
bookmark link, 147–149
document mapping, 137–138
hyperlink actions, 143–147
hyperlink formatting and tooltips, 157
jumping to report, 151–156
sorting, 141–143
types, 136–137
URL link, 149–151
visibility, 138–140
multivalued parameters (see Multivalued
parameters)
output with formatting, 133–134
parameters with stored procedures
BranchID field, 160
ChargeServiceStartDate field, 163
datasets addition, 161–162
Emp_Svc_Cost, 158–159
EmployeeTblID field, 160
No parameter values, 161
NULL values, 159–160
parameter value queries, 164
populated parameter selections, 163
query parameter, 158
query-assigned values, 160
Service Year field, 164
ServiceLogCtgryID parameter, 163
ServiceMonth parameter, 164
ServicesLogCtgryID property, 163
year and month values, 165
Report Wizard
corporate style, 128
data source, 126
generated report, 129
group and details selections, 128
Query String area, 127
tabular/matrix form, 127
subtotals, 134–136
Tablix elements, 175–177
Business intelligence (BI), 1, 6–7
dashboard, 394–397
data alerts, 397–399
report deployment (see Report deployment)
SQL analysis services
cube wizard, 362
graphical MDX query builder, 362
health-care application (see Health–care
application)
Microsoft SharePoint 2010, 373
OLAP solution, 362
tabular models, 362
VertiPaq Engine, 362
stand–alone installation (see Stand–alone
installation)
Business Intelligence Center, 388–389
Business Intelligence Development Studio
(BIDS), 6, 13–14, 40–43
Business Intelligence Semantic Model (BISM),
362