Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi , OTBI Analysis always works based on data access only. This feature or functionality is already in place with OTBI. If you can provide more details or the thread which you are referring to, i can review details and respond. Thanks Gayatri
-
Hi , please refer to this document How To redirect BIP Report dynamically from custom page created in fusion? (Doc ID 2652703.1) Thanks
-
Hi, Please deselect options (Show Controls , Allow Sharing Report Links) from Report properties shown in screen shot below to adjust report options accordingly:
-
Hi, Please review below url for Lineage document for HCM for reference :https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1 This Spreadsheet will hold table name and column which is referred by respective subject area.
-
Hi, Embed this below piece of code in BIP report : This Code will pull Business Units associated with Logged in User based on Data access provided. In BIP Report, we can restrict using this: select * from fun_all_business_units_v fabv where fabv.STATUS = 'A' AND fabv.bu_id in (select distinct role.org_id from…
-
Hi, Is the Output in Screen shot from OTBI Subject Area. Can you please provide which Subject Area you are using.
-
Hi, To Fetch OTBI Subject Areas and relevant column details , look for Financial Lineage Data base Mapping with View Objects Excel for Rel in which you are working. For More Details , Check this Oracle Note : Fusion OTBI Data Lineage Mapping (Doc ID 2721576.1)
-
Hi, OTBI Shows Secured Data based on Data Access provided for a heirarchy to the Logged In User through Manage Data Access for Users Task. If User has been assigned a Single BU Data access, then logged in user will not be able to view data of other BU's from OTBI Subject area. Please go through My Support Oracle Note for…
-
Try this Replace with Current_Date and try below Sample Code to fetch Date value SELECT TO_CHAR(TO_DATE(substr('2023-11-01T00:00:00.000+00:00',1,INSTR('2023-11-01T00:00:00.000+00:00','T',1)-1),'YYYY-MM-DD'),'dd-mon-yyyy', 'NLS_DATE_LANGUAGE=ENGLISH') from dual
-
Hi , Create two Analysis Item with Onhand Details Item with Invoice , Pending PO'S You can create a common Dashboard prompt and pass Item No to both Analysis in One Dashboard to View as one Page of Information Choose to Perform Interaction or Drill down between two ANalysis and achieve this solution in case if two subject…