A

&_action parameter

Add Bookmark window

Add Conditional Highlight window

Add-In for Microsoft Office

about

administrator tasks

Advanced window

creating prompts

creating reports in Excel

enhancing reports

information maps

OLAP Cube Viewer

prerequisites

roles and responsibilities

tips and tricks

Add Levels window

Add New Group window

Add New Prompt window

Add Supplied window

administrator tasks and tools

about

Add-In for Microsoft Office

BI Dashboard

Enterprise Guide

Information Delivery Portal

Information Map Studio

OLAP Cube Studio

prompting framework

stored processes

Web Report Studio

Advanced Cube Options window

Advanced Dimension Options window

Advanced Filter Builder window

Advanced role

aggregation process

about

OLAP cubes

Aggregation Tuning module

alert emails

alert framework for dashboards

Alerts portlet

ampersand (&)

Analysis role

Application Servers

ArcGIS Server

ARM Log mechanism (aggregations)

artwork, inserting into reports

Assign Columns window

Assign Data window

Authorization Manager plug-in

AUTOEXEC file, adding LIBREF code to

automatic variables

B

background processing

backslash (/)

Balanced Scorecard approach

banner images

bar charts

in Excel charts

in web reports

BI (Business Intelligence)

See also specific tools

about

administration tools

implementation decision streams

reporting tools

viewing tools

BI Dashboard

about

administrator tasks

creating custom indicators

creating dashboards

enhancing dashboards

indicator interactions simulating prompts

planning dashboard creation

prerequisites

roles and responsibilities

tips and tricks

BI Server, importing data from

BMP image type

bookmarks

adding to portal pages

creating

setting for OLAP cubes

storing

Business Intelligence

See BI (Business Intelligence)

business rules, establishing

C

caching, data

Calculated Measure wizard

Calculation Type window

CALL SYMPUT statement

CANDY library

Cardinality mechanism (aggregations)

cascading prompts

about

building

dashboards

shared prompts

tools supporting

cascading style sheets (CSS)

CASE statement

Category data item

about

group breaks by

sorting

central storage file system

chaining stored processes

channels, publication

See publication channels

charts

built in Excel

built in PowerPoint

built in Word

improving appearance of

Choose Data window

Browse button in

Excel Data field

Existing Worksheet field

SAS Data in Excel field

client-side filters

Collection portlets

color prompt type

color schemes

for dashboards

for web reports

Column Heading window

columns layout

conditional highlighting

Connections window

Content Management Properties role

Copy to SAS Server window

Create New SAS Stored Process Wizard window

creating prompts

creating stored processes

prompt groups

crosstabulation tables

CSS (cascading style sheets)

Cube Designer wizard

Aggregations page

Dimension Tables page

Dimensions page

Drill-Through page

Export Code button

General page

Input page

Measure Details page

Member Property page

Select Measure page

cube job

Cube Manager (Excel)

custom formats

custom measures

adding to reports

creating

defining calculated members for

customizing web reports

D

dashboard configuration files

dashboard objects

Dashboard portlets

dashboards

about

alert framework

arranging

cascading prompts

client-side versus server-side filtering

color schemes

creating

creating drill paths

creating indicator data

creating indicators

creating interactions between indicators

creating ranges

creating with cascading prompts

data caching

data summarization

enhancing

font styles and sizes for

linking to stored processes

linking to web reports

naming conventions

organizing

planning

promotion notes

resizing

stored processes as custom indicator displays

stored processes as indicator data

testing prompts within

data caching

data grouping

data items (information maps)

assigning to report elements

bar charts

creating

line graphs

organizing

web reports

data library prompt type

data sets, creating on server

data source item prompt type

data source prompt type

data sources

enabling for caching

for dashboards

for OLAP cubes

for web reports

information maps

prefiltering for information maps

data storage

See storage considerations

data tables

adding conditional highlighting

building with SAS tasks

crosstabulation

enabling caching for

