data warehouse sap bex variables

《data warehouse sap bex variables》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、SAPBusinessIntelligenceModule1BExVariables,Conditions,&ExceptionsVersion1Module1VariablesPage2Version1Module1UsingVariables•Variablesareparametersofaquerythat–AredefinedinQueryDesigner.–ArefilledwithvalueswhenyouexecutethequeryorWebapplication.•Valueselectionscanbesave

2、dasvariantsforendusers’needs.Page3Version1Module1VariablesVariablesarefunctionsthatprovidethereportinguserwiththeabilitytoselectparametersforrunningaquery.•CharacteristicValueVariable–isusedtorestrictthevalueforaspecificcharacteristic.CharacteristicCalendarYearInsteado

3、ffixingthecalendaryear,thequerywillprompttheuserfortheyear.•TextVariable–isusedtocreateadescriptionlikeacolumnheadingbasedonthevalueofanotherquerycomponent.ColumnDescriptionDynamicallygeneratethecolumnheadingof“NetSales2010”insteadofNetSalesbyusingatextvariabletiedtoth

4、eyearvalue.Page4Version1Module1DefiningCharacteristicVariables•AvariableeditorisavailableinQueryDesignerfordesigningandchangingvariables.Page5Version1Module1VariableProcessingTypesTherearefourdifferentwaystoprocessvariables1.Manualentry/default2.Replacementpath3.Author

5、izations4.CustomerexitPage6Version1Module1VariableProcessing-ManualEntry/Default•ManualEntryallowstheusertoenterthevaluetheywish•ADefaultallowstheusertoselectthedefaultvalueGeneralVariablesVariableCurrentSelectionDescriptionYear20112011SalesOrganizationUS01US01UnitedSt

6、atesPage7Version1Module1GeneralVariableDefinition•Selectingcreatenewvariablebringsyoutothepropertiesscreen•Providethetechnicalname&description•Defaultstypeofvariable•ProcessingBy–ManualInput/DefaultValue–ReplacementPath–Authorization–CustomerExit•ReferenceCharacteristi

7、cPage8Version1Module1VariableDetails•Variablerepresents“selection”•OptionalorMandatory•Defaultstypeofvariable•VariableReadyforInputpresentsthevariableselectionscreenPage9Version1Module1DefaultValues•DefaultValuesscreenallowsyoutochooseadefaultentry•March2001inthiscaseP

8、age10Version1Module1ReplacementPathVariables•CalendarMonthVariableissettoReplacementPath(CurrentDate)•CurrentDateVari