Popular Tags
- OTBI 1,463
- Reporting 1,403
- FDI 1,166
- Fusion AI Data Platform 1,025
- Analysis and Data Visualization 995
- BI Publisher 869
- Analysis 685
- Oracle Fusion Analytics 602
- Administration 556
- OAC 496
- OBIEE 435
- Fusion HCM Analytics 419
- Analytics 414
- Fusion ERP Analytics 398
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 230
- Oracle Analytics Cloud 224
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics and AI Community
Oracle Analytics and AI Community, designed for Data Engineers, Data Analysts, Data Scientists, and AI leaders to share knowledge, discuss best practices, collaborate and drive innovation using Oracle Analytics and Oracle AI Data Platform.
Discussion List
-
Some AP invoices are missing in the OTBI Payables ReportHi Team We have created OTBI report in Payables. In that report we have given three parameters 1) Accounting period 2) Supplier 3) Business Unit. If we download the repo…Rajesh Kushwaha 81 views 7 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
3Sorting Behavior of the search box should be the same as the LOV sorting behaviorWhen I scheduled the custom BIP report, I found that the sorting behavior of the parameter while in LOV follows the order I defined in the LOV sql in data model, but the…CS Yuen-Oracle 1 view 0 comments 3 points Started by CS Yuen-Oracle Oracle Analytics Publisher Idea Lab -
1Anomaly detection for time series with Kats (Meta)Anomaly detection for time series with Kats (Meta) in DVBenjamin Arnulf-Oracle 1 view 0 comments 1 point Started by Benjamin Arnulf-Oracle Oracle Analytics Idea Lab -
2LSTM Forecast Algo in Oracle AnalyticsBring the LSTM algo in Oracle Analytics. It would be excellent as a second pass after running Prophet. If you read this idea and you work in FP&A or Finance or Finance C…Benjamin Arnulf-Oracle 1 view 0 comments 2 points Started by Benjamin Arnulf-Oracle Oracle Analytics Idea Lab -
While creating a credit memo in oracle fusion in credit transactions i am facing the below error.You can't overapply this transaction. (AR-855287) The transaction type assigned to the transaction doesn't allow overapplication. You can only apply a credit or receipt …SAITEJA_01 281 views 3 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
7Bring NeuralProphet to one click forecastI love the new Prophet algorithm from Meta and I’m very proud of Oracle for bringing it to the Data Visualization engine. Now, I would like to see the next evolution for…Benjamin Arnulf-Oracle 11 views 0 comments 7 points Started by Benjamin Arnulf-Oracle Oracle Analytics Idea Lab -
Need backend query to fetch audit details of Job profileHi, We have enabled audit for jobs and trying to fetch the job profile details through BIP Report who, when and what are the changes that are made but somehow we couldn'…Anjana Bharidey 1 view 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
Using report parameter to call different excel template in different layoutHi, We have an requirement from our client. They have more than 10 RTF different template for a report. When the user run the report, user have an option to choose which…Yeung Shing Keith 11 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
Is there a way to find all data models using a specific field?I asked Oracle this question years ago (and the answer was no), but I wanted to check again with this group to see if anyone found a way to accomplish it. We need to fin…Scott Paulin 41 views 4 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum -
51Increase in OTBI Analysis row limitOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): In Oracle OTB…Ranjithkumarrr 1.7K views 2 comments 51 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab -
SQL to get individual compensation plan items to show under Additional compensationI want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and option…Raghavendra M 101 views 2 comments 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform Forum -
11Option to increase ACL limitOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): WM Morrisons Supermarket Limited Desc…Pradeep T U 408 views 4 comments 11 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab -
Difference between FDI and OBIEECan you share the differences between FDI and OBIEE -
OTBI analysis - problem with left outer joinHi, I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submit…User_RD03L 132 views 2 comments 0 points Most recent by JustinLitalien Oracle Transactional Business Intelligence Forum -
6Ability to identify orphaned scheduled Agents & Jobs after their owner leavesWe are having tough time with identifying orphaned agents and BIP jobs which are running and sending alerts by employees who are no longer with the company. With OAS 9.0… -
3OAC Classic - Control over which folders are automatically expanded in the dashboard menuDescription On opening the dashboard menu in OAC Classic, a number of folders are automatically expanded. I understand this is by design and "The menu uses a certain amo… -
3Dynamic display of sets of columns in OTBI or BIP reporting tools depending on run locationOrganization Name Marriott Description Hi We have a gap in our requirements where we need the reports to only display country specific columns. We want our reports (BIP …Michael John Sabaco 22 views 2 comments 3 points Most recent by Rodrigo Baca Oracle Transactional Business Intelligence Idea Lab -
Fiscal Year / Fiscal Period filters not applying correctly in AP Expense subject area workbookHi, Relatively new to FDI and trying to create a simple table visualisation from the Financials - AP Expense subject area but the Fiscal Year and Fiscal Period fields ar…Elaine Hendry 62 views 6 comments 0 points Most recent by Gianni Ceresa Oracle Fusion AI Data Platform Forum -
Not receiving totalResults value while using filter in /hcmRestApi/scim/Users restAPIWe tried using the below query: https://hctz-dev2.fa.us2.oraclecloud.com/hcmRestApi/scim/Users?totalResults=true&filter=(active eq true) to find all the active users in …User_62V8U 11 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Fusion AI Data Platform Forum -
How can we calculate total Off Cycle Payments using the standard columns available in HCM SAHow can we calculate total Off Cycle Payments using the standard columns available in HCM SAViswanatha Reddy Patil 21 views 2 comments 1 point Most recent by Gianni Ceresa Oracle Fusion AI Data Platform Forum