joining

populating list of available values

web reports

date prompt type

date range prompt type

dates, tips and tricks

DATETIME() function

dboard_sas.dsx file

dependencies between prompts

about

building

dashboards

shared prompts

tools supporting

dependent objects

detail tables (data source)

detailed data

about

creating OLAP cubes from

Dimension Designer

about

General page

Hierarchy page

Level page

dimensions (OLAP cubes)

about

creating from star schema tables

creating OLAP cubes from detailed data

designing cube structure

geographic locations

time

distribution lists, global alerts

DSX files

dynamic lists

dynamic prompts

dynamically populating list of available values

E

Edit Filter window

Edit Image window

Edit Indicator Alerts window

Edit Page Content window

Edit Prompt window

Dependencies tab

General tab

Prompt Type and Values tab

editing report schedules

emails for alerts

Enterprise Guide

about

administrator tasks

application window

creating prompts

filtering information maps

information maps

OLAP Cube Explorer

prerequisites

project prompts

stored processes

tips and tricks

ESRI ArcCatalog

ESRI ArcMap

ESRI map component

Excel (Microsoft)

See Microsoft Excel

Export Code window

Export/Import wizard

exporting code from OLAP Cube Studio

expression editor

CASE statements

creating data items

F

fact tables

file or directory prompt type

files

about

central storage file system

pointing to

setting default server-side folder for

Files folder

filters

client-side versus server-side

creating for reports

cutting/pasting values into

date

for Excel data

for information maps

functions

identity-based

indicator data

making optional

setting up information map prefilters

Filters window

folders

creating

dashboard organization

naming conventions

setting default server-side

setting up shared prompt structure

font styles and sizes for dashboards

Format catalog

FORMAT procedure

formats

custom

storage location for

fully summarized tables (data source)

functions, filters

G

GEO dimension type

Get Values window

GIF image type

GIS Maps Definition window

global alerts

global macro variables

about

stored processes

%global statement

Goal-Question-Metric paradigm

GOPTIONS statement

HSIZE option

VSIZE option

graphs, adding to Excel worksheets

grid layouts

group breaks

about

assigning to stored process prompts

controlling multiple objects with

Group Breaks window

group content administrators

grouping data

grouping prompts

See prompt groups

H

hierarchies (OLAP cubes)

about

creating OLAP cubes from detailed data

designing cube structure

time dimensions

unbalanced or ragged

Hierarchy data item

highlighting, conditional

HOLAP storage technique

HSIZE option (GOPTIONS statement)

HTML code in stored processes

hyperlinks

creating

quick reference for prompts

I

identity-based filters

identity properties

images, adding to reports

importing data from BI Server

indicators

creating custom

creating for dashboards

creating interactions between

custom displays with stored processes

enabling personal alerts for

filtering

font styles and sizes

simulating prompts

stored processes as indicator data

width and height settings

INFOMAP procedure

Infomap.dsx file

Information Delivery Portal

about

administrator tasks

checking stored process status

creating portal pages

displaying alerts

enhancing portals

portlet overview

prerequisites

publishing data and results

tips and tricks

Information Map Studio

about

administrator tasks

creating dashboards with cascading prompts

creating information maps

enhancing information maps

prerequisites

prompts

roles and responsibilities

tips and tricks

information maps

about

adding custom formats

adding custom measures to reports

adding filters

adding prompts

allowing value-generation for prompts

CASE statements

creating

creating data items

creating filters for

creating identity-based filters

enabling caching for

enhancing

filtering

integrating stored processes with

joining tables

OLAP cube sort order

opening

organizing metadata folder structure

prompt groups

prompts for web reports

repairing broken

selecting and organizing data sources

setting up prefilters

shared prompts

sharing optional prompts

sourcing with OLAP cubes

testing

using templates with

web report group break example

web reports

Intelligence Platform

INTNX function

J

joining tables

JPEG image type

L

%LET statement

levels (OLAP cubes)

