H5 – Multidimensional Reporting

A specialist course on multidimensional data sources and dimensional report authoring. Topics include members, member sets, MUNs, slicers, set functions, drill behavior and drill-through.

Chapters and lessons

H5-01 Fundamentals

• H5-01-1 Fundamentals of dimensional reporting
• H5-01-2 Insert options and drill-down
• H5-01-3 Drill-up, expanding and collapsing members
• H5-01-4 Members and member sets 1
• H5-01-5 Members and member sets 2

H5-02 Navigation

• H5-02-1 Member Unique Names (MUNs)
• H5-02-2 Family functions: quarterly report
• H5-02-3 Set, item and tuple

H5-03 Special measures

• H5-03-1 Special members and measures
• H5-03-2 CurrentMeasure
• H5-03-3 CurrentMember and CompleteTuple

H5-04 Filtering

• H5-04-1 Slicer
• H5-04-2 topcount
• H5-04-3 Except
• H5-04-4 Filter function
• H5-04-5 Filter function: attributes
• H5-04-6 Detail filters

H5-05 Calculations

• H5-05-1 Descendants family function
• H5-05-2 Ancestor family function
• H5-05-3 Aggregate calculation with Except

H5-06 Sorting

• H5-06-1 Set sorting
• H5-06-2 ORDER function

H5-07 Functions

• H5-07-1 LastPeriods and PeriodsToDate
• H5-07-2 linkMember

H5-08 Drill methods

• H5-08-1 Advanced drill behavior

H5-09 Drill-through

• H5-09-1 Target report (dimensional)
• H5-09-2 Target report (relational)
• H5-09-3 Source report: drill-through

H5-10 Cognos macros

• H5-10-1 Member Unique Name macro