Training Services

Administrator Training Course Printer Version

Audience

This course is designed for administrators who want to configure Futrix for Business Intelligence.

Course Description

This one-day course focuses on using the Futrix Administrator management console to configure the Futrix system.

Prerequisites

You should be competent in the use of the Futrix end user environment to the level presented in the Futrix User Training course.

No knowledge of SAS software is required to successfully complete the core of this course. However, it would be useful to have attended the SAS Programming 1 course to understand some Futrix Administration concepts.

Objectives

When you have completed this course you should be able to:

Initial Set Up

install and invoke Futrix
update the Futrix license key
understand "libraries" and "library references"

Library & Installation Management

broadly understand the purpose of each core Futrix library
add and remove your own library references
set up scripts to run on Futrix initialization

SAS Integration

set up integration with SAS Metadata Server, SAS OLAP Server and SAS Stored Processes
link to third party DBMS's via SAS/Access products

Promotion Management

describe the Futrix system areas which can be split into development, test or production environments
set up promotion control
control the promotion from development to test and from test to production

Format Management

define search paths for formats (local & remote servers)
add, remove and modify measure formats
understand the different types of dimension formats that can be created and maintained in Futrix
add, remove and modify dimension formats

Metabase Management

read and understand the contents of the metadata matrix
add new subjects and register new data
edit existing meta–items, dimensions, measures
import and export meta–items
select the metadata matrix attributes for display
perform formatted grouping chagen management
handle personal alerts and alert processing

Menu Management

add, remove and restructure items within the menu
add, edit or delete menu groups
understand the relationship between the metabase and menu items
understand the different ways of saving reports to the main menu
set up the holding location for global requests
manage submitted global requests

General Security

understand security uses and Futrix security roles
create and edit security roles
modify general Futrix security settings and password requirements

User Registration and Restricted Access

add, edit and delete users and groups
create reports about security group membership and user attribute settings
restrict access to Futrix elements such as dimensions, measures, menu items
restrict access to dimension values (row level security)
restrict access to Futrix functionality
restrict access and set Futrix preferences

End User Interface Management

understand and edit Futrix user types
restore the original settings for user types
set default preferences for all Futrix users
add new commands to the Futrix environment
customize the items on the menu bar and toolbar
change the behavior and items in the pop-up menu
change how double-clicks are interpreted in viewpoints
customize a web skin

Secondary Data Sources

specify secondary data sources within Futrix
create a summary data set as a secondary data source
understand how cubes store data and when to use them
create a cube from within Futrix
save the source code to create a cube independently
minimize the volume of a cube with many dimensions

Tracking & Performance Management

create pre–calculated stored cache to speed up response times of user reports
set up and update the tracking analysis data
use the pre–defined tracking viewpoints to analyze users' actions and queries

General Futrix Administration

understand administration locking
remove locks if they are no longer in use

Static Publishing (Optional)

understand static publishing groups
understand "By Group" dimensions and how to use them
publish static reports

Client/Server Manager (Optional)

register a remote server within Futrix
understand remote library references and remote formats