LIBNAME statement

libraries, metadata

See metadata folders/libraries

librefs

line graphs

linking

dashboards to stored processes

dashboards to web reports

web reports with prompts

List Report wizard

building reports with SAS tasks

Define List page

Provide Title and Footnote page

Specify Totals page

lists, dynamic

log files

logos, adding to reports

M

macro language

global macro variables

integrating multiple selection prompts into stored processes

macro logic

macro variables

quotation marks

macro variables

about

global

macro logic

prompting framework

quotation marks

Manage Content window

Manage Prompts window

Management Console

about

adding images and logos to reports

alert emails

allowing limited access

Authorization Manager plug-in

dashboard organization

enabling caching

establishing group administrators

establishing publication channels

Export/Import wizard

member-level security

modifying library options

New Stored Process wizard

prompt groups

prompting

ReadMetadata access

roles and responsibilities

Schedule Manager plug-in

scheduling OLAP cube refresh

setting default server-side file folder

shared prompt access requirements

User Manager plug-in

MDX (multidimensional expressions)

Measure data item

measures (OLAP cubes)

about

custom

designing cube structure

member-level security (Management Console)

members (OLAP cubes)

META librefs

metadata folders/libraries

about

access considerations

defining

organizing

physical paths

registering for stored processes

synchronizing changes

updating

Metadata Server

about

Add-In for Microsoft Office

connecting to

creating profiles

Information Map Studio

referential integrity

viewing the environment

%_METAFOLDER reserved macro variable

Microsoft Excel

about

accessing OLAP cubes

building charts with SAS tasks

building reports with SAS tasks

copying modified data to SAS server

creating reports in

enhancing reports

filtering and sorting data

importing data from BI Server to

Ribbon depicted

security considerations

sharing results with other applications

Microsoft Office

Microsoft Outlook

about

Gadget Pane

SAS Central

SAS reports

sharing reports with others

Microsoft PowerPoint

Microsoft Word

missing data, adjusting settings for

Modify access

Modify Data Source window

Modify Profile window

MOLAP storage technique

MONTH() function

multidimensional expressions (MDX)

N

n-way summary

naming conventions

Navigator portlets

New Filter window

New Group window

New Library wizard

New Member window

New Prompt window

Dependencies tab

General tab

Prompt Type and Values tab

New Stored Process window

New Stored Process wizard

setting up source code repository

shared prompting

no_bottom_matter option (ODS HTML statement)

no_top_matter option (ODS HTML statement)

numeric prompt type

numeric range prompt type

NUNIQUE function

NWAY aggregation

O

ODS HTML statement

no_bottom_matter option

no_top_matter option

ODS options

_ODSDEST option

_ODSOPTIONS option

_ODSSTYLE option

OLAP Creator group

OLAP Cube Explorer

about

adding conditional highlighting

creating custom measures

opening OLAP cubes

setting OLAP cube bookmark

OLAP Cube Studio

about

about OLAP cubes

administrator tasks

Aggregation Tuning module

creating OLAP cubes

enhancing OLAP cubes

exporting code from

Inventory tab

maintaining OLAP cubes

prerequisites

OLAP Cube Viewer

OLAP Cube Viewer window

OLAP cubes

about

accessing from Excel

adding custom measures to reports

adding geographic locations

adding time dimensions

aggregation

creating

creating from detailed data

creating from star schema tables

creating your first

designing structure

enhancing

flavors of

linking reports with prompts

maintaining

opening

querying to allow for prompting

Report Wizard

scheduling refresh

security considerations

setting bookmarks

sort order and information maps

sourcing information maps

structure overview

terminology for

updating in-place

web reports

OLAP procedure

OLAP role

OLAP schemas, granting access to

OLAP Server

OLAPOPERATE procedure

omr.dsx file

Open Data Source window

Open Information Map window

opening information maps

opening OLAP cubes

Outlook (Microsoft)

See Microsoft Outlook

