Oracle Business Intelligence

Popular Tags
- OTBI 950
- Reporting 844
- Analysis and Data Visualization 648
- Analysis 573
- BI Publisher 506
- Administration 499
- reports 283
- obiee 282
- Oracle Fusion Analytics 242
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 213
- Data Connectivity 185
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 107
- OBIEE Answers 102
- Access and Manage Data 102
Oracle Business Intelligence
Discussion List
-
Ways to limit amount of data from DB(Oracle) to OBIEE 12cOBIEE 12.2.1.4 What are effective ways to limit the amount of data that Oracle DB returns to the BI The purpose is to limit amount by rownum or by datasize We use Result…
-
MICR code not coming properly once customization is done in seeded reportOracle Fusion Cloud Applications 23C (11.13.23.07.0) MICR code in check print template is not coming properly ad soon as we add any condition in it. Even if we add 1=1 c…
-
how do you migrate analytics security between environmentsTried to exporarchive from the environment with the security we would like to replicated and imported into the target environment but did not seem to work. The obiee tea…
-
Default dates as start and end of financial yearHello, I have a BI publisher report which uses 2 date parameters i.e. Start and End Date. They must be defaulted to the start and end of financial year. i.estart date wo…
-
Line break in the x axis label of the graphHi, I have created a graph in which x axis contain year and quarter. As part of the standard format, we want X axis label of the report as like below screenshot. (i.e. F…
-
[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42015] CannHi We migrated some reports from UAT to PROD. The reports work well in the UAT OBIEE. But after the migration we get an error in few reports. The error is as follows. [n…
-
Why export link is not available under dashboard report?Hi , I want to add Export link to a report in dashboard. I added export and refresh options from report link in the property icon of the dashboard. But only refresh opti…
-
Pass results from an analysis in OAC to filter values of an analysis in ERP OTBII am trying to compare data from ERP/OTBI to OAC and then pull additional details from ERP based on the results of the comparison. For example, I have dimensions A, B, C…
-
Issue in RTF template while trying to Grouping based on particular columns.We had a BIP Query which is having two datasets G1 and G2. Need to compare Person Number and Date field from G1 with G2 and if it is same then result should be produced …
-
Adding a parameter at performance document levelHi Team, We are trying to add a parameter to the report (which renders performance rating information of the employee) and attaching it to the instruction of a questionn…
-
OBIEE 12c server service won't start after upgradeHello Experts, I'm currently performing an upgrade from version from Release 12.2.1.2 to Release 12.2.1.4.0 by using this document: https://docs.oracle.com/middleware/bi…
-
Users are trying to view the reports but they are getting "Error 401 – Unauthorized”When a user leave an analytics page idle for about 30mins user gets Error 401 – Unauthorized instead of logging out this issue occurs intermittently when user leave the …
-
How to get active bip session token from front end of standalone application?Hi, How do we get the active bip session token from Fusion to the standalone application after logging in to Fusion like sso login? Thanks in advance Srimathi
-
Single Row Values QHi all I'm creating my first reports on R&A. And i am stuck WITH a basic thing. I would like to have all the Preference's column result into a single row. would apprecia…
-
Can we use a DDR in filter condition of another report which is built using data model?I have a DDR created in BI, and I want to use it in filter condition of another report which is built using data model. Is it possible? I am getting error when doing so.…
-
Subject Area Workforce Management - Person Real Time does not include Person's Previous AddressI am currently working on a report that requires to display the previous and current home address of an employee. I have used the subject area Workforce Management - Per…
-
Write Back in OBIEE 12C throws an error An error occurred while writing to the server. Please checkOBIEE Version: 12.2.1.2.0 We have our writeback working previously but suddenly it is throwing the below error : I had my .xml file as below: & My instanceconfig.xml as …
-
ora-28040 No matching authentication protocol when running 11g RCU against 12c DBHi Guys, Need to create the metadata schemas through RCU 11g on a 12c DB and getting the above error. The RCU was downloaded from https://www.oracle.com/middleware/techn…
-
OBIEE11.1.1.9 (Exalytics Server) to OCI Migration (VM's)Hi Team, Our customer is planning to lift and shift their existing OBIA 10.1.1.10.2 stack with 1. ODI 11.1.1.9 2. OBIEE 11.1.1.9 with Exalytics Server 3. DB12c to Oracle…
-
Oracle BIPHello All, > Oracle BI Publisher I have creating report using Oracle BI Publisher. I used csv file as data source in Data Model. Also created parameter in the report. Wh…
-
Use XLSX file types as layouts in BI Publisher?Is there a plan to allow us to upload XLSX template files in BI Publisher in a future release? My company is forcing read-only mode on all XLS files as a new workstation…
-
Passing value from one report to another report as a parameter using value as a hyperlinkHi All, can you someone help me on this issue obiee report. Details : report 1 Subject area A : column X (values in X is 1,2) union subject area B : column Y(values in X…
-
Is it possible to filter the results of an analysis using a calculated measure?Hi, I have a requirement to filter the report so that it only shows the items which have had
-
How to preserve the single space character in the report?In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the report. Ple…
-
Getting error while creating reportHello All, We are recently migrating from OBIEE 12c to OAS 6.4. But we are facing one problem after migration. One of our connection pool contains connection for vertica…
-
BIP Interactive Dashboard, how many records will be shown in the filter?We have created a BIP Report and selected the interactive layout. We have a column example contract number, but when we filter on the column it only shows a few values i…
-
Bursting output previewHi All, Could you please let me know if there is a way to enable/disable bursting on the ESS job. Requirement is to preview the output before Bursting. under reports and…
-
Pivot functionality in excel template does not work when the number of data rows exceed 65KWe are using excel template pivot functionality to develop a costing report. Oracle supports only xls excel template and this is causing issue when the number of data ro…
-
OBIEE - Excel Export ErrorHi , I am getting error in the report export . i am seeing "Error generating document:" in the excel , when i checked in saw log , i found this error [OBIPS] [ERROR:10] …
-
where is the baseline validation tool?hi, I need to set up some automatic regression tests. A lot of guides refer me to the Baseline validation tool. It should come with OBIEE developer client tools. When I …