{"id":32159,"date":"2026-01-06T09:04:00","date_gmt":"2026-01-06T09:04:00","guid":{"rendered":"http:\/\/kovaion-new1.local\/how-to-enable-flexible-reporting-in-oracle-redwood-dashboards-with-otbi\/"},"modified":"2026-01-06T11:25:56","modified_gmt":"2026-01-06T11:25:56","slug":"how-to-enable-flexible-reporting-in-oracle-redwood-dashboards-with-otbi","status":"publish","type":"post","link":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/how-to-enable-flexible-reporting-in-oracle-redwood-dashboards-with-otbi\/","title":{"rendered":"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI"},"content":{"rendered":"<p>&nbsp;<\/p>\n<h2><strong>Overview<\/strong><\/h2>\n<ul>\n<li>This blog discusses the processes and steps to Flexible Reporting in Redwood Dashboards.<\/li>\n<li>Oracle Transactional Business Intelligence (OTBI) content can now be configured as a data source for Redwood Analytics in specific Fusion pages.<\/li>\n<li>It allows business users to add charts, tables, and metrics from OTBI into dashboards, enabling real-time, contextual analytics.<\/li>\n<li>This feature improves user experience by reducing navigation to separate BI tools and providing seamless access to insights within the Redwood UX.<\/li>\n<li>It supports multiple visualization types like Bar, Line, Pie, Donut, Funnel, Metric Cards, and Tabular reports.<\/li>\n<li>This feature is available across Redwood dashboards in HCM, Financials, Procurement, and other modules, wherever visualizations are supported.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Summary<\/strong><\/h2>\n<p>In brief, the procedure for creating Redwood Analytics is as follows:<\/p>\n<ul>\n<li>Create OTBI reports that provide the necessary data to present to users.<\/li>\n<li>Create a\u202fVisualization Configuration\u202ffor each Redwood Analytic that is required.<\/li>\n<li>Use the\u202fEdit Page Layout\u202ffeature to drag and drop new Redwood Analytic KPIs and Visualizations onto your dashboards.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Steps to Enable Oracle Redwood Flexible Reporting for Real-Time Analytics<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<ul>\n<li>Access the page by appending \/fscmUI\/redwood\/cx-analytics\/application\/container\/dvconfig after the &#8220;.com&#8221; in the pod URL. Use the Add button to include new KPIs and visualizations.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18027\" aria-describedby=\"caption-attachment-18027\" style=\"width: 740px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18027\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-1-Home-Page-300x152.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 1- Home Page\" width=\"740\" height=\"375\" \/><figcaption id=\"caption-attachment-18027\" class=\"wp-caption-text\">Fig 1: Home Page<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18026\" aria-describedby=\"caption-attachment-18026\" style=\"width: 740px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18026\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-2-Visualization-Configuration-300x144.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 2 - Visualization Configuration\" width=\"740\" height=\"355\" \/><figcaption id=\"caption-attachment-18026\" class=\"wp-caption-text\">Fig 2: Visualization Configuration<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>This section will display all the OTBI dashboards that have created within this Visualization Configuration<\/p>\n<ul>\n<li>Click Add Visualization<\/li>\n<li>Select the\u202fOTBI Analysis\u202fsource type.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18025\" aria-describedby=\"caption-attachment-18025\" style=\"width: 738px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18025\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-3-Create-Configuration-300x144.png\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 3: Create Configuration\" width=\"738\" height=\"354\" \/><figcaption id=\"caption-attachment-18025\" class=\"wp-caption-text\">Fig 3: Create Configuration<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Select the folder containing the OTBI analysis, search for the required analysis, and choose it from the LOV.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18024\" aria-describedby=\"caption-attachment-18024\" style=\"width: 740px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18024\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-4-OTBI-Analysis-source-type-selection-300x141.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 4: OTBI Analysis\u202fsource type selection\" width=\"740\" height=\"348\" \/><figcaption id=\"caption-attachment-18024\" class=\"wp-caption-text\">Fig 4: OTBI Analysis\u202fsource type selection<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Click on Visualization Type to choose the required chart.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18023\" aria-describedby=\"caption-attachment-18023\" style=\"width: 728px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18023\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-5-Configuration-for-Hires-by-Gender-Visualization-300x143.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 5: Configuration for - Hires by Gender - Visualization\" width=\"728\" height=\"347\" \/><figcaption id=\"caption-attachment-18023\" class=\"wp-caption-text\">Fig 5: Configuration for &#8211; Hires by Gender &#8211; Visualization<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Based on the OTBI report data, the page auto-selects a visualization type. The Details section is filled in, and the Redwood Analytic appears on the right. The fields in the Details section differ depending on the visualization type, such as pie charts or bar charts.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18022\" aria-describedby=\"caption-attachment-18022\" style=\"width: 731px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18022\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-6-300x135.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 6:\" width=\"731\" height=\"329\" \/><figcaption id=\"caption-attachment-18022\" class=\"wp-caption-text\">Fig 6:<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Click the + icon in the Filter section to add a filter to the chart.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18021\" aria-describedby=\"caption-attachment-18021\" style=\"width: 745px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18021\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-7-Filter-section-300x31.jpg\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 7 - Filter section\" width=\"745\" height=\"77\" \/><figcaption id=\"caption-attachment-18021\" class=\"wp-caption-text\">Fig 7: Filter section<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>Applying a filter will modify the chart accordingly.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_18020\" aria-describedby=\"caption-attachment-18020\" style=\"width: 757px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-18020\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Fig-8-Hires-by-Gender-Visualization-with-Month-Filter-300x143.png\" alt=\"How to Enable Flexible Reporting in Oracle Redwood Dashboards with OTBI - Fig 8: Hires by Gender Visualization with Month Filter\" width=\"757\" height=\"361\" \/><figcaption id=\"caption-attachment-18020\" class=\"wp-caption-text\">Fig 8: Hires by Gender Visualization with Month Filter<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<ul>\n<li>As the final step, change the Redwood Analytics visualization status to Active. To make changes in the future, the status must be inactivated, the visualization saved, and then set back to Draft.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Access Requirements<\/strong><\/h2>\n<p>The following privileges are required:<\/p>\n<p><strong>1. Visualization Configurator:<\/strong><\/p>\n<ul>\n<li>To view the dashboard: ZCA_VIEW_DATA_VISUALIZATION_CONFIGURATION_PRIV<\/li>\n<li>To configure the dashboard:\u00a0 ZCA_MANAGE_DATA_VISUALIZATION_CONFIGURATION_PRIV<\/li>\n<\/ul>\n<p>2. Each dashboard controls Edit Page Layout through a specific privilege, which is documented in the What&#8217;s New entry for that dashboard. For instance, the (HCM) Team Activity Center requires PER_EDIT_TEAM_ACTIVITY_CENTER_LAYOUT privilege to allow layout edits.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Tips and considerations<\/strong><\/h2>\n<p>This may not be a comprehensive list of tips and considerations, but it covers the most common ones:<\/p>\n<ul>\n<li>Line charts cannot process numeric values on the X-axis. These values must be CAST to CHAR in OTBI for proper functionality. This limitation may also affect other chart types. In some cases, you may need to clear the Category field in the Visualization Configuration tool.<\/li>\n<li>The Tabular Chart type in the visualization tool may display the error: &#8216;Select values for all the required fields to generate the visualization.&#8217; Currently, there is no known solution for this issue.<\/li>\n<li>The X-Axis LOV in the configuration tool displays only the first eight columns from the OTBI report. If additional columns are needed, you should reorder the columns in the OTBI report.<\/li>\n<li>Some OTBI features are not supported by the visualization tool. The following features are currently unsupported (this list is not exhaustive): View Selector, Column Selector, Drills, Prompts<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Upcoming Features<\/strong><\/h2>\n<ul>\n<li><strong>Expanded Page Support Across Modules:<\/strong> Oracle plans to extend support for flexible OTBI visualizations to more Redwood pages, beyond the current releases where it&#8217;s available. Notifications will be provided in future What\u2019s New documents when new pages become supported.<\/li>\n<li><strong>Enhanced Roadmap for Supply Chain Modules:<\/strong> Releases 25D and 26A are expected to include enhancements for the Supply and Demand Planning dashboards. Currently, Redwood support in these areas is limited, but full visual and analytic capabilities are anticipated in later releases like 26D.<\/li>\n<li><strong>General Future Enhancements Across Modules:<\/strong> While no specific public roadmap exists for future flexible reporting features, Oracle is steadily enhancing Redwood UX across HCM, SCM, Finance, ERP, and more.<\/li>\n<\/ul>\n<p>The <strong><a href=\"https:\/\/www.kovaion.com\/blog\/oracle-cloud-hcm-25c-release-update\/\" target=\"_blank\" rel=\"noopener\">25C release<\/a><\/strong> introduced Flexible Reporting, and Oracle continues to enhance and broaden Redwood capabilities in future updates.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Business Benefits of Flexible Reporting in Oracle Redwood Dashboards<\/strong><\/h2>\n<ul>\n<li><strong>Real-Time Decision Making:\u00a0<\/strong>With Oracle Redwood Dashboards, organizations can access real-time analytics directly within Fusion applications. This eliminates delays caused by switching to separate BI tools, empowering managers to act faster and smarter.<\/li>\n<li><strong>Improved User Experience:<\/strong> The Redwood UX provides a modern, intuitive interface that simplifies how employees interact with data. By embedding OTBI visualizations into dashboards, users enjoy a seamless experience without complex navigation.<\/li>\n<li><strong>Contextual Insights Across Modules:\u00a0<\/strong>Flexible reporting enables contextual analytics in HCM, Finance, Procurement, and Supply Chain. Decision-makers can view dashboards tailored to their roles, enhancing productivity and business outcomes.<\/li>\n<li><strong>Enhanced Productivity with Self-Service Reporting:\u00a0<\/strong>Business users can configure charts, KPIs, and tables independently, reducing dependency on IT or BI teams. This self-service analytics approach accelerates reporting cycles and lowers operational costs.<\/li>\n<li><strong>Streamlined Compliance and Accuracy:\u00a0<\/strong>By pulling data directly from Oracle Transactional Business Intelligence (OTBI), reports remain consistent, accurate, and compliant with organizational policies. This minimizes manual errors and ensures trustworthy insights.<\/li>\n<li><strong>Future-Ready Analytics:\u00a0<\/strong>With Oracle continuously expanding Redwood analytics capabilities in upcoming releases, organizations adopting flexible reporting today are better positioned for scalable digital transformation tomorrow.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><strong>Conclusion<\/strong><\/h2>\n<p>Flexible Reporting in Redwood Dashboards brings a modern, user-friendly way to integrate analytics within Oracle Fusion. By leveraging OTBI and Redwood\u2019s visualization capabilities, it eliminates dependency on hardcoded BI reports, enabling business users to create interactive, role-based dashboards with real-time insights\u2014ultimately improving decision-making and user experience.<\/p>\n<p>&nbsp;<\/p>\n<h2><strong>Ready to Unlock the Power of Redwood Dashboards?<\/strong><\/h2>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.kovaion.com\/service\/oracle-redwood-ux-implementation\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-17912\" src=\"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-content\/uploads\/2026\/01\/Implement-Oracle-Redwood-with-us-300x65.png\" alt=\"Implement Oracle Redwood with us\" width=\"775\" height=\"168\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>At Kovaion Consulting, we help enterprises harness the full potential of <strong><a href=\"https:\/\/www.kovaion.com\/service\/oracle-redwood-ux-implementation\/\" target=\"_blank\" rel=\"noopener\">Oracle Redwood UX<\/a><\/strong> and OTBI analytics to create flexible, real-time dashboards that drive smarter decisions. Our experts specialize in <strong><a href=\"https:\/\/www.kovaion.com\/service\/oracle-hcm-cloud\/\" target=\"_blank\" rel=\"noopener\">Oracle HCM<\/a><\/strong>, Finance, Procurement, and Supply Chain modules, ensuring your teams get seamless, role-based insights without the complexity.<\/p>\n<p>Accelerate your Oracle Cloud journey with <strong><a href=\"https:\/\/www.kovaion.com\/service\/oracle-redwood-ux-implementation\/\" target=\"_blank\" rel=\"noopener\">Kovaion\u2019s Redwood implementation<\/a><\/strong> and reporting services.<\/p>\n<p>Get in touch with our experts to explore how we can tailor Redwood dashboards to your business needs.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Author<\/strong>: Sameer Shaik, Oracle HCM Consultant<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Overview This blog discusses the processes and steps to Flexible Reporting in Redwood Dashboards. Oracle Transactional Business Intelligence (OTBI) content can now be configured as a data source for Redwood Analytics in specific Fusion pages. It allows business users to add charts, tables, and metrics from OTBI into dashboards, enabling real-time, contextual analytics. This [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":21829,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[18],"tags":[],"class_list":["post-32159","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle-hcm"],"acf":[],"_links":{"self":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/32159","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/comments?post=32159"}],"version-history":[{"count":1,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/32159\/revisions"}],"predecessor-version":[{"id":32160,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/posts\/32159\/revisions\/32160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media\/21829"}],"wp:attachment":[{"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/media?parent=32159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/categories?post=32159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stage.kovaionplay.com\/stage-kovaion\/wp-json\/wp\/v2\/tags?post=32159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}