BO Hintz Old

Class Group of individual Objects

Object refer to column of data

Universe Designer table maps to form fields to object in the universe

Joins more than one table in a report

Context resolves which join path

Aliases resolve the loops

Measure aggregate form

Dimension textual information

LOV associated with an object in the universe

Advanced objects SQL editor

Prompt interactive objects

Cascading Prompts means one prompt depends on another prompt..

Alters type of formatting

Break Table into multiple pieces

Row level security - table mappings to provide another way to implement

Object level security -
Private controlled Restricted Public Confidential

Type of provides –
Free Hand SQL Personal Data files Stored procedures VB Macros OLAP

Date Formula- = Format Date ((ToDate,"YYYY-MM-DD"),"DD-MM-YYYY")


Users-
General Supervisor Supervisor Designer Supervisor Designer User Versatile user

BCA Scheduling the reports - Hourly /Daily / Weekly / Monthly

General Actions Categories Scheduling Distribution

Send to BCA –
Which Server / Action / Locate Destination /Task scheduling /Distribution

Eport as-
HTML File / Report(BO) / Via BO / PDF / Excel
Repository

Universe Design Quick Design Wizard Universe Name must be 8 characters

Definition /Summary /Strategies/Control/SQL/Links / Parameter

Definition DSN, Personal / Shared / Secured

Summary Table / Join / Aliases / Conditions (Predefined)

Strategies Objects/Joins/Tables (select from drop down list)

Control Limit-Size/Execution/Text Object Size

SQL Query/Cartesian/Multiple points

Link Universe

Parameter Database SQL Parameters Parameters and property

Universe Customization

Universe Pane Edit Properties (Definition Properties Advanced)

Definition
-> Name - Type Description Select Where sum
Properties
-> Qualification-Associate a List of Values (Dimension Measure Detail)
Edit Select statement of Objects…

Tables & Columns Class & Objects Operators Function

Report Creation: Report Wizard –


Data Access Specification - Universe or Others

Others
– Free Hand SQL Personal Data files Stored procedures VB Macros OLAP

Query Panel –
Right Side Class & Objects Left Side Result Objects & Conditions Run Query

Slice & Dice
- Analyzing Data / Sort information / Filtering, grouping, calculation of groups

Filter Ranking Alters SQL View Sorter Sum