Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 592
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 357
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Cloud and Server
Ask questions in the Oracle Analytics Cloud and Server forum to get immediate help from peers and experts. Collaborate on best practices and dive into discussions around Data, Analytics and AI.
Discussion List
-
Subtotal of the first 10 positionsHi I have a track record with the top 10 positions to go.I will need a subtotal of the top 10 positions in addition to the grand total.So it must have 2 totals in my arr… -
Subtraction between the grand Total and a subtotalJ’aimerais faire la soustraction entre le grand total et un sous-total pour obtenir un autre sous total dans un même tableau. Peut-on faire cela ? Dans mon exemple: Ce s…
-
Sous-totauxI would like to know how to do subtotals in a pivot table(see picture attached) J’aimerais savoir comment faire des sous-totaux dans un tableau croisé dynamique (voir l’…
-
Issue with multiple kta at rpdI have table 5 tables A(dimesion1) B(dimesion2) C( fact1) D (fact2) E( fact3) Where A and B have relationship with all 3 fact tables.at bmm layer I have multiple tables …
-
How to schedule OTBI report to run on Monday to Friday where the days are incrementedI have an OTBI Report for order fill rate, I need to schedule this report to start to run on Monday to Friday. how do I add a date SQL which increments meaning if I run …
-
OBIEE Scheduling Tool and user accessHello - apologies ahead of time for not knowing the proper way to ask this question but... we use OBIEE to run ad hoc queries but have not engaged with the automated sch…
-
Unable to change column data format to HTMLI'm running OBIEE 12.2.1.3 on Windows Server 2016. I am having trouble changing the "Treat text as" field on the Column Properties dialog. I am not seeing any options ot…
-
Repository Dynamic variables refreshOur repository dynamic variables stop refreshing occasionally. Is there any way/command that we can use to restart refreshing them or do we have no other option than to … -
OBI: 12.2.1.4.0 - Global CurrenciesHi All, I'm hoping you can help. I am part of the team that looks after report development front-end for a company who has recently procured OBI, I have good experience …
-
Filter based on Direct database requestOBIEE 12.2.1.4 Can we create filters for regular answer queries based on DDR?
-
OBIEE 12.2.1.3 Agent failed to deliver reportHi Gurus, We have an agent configured on top of a report. This agent runs at 8 am every morning based on a condition that the count of an item should be greater than 0. …
-
REMOVE NULL OR BLANKHi, I'm new in Oracle Analytics Cloud. Kindly assist me on how to remove or filter out null values in specific data column rows? Thank you.
-
Error 403--Forbidden From RFC 2068 Hypertext Transfer Protocol -- HTTP1/1 - OBIEE 12cHi, this error occurred while logging to Weblogic, these are the screenshots of services running correctly, but not able to login weblogic. @Gianni Ceresa Sir can you pl…
-
How to display max date by multiple columnsHi, How can I display the max date for each exist assignment status? In this example the person number 977677 need display 2 rows: * active = 1/6/2022 * Inactive = 8/5/2…
-
Error 500--Internal Server ErrorHi, After applying recent patches(CPUAPR2022) to the BI server, we are getting below error message. I observed all the all the services are UP and Running. I didn't find…
-
-
Build clusters for columnsHello there, i have a question considering how users can include columns in the report. For one report we have now more than 50 columns (required from the customers). As…
-
How to Configure Fusion HCM BI server to support Evaluate function in OTBIHi, I need to use the LEAD / LAG functions in OTBI. When I do, I get the error below: Formula syntax is invalid. [nQSError: 10058] A general error has occurred. (HY000) …
-
BI Publisher Report Job ProblemHi all friends, We have a problem in our company while resending report jobs on BI Publisher. Because of an issue, we need to run the report job again, but it fails. The…
-
Is it possible to have an OBIEE 12c user that only has access to one subfolder of Shared Folders?Hi! I need to organize catalog permissions as follows: A certain role should not be able to access any folder in Shared Folders except one folder. This role should be ab…