Popular Tags
- OTBI 1,413
- Reporting 1,374
- FDI 1,004
- Analysis and Data Visualization 963
- BI Publisher 825
- Analysis 666
- Oracle Fusion Analytics 557
- Administration 554
- OBIEE 425
- OAC 364
- Analytics 359
- BI Publisher Data Models 338
- Security 279
- Answers 263
- Analyses 253
- HCM 243
- Developers 240
- BIP 236
- Data Modelling and Datasets 220
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 189
- Report Output 181
- Customizing Reports 151
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Reporting
Discussion List
-
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat… -
Action Links not workingSummary: In the below report, I have 3 columns (2 with column selectors & 1 hidden), and one hierarchical column. The 2 columns with column selector are hidden by defaul…Amrita Gupta-Oracle 377 views 8 comments 0 points Most recent by Ruma Bhatnagar-Oracle Oracle Analytics Cloud and Server -
6FDI Report Download with prompts/filter values in the headerLooking for a way to download FDI/FAW reports in data/excel form along with prompts/filters/parameter values in the header so as to have better information on the report…Abhishek J 62 views 5 comments 6 points Most recent by Krishna Prasad Kotti-Oracle Oracle Analytics Cloud and Server Idea Lab
-
Job change - OTBI reportHello, I would like to create an OTBI report to highlight the date of an employee's business title change. I don't want to use a specific reason code (ex promotion) beca…Jacqueline GRANDIN 35 views 3 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 1.2K views 11 comments 0 points Most recent by User_ABC0S Oracle Transactional Business Intelligence
-
3OAC DV Workbook Number FormatOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): In OAC Data V…Carlos Marques - Oracle 244 views 5 comments 3 points Most recent by Anders W. Langholm Oracle Analytics Cloud and Server Idea Lab
-
BIP Reports are ending in Error with ORA-56733: logical I/O limit exceeded - call abortedBIP Reports completing with 'Time Out' ERROR after running around 3 hours and exceeding the Data Model 'Query Time out" limit and displaying below error message Waiting …
-
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…Nalinee Uppiah 1.6K views 13 comments 0 points Most recent by Luis Villagomez - IMMI Oracle Transactional Business Intelligence
-
Need to Add more Information from Seeded Data ModelSummary We've successfully customized an AR Invoice Print Layout, but we need more information that the Seeded Data Model Does not Provide Content Hi, we're in the middl…Juan Miguel Isip-94819 133 views 2 comments 1 point Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
1Excel template to be generating output in Excel 2007 or Beyond versionsOur client had a requirement of a custom BIP report with 99+ columns to be fetched and expected volume of more than 1 Million per execution. Current functionality allows…Agshukla 11 views 1 comment 1 point Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Error when having a string concatenation of two columns over 4000 characters dataHi, We are encountering an error when concatenating two columns in the report(OAC), as the combined number of characters exceeds the 4000-character limit. While we under…Subhakara Netala-Oracle 148 views 9 comments 0 points Most recent by Subhakara Netala-Oracle Oracle Analytics Cloud and Server -
45Ability to change the name of Grand Totals and Subtotals in Pivot/Table visualizationsOrganization Name GSO Description We need the ability to change the name of Grand Totals and Subtotals in Pivot and Table visualizations. Use Case and Business Need This…Costin Domozina - Oracle 374 views 13 comments 45 points Most recent by Benoît Vedrines Oracle Analytics Cloud and Server Idea Lab -
How to restrict prompt values in Dashboard PromptHi Experts, Could you help me restrict the prompt values in the dashboard prompt? I'm using this dashboard & column, "Recruiting - Recruiting Real Time"."Job Requisition…
-
Oracle Analytics Publisher - How to remove the "xdo" text appearing near to the reports navigationsHi Team, Any solution/suggestions to remove the "xdo" text appears near to the report's navigation bar. Please refer the attached screenshot for the reference.Kartik Mali-Oracle 21 views 3 comments 0 points Most recent by Kartik Mali-Oracle Oracle Analytics Publisher -
Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances?Trying to build an opex report but only getting the current period values not year to date. Do I have to add multiple rows of sql into the data model to add all the peri…Lynda G 86 views 7 comments 0 points Most recent by Lynda G Oracle Transactional Business Intelligence
-
General Ledger Balances Real Time- Natural Account Segment Hierarchy not showing dataTeam, Need help on General Ledger Balances Real Time subject Area. As per description, this subject area is based on Multidimensional Cube. When we create report to see …FDI_USER 112 views 4 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence -
OBI TIMEZONE: OPERA CLOUD VS OPERA R&A Timing ARE NOT MATCHINGHi team, My time in Opera is Different from time in the report generated in R&A . R&A uses GMT time zone. I am based in Doha (GMT+3), so the report is showing data 3 hou…
-
33Upload Custom Color PaletteOrganization Name University of Kansas Description We'd like to be able to upload our own custom color palette that is associated with our company branding for our repor…Brendan J. Doyle-Oracle 419 views 10 comments 33 points Most recent by ScottJohnson Oracle Analytics Cloud and Server Idea Lab -
BI Bursting with PDF attachment and HTML in the bodySummary BI Bursting with PDF attachment and HTML in the body Content Hi All Kindly, I have business requirement as following: * to send email to our customers email with…
-
How to restrict access to audit tables in fusion HCMHi All, We have a certain requirement to restrict access to audit tables like "CMP_SALARY_". People with only specified roles/permissions should be able to query this ta…Thimmaiah CP-Oracle 111 views 4 comments 0 points Most recent by Simon Ng Oracle Analytics Publisher