36
ThepersonwhocreatestheDesktopIntelligenceuniverseorganizesobjects
inhierarchies,withthemostgeneralobjectintheclassatthetopandthe
mostdetailedatthebottom.
Objectsaregroupedinthiswaytomakeiteasyforyoutofindwhatyouare
lookingfor.Theyareclassifiedinsidethegroupssothatifyouwanttomake
ahighlevelreportyouknowyouneedtoincludeobjectsatthetopofthelist
inyourqueryandifyouwantamoredetailedreportthenyouchooseobjects
fromfurtherdownthelist.
Hierarchies
Objectsarealsoorganizedinthiswayfordrilling.Whenyouanalyzedata
indrillmode,youusehierarchies.Theuniverseclassesarethedefault
hierarchiesusedfordrillingbuttheuniversedesignercanalsosetupcustom
hierarchies.Youcanalsocreateandedithierarchiesinyourreports.
Drillhierarchiescontaindimensionobjectsonly.Indrillmode,youdrilldown
ondimensions,forexamplefromYeartoQuartertoMonth.Ateachlevel
DesktopIntelligencerecalculatesmeasuressuchasRevenueorProfitMargin.
Theclassicdimensionsonwhichadesigneroradvancedusercreates
hierarchiesaregeography,timeandproduct.Inthedemouniverse,Island
ResortsMarketing,therearefourhierarchies:
• Resort(Country,Resort,ServiceLine,Service)
• Sales(Year,Quarter,Month,Week,InvoiceDate)
• Customer(CountryofOrigin,Region,City,Customer)
• Reservations(ReservationYear,ReservationQuarter,ReservationMonth,
ReservationWeek,ReservationDate)
Whenyousetupareportfordrilling,youincludehighlevelobjectstodisplay
inyourtableorchartbutincludemoredetailedobjectsinyourscopeof
analysis.DesktopIntelligenceretrievestheseobjectsfromthedatabaseand
storesthembehindthescenesinyourreportsothattheyaretherewhen
youneedthem.
Beforeyoucananalyzedataindrillmode,youhavetosetupthis
behind-the-scenesdata.
DesktopIntelligenceAccessandAnalysisGuide
115
8
AnalyzingDatainDrillMode
Overview