Stored Processes
OLAP Cubes
Potpourri
100
What is a SAS application that can be used to create, register, and execute stored processes?
Enterprise Guide
100
What are the data values in a cube that can be summarized and analyzed, e.g. average sales or total costs?
Measures
100
True or False: Multiple measures can be displayed at the same time using the OLAP Analyzer in Enterprise Guide?
True
200
What is a SAS program stored on a server that can be accessed from many of the SAS Platform applications, including the Add-In for Microsoft Office?
Stored Process
200
What can be used as a data source in an information map, in addition to SAS data sets and third-party databases?
OLAP Cube
200
What is the action of viewing the detail data for an OLAP cube (base table) from the client application?
Drill through
300
What are the options that enable users to make a selection that controls the output of a stored process?
Parameters
300
What are three applications from which SAS OLAP cubes can be viewed?
Enterprise Guide, Add-In for Microsoft Office, and Web OLAP Viewer for Java
300
What is a component on a Portal page in which content and links to content are displayed?
What is a portlet?
400
What are the three steps to create a stored process?
Write the program, register the stored process, test
400
What is the order of the levels of detail within a dimension, which allow users to navigate "up and down" a cube?
Hierarchy
400
What is used to organize parameters and is useful when there are many parameters because it makes the parameter dialog box less crowded?
Parameter groups
500
What are the two SAS servers that can execute a stored process?
Workspace and Stored Process Servers
500
What are (at least) two possible actions for navigating a hierarchy from a given level?
Drill up and drill down, isolate, remove, expand, or drill through
500
What are the four ways to create a report in Web Report Studio?
Quick Report, Wizard, Template, and Report Editor
M
e
n
u