FacetsandInformationSpaces
Calculatingmeasures
Selectingmultiplevalues
Facetpanescrollbar
Thefilterpane
4.2.1.1 The search box within the Explore tab
ThesearchboxwithintheExploretab,isdifferentfromtheothersearchboxesontheHometab.You
canusethissearchboxforspecificallyfindingsuggestedfacetsandtheirvalues.Forexample,you
havesearchedfor2003.ThevalueisfoundwithintheYearfacet.Thefacetsarerearrangedsothat
theYearfacetappearsfirstand2003ishighlightedinorange.2003,iffound,isalsohighlightedwithin
thefilterpane,thechart,andthelegend.Ifamatchingresultisinacollapsedfacetbutisnotaselected
value,thecollapsedfacetinhighlightedinorange.
Usethissearchboxtofindthefacetsandtheirvaluesquicklyinordertoaidyourexploration.
Note:
Whenyouperformasearchonfacetvaluesusingwildcards,amaximumof1024matchesisreturned.
4.2.1.2 Facets and Information Spaces
ThefacetsavailabletoyouintheExplorationtabareconstructedfromtheactualcontentofthe
InformationSpaceyouhaveopened.EachexplorationfacetisbaseduponthecontextoftheInformation
Spaceanditsmeasuresanddimensions.Forexample,whenanInformationSpaceisrepresenting
fashion(clothesandproductlines)ameasurecouldbeSalesRevenue,andtheremainingfacetscould
includeProductLines,City,Year,andPrice.
Youcanusethefacetstoexploreyourdatabyselectingfacetvaluesandtoviewdatavaluesdirectly.
Selectingavalue(eitherviasingleselection,ormulti-selection)changessubsequentfacetsaswellas
changingyourchosenvisualization-thetableorthechart.Forexample,youwishtoseethenumber
ofProductLinesyouhadduring2003.Byselectingthefacetvalueof"2003"withinthe"Year"facet
wouldfilterthevalueswithintheProductLinesfacet(onlytheLinesfor2003wouldbeshown).
Additionallythevisualizationwouldchangetoaccommodateyourfacetselection.
Category facet
Categoryfacetsallowyoutoselectcategoriesandtheirvaluestofilterdownthedatayouareexploring.
Thesefacetsandtheirvaluesareconstructedfromdatasourceobjects(dimensions)usedbyan
InformationSpace.Forexample,theCountryfacetcouldhavelabelssuchasBelgium,France,UK,
US,Germany.Eachhasanumericvaluewhichisbasedupontheprimarymeasureselectedbyyou.
2012-03-19
41
Exploring data
Pdf metadata - add, remove, update PDF metadata in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Allow C# Developers to Read, Add, Edit, Update and Delete PDF Metadata
pdf xmp metadata viewer; rename pdf files from metadata
Pdf metadata - VB.NET PDF metadata library: add, remove, update PDF metadata in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
Enable VB.NET Users to Read, Write, Edit, Delete and Update PDF Document Metadata
view pdf metadata; edit pdf metadata online
Measures
MeasuresarelistedinthemeasurepanelintheExplorationtab.Themeasurepanelislocatedonthe
lefthandsideofthefacetpane.Thechoiceofthemeasuredirectlyimpactsthevisualizationdisplayed
andthefacetvalues.Measurelistsarealwaysvisibletoyou(dependingonthenumberofmeasures)
withatleastoneavailablemeasure.Primarymeasuresarehighlightedandrelatedvaluesaredisplayed
withinfacets.
Related Topics
NavigatingthroughanInformationSpace
4.2.1.3 Calculating measures
Tocalculateameasure,theInformationSpaceneedstocontainatleasttwooriginalmeasuresfroma
datasource.
Withthisfunction,youcandefinemeasuresbasedonexistingmeasuresintheInformationSpace.You
canusethecalculatedmeasuresduringexplorationforeachfacetandforvisualization.Youcanexport
theexplorationresultstoaCSVfileorasaWebIntelligencequery.
Todefineacalculatedmeasure:
1. SelectAddCalculationinthemeasurepanel.
2. Enternameanddescriptionforthenewcalculation
3. Selectthefirstmeasureforthecalculation
4. Selectanoperatorforthecalculation(add,subtract,multiplyordivide)
5. Selectthesecondmeasureforthecalculation
6. SelectOK
Thenewdefinedmeasureisavailableinthemeasurepanel.Youcanuseitforexplorationasother
measures.
Toeditordeletecalculatedmeasure,usetheiconsnexttotheaffectedmeasures.
Tosavecalculatedmeasuresforothersession,bookmarktheexplorationtoyourbrowser.Whenyou
callitfromyourbrowserfavoritelist,thecalculatedmeasuresareavailableasbefore.
YoucanexporttheexplorationresultstoaCSVfileorasaWebIntelligencequery.InaCSVfile,the
resultofthecalculatedmeasureisdisplayed.InaWebIntelligencequery,thecalculatedmeasureis
displayedasformula.
Related Topics
NavigatingthroughanInformationSpace
2012-03-19
42
Exploring data
How to C#: Modify Image Metadata (tag)
edit, C#.NET PDF pages extract, copy, paste, C#.NET rotate PDF pages, C#.NET search text in PDF, C#.NET edit PDF bookmark, C#.NET edit PDF metadata, C#.NET
batch pdf metadata editor; delete metadata from pdf
C# TIFF: TIFF Metadata Editor, How to Write & Read TIFF Metadata
C# TIFF - Edit TIFF Metadata in C#.NET. Allow Users to Read and Edit Metadata Stored in Tiff Image in C#.NET Application. How to Get TIFF XMP Metadata in C#.NET.
delete metadata from pdf; pdf xmp metadata
4.2.1.4 Selecting multiple values
Selectingavalue(whetherinafacetorachart)issimple,andisachievedbyclickingthevalue.When
youclickadatatableorchartvalue,thevalueishighlightedtosimplifyyouranalysis.Youcanalso
selectmultiplevaluesinthemeasurefacet,thedimensionfacets,theExploremore...dialogandthe
chartlegendtoanalyzeyourdata.
Youcanselectmultiplevaluesviathekeyboard.Pressingakeyonthekeyboardandclickingwiththe
mouseallowsyoutoselectmorethanonevalue.Therearetwokeysthatareusedandaresummarized
inthefollowingtable:
Description
Key
Bypressingthiskeyyouareabletoselectmultiplevaluesinagivenrange.
Shift
Bypressingthiskeyyouareabletoselectdiscontinuousmultiplevalues
whereyouindicate.
Control
Note:
Datavalueselectionisindependentfromwherethevaluesarelocated.Forexample,afacet,thedata
table,achart.
4.2.1.4.1 The Explore more... option for selecting additional values
YoucanseeandaccessalotofInformationSpacedata.Tomakenavigationandanalysiseasierfor
youthereisanExploremore...option.Thisoptionisforaccessingdatavaluesthatarenotdisplayed
directlytoyou.Forexample,afacetrepresentingcolorcanhavenumerousvalues.
Toaccommodatetheothervalues,theExploremore...optionappearsbelowthetoptenfacetvalues.
Theoption,whenclicked,displaysallvaluesintheExploremore...dialog.
Yousimplyclickthevaluesyouwanttouse(useShiftorControlclickstoselectmultiplevalues)and
movethemintotheSelectedValuespane,usingthearrowbuttonssituatedontheright.Ifthereare
alotofvalues,scrollthroughthemandclickthevaluesyouwant.EnsureyoukeeptheShiftorControl
keypressedwhenperformingmultipleselection.
Note:
Asdefaultamaximumof100valuescanbeselectedwithintheExploremore...dialog.
Youcanalsosortthevalues(toviewthetoporbottomvalues)byclickingtheheaderswithinthedialog.
UsetheRefineoptiontofilterthelistofvalues.WhenyouhavechosenyourdesiredvaluesclickDone
tofinishyourselection.
Note:
WhenyouperformasearchonfacetvaluesintheExploremore...dialog,thefacetvaluesthatmatch
thesearchcriteriaarenothighlighted.
2012-03-19
43
Exploring data
VB.NET PDF Library SDK to view, edit, convert, process PDF file
PDF Metadata Edit. Offer professional PDF document metadata editing APIs, using which VB.NET developers can redact, delete, view and save PDF metadata.
remove pdf metadata; rename pdf files from metadata
C# PDF Library SDK to view, edit, convert, process PDF file for C#
accordingly. Multiple metadata types of PDF file can be easily added and processed in C#.NET Class. Capable C#.NET: Edit PDF Metadata. PDF SDK
get pdf metadata; preview edit pdf metadata
Related Topics
Selectingmultiplevalues
4.2.1.5 Facet pane scrollbar
Thescrollbarinthefacetpaneisusedfornavigatingthroughtheavailablefacetssoyoucanchoose
certainfacetvaluesforexploration.Sincenotallfacetsaredisplayedatonetime,youareabletomove
throughallthefacetswiththescrollbar.
Toseethefacetsthatarenotdisplayed,navigatewiththescrollbarforwardorback.Duringthe
navigation,thetooltipshowsthefacetsthatwillbedisplayedwhenreleasingthescrollbar.Onceyou
havefoundthefacetvaluesyouaresearchingfor,clickthevaluestoselectthem.Thefacetbecomes
selectedandtheremainingfacetsarereordered.
4.2.1.6 The filter pane
Whennavigatingthroughyourdatayoucanseetheselectedfacetsandvaluesinthefilterpane.The
filterpaneislocatedbetweenthefacetpaneandthevisualizationpanewithintheExplorationtab.
Theselectedfacetsaredisplayedasseperatecollapsedboxes.Whenyouselectmorefacetsthancan
bedisplayedinthefilterpane,youcanusethebackandforwardbuttonstonavigatethroughtheselected
facets.Youcanalsochangetheselectedfacetvaluesinthefilterpane.
4.2.2 Saving exploration results as a bookmark
Youcansaveanexplorationasabookmark.
Note:
WhensavinganexplorationasabookmarkusingtheMozillaFirefoxbrowser,youmusteditthebookmark
propertiestoensuretheexplorationopensinthemainwindowandnotthesidepane.Dothisasfollows:
RightclickthebookmarkandselectProperties fromthecontextlist.CleartheLoadthisbookmark
inthesidebar""checkbox,andclickSave"".
1. ClicktheBookmarkiconormenuitemasyouwouldtobookmarkanyotherwebpage.
2. Usingthebookmarkbrowser,selectwhereyouwanttosavethebookmark,typeitsname,andthen
clickOK
2012-03-19
44
Exploring data
How to C#: Basic SDK Concept of XDoc.PDF for .NET
XDoc.PDF for .NET supports editing PDF document metadata, like Title, Subject, Author, Creator, Producer, Keywords, Created Date, and Last Modified Date.
endnote pdf metadata; modify pdf metadata
VB.NET PDF File Compress Library: Compress reduce PDF size in vb.
Document and metadata. All object data. File attachment. Flatten visible layers. VB.NET Demo Code to Optimize An Exist PDF File in Visual C#.NET Project.
metadata in pdf documents; add metadata to pdf programmatically
Yourexplorationcontexthasbeensavedasabookmark.Whenyouloadthebookmark,the
explorationpageisdisplayed.Ifyouareloggedout,logbackintoSAPBusinessObjectsExplorer.
4.2.3 Exploring local Excel files
TheExcelfilemustbeavailableonyourcomputer.
ToexplorealocalExcelfile:
1. Onthe"Home"tab,gotoUploadaspreadsheettoexploreandbrowseforanExcelfile(.xlsor
.xlsx)onyourcomputeranduploadit.
2. Optional:Select"PreviewandConfigure",ifyouwanttoconfigureyourdata.
Youcandefineforeachcolumninyourfile,ifitshouldbedisplayedasdimensionormeasure.You
canalsohideacolumn.
3. Select"ExploreNow".
YoucanexploreyourfilelikeanInformationSpace.
Related Topics
CreatingInformationSpaceswithExcelfiles
NavigatingthroughanInformationSpace
4.3 Data analysis features
4.3.1 Sorting facets
Tocustomizeyourexplorationview,youcanapplyasorttofacetvalues.
Themethodsavailableforsortingare:
• Explorersort
Thedefaultsortmethodarrangesthefacetvaluesaccordingtorelevancy.
• AtoZsort
Sortsthevaluesinascendingorder.Forexample,aYearfacetwithvaluesof2007,2006,and2005
issortedtoshow2005,2006,andthen2007.
2012-03-19
45
Exploring data
VB.NET PDF Image Extract Library: Select, copy, paste PDF images
Get image information, such as its location, zonal information, metadata, and so on. Extract image from PDF free in .NET framework application with trial SDK
embed metadata in pdf; pdf metadata
C# PDF File Compress Library: Compress reduce PDF size in C#.net
Comments, forms and multimedia. Document and metadata. All object data. Detect and merge image fragments. Flatten visible layers. C#.NET DLLs: Compress PDF Document
adding metadata to pdf files; view pdf metadata in explorer
• ZtoAsort
Sortsthevaluesindescendingorder.Forexample,aCountryfacetwithvaluesofUK,USA,France,
Norway,andMexicoissortedtoshowUSA,UK,Norway,Mexico,andthenFrance.
• SmallesttoLargest(sortonmeasure)
Sortsthemeasurevaluesinascendingorder.Forexample,aYearfacetrepresentingsalesrevenue
(withvalues2007=$100750,2006=$90500,and2005=$200444)issortedtoshow:2006=$90500,
2007=$100750,andthen2005=$200444.
• LargesttoSmallest(sortonmeasure)
Sortsthemeasurevaluesindescendingorder.Forexample,aYearfacetrepresentingsalesrevenue
(withvalues2007=$100750,2006=$90500,and2005=$200444)issortedtoshow:2005=$200444,
2007=$100750,andthen2006=$90500.
Youcanapplysortingwithinthe"Objects"tabwhilecreatinganInformationSpace.Thedimension
objectswithinthe"MeasuresandDimensions"panehaveaniconindicatingtheirsortingmethod.By
default,objectsusedefaultsorting,clicktheobjectyouwishtosort,thenchoosethesortingmethod
youwishtoapply.Forexample,clickAtoZ,tochangethesortingmethod.TheiconchangestotheA
toZsort.Toreturntothedefaultsort,clickExplorer.
Whennavigating,youcanoverwritethefacetsortingbyusingthesortingmethodsonthefacets.
4.3.2 Data highlighting
Datahighlightingisasimplewayofensuringthatdatayouarefocusingupon(forexample,viaachart)
isalsofocusedelsewheresuchasonthelegendandthechartlabels.
Forexample,youareanalyzingapiechartrepresentingthesalesrevenuebetweenvariouscitiesin
theworld.IfyouclickthesectorforNewYorkitwouldbecomehighlightedalongwiththevaluelabel
andthelegendvalues.Ifchangeyourvisualization,thehighlightingandselectionarekepttohelpyou
followyourdata.
AnotherexampleiswhenyouperformakeywordsearchwithintheExplore:tab,anymatchestoyour
keywordswithinthesearchresultsarehighlightedwithinthefacets,thefilterpane,thelegend,andthe
visualization.
Thereisarelationshipbetweenthechartandlegendhighlighting.Thevalueswithinthechartarealso
highlightedifthevaluesinthelegendarehighlighted.
Datahighlightinghelpsyouranalysisbyprovidingaclearerviewofdataandexposingtherelationships
betweenvisualizationandvalues.
2012-03-19
46
Exploring data
4.3.3 Facet selection and filtering
AfterexploringyourInformationSpaceviathefacets,youcanusethechartforanalyzingyourdata.
Onemethodofinteractingwiththechartforfurtheranalysisisdouble-clickingtheregionsthatrepresent
thedata(forexample,abarofabarchartorasectorofapiechart).Thisactionselectsfacetvalues
whichperformsfurtherfiltering.
Forinstance,youcandouble-clickabarofabarchartthatisrepresentingthesalesrevenueof2007.
Thisactioncausesthe2007facetvaluewithintheYearfacettobecomeselected.Thechartchanges
accordingtoyourselection(filteringhasbeenapplied),inthiscase,thechartnowshowsthesales
revenueof2007,dividedintoquarters.Asingleclickofaregionhighlightsthedata(withinthechart
andlegend)butdoesnotperformselection.
Youcanalsoselectfacetsbyselectingthechartregionswithyourcursor.Forexample,holddownthe
Shiftkeyclickanddragyourcursoroverthebarsofabarchart.Thecorrespondingfacetsandfacet
valuesareselectedandthechartandlegendchangeaccordingly.Selectingtheregionswithoutholding
downtheShiftkeyhighlightsthedata(withinthechartandlegend)butdoesnotperformselection.
Anothermethodoffacetselectionisbydoubleclickingthedatawithinthelegend.
4.3.4 Adding a second dimension for analysis in charts
Youcanaddaseconddimensiontothefollowingtypeofcharts:
• Trendlinechart
• Barchart
Addingaseconddimensiontoachartallowsyoutovisualizeasecondaxeofanalysisforyourdata
withinthesamechart.Youcancontinuetoaddandchangemeasuresasyouwouldforasingle
dimension,theoperationsareaffectedtobothdimensions.
1. FromaTrendorBarchartclickthedimensiondropdownlistboxnexttothecurrentdimension.
2. Selectadimensioninthelist.
Youhavethefollowingoptionstoapplytotheseconddimensioninthechart:
2012-03-19
47
Exploring data
Description
Dimension
sort options
Whatvaluestoyouwanttobeshownbypriorityforthedimension?Youhavethe
followingchoices:
Sortpriority
Allvaluesaredisplayedtoamaximumof1000rows.
Sort
Youdefinethenumberofrowsto
includeintheNumberofRowsbox.
Thetoprankingvaluesare
displayed..
Top
Thebottomrankingvaluesare
displayed
Bottom
Thefirstvaluesinthelistare
displayed.
First
Thelastvaluesinthelistare
displayed
Last
Howmanyvaluesforthedimensiondoyouwanttoappearinthechart?
Numberof
rows
Basedonthesortpriorityselected,whatsortofvaluesforthedimensiondoyou
wanttoprioritize?
Sortcriteria
Selecteitherdimensionoramea-
sure
Sort
Selectameasure
ToporBottom
Youcanonlyselectthecurrentdi-
mension
FirstorLast
3. SelectthedimensionsortoptionsandClickOK.
Forbarchartswithaseconddimensionyouhavethedisplayoptionsthatappearasradiobuttons
underthechart.Theseallowyoutochangethedisplayasfollows:
Description
Bar chart second dimension display
option
Defaultsinglecolordisplayforallvalues.Theseconddi-
mensionvaluesareshowninagridunderthechartfor
thefirstdimension.
Leftbutton
Showsadifferentcolorforeachseconddimensionvalue
butallvaluesarecombinedonasinglebarforthefirst
dimension
Centerbutton
Showsadifferentcolorforeachvalue.
Rightbutton
2012-03-19
48
Exploring data
4.3.5 Tooltips
WhenusingSAPBusinessObjectsExploreryouinteractwithInformationSpacedataviafacets,tables,
aswellasvariousothercomponents.Thereisastraightforwardyeteffectivemethodtoshowyouextra
informationwhileyousearchandwhileyouanalyze,themethodiswithtooltips.
Whenyouhoveroveraspecificarea,theinformationisbaseduponthisarea.Thefollowingtableshows
someexamplesoftooltipsthatareshowntoyou:
Example Tooltip text
Location
Example
Country=France,Revenue=45000
chartview
sectorofapierepresentingsales
revenue
Customer'slastname
datatable
tableheader
Customer'slastname
InformationSpacecre-
ationdialog
universeobjectrepresenting
salescustomerdetails(Cus-
tomer)
Tooltipsthushelpyouunderstandthedatabehindthedisplayedvalues.
4.4 Analyzing explored data
Lookingatyourdatathroughtheexplorationfacetsisvaluablebutoftenitiseasiertoanalyzevalues
usingachartoratable.Bypresentingthedatainameaningfulformatallowsyoutonoticepatterns
andconstraints,andtoperformcomparisons.Withtablesandcharts,youhaveaclearerviewofdata
withoutnecessaryknowingthenumbersbehindthevisualization.
Thissectiondiscussesthedatatableandthechartsaccessibleasanalysistypesthatareavailableto
youforviewingyourdata.
4.4.1 The data table
Thedatatableallowsyoutoseetherawdatathatisbehindthecharts.Youcannavigatethroughdata
presentedinrowsandcolumns.
Dataisnotaggregatedorfiltered(bycolumn)withininthetable.
2012-03-19
49
Exploring data
Todisplayandnavigatethroughdata:
1. ClickTabletochangetothedatatable.
Thevisualizationrepresentingyourexploreddata(ifitwasnotalreadyintableview)willchangeto
atable.
2. Clickthenavigationarrowsinthetableviewtonavigatethroughthedifferentrowsofdata.
3. Customizetheview
Tocustomizetheviewofatable,youcanresizeeachcolumnandmovethecolumnswithinthe
tableusingdraganddrop.Thecostumizedviewisavailableuntilyouclosethesession.
4.4.2 Analysis types
Theanalysistypesareusedtomodifyhowyouviewyourdatawithcharts.Forexample,onceyouhave
usedtheexplorationfacetswithintheExplore:tabtonarrowdownyourdata,youcanchangethe
defaultanalysistypetoanotheranalysistype.Thevisualizationchangepermitsyoutohaveadifferent
perspectiveandallowsfurtheranalysis.
Analysistypesallowyoutoseepatterns,differencesindatavalues,andpermityoutoexamineyour
dataviasimplecomparisons.Furthermoreeachanalysistypeoffersseveralcharttypestovisualize
yourdata.
SAPBusinessObjectsExplorerchoosesthebestcharttouseforyourprovideddatabyranking.The
listofavailablechartschangestatusaccordingtothedataandyourselection,forexample:
• Chartsthatarenotsuitedfortheprovideddatacannotbeselected.
• Chartsthataresuitableareenabled.
• Chartsthatarethemostsuitablearehighlightedwithayellowstar.
• Thechartthatyouselectappearsontheanalysistypebutton.Foreachanalysistypethatyouhaven't
selected,themostsuitablechartishighlightedwithayellowstarandalsoappearsontheanalysis
typebutton.
Ifyouselectmorethanonemeasure,thecharttypesenabledchange.Forexample,averticalbarchart
withtwoyaxesisenabledunderthecomparisonanalysistype.
Therearefiveanalysistypesavailable:
Available charts
Description
Analysis type
• verticalbarchart
• horizontalbarchart
• barchartwithtwoyaxes
• radarchart
• multipleradarchart
• surfacechart
• tagcloudchart
Usetoviewthedifferencesbetween
values.Itprovidesthesimplecompar-
isonofcategoricaldivisionsofmea-
sures.Itisthedefaultanalysistype.
Forexample,youcoulduseabar
charttocomparethedifferencesin
yoursalesrevenuebetweendifferent
countries.
Comparison
2012-03-19
50
Exploring data
Documents you may be interested
Documents you may be interested