Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
Welcome to the Oracle Transactional Business Intelligence Community Forum!
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.
If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi
For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Transactional Business Intelligence
Discussion List
-
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… -
call a procedure on oracle bi publisher 12cSummary oracle bi publisher add Global-Level Element by PL/SQL Content Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mod…
-
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…
-
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 …
-
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…
-
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…
-
How can I export a list of all active reports we have HCM?Summary I need to have a list of all our reports in HCM BIP (and/or)OTBI Content How can I found out how many reports there are in use at the sys? Who created them, acti…
-
Sort drop-down list descendingly in Table Prompts in AnalysisSummary How to sort drop-down list descendingly in Table Prompts in Analysis Content In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to s…
-
How to upload css in a dashoardContent Hello Guys, Sorry for my ignorance, I have seen that it is possible to refer to style sheets when you want to edit sections of the dashboard. My question Is? Whe…
-
List of AgentsSummary List of Agents in "My Folders" Content Hi Team, Does anyone know how to list a list of Agents that were created by users and saved in their "My Folders"? I belie…
-
Referencing Parameters in the Layout Editor FilterSummary Referencing Parameters in the Layout Editor Filter Content Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
-
BICC for GL ExtractSummary BICC for GL Extract Content Hi, We do have an auditing requirement to extract large volume of data from GL Lines and GL balances which may have more than 3 milli…
-
Report on SocialSummary Need to create a report on Application Social Content Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select f…
-
BIP Excel templateSummary ER for Excel XLSX version Content Hi Everyone, Does anyone know the ER# - even better with ETA, regarding having XLSX for Excel Templates in BI Publisher reports…
-
How to override NULL values with existing valuesSummary How to override null value with values from another column in OBIEE Analysis Content When building an analysis in OBIEE, what would be the code to enter into the…
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…
-
What is catalog folder Extension?Summary Does anyone know the purpose of the empty shared folder Extension in the catalog? Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, … -
Suspended job reportSummary Suspended job report Content Hi, I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before s…
-
Building BOM using analysisSummary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levels Content In OBIEE, pre-built analysis "BOM" and "…
-
Deferred Termination field in OTBISummary looking on how to determine a deferred termination Content Hello, I have been asked to create a report showing the associates with a deferred termination. When t…