SAP HANA Studio开发人员手册

PUBLICSAPHANAPlatform2.0SPS00DocumentVersion:1.0–2016-11-30SAPHANADeveloperGuideForSAPHANAStudioContent1IntroductiontoSAPHANADevelopment..........................................91.1SAPHANAArchitecture.......................................................10SAPHANAIn-MemoryDatabase...............................................11SAPHANADatabaseArchitecture..............................................13SAPHANAExtendedApplicationServices........................................14SAPHANA-BasedApplications................................................171.2DeveloperInformationMap.....................................................17SAPHANADeveloperInformationbyGuide.......................................20SAPHANADeveloperInformationbyTask........................................24SAPHANADeveloperInformationbyScenario.....................................261.3DeveloperScenarios..........................................................29DevelopingNativeSAPHANAApplications........................................31DevelopingNon-NativeSAPHANAApplications....................................362GettingStarted............................................................402.1Prerequisites...............................................................412.2SAPHANAStudio............................................................41TheSAPHANADevelopmentPerspective........................................422.3SAPHANAXSApplicationDescriptors.............................................462.4SAPHANAProjects..........................................................462.5Tutorials..................................................................47Tutorial:MyFirstSAPHANAApplication.........................................48Tutorial:UsetheSAPHANAODataInterface......................................653SettingUpYourApplication...................................................693.1RolesandPermissionsforXSDevelopment.........................................703.2MaintainingDeliveryUnits......................................................72MaintaintheDelivery-UnitVendorID............................................74CreateaDeliveryUnit.......................................................753.3UsingSAPHANAProjects......................................................77MaintainaRepositoryWorkspace..............................................78CreateaProjectforSAPHANAXS.............................................80ShareanSAPHANAXSProject...............................................83ImportanSAPHANAXSProject...............................................843.4MaintainingRepositoryPackages.................................................85DefinetheRepositoryPackageHierarchy........................................86AssignRepositoryPackagePrivileges...........................................912PUBLICSAPHANADeveloperGuideContentCreateaRepositoryPackage.................................................94DeleteaRepositoryPackage.................................................953.5CreatingtheApplicationDescriptors..............................................96CreateanApplicationDescriptorFile............................................98EnableAccesstoSAPHANAXSApplicationPackages..............................100CreateanSAPHANAXSApplicationPrivilegesFile.................................1163.6MaintainingApplicationSecurity................................................120SetupApplicationSecurity..................................................121SetupApplicationAuthentication.............................................1233.7MaintainingHTTPDestinations.................................................128Tutorial:CreateanHTTPDestination...........................................129Tutorial:ExtendanHTTPDestination...........................................141Tutorial:CreateanOAuthConfigurationPackage..................................1453.8MaintainingApplicationArtifacts................................................160Design-TimeApplicationArtifacts.............................................160Studio-BasedSAPHANADevelopmentTools.....................................1644SettinguptheDataPersistenceModelinSAPHANA...............................1684.1CreatingthePersistenceModelinCoreDataServices.................................170CDSEditors.............................................................171CreateaCDSDocument....................................................175CreateanEntityinCDS....................................................200MigrateanEntityfromhdbtabletoCDS(hdbdd)...................................218CreateaUser-DefinedStructuredTypeinCDS....................................222CreateanAssociationinCDS................................................236CreateaViewinCDS......................................................251ModificationstoCDSArtifacts...............................................276Tutorial:GetStartedwithCDS...............................................280ImportDatawithCDSTable-Import...........................................2844.2CreatingthePersistenceModelwithHDBTable......................................296CreateaSchema.........................................................297CreateaTable...........................................................301CreateaReusableTableStructure............................................310CreateaSequence........................................................313CreateanSQLView.......................................................322CreateaSynonym........................................................328ImportDatawithhdbtableTable-Import........................................3335SettingUptheAnalyticModel................................................3465.1SettingUptheModelingEnvironment.............................................346SetModelerPreferences...................................................346SetKeyboardShortcuts....................................................347SAPHANADeveloperGuideContentPUBLIC35.2CreatingViews.............................................................348AttributesandMeasures...................................................348FirstStepstoViewCreation.................................................349CreateAttributeViews.....................................................352CreateAnalyticViews......................................................357CreateGraphicalCalculationViews............................................364CreateScript-BasedCalculationViews.........................................376ActivatingObjects........................................................379DescriptionMapping......................................................382ImportBWObjects.......................................................383GroupRelatedMeasures...................................................3855.3AdditionalFunctionalityforInformationViews.......................................386CreateLevelHierarchies...................................................386CreateParent-ChildHierarchies..............................................388InputParameters........................................................392AssignVariables.........................................................393UsingCurrencyandUnitofMeasureConversions..................................393ManageInformationViewswithMissingObjects...................................3935.4WorkingwithViews..........................................................394ManageEditorLayout.....................................................394ValidateModels..........................................................395MaintainSearchAttributes..................................................395DataPreviewEditor.......................................................396UsingFunctionsinExpressions...............................................397ResolvingConflictsinModelerObjects.........................................3975.5CreateDecisionTables.......................................................400ChangingtheLayoutofaDecisionTable........................................402UsingParametersinaDecisionTable..........................................403UsingCalculatedAttributesinDecisionTables....................................4055.6GenerateObjectDocumentation................................................4056DevelopingProcedures.....................................................4076.1SQLScriptSecurityConsiderations..............................................4096.2CreateandEditProcedures....................................................411DefineandUseTableTypesinProcedures.......................................413Tutorial:CreateanSQLScriptProcedurethatUsesImperativeLogic....................4156.3CreateScalarandTableUser-DefinedFunctions.....................................420Tutorial:CreateaScalarUser-DefinedFunction...................................420Tutorial:CreateaTableUser-DefinedFunction....................................4256.4CreateProcedureTemplates...................................................430CreateProcedureTemplateInstances..........................................431UpdateProcedureTemplatesandInstances.....................................4334PUBLICSAPHANADeveloperGuideContentDeleteProcedureTemplatesandInstances......................................4336.5DebuggingProcedures.......................................................434SetupDebuggerPrivileges..................................................434DebugDesign-TimeandCatalogProcedures.....................................435DebuganExternalSession..................................................4386.6DevelopingProceduresintheModelerEditor.......................................4406.7TransformingDataUsingSAPHANAApplicationFunctionModeler........................441ConvertingdeprecatedAFLModels(AFLPMMLobjects).............................444SettinguptheSAPHANAApplicationFunctionModeler.............................445Flowgraphs.............................................................447Modelingaflowgraph......................................................449Tutorial:CreatingaRuntimeProcedureusingApplicationFunctionModeler(AFM)..........486Nodepaletteflowgraphs...................................................4907DefiningWeb-basedDataAccess..............................................4957.1DataAccesswithODatainSAPHANAXS..........................................495ODatainSAPHANAXS....................................................496DefinetheDataanODataServiceExposes.......................................497ODataServiceDefinitions...................................................497CreateanODataServiceDefinition............................................501Tutorial:UsetheSAPHANAODataInterface.....................................503ODataService-DefinitionExamples............................................507ODataServiceDefinitionLanguageSyntax(XSAdvanced)...........................529ODataServiceDefinition:SQL-EDMTypeMapping(XSAdvanced)......................532ODataSecurityConsiderations...............................................533ODataBatchRequests(XSAdvanced).........................................5337.2DataAccesswithXMLAinSAPHANAXS..........................................536XMLforAnalysis(XMLA)...................................................537XMLAServiceDefinition....................................................538XMLASecurityConsiderations...............................................539MultidimensionalExpressions(MDX)..........................................539MDXFunctions..........................................................540MDXExtensions.........................................................542DefinetheDataanXMLAServiceExposes.......................................546CreateanXMLAServiceDefinition............................................547Tutorial:UsetheSAPHANAXMLAInterface.....................................5487.3UsingtheSAPHANARESTAPI.................................................550SAPHANARESTInfoAPI...................................................551SAPHANARESTFileAPI...................................................552SAPHANARESTChange-TrackingAPI.........................................557SAPHANARESTMetadataAPI...............................................558SAPHANARESTTransferAPI...............................................559SAPHANADeveloperGuideContentPUBLIC5SAPHANARESTWorkspaceAPI..............................................5618WritingServer-SideJavaScriptCode...........................................5638.1DataAccesswithJavaScriptinSAPHANAXS.......................................5638.2UsingServer-SideJavaScriptinSAPHANAXS......................................564Tutorial:WriteServer-SideJavaScriptApplicationCode.............................5648.3UsingServer-SideJavaScriptLibraries............................................579ImportServer-SideJavaScriptLibraries........................................580WriteServer-SideJavaScriptLibraries..........................................5828.4UsingtheServer-SideJavaScriptAPIs............................................583Tutorial:UsetheXSJSOutboundAPI..........................................595Tutorial:CallanXSProcedurewithTable-ValueArguments..........................599Tutorial:QueryaCDSEntityusingXSDataServices................................603Tutorial:UpdateaCDSEntityUsingXSDataServices...............................6088.5CreatingCustomXSSQLConnections............................................611CreateanXSSQLConnectionConfiguration.....................................6138.6SettingtheConnectionLanguageinSAPHANAXS...................................6198.7SchedulingXSJobs..........................................................621Tutorial:ScheduleanXSJob................................................622AddorDeleteaJobScheduleduringRuntime.....................................6318.8TracingServer-SideJavaScript.................................................632TraceServer-SideJavaScriptApplications.......................................633ViewXSJavaScriptApplicationTraceFiles......................................6358.9DebuggingServer-SideJavaScript...............................................635CreateaDebugConfiguration................................................639ExecuteXSJavaScriptDebugging.............................................640TroubleshootServer-SideJavaScriptDebugging..................................6458.10TestingXSJavaScriptApplications..............................................647AutomatedTestswithXSUnitinSAPHANA......................................648ApplicationDevelopmentTestingRoles.........................................649TestanSAPHANAXSApplicationwithXSUnit....................................649TestingJavaScriptwithXSUnit...............................................6639BuildingUIs..............................................................6709.1BuildingUserInterfaceswithSAPUI5forSAPHANA..................................6709.2ConsumingDataandServiceswithSAPUI5forSAPHANA..............................6719.3SAPUI5forSAPHANADevelopmentTutorials.......................................672Tutorial:CreateaHello-WorldSAPUI5Application.................................673Tutorial:ConsumeanXSJSServicefromSAPUI5..................................677Tutorial:ConsumeanODataServicefromSAPUI5.................................683Tutorial:ConsumeanODataServicewiththeCREATEOption.........................690Tutorial:CreateandTranslateTextBundlesforSAPUI5Applications....................6976PUBLICSAPHANADeveloperGuideContent9.4UsingUIIntegrationServices...................................................702CreatingContentforApplicationSites..........................................703SAPFioriLaunchpadSites..................................................715CreatingaStandardSite....................................................722ConfiguringtheSAPHANAHomePage.........................................72310SettingUpRolesandPrivileges...............................................72410.1CreateaDesign-TimeRole.....................................................725Roles..................................................................731Privileges...............................................................74110.2CreatingAnalyticPrivileges....................................................762CreateClassicalXML-basedAnalyticPrivileges...................................763CreateSQLAnalyticPrivileges...............................................765AnalyticPrivileges........................................................76711SAPHANAApplicationLifecycleManagement....................................78911.1PreparingtoUseSAPHANAApplicationLifecycleManagement..........................791AssignUserRoles........................................................792MaintaintheDelivery-UnitVendorID...........................................79611.2SettingUptheTransport......................................................797SettingUpandUsingNativeSAPHANATransport.................................799SettingUpandUsingCTSTransport...........................................80611.3MaintainingDeliveryUnits.....................................................815CreateaDeliveryUnit......................................................816AssignPackagestoaDeliveryUnit.............................................818ExportaDeliveryUnit......................................................819ImportaDeliveryUnit......................................................82111.4MaintainingProducts........................................................822CreateaProduct.........................................................823AssignaDeliveryUnittoaProduct............................................82511.5SAPHANAChangeRecording..................................................826EnableSAPHANAChangeRecording..........................................827CreateChangelists.......................................................829AssignObjectstoChangelists................................................830ApproveContributionstoChangelists..........................................832ReleaseChangelists.......................................................833FilterandSearchforChangelists..............................................83411.6AssemblingAdd-OnProductsandSoftwareComponents..............................83611.7InstallingandUpdatingSAPHANAProductsandSoftwareComponents....................83711.8Usinghdbalm..............................................................838hdbalmCommands,Options,andVariables......................................840EnableSSLforhdbalm.....................................................844SAPHANADeveloperGuideContentPUBLIC7ProxySupportforhdbalm..................................................845hdbalminstallCommand...................................................846hdbalmassembleCommand.................................................851hdbalmimportCommand..................................................852hdbalmtransportCommand.................................................853hdbalmlogCommand.....................................................854hdbalmproductCommand..................................................854hdbalmduCommand.....................................................856hdbalmdependenciesCommand.............................................858hdbalmpackageCommand.................................................859hdbalmadminCommand...................................................86011.9SAPHANARepositoryTranslationTool............................................861SAPHANARepositoryTranslationTool(RTT)Parameters...........................863ConfiguretheRepositoryTranslationTool.......................................865CreateText-StringsPackagesforTranslation....................................866ExportText-StringsFilesforTranslation........................................867ImportTranslatedText-StringsFiles...........................................86711.10MaintainingTranslationTextStrings...