output devices

choosing

publishing results to multiple

P

package output

page tabs, changing order of

passwords, stored

permanent output

personal alerts

Pivot Table wizard

pivot tables (Excel)

populating list of available values

dynamically

using data tables

portal pages

about

accessing without logging in

adding bookmarks to

adding new

adding new content to

adding previously created portlets

adding Report portlets

changing layout of

changing page tab order

creating

enhancing

portlets

about

adding previously created

adjusting size of

Alerts

Collection

controlling

Dashboard

for bookmarks

Navigator

Report

Stored Process

Stored Process Alerts

URL

WebDAV Navigator

PowerPoint (Microsoft)

preferences, specifying for reports

Preferences window

prefilters for information maps

*ProcessBody special code

processes, stored

See stored processes

profiles, creating

Profiles list (Enterprise Guide)

program execution, choosing location of

Programming role

project prompting

See also prompting framework

about

applying prompts to queries

grouping restrictions

stored processes

viewing prompts

promotion notes

prompt groups

about

creating

creating for Web Report Studio

group types

information maps

selection groups

Prompt Manager window

Prompt Value Specification window

prompting framework

about

adding prompts to information maps

administrator tasks

building cascading prompts

dependencies between prompts

dynamic prompts

indicator interactions simulating prompts

integrating selection prompts into stored processes

linking reports with prompts

project prompting

prompt groups

prompts from information maps for web reports

querying OLAP cubes

quick reference

selection groups

shared prompts

sharing optional prompts in information maps

stored processes

tips and tricks

usage examples

value-generation prompts

Properties window

bar charts

dashboards

data items

global alerts

identity-based filters

indicators

information maps

OLAP cubes

OLAP schemas

OLAP Server

portlets

shared prompts

stored processes

table joins

Workspace Server

Public Kiosk

publication channels

establishing

modifying

publishing data and results

subscribing to

Publish to the Enterprise wizard

publishing results to multiple devices

pull environments

push environments

Q

queries

applying prompts to

performance considerations

to OLAP cubes to allow for prompting

Query Builder

quick reference for prompts

