Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Hi Sean Can you please try the below step and verify the results Open the RTF Template in the BI Desktop Builder—>click on Table properties of the column—>Click on Options—>choose the option "Automatically resize to fit contents".
-
HI Please review the given help center documentation links it might be helpful. https://docs.oracle.com/en/cloud/saas/financials/25b/faofb/Fixed-Assets-Asset-Balances-Real-Time-SA-183.html https://docs.oracle.com/en/cloud/saas/financials/25b/occar/financials-descriptive-flexfields-for-business-intelligence.html
-
Hi In OTBI (Oracle Transactional Business Intelligence) analysis, the GROUP BY clause allows you to aggregate data by specific columns, creating groups based on shared values. This is often used with aggregate functions like SUM(), AVG(), COUNT(), etc., to summarize data within each group. Please review the given OTBI help…
-
Hi Burak Please review the existing post for the similar issue. https://community.oracle.com/customerconnect/discussion/843359/bi-publisher-pivot-table-limit-configuration-of-able-to-add-only-5-columns
-
Hi Apply filter condition in the report to display value when the values is >0 or not equal to null.
-
Hi Vijay Please review the given documentation about available BIP Webservices Doc ID 2086077.1 Fusion Application BI Publisher (BIP) : Available Public Webservices in Fusion Applications NOTE: REST webservices of BI Publisher are currently not available for consumption in Fusion Application. There are no plans to include…
-
Hi Kanchana Please review the given OTBI help center documentation link https://docs.oracle.com/en/cloud/saas/human-resources/25b/faohb/Workforce-Performance-Performance-Rating-Real-Time-SA-255.html#Description…
-
Hi Amit Please use BI Broker mode while scheduling the PVO from BICC and then verify the results. BI Broker Mode for Extraction https://docs.oracle.com/en/cloud/saas/applications-common/24d/biacc/configure-offerings-to-extractofferingsdata-store-for-offering.html
-
Hi Please review the given help center documentation https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/sort-values-views.html
-
Hi John Mayo Please check user can view the required data from the Fusion UI page. If yes, Review the NQSquery.log of the analysis report contains any security predicate 1=2. If yes, Please review the given OTBI help center documentation link and ensure user is assigned with proper Duty/Job role.…
-
Hi Dhanashree Please review the given OTBI help center documentation link and also review database lineage Mapping details https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/faosm/Costing-Work-Order-Costs-Real-Time-SA-452.html#Description…
-
Hi Sunil Please customize the Seeded report using Customize option and ensure to copy all the contents in the /shared/Custom folder. Refer to the help center documentation about Customization. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-user/customizing-reports.html#GUID-31FA639D-E8E8-43B8-AB04-4014B747BB3D Create…
-
H Azul Please use session variables to restrict the data based on user access. Refer to the help center documentation link. https://docs.oracle.com/en/cloud/saas/sales/facaa/user-party-id-session-variable.html
-
Hi Kritika Please review the given documentation link and follow the steps recommended in the PDF attachment. KB8498 OTBI - General Ledger - Balances Real Time Subject Area not Returning Data; More Information on General Ledger Subject areas KFF-Configuring_Key_Flexfield_Segments_FINS_OTBI_FINAL.pdf…
-
Hi Francesca Please review the given documentation link about OTBI subject area https://docs.oracle.com/en/cloud/saas/financials/25b/faofb/General-Ledger-Transactional-Balances-Real-Time-SA-189.html#Duty-Roles KB8498 OTBI - General Ledger - Balances Real Time Subject Area not Returning Data; More Information on General…
-
Hi In Fusion SAAS BI application there is no option available to Export or Import fonts from one instance to another. Please use upload center option to upload the font in BI Publisher. Navigate to Manage Publisher—>click Upload center and also use Font Mapping to review the uploaded font details.…
-
Hi Please review the BICC documentation link about Data store PVO's and BICC lineage mapping details. https://docs.oracle.com/en/cloud/saas/applications-common/25b/biacc/review-view-object-to-database-lineage-mappings.html
-
Hi Oriana Please review the given help center documentation about Edit view https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/graph-data-analyses.html#GUID-BD555AE3-9810-4DDC-8A54-F687DD278743 Edit the Graphical view—>Click on XYZ option Graph properties—>Click on Style or Tiles and Labels and set the color as per your…
-
Hi Team Please review the OTBI subject area database lineage mapping details https://community.oracle.com/customerconnect/discussion/40268/financials-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1 If any of the columns not exposed in the OTBI subject area and if you feel this is desirable feature, please…
-
Hi For usage metrics, Please review and configure BIP Audit KB61120 Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? OR Doc ID 2059102.1 Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers?