Hyperion Designer
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Hyperion Designer as PDF for free.
More details
- Words: 469
- Pages: 36
Designer Study Notes
Features }
S Support t for f allll iindustry-standard d t t d dd databases t b
}
Extensive formatting tools
}
Graphically displaying
}
Drilling-down Drilling down into data
Prepared by [email protected]
P. 2
Process
Prepared by [email protected]
P. 3
User Interface
Prepared by [email protected]
P. 4
Standard Toolsbar
Prepared by [email protected]
P. 5
Formatting Toolbar
Prepared by [email protected]
P. 6
Status
Prepared by [email protected]
P. 7
Save Query Results with Document }
Make M k sure that th t the th allll off the th items it iin th the Q Query, R Results lt and d th the Computed Columns lists are selected, and then click OK.
Prepared by [email protected]
P. 8
Sorting Columns
Prepared by [email protected]
P. 9
Limiting Data
Prepared by [email protected]
P. 10
Pivot
Prepared by [email protected]
P. 11
Drill Anywhere
Prepared by [email protected]
P. 12
Adding Color
Prepared by [email protected]
P. 13
Chart
Prepared by [email protected]
P. 14
Report
Prepared by [email protected]
P. 15
Smart Report
Prepared by [email protected]
P. 16
Import
Prepared by [email protected]
P. 17
Export }
S ti Section — Dashboard — Results — Reports
Prepared by [email protected]
Î Î Î
JPEG File unaggregated data aggregated data
P. 18
Send
Prepared by [email protected]
P. 19
Page Header
Prepared by [email protected]
P. 20
Query
Prepared by [email protected]
P. 21
Regular Subquery }
who h sold ld more th than th the average off allll sales l representatives? t ti ?
Prepared by [email protected]
P. 22
Preaggregating
Prepared by [email protected]
P. 23
Merge Queries
Prepared by [email protected]
P. 24
Results
Prepared by [email protected]
P. 25
Total }
C l Column T Totals t l
}
Grand Totals
}
Break Totals
Prepared by [email protected]
P. 26
Grouping Columns
Prepared by [email protected]
P. 27
Query Multidimensional Database
Prepared by [email protected]
P. 28
OLAP Query Options
Prepared by [email protected]
P. 29
Build OLAP Query } }
}
}
A dimension di i can b be represented t d only l on one axis. i To pivot data in the OLAPQuery section, move the items in the O tli Outliner panes. Levels from the same dimension must be grouped together in both the Side Labels and Top Labels panes panes. The hierarchy of a dimension cannot be broken.
Prepared by [email protected]
P. 30
Limits
Prepared by [email protected]
}
q ((=)) Equal
}
Not Equal (<>)
}
Less Than (<)
}
Less or Equal (<=)
}
Greater Than (>)
}
Greater or Equal (>=)
}
B i With Begins
}
Contains
}
Ends With
}
Like
}
Is Nul
}
Between
}
Not P. 31
Compound Limit
Prepared by [email protected]
P. 32
Variable Limit
Prepared by [email protected]
P. 33
Customize Limit
Prepared by [email protected]
P. 34
Computed Items
Prepared by [email protected]
P. 35
Operators Arithmetic
Comparison
Statements
Logical
Prepared by [email protected]
P. 36
Features }
S Support t for f allll iindustry-standard d t t d dd databases t b
}
Extensive formatting tools
}
Graphically displaying
}
Drilling-down Drilling down into data
Prepared by [email protected]
P. 2
Process
Prepared by [email protected]
P. 3
User Interface
Prepared by [email protected]
P. 4
Standard Toolsbar
Prepared by [email protected]
P. 5
Formatting Toolbar
Prepared by [email protected]
P. 6
Status
Prepared by [email protected]
P. 7
Save Query Results with Document }
Make M k sure that th t the th allll off the th items it iin th the Q Query, R Results lt and d th the Computed Columns lists are selected, and then click OK.
Prepared by [email protected]
P. 8
Sorting Columns
Prepared by [email protected]
P. 9
Limiting Data
Prepared by [email protected]
P. 10
Pivot
Prepared by [email protected]
P. 11
Drill Anywhere
Prepared by [email protected]
P. 12
Adding Color
Prepared by [email protected]
P. 13
Chart
Prepared by [email protected]
P. 14
Report
Prepared by [email protected]
P. 15
Smart Report
Prepared by [email protected]
P. 16
Import
Prepared by [email protected]
P. 17
Export }
S ti Section — Dashboard — Results — Reports
Prepared by [email protected]
Î Î Î
JPEG File unaggregated data aggregated data
P. 18
Send
Prepared by [email protected]
P. 19
Page Header
Prepared by [email protected]
P. 20
Query
Prepared by [email protected]
P. 21
Regular Subquery }
who h sold ld more th than th the average off allll sales l representatives? t ti ?
Prepared by [email protected]
P. 22
Preaggregating
Prepared by [email protected]
P. 23
Merge Queries
Prepared by [email protected]
P. 24
Results
Prepared by [email protected]
P. 25
Total }
C l Column T Totals t l
}
Grand Totals
}
Break Totals
Prepared by [email protected]
P. 26
Grouping Columns
Prepared by [email protected]
P. 27
Query Multidimensional Database
Prepared by [email protected]
P. 28
OLAP Query Options
Prepared by [email protected]
P. 29
Build OLAP Query } }
}
}
A dimension di i can b be represented t d only l on one axis. i To pivot data in the OLAPQuery section, move the items in the O tli Outliner panes. Levels from the same dimension must be grouped together in both the Side Labels and Top Labels panes panes. The hierarchy of a dimension cannot be broken.
Prepared by [email protected]
P. 30
Limits
Prepared by [email protected]
}
q ((=)) Equal
}
Not Equal (<>)
}
Less Than (<)
}
Less or Equal (<=)
}
Greater Than (>)
}
Greater or Equal (>=)
}
B i With Begins
}
Contains
}
Ends With
}
Like
}
Is Nul
}
Between
}
Not P. 31
Compound Limit
Prepared by [email protected]
P. 32
Variable Limit
Prepared by [email protected]
P. 33
Customize Limit
Prepared by [email protected]
P. 34
Computed Items
Prepared by [email protected]
P. 35
Operators Arithmetic
Comparison
Statements
Logical
Prepared by [email protected]
P. 36
Related Documents
Hyperion Designer
October 2019 25
Designer
July 2020 24
Designer
October 2019 47
Designer
November 2019 42
Hyperion Theater
April 2020 22