quotation marks (")

R

ragged hierarchies

RDBMS (relational database management system)

Read access

ReadMetadata access

reference for prompts

referential integrity for Metadata Server

refreshing

OLAP cubes

web reports

registering stored process metadata

relational database management system (RDBMS)

Relationship Properties window

Report Linking window

Report portlets

REPORT procedure

Report Wizard

reports and reporting tools

See also web reports

See also specific tools

repository, source code

resizing dashboards

Resource Replacement feature

ROLAP storage technique

roles (Enterprise Guide)

S

SAS Add-In for Microsoft Office

See Add-In for Microsoft Office

SAS Application Servers

SAS BI Dashboard

See BI Dashboard

SAS BI Server

importing data from

modifying data on

SAS Business Intelligence

See BI (Business Intelligence)

SAS Central

SAS Enterprise Guide

See Enterprise Guide

SAS Information Delivery Portal

See Information Delivery Portal

SAS Information Map Studio

See Information Map Studio

SAS Intelligence Platform

SAS Management Console

See Management Console

SAS Metadata Server

See Metadata Server

SAS OLAP Cube Studio

See OLAP Cube Studio

SAS Portal window

SAS server, copying modified data to

SAS stored processes

See stored processes

SAS tasks

building Excel charts with

building reports with

SAS data with Excel charts

SAS Trusted User identity

SAS Web Report Studio

See Web Report Studio

SASApp Application Server

SAS.ExternalIdentity identity property

SASGUEST user

SAS.IdentityGroups identity property

SAS.IdentityName identity property

SASMeta Application Server

SAS.PersonName identity property

SASSRV account

SASUSER group

SAS.UserId identity property

Schedule Manager plug-in (Management Console)

scheduling

OLAP cube refresh

web reports

security

allowing limited access to Management Console

Excel considerations

OLAP cubes

organizing metadata folder structure

shared prompt access requirements

shared prompt folder structure

SECURITY_SUBSET option

selection groups

Server List window

server-side filters

Set Up Indicator Interactions window

Set Up Link window

shared prompts

about

access limitations

access requirements

creating

making optional

setting up central starting point

setting up folder structure for

stored processes

tools supporting

usage considerations

sharing reports

snowflake schema

sorting

customizing for web reports

Excel data

OLAP cubes

source code repository

spark table

.spk files

SQL procedure

%_SRVNAME reserved macro variable

%_SRVPORT reserved macro variable

standard groups

star schema tables (data source)

about

adding dimensions with

creating OLAP cubes from

defining

SQL views

storage considerations

bookmarks

central storage file system

formats

OLAP cubes

stored passwords

Stored Process Alerts portlets

Stored Process portlets

Stored Process Server

Stored Process Web Application Tree view

Stored Process wizard

stored processes

about

accessing

adding special codes

administrator tasks

as custom indicator displays

as indicator data

chaining

changing codes

checking status of

choosing servers

creating

creating web reports

creating your first

enabling caching for

enhancing output for

HTML code usage in

integrating

integrating multiple selection prompts into

linking dashboards to

methods for using prompts

overriding result formats for

prerequisites

prompt groups

registering metadata

running

running in background

tips and tricks

viewing results

web report group break example

%STPBEGIN macro variable

about

adding

creating custom indicators

warning message about

stp.dsx file

%STPEND macro variable

about

adding

creating custom indicators

warning message about

streaming output

See also stored processes

Style Editor

Style Manager window

styles

about

customizing

modifying

stored process output

viewing available

subscribing to channels

SUBSTR function

SUMMARY procedure

synchronizing

code to processes

metadata library changes

T

tables

See data tables

tasks (SAS)

building Excel charts with

building reports with

SAS data with Excel charts

templates

creating

information maps

Test the Information Map window

testing

information maps

prompts within dashboard viewer

text prompt type

text range prompt type

TIF image type

time dimension type

time prompt type

time range prompt type

time-series functions

timestamp prompt type

timestamp range prompt type

tips and tricks

Add-In for Microsoft Office

BI Dashboard

Enterprise Guide

Information Delivery Portal

Information Map Studio

prompting framework

stored processes

Web Report Studio

TITLE2 statement

TODAY() function

traffic lighting

transient output

transparent groups

U

unbalanced hierarchies

Unchallenged Access User account

Update Library Metadata window

updating OLAP cubes in-place

URL portlets

User Manager plug-in (Management Console)

V

value-generation prompts

variable prompt type

View Manager (Excel)

View SAS Data window

viewing tools

See also specific tools

VSIZE option (GOPTIONS statement)

W

Web Report Studio

about

administrator tasks

creating prompts

creating web reports

custom output in

enhancing web reports

information maps

linking dashboards to

prerequisites

prompt groups

report data overview

roles and responsibilities

tips and tricks

web reports

about

adding conditional highlighting

adding custom measures to

adding data to

adding images

adding logos

bar charts in

controlling multiple objects with group breaks

creating

creating custom sort order for

creating filters for

creating templates

crosstabulation tables in

customizing

data items for

data sources for

developing for wide consumption

distributing

enhancing

grouping data

inserting artwork into

line graphs in

linking dashboards to

linking with prompts

portlets supporting

prompts from information maps for

Report Wizard with OLAP cubes

scheduling

selecting color schemes

specifying preferences for

using templates with information maps

WebDAV location

WebDAV Navigator portlets

WHERE statement

assigning prompts to stored processes

creating SAS programs

integrating multiple selection prompts into stored processes

Word (Microsoft)

WORK folder

Workspace Server

Write access

WriteMemberMetadata access

WriteMetadata access

accessing information maps

accessing OLAP schemas

creating OLAP cubes

establishing group administrators

Y

YEAR() function