Skip to main content

36 to 38 OTBI

 














End User 



Other Properties

Default Sort



Custom Heading


Filters



Prompts





Dragging Column inside for Filter and Section 


Advance to know SQL Issued


Export 





Fine tuning Layout in Result Options 

By default Compound Layout 



With Edit Pencil Icon










Click Pencil icon in Graph to exclude any columns






Sample Standard Dashboard






 

Cloning Standard Dashboard







Default Prompt US Bu

Instead of Save we have to use save as to point to custom folder


Delete standard prompt and drag n drop custom one



    Migration and Security Same like BIP but we cannot create ESS job out of OTBI


AGENT



We cann't change standarad dashboad view we have to clone and change

Comments

Post a Comment

Popular posts from this blog

1& 2 - Introduction to Fusion Cloud and Course Content

  Front End Pages were developed using JET Framework. Backend access won't be available we have to use BI server FRS/Smart view - Essbase OTBI - Subject Area BIP - Select tables In Fusion Cloud applications you cannot create the process all together from the beginning and you cannot modify the the workflow process also so what you can do you can configure the approval rules you can configure the approval so that means who can approve who has to take the action who has to be notified so all those approval rules . If process is not there you cannot do anything 
Post a Comment
Read more

27, 28 REST API SOAP Services

  PPT Webservices REST SOAP Notes **************************************************************************** SOAP Services - Old Timer **************************************************************************** Service WSDL URL: https://servername/fscmService/ErpIntegrationService?WSDL https://fa-esev-saasfademo1.ds-fa.oraclepdemos.com/fscmUI/faces/FuseWelcome?fndThemeName=Vision_Default fin_impl or hcm_impl5 or scm_impl vNE3n%4* https://fa-esev-saasfademo1.ds-fa.oraclepdemos.com/fscmService/ErpIntegrationService?WSDL EBS - Concurrent Programs Fusion Cloud - ESS Job - Enterprise Scheduler Service Job (Conc Prog) Fusion Cloud: ERP Cloud - FSCM - Financials and Supply Chain Mgmt HCM Cloud - HCM - Core HR, Payroll etc. PL/SQL Pkg -> (Procedures -> Logical units) SOAP Web Service -> (Operations -> Logical units) ESS - Enterprise Scheduler Service Job (conc prog) SubmitESSJobRequest Operation: Input - SubmitESSJobRequestMsg -> attributes defined -> jo...
Post a Comment
Read more

8 to15 BIP Data Model RTF ESS Job Schedule and Bursting

  Tools -> Report and Analytics -> Browse Catalog Fusion URL/analytics  Custom Folder Significance in Shared Folders Getting Table Information Official Docs Record Issue and Raise SR with Oracle [If not able to find] In Create New Data Model In Fusion Audti tables with _ at the end of table not like _A in EBS Drag n Drop Link between two groups like above Parameter type menu for  LOV to use and Refresh Check box Save as sample data and create Reprot Generate RTF automatically ESS Job LOV  for ESS Job Parameters In ESS Job we cannot pass first parameter value to the second parameter like in EBS and BI publisher - Limiation SR with Oracle UCM or Content Server or WebCentre Content - FusionURL/cs We won't this BI Publisher Schedule as we cannpt chnage dynamically mails or subject or msg body. We will mostly use bursting concept Schedule from ESS Bursting SQL For UCM Delivery Channel SQL for Email Delivery Channel SQL for FTP Delivery Channel In order for FTP to wo...
Post a Comment
Read more