oracle r12教程第10周ebsdba专业数据分析网站

FirstFirstintroducedintools Separationofdatalayer,presentationlayerandtranslation MultipleBI. XMLMultipleSmallOpen BIXSL-FOIndustrystandardXSL-FOIndustrystandardLayout tecanbecreatedbyanydesktopAcrobat –BIPublisherdesktop ... AnJ2EEapplicationrunningonBIPublisher...c:\OraHome_1\jdk\bin\java.exe-jarormi://localhost:23791oc4jadminoc4jadmin-Administratoroc4jadmin PrepareXML DATAGURU专业数据分

7 :a Format)fileOracleBI =>Data=>LoadSampleXMLOracleBI =>Insert=>OracleBI =>Insert=>OracleBI =>Validate OracleBI =>Preview Create te:aRTF(RichTextFormat) BIPubliserEBS Datamain Data 使用Data XMLdata te:aXMLfilewithspecificInterpretedbyXDODTEXE(aJavaOracleTheRDFgeneratesXMLasthe BIPubliserEBSCreateCreatetablesin Create ackaesinCreateadata tetocreateAnXMLfilebyContainslistofSQLstogeneratethe BIPubliserEBSDefineDefinedataLogonto“XMLPublisherAdministrator”(N)XMLPublisherAdministrator=>Home=>DataName:Application:ApplicationObjectData te:Addfile=> BIPubliserEBS “XMLPublisherAdministrator”(N)XMLPublisherAdministrator=>Home=> Name:Code:Application:ApplicationObjectDataDefinition: tefiles:uploadfromPC:Language: BIPubliserEBSProgram:MY ListingShortName:MYCUSINV_DATA_DEF(MUSTbesameasthe"code"indataApplication:ApplicationObjectExecutableName:OutputFormat:seq:Parameter:valueset:4Addtheconcprogram"MY ListingDataDef"to(N)Security>Responsibility>Groupname:SystemAdministratorApplication:Applicationobject BIPubliserEBSCreate uilder=>File|New=>selecttheoptiontobuildanewreport=>OnDataModeleditor,ClicktheSQLQueryiconintheleft-handtoolpalette.Inputthefollowing(Query1)andchangeitsgroupname PANY.select'FocusThreadLimited' Listing'asREPORT_TITLE,'' _SITEfromSimilarlyinputthisSQLquery(Query2)andrenamethegroupasG_CUSTOMER_LIST:select*fromSimilarlyinputthisSQLquery(Query3)andrenamethegroupas _LIST:select* JointheQuery2andQueryclicktheDataLinkiconinthetoolpaletteoftheDataandthendragthelinkfromCUSTOMER_IDinQuery2toCUSTOMER_ID(labeledCUSTOMER_ID1)Savethereportas BIPubliserEBSCreatetheOracleReportConc(N)Concurrent|ExecutableName:MY2CUSINVshortName:MY2CUSINVexecutionfilename:MY2CUSINVExecutionMethod:OracleReports BIPubliserEBSCreatetheOracleReportConc(N)concurrent|program|DefineName:MY2Customer shortname:MY2CUSINVexecutablename:Application:ApplicationObjectLibraryAttachoutputformat:style: BIPubliserEBSAddtheconcurrentprogram"MY2 Listing"toSystemAdministratorReportsrequest(N)Security|Responsibility| BIPubliserEBScopycopythefileMY2CUSINV.rdfinbinarymodetoNote:forstep4and5,thatisbecausewewanttotestitwiththe"sysadmin"andunderthecontextof"ApplicationObjectThesetupcanbedifferentifyouwanttestitunderdifferentuserdifferent BIPubliserEBSCreatetheDataLogonto“XMLPublisherAdministrator”(N)XMLPublisherAdministrator=>Home=>DataName:CODE:MY2CUSINV(Note:theshortnameoftheconcurrentApplication:ApplicationObject BIPubliserEBSCreatethe tefor(N)XMLPublisherAdministrator=>Home=> Name:MY2CUSINVCode:MY2CUSINVApplication:ApplicationObjectDataDefinition: tefiles:uploadfromPC:Language: BIPubliserEBSwhensubmitrequestfor"MY2 Listing",intheoptionsformat,multiplechoicetheresuchaspdf,html,rtfNote:AlsobearinmindthatcomparedwithotherOraclereports,wedesignthelayoutforit.Thelayoutcomesfromthe te,whichdesigneddesignedintheBIpublisher DevelocustomSysadmin(functionsecurityetc)andtablestructures(week ram(weekForms(WeekRe WeekOAFprogram(WeekBIpublisher(<176852.1>IntegratingCustomApplicationswithOracleApplicationsRelease<70167.1>StepbyStepguidetoCreatingaCorPro*CStandaloneConcurrentprogramforOracleapplicationscreateasqlcustom1)Createdirectorystructurefor customcd$APPL_TOPmkdirmyerpmkdirmermkdirmyerp/12.0.0/adminmkdirmyerp/12.0.0/sqlmkdirmkdirmyerp/12.0.0/reportsmkdirmyerp/12.0.0/formsmkdirmyerp/12.0.0/forms/USmkdirmyerp/12.0.0/libmkdirmkdir2.IncludethecustommoduleintotheEBSvi<MYERP_TOPoa_var="s_merto"oa_type="PROD_TOP"oa_enabled="FALSE">u01appl/m 12.0.0<cd.echo3.CREATEcreatetablespaceMYERPdatafile'/u04/data/MYERP01.dbf'size.createuserMYERPidentifiedbyMYERPdefaulttablespaceMYERPtemporarytablespacetempquotaunlimitedonMYERP;grantconnect,resourceto customOracleApplication=MYERPCustomApplicationShortName=MYERPBasepath=Description=MYERPCustom rOracleDatabaseUserName=MYERPPassword=MYERPPrivilege=EnabledInstallGroup=0Description=MYERPCustomApplication7)Add a "MYERPCustomApplication"--8)Create (N)Security-->responsibility-->RequestGroup=MYERPRequestGroupApplication=MYERPCustomApplicationCode=MYERPDescription=MYERPCustom9)Create(N)Application= Name=MYERPCustomApplicationType=Description=MYERPCustomSeq=Prompt=View Function=ViewAllConcurrentRequestsDescription=ViewRequestsSeq=Prompt=RunRequests Function=Requests:Description=Submit10)Createnew(N)Security-->Responsibility-->DefineResponsibilityName=MYERPCustomApplication=MYERPCustomResponsibilityKey=MYERPCUSTOMDescription=MYERPCustomResponsibilityAvailableFrom=OracleApplicationsDataGroupName=DataGroupApplication=MYERP=MYERPCustomRequestGroupName=MYERPRequest11)Add addthe"MYERPCustom"responsiblityto"sysadmin"12)Developthecd$MYERP_TOP/sqlvimyconcperf.sqlGrantalltheprivilegetoCreatesynonyminAPPSforalltheMYERPdataDeveloptheconcurrenExecutable:ShortName:MYERPCONCPERFApplication:MYERPCustomApplicationExecutionMethod:SQL*PLUSExecutionFileName:merconc(note:theSQLfilenameismyerpconcperf,casesensitiveandwithoutthesuffixandOraclewilltrytofinditin$MYERP_TOP/12.0.0./sqlDevelop concurrentProgram:MYERPConcPerfreportShortNam