Using Xcelsius 2008 with SAP NetWeaver BW

SAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG1UsingXcelsius2008withSAPNetWeaverBWAppliesto:Xcelsius2008EnterpriseServicePack02(andhigher)SAPNetWeaverBW7.0Enhancementpackage01ServicePack05(andhigher)SummaryInthisshortarticleyouwillusetheSAPNetWeaverBWdirectconnectivitywithXcelsius2008.Author:IngoHilgefortCompany:SAPCreatedon:8June2010UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG2TableofContentsXcelsius2008andSAPNetWeaverBW–DataConnectivityOverview............................................................3Copyright...........................................................................................................................................................26UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG3Xcelsius2008andSAPNetWeaverBW–DataConnectivityOverviewWithXcelsius2008ServicePack02combinedwithSAPNetWeaverBWyoucannowconnectXcelsiusdirectlytoSAPNetWeaverBWandIthoughtIprovidesomemoredetailsonhowthisconnectivityworksandwhatkindofmeta-dataitoffersbasedonyourSAPBWsystem.Firstofallyouneedtofulfillthefollowingtechnicalpre-requisites:SAPNetWeaverBW7.01(SAPenhancementpackage01),ServicePack05SAPBusinessObjectsXcelsiusEnterprise2008ServicePack02SAPFrontend7.xinstalledontheclientwithBIAdd-OnsInaddition,thisnewconnectivityisbasedontheBIConsumerServices.Therefore,youneedtohavetheBIABAPandBIJavastacksdeployed.Youcanfindfurtherdetailsinnote917950and937697.MostofyouarefamiliarwiththeimageshownbelowoutliningallthedifferentoptionshowtoconnectXcelsiustoyourSAPlandscape.ThisimagedoesalsoincludethenewconnectivityoptionwhereyoucanconnectXcelsiusdirectlytoyourSAPNetWeaverBWsystem.WhenyouleveragethisnewconnectivityyoucanexpectXcelsiustoleveragetheexistingmeta-datafromyourBWquery.ThehereshowntableoutlineshowXcelsiuswillleveragethemeta-data:UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG4SAPNetWeaverBWqueryelementXcelsius2008CharacteristicEachcharacteristicintheactualdatasetisretrievedbasedonthesettings(suchasthekeyandshort,medium,andlongtexts)intheSAPNetWeaverBWquery.Inaddition,eachcharacteristicisalsoavailablewithalistofmembersthatyoucanuseforfilteringorprovidingalistofvaluesforvariables.HierarchiesEachlevelofthehierarchyispresentedasacolumninthedataset.ThedepthofthehierarchydependsontheconfigurednumberoflevelsintheBExQueryDesigner.KeyfiguresEachkeyfigurecanbeshownasaplainnumericvalueorasaformattedvaluebasedontheuserpreferences.ThischoicecanbemadeforeachSAPNetWeaverBWconnectionconfiguredintheXcelsiusDesignerDataManager.CalculatedandrestrictedKeyfiguresEachcalculatedorrestrictedkeyfigureistreatedlikearegularkeyfigure.TheuserdoesnothaveaccesstotheunderlyingdefinitionintheXcelsiusDesigner.FilterFiltersareappliedtotheunderlyingquery.Theuserhasaccesstotheconfiguredfiltervaluesandcanusethosevaluesfordisplaypurposes.TheusercanalsosetadditionalfiltervaluesforcharacteristicsfromtheunderlyingSAPNetWeaverBWqueryduringtheruntimeoftheXcelsiusobject.NavigationalattributesNavigationalattributesaretreatedthesameasacharacteristic.DisplayattributeDisplayattributescanbeusedforalistofvaluesandcanbecomepartoftheoveralldataset.Intheactualdataset,adisplayattributecanonlybeshownwiththeactualcharacteristic.VariablesVariablesfromtheSAPNetWeaverBWqueryaretransferredtoXcelsiusaspartoftheconnection.TheyareshownasvariablesintheInputValuesareaoftheSAPNetWeaverBWconnectionsettings.UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG5InthenextcoupleofstepsIwilluseanexamplequeryandexplainhowtheelementsaremadeavailabletoyouintheXcelsiusDataManager.MysampleSAPNetWeaverBWqueryisbasedontheSAPNetWeaverDemomodelInfoProvider0D_NW_M01.OurBWquerycontainsthreecharacteristicsandtwokeyfiguresandwealsoincludedavariableforcharacteristicCountry.UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG6NowtoconnectXcelsiustotheBWquery:1.IntheXcelsiusDesignerusthemenuDataConnections2.UsetheAddbuttonandselecttheoptionSAPNetWeaverBW3.ClickonthebuttonBrowse.YouwillbeaskedtologontotheSAPsystemandcanthenselecttheBWquery.4.AfteryouconnecttotheBWqueryalltheelementsareshownintheInputandOutputValues.TheInputareaincludes:FiltersVariablesTheOutputareaincludes:VariablesCharacteristicsInformationabouttheBWqueryStaticFilterinformationErrorMessagesThevariablesarelistedintheInputandOutputarea.IntheInputareayouactuallycansendvaluestobeusedbythosevariablesandintheOutputareayoucanreceivethelistofmembers(F4help).UsingXcelsius2008withSAPNetWeaverBWSAPCOMMUNITYNETWORKSDN-sdn.sap.com|BPX-bpx.sap.com|BOC-boc.sap.com|UAC-uac.sap.com©2010SAPAG7IfwestartwiththeCharacteristicinformationintheOutputarea–hereforcharacteristicCountry,wecanseethatforeachcharacter