-
Missing Folder in OBI
Summary Is there a way to recover missing folder in BI. Content We have a folder Analytic Library that is missing in our production environment. I can see it in our PTFDev environment. I am not sure how this folder was removed. But is there a way to recover it? Thanks in advance for your help!!
-
Dynamic Report layouts in BI Publisher
Summary Dynamic Report layouts in BI Publisher Content We have a requirement from a client where from the prompts, if we select any attributes you report layout has to show case those field attributes in the report layout. Any help is highly appreciated
-
BI Mobile HD Apps
Summary OTBI reports in BI Mobile App Content We would like to view reports created in OTBI from within BI Mobile HD app. What steps need to be taken to have the OTBI created reports to show in good resolution in the app?
-
create analysis from direct db query
Summary how to created direct db query Content Hi Is there a way to create an analysis from direct database query. I tried the option but cannot get it to work. is there any additional set that is required for this? please advise.
-
Prompt Dashboard for cross subject areas
Summary Prompt Dashboard for cross subject areas Content Hello, I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in the resulted query. If I wanted to insert the analysis in a dashboard, how do I create a dashboard prompt in order to filter appropriately the analysis…
-
OTBI Action Link Not working for union report-Finance Module
Summary OTBI Action Link Not working for union report-Finance Module Content Hi, I am using "Receivables - Transactions Real Time" and "Receivables - Receipts Details Real Time" subject areas for both summary and detail report (Union report) and an action link for site field. I have a value in union 2 for a particular…
-
Complex filters - grouping 3 filters together
Content I want to create a complex filter which requires grouping 3 filters with another set of filters. I have played around clicking the AND / OR to get the combination, but it has not worked so far. Can someone point me in the right direction ? This is what I am trying to achieve Filter 1 AND ( (Filter 2 AND Filter 3)…
-
Dashboard Custom Print and Export design in 12C
Summary Any resources that give detailed instructions on how to design a custom print layout? Content Hello, I have stumbled across a 'Custom Print and Export Layouts' feature in our OBIEE 12C dashboards. I got as far as importing into BI Publisher data model and report (which I am familiar with as well) but that's about…
-
How To Add Descriptive Flexfield To Fusion Transactional Business Intelligence (OTBI)
Content Hi, I have did these steps Sequentially 1-From Manage Descriptive Flexfields page i have checked the [BI Enabled] flag . 2-Deployed the Flexfield . 3- Run these processes from ESS 3-1: Create Rules XML File for BI Extender Automation 3-2 : Import Oracle Fusion Data Extensions for Transactional Business Intelligence…
-
OTBI Pivot Table TopN function
Content Hi, can someone provide some quidance on restricting pivot table results (and associated chart) to the Top 10 results based on Nationality by Person Count. Thanks in advance Linda
-
Working with Agents - OTBI - Help needed
Summary I've setup an agent to deliver a report via E-mail... I tried everything but report is being delivered with no results: Content Hi, I've setup an agent to deliver a report via E-mail (as an attached excel file)... I tried everything but report is being delivered with no results\: BTW when I'm running the report…
-
Read Only Access to OBTI for users
Summary Read Only Access to OBTI for users Content How can we restrict users not to change the reports layout in OTBI, currently they have teh access and they can have the access to edit the report. Any guide line to manage their roles. Thanks Farooq
-
Scheduling Agent with Prompt
Summary Scheduling Agent with Prompt Content I have a report that has a facility filter prompt built into it. I've created several scheduling agents based on this report and each is prompted in the scheduling agent for a different facility however the only scheduling agent that returns data is for the very first facility…
-
Decimals not appearing on excel export when run through agent
Summary Decimals not appearing on excel export when run through agent Content I have some reports that I have created a scheduling agent to automatically run and email to some colleagues. When these reports are run through BI Publisher and exported to excel manually, the decimals are shown. When the agent runs the report…
-
Contract Changes in HCM Cloud
Summary How to handle changes to contract using HCM Cloud Content Hi, We are using HCM Cloud and one of our areas we are falling down on is changes to peoples contracts I.e. changes to hours, location/job changes etc. At present we do not have a facility setup for these changes to be sent automatically by letter to the…
-
Dashboard configuration
Summary Recommendation for what to configure the width of a dashboard Content Hello, I am in the processing of building a dashboard and I am running into an issue with formatting. Ideally, I would like the width of the dashboard to fit the size of the screen and not have to scroll left to right. Any recommendations on how…
-
OTBI sessions
Summary How do I differentiate OTBI sessions Content I am wondering if like the HCM landing page background, we can color codde OTBI environment so I don't accidently make changes to my reports in Prod instead of in Test. Ideas please. TIA
-
Oracle BI Publisher - Report on Report Job History
Summary Find a way to acquire all Report Job History listed and extract all data to Excel Content Hi, I used to be an Apps DBA\Technical application Support on R12 EBS back in the day and I wanted to know if we can extract all jobs running within Report Job History within BI Publisher? If there is no obvious download 'all…
-
Dynamically place the custom logo in BIP reports in Fusion Cloud
Summary Dynamically place the custom logo in BIP reports in Fusion Cloud Content Hi, We need to developed few custom reports as per the requirements. In this implementation we have around 30 companies each of them has its own logo. so in the report template we need to make the displaying logo dynamic means if user from…
-
Packages in BI publisher
Summary Packages in BI publisher Content Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard packages . So how i can access these packages in oracle cloud fusion ? and how to know if these packages are in oracle cloud fusion or not ? Also can i…
-
Formatting Totals Row
Summary Formatting Totals Row Content I have a report that I used the aggregation rule (totals row) to calculate the sum or average of the entire column upon running the report. There are a few columns that I recently added that I would like to center. Is this possible? See attached image. Thanks, Paul
-
Can we have a Date Type Parameter as a Presentation Variable ?
Summary Date Type Parameter as Presentation Variable in Fusion OTBI Reports? Content HI Friends, Any idea how can we get the above requirement ?
-
BI Report Output Formatting Options based on Security Roles
Content Hi, I understand it is possible to specify the report output options at the time of report design, however I wanted to ask if we can do a conditional login on that? For eg. HR Manager can have 3 options PDF, RTF and CSV LM can have only PDF Employee can have only RTF. Not sure if it is possible but wanted to hear…
-
Remove line feed from OTBI Report
Summary Remove line feed from OTBI Report Content Hi all Is there any way to remove line feed and carriage return from text columns in OTBI report? I tried to define a new analysis sql in advanced tab and use instruction like "replace(OTBI column, chr(10), ' ')" , but i receive an error (message:…
-
Exceeded configured maximum number of allowed input records
Summary Error message received when running report Content Hi, could someone explain why I get the attached error? Many thanks, Antony.
-
Table display issue
Summary How do I expand the table results view Content When I create an OTBI report sometimes the table does not fill the page (even with 2/3 columns) but instead creates a small window with the ability for the user to scroll across. How do I expand the table view to show all of the information on the screen without the…
-
Multiple subject area Issue in Cloud BI report
Summary Unable to get the measure values of 2nd subject area Content Hi All, I am working on Procurement subject areas in cloud BI version is 11.1.1.9 Report Requirement: Report should display total amount spent on different categories with or without Blanket Purchase Agreement This is required to built with two subject…
-
Translate SQL of OTBI in ApplicationDB HCM
Summary How to Translate SQL of OTBI in ApplicationDB HCM? Content Hello, I have verified that in SA of OTBI there aren't some value that I want to use in a report. I found this in Application table and I want to create a new BI publisher.,I verified that the join between OBIEE dataset and ApplicationDB dataset is very…
-
Purchase requistion Status analysis
Summary Analysis for Purchase Requistions status Content Hi, I need to developed OTBI analysis for Purchase Requisition with below information: PR number PR Amount Created by Creation date Status Pending with Can someone please help me to develop this analysis in OTBI. Thannk
-
Pass Groovy script variable to OTBI Dashboard
Summary Pass Groovy script variable to OTBI Dashboard Content Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard prompt directly). The page is designed by groovy script and I have added Dashboard in that page. For example I want to send the PO number into the Dashboard…
