Solutions 7

Solutions 7

Documents
308 pages
Lire
Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

Description

  • cours magistral - matière potentielle : notes
  • cours magistral
ITET Analysis III HS 2011 A. Cannas da Silva Solutions 7 1. 1. We change variable and obtain ∫ 5 1 δ(x)(x+ 3)2dx, then the definition can be applied and gives zero, since the point x = 0 is not in the interval ]1, 5[. 2. We use the definition of the distributional derivative and obtain − ∫∞ −∞ δ(x − pi) cosxdx = 1.
  • direction perpendi- cular to the boundary line
  • green function of the upper half plane
  • start with the wanted equation for distribu- tions
  • function

Sujets

Informations

Publié par
Nombre de visites sur la page 15
Langue English
Signaler un problème

®Oracle Sales Analyzer
Administrator’s Guide
Release 11i
June 2001
A87517-01Oracle Sales Analyzer Administrator’s Guide, Release 11i
A87517 01
Copyright © 1996, 2001 Oracle Corporation. All rights reserved.
The Programs (which include both the software and documentation) contain proprietary information of
Oracle Corporation; they are provided under a license agreement containing restrictions on use and
disclosure and are also protected by copyright, patent, and other intellectual and industrial property
laws. Reverse engineering, disassembly, or decompilation of the Programs is prohibited.
The information contained in this document is subject to change without notice. If you find any problems
in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this
document is error free. Except as may be expressly permitted in your license agreement for these
Programs, no part of these Programs may be reproduced or transmitted in any form or by any means,
electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.
If the Programs are delivered to the U.S. Government or anyone licensing or using the Programs on
behalf of the U.S. Government, the following notice is applicable:
Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial
computer software" and use, duplication, and disclosure of the Programs, including documentation,
shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.
Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer
software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR
52.227 19, Commercial Computer Software Restricted Rights (June, 1987). Oracle Corporation, 500
Oracle Parkway, Redwood City, CA 94065.
The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently
dangerous applications. It shall be the licensee’s responsibility to take all appropriate fail safe, backup,
redundancy, and other measures to ensure the safe use of such applications if the Programs are used for
such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the
Programs.
Oracle is a registered trademark, and Express is a trademark or registered trademark of Oracle
Corporation. Other names may be trademarks of their respective owners. Contents
Send Us Your Comments .................................................................................................................. ix
Preface............................................................................................................................................................ xi
Conventions.......................................................................................................................................... xiv
Documentation Accessibility ............................................................................................................. xv
1 Introduction to Oracle Sales Analyzer
The Analyzer Product Family........................................................................................................... 1-2
Database Configurations................................................................................................................... 1-3
Thick Client Access Mode ................................................................................................................ 1-5
Thin Client .................................................................................................................. 1-7
Issues for Thick and Thin Client Access........................................................................................ 1-9
Web Client Access Mode................................................................................................................. 1-10
2 Your Role as Administrator
Summary of Tasks............................................................................................................................... 2-2ry of Tools............................................................................................................................... 2-3
Relational Access Administrator ..................................................................................................... 2-4
Batch Manager..................................................................................................................................... 2-5
Express .................................................................................................................................................. 2-6
Analyzer Web Administrator ......................................................................................................... 2-10
Application Manager ...................................................................................................................... 2-11
Database Manager ............................................................................................................................ 2-12
Analyzer.............................................................................................................................................. 2-14
iiiTools for Troubleshooting ............................................................................................................... 2-15
3 Building the Database
Measures, Variables, and Formulas................................................................................................. 3-2
Dimensions ............................................................................................................................... ........... 3-3
Levels and Hierarchies....................................................................................................................... 3-6
Attributes.............................................................................................................................................. 3-9
Data Access........................................................................................................................................... 3-9
The Build Process.............................................................................................................................. 3-11
4 Working With Express Databases and Catalogs
Working with Express Databases .................................................................................................... 4-2
Remote Express Databases................................................................................................................ 4-3 Personal Databases .............................................................................................................. 4-4
Local Express Databases .................................................................................................................... 4-6
Working with Catalogs ...................................................................................................................... 4-7
Catalogs in the Server Database ...................................................................................................... 4-8
Catalogs in the Catalog Database .................................................................................................... 4-8
Integrated Catalogs............................................................................................................................. 4-9
5 Setting Up Database Access for a Windows Client
General Instructions for Database Setups ..................................................................................... 5-2
Creating a Configuration File........................................................................................................... 5-6
Selecting an Access Mode ................................................................................................................. 5-9
Specifying the Database Path for a Slice...................................................................................... 5-11
Maintaining a Shell Database ........................................................................................................ 5-12
Setting Up Login to the Database or to a Relational Manager ................................................ 5-15
Creating an Icon to Start a Database ............................................................................................. 5-19
Setting Up a Workstation User Name ........................................................................................... 5-22
Changing the Default Directory for Thin Client Publish to File ............................................ 5-24
6 Setting Up Communications for a Windows Client
General Instructions for Communications Setups....................................................................... 6-2
Communications Setups for Thick Client Access ........................................................................ 6-3
ivCommunications Setups for Thin Client Access.......................................................................... 6-5
7 Setting Up Database Access for Web Users
About Web Access .............................................................................................................................. 7-2
Defining Virtual Directories in the Web Listener........................................................................ 7-3
Implementing Web Security............................................................................................................. 7-3
Implementing Single Sign-on.......................................................................................................... 7-4
Setting Up the Analyzer Home Page .............................................................................................. 7-7
Customizing the Web Application ................................................................................................ 7-18
Providing Web Access to Users...................................................................................................... 7-20
8 Managing User Access to a Remote Database
Implementing Access to Remote Databases.................................................................................. 8-2
Creating and Maintaining User Groups......................................................................................... 8-5
Creating and Maintaining Users...................................................................................................... 8-9
Importing User Names from Oracle Applications ..................................................................... 8-12
Creating, Maintaining, and Populating Libraries ...................................................................... 8-13
9 Scoping a Database
Overview of Scoping.......................................................................................................................... 9-2
Defining Data Cubes ......................................................................................................................... 9-3
Copying Data Cubes .......................................................................................................................... 9-6
Defining Scopes.................................................................................................................................. 9-7
Enabling Scoping.............................................................................................................................. 9-12
Associating Scopes with User Groups.......................................................................................... 9-12
Refreshing Scopes for a Shared Shell........................................................................................... 9-13
Modifying Scopes............................................................................................................................. 9-14
Removing Scopes.............................................................................................................................. 9-14
10 Building a Slice
General Instructions for Building a Slice .................................................................................... 10-2
Defining a Slice................................................................................................................................. 10-3
Creating a Slice Directly.................................................................................................................. 10-8
Creating a Slice from Files ............................................................................................................ 10-10
vGeneral Instructions for Updating a Slice ................................................................................. 10-13
Updating a Slice Directly .............................................................................................................. 10-14
Updating a Slice from Files........................................................................................................... 10-16
Upgrading a Slice............................................................................................................................ 10-17
11 Customizing a Database
Using Dimension Abbreviations in Customizations................................................................. 11-2
Providing Custom Names ............................................................................................................... 11-2
Changing Level Names.................................................................................................................... 11-6
Providing Permanent Custom Aggregates and Measures ........................................................ 11-8
Hiding Measures............................................................................................................................. 11-13
Enabling Prior and Year-Ago Time Aggregates ........................................................................ 11-14
Modifying Aggregation Methods................................................................................................ 11-15
Configuring Databases for Forecasting...................................................................................... 11-21
Adjusting for Fluctuations in Time............................................................................................. 11-22
Defining the Latest Time Period.................................................................................................. 11-23
Modifying Translation Tables ...................................................................................................... 11-26
12 Controlling the Display of Data
Attributes for Displaying Measure Values .................................................................................. 12-2
Formatting Measure Values ............................................................................................................ 12-3
Installing Measure Value Formats................................................................................................. 12-6
Changing the Order of Dimension Values .................................................................................. 12-9
Setting Dimension Value Limits.................................................................................................. 12-11
Specifying Default Documents.................................................................................................... 12-15
13 Customizing the Client Interface
Customizing Menus and the Toolbar............................................................................................ 13-2
Managing Customizations .............................................................................................................. 13-7
Installing Custom Help ................................................................................................................... 13-8
Installing a Custom Application.................................................................................................. 13-11
Using Languages Other Than English ....................................................................................... 13-13
viA Catalog Descriptions
AG.CATALOG (Custom Aggregate Catalog) ................................................................................ A-2
AP.CATALOG (Applications Catalog)............................................................................................ A-4
CA.CATALOG (Custom Analysis Catalog) ................................................................................... A-5
CO.CATALOG (Component Catalog)............................................................................................. A-5
DA.CATALOG (Data Catalog) ......................................................................................................... A-7
DACAT (Data Catalog) .................................................................................................................... A-11
DF.CATALOG (Data Format Catalog)........................................................................................... A-15
DI.CATALOG (Display Catalog) ................................................................................................... A-17
DMCAT (Dimension Catalog)........................................................................................................ A-19
DV.CATALOG (Data Cube or Data View Catalog) .................................................................... A-20
FC.CATALOG (Forecast Catalog) .................................................................................................. A-21
FD.CATALOG (Folder Catalog) ..................................................................................................... A-23
GP.CATALOG (Group Catalog) ..................................................................................................... A-24
GR.CAT (Graph Catalog) .................................................................................................... A-25
INCAT (Infer Catalog) ..................................................................................................................... A-26
MP.CATALOG (Map Catalog) ........................................................................................................ A-27
MRCAT (Measure Catalog)............................................................................................................. A-28
MX.CATALOG (Maximum Values Catalog)................................................................................ A-30
OP.CATALOG (User Option Catalog)........................................................................................... A-33
SC.CATALOG (Slice Catalog) ........................................................................................................ A-33
SG.CATALOG (Segment Catalog)................................................................................................. A-35
SL.CATALOG (Saved Selection Catalog)..................................................................................... A-36
SO.CATALOG (Source Catalog) .................................................................................................... A-37
SOCAT (Source Catalog) ................................................................................................................. A-38
SP.CATALOG (Scope Catalog) ....................................................................................................... A-40
TB.CATALOG (Report or Table Catalog)..................................................................................... A-40
UR.CATALOG (User Catalog) ........................................................................................................ A-42
B Initialization Files
Overview of Initialization Files....................................................................................................... B-2
Application Manager (APPMGR.INI)............................................................................................ B-2
Analyzer (ANALYZER.INI) .............................................................................................................. B-8
Database Manager (DBMANAGE.INI)........................................................................................ B-14
viiC RDC File
Overview of RDC File........................................................................................................................ C-2
RDC File Functions ............................................................................................................................ C-2
Example: RDC File.............................................................................................................................. C-2
Index
viiin
n
n
n
n
n
n
Send Us Your Comments
Oracle Sales Analyzer Administrator’s Guide, Release 11i
A87517-01
Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this
publication. Your input is an important part of the information used for revision.
Did you find any errors?
Is the information clearly presented?
Do you need more information? If so, where?
Are the examples correct? Do you need more examples?
What features did you like most about this manual?
If you find any errors or have any other suggestions for improvement, please indicate the chapter,
section, and page number (if available). You can send comments to us in the following ways:
FAX - 781-684-5880. Attn: Oracle Sales Analyzer
Postal service:
Analytic Solutions Documentation Manager
Oracle Corporation
200 Fifth Avenue
Waltham, MA 02451-8720
USA
If you would like a reply, please give your name, address, and telephone number below.
If you have problems with the software, please contact your local Oracle Support Services.
ixx