Drillingusingcustomhierarchies
Youmayfindthatthedefaultorderinwhichdimensionobjectsarearranged
inhierarchiesisnotoptimalforyouranalysisneeds,orthatyouneedtodrill
onahierarchythathasobjectsfromdifferentclasses.
Youcaneditahierarchybychangingtheorderofthedimensionsitcontains,
byaddingdimensionstoit,andremovingdimensionsfromit.Youcanalso
renameahierarchy,andevendeleteit.
Youcanalsocreateyourownhierarchiesusingdimensionsavailableinthe
reportorbyusinguserobjects.Therearetwotypesofcustomhierarchies:
• Pre-definedcustomhierarchiesthataresetupbytheuniversedesigner
andwhichcanbere-usedinotherdocuments.
• Hierarchiesyoucreateyourselfandwhicharesavedonlyinthedocument
youcreatedthemin.
Editinghierarchies
Thechangesyoumaketoahierarchythatwascreatedbyauniversedesigner
affectyourworkindrillmodeonly.Forexample,ifyoudeleteahierarchy,
youcannolongeruseitindrillmode.However,thehierarchyremains
unchangedintheuniversesoyoucanstillusethehierarchytodefinescope
ofanalysiswhenbuildingaqueryontheuniverse.Theuniversedesigneris
theonlypersonwhocaneditordeletehierarchiesattheuniverselevel.
Toeditahierarchyfordrillmode
1. ClickHierarchiesontheAnalysismenu.
TheHierarchyEditoropens.
2. IntheAvailableHierarchiesbox,clickthe+signtoviewthecontentsof
thehierarchyfolder.
3. IntheAvailableDimensionsbox,clickthe+signtotheleftofthefolder
toviewthelistofdimensions.
4. Maketherequiredchanges
5. clickOKtoclosetheHierarchyEditor.
DesktopIntelligenceAccessandAnalysisGuide
131
8
AnalyzingDatainDrillMode
Drillingusingcustomhierarchies
Add editable fields to pdf - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF
Online C# Tutorial to Insert, Delete and Update Fields in PDF Document
changing font size in a pdf form; add print button to pdf form
Add editable fields to pdf - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF
How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code
pdf save form data; create a pdf form online
Toaddadimensiontoanexistinghierarchy
1. Clickthedimensionyouwanttoaddtothehierarchy,
2. ClickAdd.
Thedimensionyouclickedappearsinthehierarchy'sfolderinthe
AvailableHierarchiesbox.
IftheHierarchyEditordoesnotlistthedimensionthatyouwanttoadd
toyourhierarchy,youmayhavetoexpandyourscopeofanalysis.See
"Expandingscopeofanalysis."
Youcannotcombinedimensionsfromdifferentdataprovidersinasingle
hierarchy.
Tochangetheorderofthedimensionsinahierarchy
1. Clickthedimensionyouwanttomoveupordowninitshierarchy.
2. ClickMoveUporMoveDowntochangethedimension'spositioninthe
hierarchy.
Torenameahierarchy
1. Clickthehierarchyyouwanttorename.
2. Clickasecondtimeonthehierarchyname,thentypethenewname.
Toremoveadimensionfromahierarchy
• Clickthedimensionyouwanttodelete,thenclickRemove.
Todeleteahierarchy
• Clickthehierarchyyouwanttodelete,thenclickRemove.
132
DesktopIntelligenceAccessandAnalysisGuide
AnalyzingDatainDrillMode
8
Drillingusingcustomhierarchies
C# PDF Convert to Text SDK: Convert PDF to txt files in C#.net
NET project. Powerful .NET control for batch converting PDF to editable & searchable text formats in C# class. Free evaluation library
acrobat create pdf form; changing font size in pdf form
C# Create PDF Library SDK to convert PDF from other file formats
Create fillable PDF document with fields. searchable and can be fully populated with editable text and document creating toolkit, if you need to add some text
adding a text field to a pdf; adding image to pdf form
Creatinghierarchies
Youcancreateyourowncustomhierarchiesfromanydimensionsavailable
inthereport.Thedimensionsyouincludeinahierarchycanbelocal
variables,derivedvariables,ordimensionsreturnedbydataproviders.
Note:
Youcanalsouseadate-typeuserobjectasthebasisforatimehierarchy.
Forinformationonuserobjectssee"Creatinguserobjects."
Tocreateacustomhierarchy
1. ClickHierarchiesontheAnalysismenu.
2. TheHierarchyEditoropens.
3. ClickNewintheHierarchyEditor.
4. Typethenameofthenewhierarchy,thenclickoutsidethenamebox.
5. IntheAvailableDimensionsbox,clickthefirstdimensionforthenew
hierarchy,
6. ClickAdd.
7. Thedimensionyouclickedappearsinthenewhierarchy'sfolderinthe
AvailableHierarchiesbox.
8. AddtheotherdimensionsyouwanttoincludeandthenclickOK.
IftheHierarchyEditordoesnotlistthedimensionsthatyouwanttoinclude
inthehierarchy,youmayhavetoexpandyourscopeofanalysis.See"
Expandingscopeofanalysis."Notethatyoucannotcombinedimensions
fromdifferentdataprovidersinasinglehierarchy.
Qualifyingdataforhierarchies
DesktopIntelligencequalifiesdataasdimensions,measuresordetails.
Hierarchiescontaindimensionsonly,soifyouwanttoincludeanobjectin
ahierarchyforanalysisindrillmode,youmustqualifyitasadimension.
Inpreparationfordrillmode,youmightneedtochangethequalificationof
userobjects,variablesorformulasthatyouhavecreatedinyourreport.For
example,youwanttoincludeavariableinahierarchy,butcannotbecause
DesktopIntelligenceAccessandAnalysisGuide
133
8
AnalyzingDatainDrillMode
Qualifyingdataforhierarchies
C# PDF Convert to Word SDK: Convert PDF to Word library in C#.net
you need to convert PDF document to some easily editable files like C#.NET DLLs and Demo Code: Convert PDF to Word Document in C#.NET Add necessary references:
add image to pdf form; changing font size in pdf form field
VB.NET PDF Convert to Text SDK: Convert PDF to txt files in vb.net
Text in any PDF fields can be copied and pasted to .txt files by keeping original layout. VB.NET control for batch converting PDF to editable & searchable text
change tab order in pdf form; create pdf form
thevariableisqualifiedasadetail.Inthiscase,youmustqualifythevariable
asadimensionbeforeyoucanincludeitinthehierarchy.
Youcanchangethequalificationofdatareturnedbystoredprocedures,
free-handSQLscripts,andpersonaldatafiles.Youcanalsochangethe
qualificationofuserobjects,localvariablesandformulas.
Note:
Youcannotchangethequalificationofdatareturnedbyaqueryonauniverse.
Torequalifylocalvariablesandformulas
1. Selectoneofthefollowingreportelementsthatdisplaystheformulaor
localvariableyouwanttoqualify:
• Acellinatableoracrosstab.
• Inachart,thedataseries,adatalabelorthelegend.
• Afree-formcell.
2. ClickVariablesontheDatamenu.
TheVariablesdialogboxopens.
3. Selectthelocalvariableorformulafromthelist.
LocalvariablesarestoredintheVariablesfolderandformulasarestored
intheFormulasfolder.
4. ClickEdit.
5. IntheDefinitiontaboftheVariableEditor,clickanoptionbuttonto
changethequalification,thenclickOK.
6. ClickCloseintheVariablesdialogbox.
Torequalifyvariables
1. ClickViewDataontheDatamenu.
2. TheDataManagerdialogboxopens.
3. IntheDataProvidersboxoftheDataManager,clicktheiconthat
representsthecolumnofdatawhosequalificationyouwanttochange.
4. ClicktheDefinitiontab.
5. Thename,type,qualificationandvaluesforthecolumnaredisplayed.
134
DesktopIntelligenceAccessandAnalysisGuide
AnalyzingDatainDrillMode
8
Qualifyingdataforhierarchies
C# PDF Text Box Edit Library: add, delete, update PDF text box in
Support to use C# source code to add text box to specified PDF position in C#.NET framework. Able to create a fillable and editable text box to PDF document in
best way to make pdf forms; cannot save pdf form in reader
VB.NET Create PDF from PowerPoint Library to convert pptx, ppt to
Add Password to PDF; VB.NET Form: extract value from fields; Convert multiple pages PowerPoint to fillable and editable PDF documents. Add necessary references:
add picture to pdf form; pdf forms save
6. IntheQualificationbox,clickanoptionbuttontochangethecolumn's
qualification.
7. ClickOK.
Torequalifyuserobjects
1. ClickUniversesontheToolsmenu.
TheUniversesdialogboxopens.
2. Selecttheuniversethatcontainstheuserobject,
3. ClickUserObjects.
4. ClickEdit.
5. IntheQualificationboxoftheDefinitiontab,clickanoptionbuttonto
changethequalification,thenclickOK.
6. ClickOKintheUserObjectsdialogbox.
Printingfromdrillmode
Youcanprintoutatable,crosstaborchartfromdrillmode.Beforeprinting
youcaninsertthecontentsoftheDrilltoolbarintotoyourreporttokeep
trackofthefiltersapplied.
ToinsertDrilltoolbarcontentsasatitle
1. ClickSpecialFieldontheInsertmenuthenclickDrillFilters.
2. Thecursorbecomesaninsertcellcursor.
3. Holdingdowntheleftmousebutton,drawaboxonyourdrillmodereport
pageinthepositionwhereyouwouldliketodisplaythetitle.
4. Releasethemousebutton.
5. Acellisinsertedthatcontainsalistofthevaluescurrentlydisplayedin
theDrilltoolbar.
Youcaneditthesizeandformattingofthecelljustasyouwouldeditany
cellinareport.
DesktopIntelligenceAccessandAnalysisGuide
135
8
AnalyzingDatainDrillMode
Printingfromdrillmode
VB.NET Create PDF from Word Library to convert docx, doc to PDF in
Protect: Add Password to PDF; VB.NET Form: extract value from fields; Convert multiple pages Word to fillable and editable PDF documents. Add necessary references
adding images to pdf forms; adding text field to pdf
VB.NET Create PDF Library SDK to convert PDF from other file
Create and save editable PDF with a blank page, bookmarks, links Create fillable PDF document with fields in Visual Basic .NET Add necessary references:
change font size pdf form; create a pdf form from excel
Toprintareportfromdrillmode
1. Makesurethereportyouwanttoprintisactive.
2. ClickPrintontheFilemenu.
Settingoptionsforworkingindrillmode
Thereareanumberofoptionsyoucansettomanagehowyouworkindrill
mode.Youcan:
• controlthenumberofitemsthatappearonthepopupsub-menus
• viewthenumberofvaluesforeachdimensionthatappearsonthepopup
menu
• systematicallycreateanewreportwhenyouswitchtodrillmode,orbe
promptedtochoosewhetherornottocreateanewreport
• controlthecursorandthetooltipthatappearindrillmode
• automaticallydisplaythetotalsorpercentagesofnumericdata(measures)
• choosetodisplayamessagebeforeclosingdrillmode
• setdrillfiltersasqueryconditionswhenyoudrillthroughtoretrievemore
datafromthedatabase
Tosetoptionsfordrillmode
1. ClickOptionsontheToolsmenu.
TheOptionsdialogboxopens.
2. ClicktheDrilltab
3. Settherequiredoptions
4. ClickOK.
136
DesktopIntelligenceAccessandAnalysisGuide
AnalyzingDatainDrillMode
8
Settingoptionsforworkingindrillmode
VB.NET Create PDF from Excel Library to convert xlsx, xls to PDF
Add Password to PDF; VB.NET Form: extract value from fields; Create fillable and editable PDF documents from Excel in Visual Basic .NET Add necessary references:
add attachment to pdf form; pdf form creator
SliceandDiceMode
9
Overview
Slice-and-dicemodeenablesyoutoswitchthepositionofdatainareport,
forexamplebymovingcolumnstorowstocreateacrosstab.
Youcanalsouseslice-and-dicemodeto:
• workwithmaster/detailreports
• displayandremovedata
• rename,resetanddeleteblocks
• turntablesandcrosstabsintocharts,andviceversa
• apply,editanddeletebreaks,filters,sorts,rankingsandcalculations
Youaccessslice-and-dicemodethroughtheSliceandDicePanel,apop-up
windowthatprovidesagraphicalrepresentationofthereportyouareworking
on.Youcarryoutslice-and-dicetasksbydragginganddroppingiconsthat
representyourdata.
Workinginslice-and-dicemode
Whenworkinginslice-and-dicemode,youusetheSliceandDicePanel.
TodisplaytheSliceandDicePanel:
1. ClickSliceandDiceontheAnalysismenu.
2. Alternatively,clickSliceandDiceontheStandardtoolbar.
TheSliceandDicePanelappears.
• Thefirstbuttononthetopleftletsyoushow/hidetheAvailable
Variablesbox.
• Thenextsetofbuttonsletsyouapplybreaks,filters,sorts,rankings
andcalculations.
• ThereportvariablesareshownintheAvailableVariablestree.
• Theoptionsonthebottomleftletyouviewallvariables,dimensions
only,measuresonly,orallvariablesbydataprovider.
138
DesktopIntelligenceAccessandAnalysisGuide
SliceandDiceMode
9
Overview
• TheSectionpaneshowsmastersinmaster/detailreports.
• TheBlockStructurespaneshowsthevariablesintheactivetable,
chartorcrosstab.
• TheCrosstab1tabshowsthenameandtype(table,chartorcrosstab)
ofeachblock.
• Youcanrename,transform,resetordeleteablockbyright-clicking
itstab,thenclickingacommandontheshortcutmenu.
Workingwithmaster/detailreportsinsliceanddice
mode
Master/detailreportsdisplaydatainsections.Eachsectioncontainsa
"master"orparentpieceofdata,forexamplearesort,orayear.Therestof
thedatainthesectionrelatestothemaster.
Thefollowingillustrationshowsamaster/detailreport,anditscorresponding
representationintheSliceandDicePanel.
• TheAvailableVariablesboxshowsthevariablesandformulasyoucan
displayinthereport.
• TheSectionboxshowsthemaster.
• TheBlockStructureboxshowsthedatathatappearsinthetable.
TheSliceandDicePanelmakesiteasytoworkwithmaster/detailreports.
Youcan:
• buildamaster/detailreport
• reorganizeamaster/detailreportbyreplacingthemasterorbybuilding
amaster/masterdetailreport
• undoamaster/detailreportbyremovingthemaster
• deactivatesectionsofmaster/detailreports
Tostructureanexistingreportasamaster/detailreportinslice
anddicemode
1. DroptheiconofthemasterintheSectionbox.
DesktopIntelligenceAccessandAnalysisGuide
139
9
SliceandDiceMode
Workinginslice-and-dicemode
2. Touseavailabledata,draganiconfromtheBlockStructurebox,dropit
intheSectionbox,thenclickApply.
3. Tousedatathatisnotyetdisplayedinthereport,draganiconfromthe
AvailableVariablesbox,dropitintheSectionbox,thenclickApply.
Tostructureanexistingreportasamaster/detailreportindrill
mode
1. Switchtodrillmode.
2. Selectthedatayouwanttouseasmaster.
3. Right-click.
4. clickSetasMasterontheshortcutmenu.
Reorganizingamaster/detailreport
Youcanreorganizeamaster/detailreportby:
• usingadifferentmaster
• buildingamaster/master/detailreport
Thisstructureenablesyoutoviewdataontwolevelsofdetail.
Toreorganizeamaster/detailreportusingadifferentmaster
1. Openamaster/detailreport.
2. SelecttheiconofthemasterintheSectionbox,thenpresstheDelete
key.
TheicondisappearsfromtheSectionbox.
3. Toreplacethemasterwithdatathatisalreadydisplayedinthereport,
draganiconfromtheBlockStructurebox,anddropitintheSectionbox.
4. Toswapthemasterwithdatathatisdisplayedinthereport,holddown
theShiftkey,thendragthemasteruntilitislocatedabovetheiconwith
whichyouwanttoswap,intheBlockStructurebox,releasethemouse
buttonandclickApply.
5. Toreplacethemasterwithdatathatisnotyetdisplayedinthereport,
draganiconfromtheAvailableVariablesbox,anddropitintheSection
box
140
DesktopIntelligenceAccessandAnalysisGuide
SliceandDiceMode
9
Workinginslice-and-dicemode
Documents you may be interested
Documents you may be interested