Popular Tags
- OTBI 1,515
- Reporting 1,429
- FDI 1,353
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,025
- BI Publisher 910
- Analysis 700
- Oracle Fusion Analytics 645
- OAC 635
- Administration 569
- Fusion HCM Analytics 481
- Fusion ERP Analytics 473
- Analytics 470
- OBIEE 446
- BI Publisher Data Models 372
- Fusion Data Intelligence 321
- Oracle Analytics Cloud 318
- Security 314
- Fusion Data Intelligence FDI 310
- HCM 301
- BIP 277
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
OTBI
Discussion List
-
Publish Agent for SubscriptionSummary I need to know the limits of the functionality Content I used several OTBI Agents to deliver some OTBI Analysis to users. To avoid them to create their own agent…Emmanuel Baillieu 41 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Oracle Transactional Business Intelligence Forum -
Scheduled Report JobsSummary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…Charan Kollipara 358 views 8 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence Forum -
Hidden fields in OTBISummary Need to find fields selected as 'Hide' as system default in column properties Content We have recently had an issue where one of our users has hidden a couple fi…Ruthie 312 views 5 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum -
2Allow Turnover Reporting by Actual Termination Date in Workforce Management - Workforce Trend SubjecOrganization Name Alkermes, Inc Description Currently, the Workforce Trend subject area aggregates turnover reporting by the assignment effective date of the termination…Ryan_Sullivan 44 views 0 comments 2 points Most recent by Ryan_Sullivan Oracle Transactional Business Intelligence Idea Lab -
Need a SQL query to list all the scheduled OTBI Analsis and dashboardsSummary We need to review and track all the OTBI reports that are scheduled via agents Content Having the ability to query this out helps us understand who all have sche…Vishal Gala 231 views 2 comments 0 points Most recent by Akshay Aiyer Oracle Transactional Business Intelligence Forum -
Extract first sets of integer from entriesSummary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…Jonathan Chan gmg 255 views 8 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
How to build an inventory analysis coupled with time constrained measure?Summary An analysis, contain info. on on-hand-quantity and open quantity, does not produce results after 15mins of run time. This happens when a time constrained measure…Jonathan Chan gmg 1 view 0 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
1Name of the User that performed a changeDescription It would be great to see the name of the user that last updated the various objects in OTBI reports. We currently have the Username but it would be good to s…Rob F 11 views 0 comments 1 point Most recent by Rob F Oracle Transactional Business Intelligence Idea Lab -
Rows overcounting in AnalysisSummary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…Jonathan Chan gmg 141 views 2 comments 0 points Most recent by Jonathan Chan gmg Oracle Transactional Business Intelligence Forum -
2Query parent and child segment values in one column for OTBI reportsDescription Need the ability to search for any parent or child value without specifying the "level" for any CoA segment in OTBI. Use Case and Business Need A customer ne…Donald Joseph 31 views 0 comments 2 points Most recent by Donald Joseph Oracle Transactional Business Intelligence Idea Lab -
Hide Set at Default button under column propertiesSummary Hiding Set as default button under column properties in an Analysis Content Is it possible to hide the 'Set as Default' button under the column properties in an …Ruthie 71 views 3 comments 0 points Most recent by Ruthie Oracle Transactional Business Intelligence Forum -
1Allow group by Task Name within Task Dimension of PPM subject areasDescription We need to be able to summarize various measures within PPM subject areas such as Budget and Cost by Task Name. Use Case and Business Need We share same task…Donna Enright 1 view 0 comments 1 point Most recent by Donna Enright Oracle Transactional Business Intelligence Idea Lab -
SQL to Query Report Library - OTBI CatalogSummary Looking for SQL or tables to report a list of all reports, properties and folder location Content Does anyone have a SQL or know the tables that would contain th…Lisa G. 974 views 4 comments 0 points Most recent by Lisa G. Oracle Transactional Business Intelligence Forum -
1Access to ERP Fusion RPDOrganization Name City of Hollywood FL Description Please provide access to our organization's RPD(s). We would like an administrative view of all the data we have acces…Kamran Butt-161785 66 views 4 comments 1 point Most recent by Shivakumar Biradar Oracle Transactional Business Intelligence Idea Lab -
Error when using TODATE(REVENUE, YEAR) Oracle SQL functionSummary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…Jonathan Chan gmg 304 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence Forum -
1Name Dimensions Between Employee and ManagersOrganization Name Ocean Capital Description In most (if not all) subject areas, you are able to pull the following dimensions for Employees: * First Name * Last Name * D…Lindsay Lamont 2 views 1 comment 1 point Most recent by Linda Dunn Oracle Transactional Business Intelligence Idea Lab -
1ERP RPD Modelling DocumentationOrganization Name Western Digital Description Use case - User want to use multiple subject areas in ERP reporting. Questions while creating report - How to know what all…Shivakumar Biradar 12 views 1 comment 1 point Most recent by Shivakumar Biradar Oracle Transactional Business Intelligence Idea Lab -
1General Ledger - Balances Real Time Subject Area - Add Calendar MonthOrganization Name Rutgers University Description Hi, I'd like to have calendar month available in this subject area, and allow proper sorting by accounting period (ie: J…Rich Merkel 1 view 0 comments 1 point Most recent by Rich Merkel Oracle Transactional Business Intelligence Idea Lab -
1OTBI Workforce Management - Absence Real TImeOrganization Name ATCO Description Raised originally in SR 3-21411028631, the Dev team advised that this subject areas limitation is not being able to include the Absenc…Kris Sochacki 1 view 0 comments 1 point Most recent by Kris Sochacki Oracle Transactional Business Intelligence Idea Lab -
2Secured BI Role – need possibility to restrict data access as per security profileOrganization Name Skanska Description For us as a global company it is important to be able to allow local units to actively participate in the maintenance. At the same …Kerstin Henriksson 11 views 1 comment 2 points Most recent by Glen Ryen Oracle Transactional Business Intelligence Idea Lab