-
Data Lineage objects removed from OBIA RPD
Hi All - I recently completed the steps to configure data lineage for OBIA, per: https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-8E9904B5-E498-40E7-88BB-6F36B309CF37.htm#BIASA24666. The data lineage ETL completed successfully. However, I am encountering some errors when trying to view the dashboards. I opened an SR for…
-
Disable Parallel Queries in BIAPPS ETL packages,
TABLE_MAINT_PROC - Often used for the routine table operations like creating index etc. This is automatically executing Create index commands in parallel mode with Degree 6. It is not getting enough resources on the DB and Often fails (as the Parallel query dies). Would like to haveb the procedure in ODI TABLE_MAINT_PROC…
-
Obiee RPD how enable hint field
Hello, I need adding a hint physical table from OBIEE, but my RPD does not show the hint field. I'm working obiee 12c. Does someone know how enable it?? I attach an image. Thanks a lot.
-
RestAPIs for OAC
Is there any list of RestAPIs available for OAC. I want to get the data from a subject area by using RestAPI
-
Data Lineage
Hi, latest version of Oracle Fusion Financials, I am looking for a document which details; - Subject Areas / Folder Contents / Fields -> Oracle Fusion Tables / Fields Similar if not the same to the old data lineage spreadsheet, does such a thing exist? thanks, Robert.
-
Obiee 12c decimal problem
Hi, We can use obiee 12.2.1.2.0. We have a problem about number decimal. We saw number on database different on report after the comma, In database 162849202712378,54 , the visible field appears as report 162849202712378,00. Even though I change the type of the field, the result is still the same.(CAST("FACT…
-
OBIEE GO URL
Hello All, I have a requirement to pass the parameters ( One static(Presentation table. column) + Prompt Values from the dashboard),I have opted for Gourl approach 1) Portal Path approach Where the detail report is in the same dashboard page within the summary report & the URL embedded navigates with the Prompted values to…
-
Problem during running configuration assistant in business intelligence 12.2.1.3
Hello all we are trying to install business intelligence 12.2.1.3.0 on a Oracle Linux machine, we installed all required software in order : 1. JDK 8 Update 151 2. Fusion Middleware Infrastructure 12.2.1.3.0 3. Business Intelligence 12.2.1.3.0 for Linux 64 operating system : Oracle Linux 6 Update 9 , packages inside…
-
Category_Set_ID Configuration in OBIA 11g
Hi, We have configured the few Category_Set_ID in BIACM for PROD_CAT1 and PROD_CAT2. After doing the selective full load in PROD_CAT_DH and PRODUCT_D and relevant staging as well. Some of tables(PROD_CAT_DHS,PRODUCT_DS) are truncating and No records found in staging. However,PROD_CAT1_WID and PROD_CAT2_WID are populating…
-
Grand Total Issue in Pivot Table
Hi, The Grand Total column here is manually created by writing the formula (The 1 Total + The 1 CPN Total). I am using Pivot table for this report. Hence, arranged Layout as shown below and opted for aggregation as TOTALS AFTER. My query is why the SUM for Grand Total column is not being populated? Please advise. Thanks
-
OBIA Data Load for HCM and Procurement offerings
Hi All, Greetings for the day. We are trying to perform data load for HCM and Procurement Offering, but before proceeding domain load I believe we have to do some changes in the csv files located in src_files(<Oracle_BI HOME>/biapps/etl/etl_load/src_files) folder. My source is EBS 12.1.3. It would be of great help that if…
-
ETL "auto-corrections" - OBIA|ODI
Hi All - Occasionally, we receive notifications that 'The following tasks had data issues that were automatically corrected by the ETL program.'. The message also contains text that states: 'Please login to BI Applications Configuration Manager to see more details and download data that caused errors'. -> Does anyone know…
-
ODI 12c with BI Applications
I'm sure this comes up every now and again - though I have searched forum over the last few months to check it hasn't been answered recently; but does anyone have any insight into when this may be coming? Regards, Mark
-
what is difference between these 3 business intellegence tools
Business intelelgence standard edition one. named user license is 1200 standard editon price is 350 dollars publisher price is 450 dollars can some one tell me the difference between three .. Thanks
-
Unable to start odi studio from the server from odi.sh
I am working on configuring BI APPS 11.1.1.10.2. The Configuration is done successfully and can log in to all the below urls 1. http://servername:7001/console 2. http://servername:7001/em 3. http://servername:9704/analytics 4. http://servername:9704/xmlpserver 5. http://servername:9704/biacm 6.…
-
OBIEE time series graphs skips the first label in x axis
OBIEE time series graphs skips the first label in x axis. The measure value is showing 12 months data. OBIEE version used is 12.2.1.0.0 . We are using time series graph to plot a measure value across 12 months data. The line plots data for 12 months, but the x axis label for month is not showing first month value. Please…
-
Condition on a Date Range
Hi, As part of a requirement, a prompt needs to be created with DATE COLUMN to which a condition need to be applied. The condition is after selecting the desired value from the FROM PROMPT, the TO PROMPT should allow a date range within 15 days. For example, in the FROM PROMPT 11/9/2017 is selected the TO PROMPT should…
-
Custom Offering in BIACM
HELLO we created a custom offering and were able to use the custom fact groups in the offering and run a load with an OOTB offering. But if we select only the custom offering (and no OOTB offering) and try to generate the load plan we are getting this error: java.lang.NullPointerException at…
-
OBIEE Scheduled jobs
Hi All, We have been receiving an email stating "FAILURE::[Picked_Staged]" and the job name as Picked_Staged. Infact the job isn't scheduled in BI, or can be seen in the failed jobs. Not sure from where this is being picked up. The following is the message in email. Please suggest how can we eliminate this. Detail Message:…
-
OBIEE 12c Simple Google Maps Report Using a Narrative - Blank map?
As the holidays approach, I find myself with a pocket of spare time where I want to try and dive into maps and OBIEE. Im mainly looking to use google maps with OBIEE 12c. From what I understand, it looks like I have two options. I can use mapviewer, and use google maps as a background layer? I did brief research on this…
-
Unable to automatically create level based hierarchy?
Bit of a silly question, but I inherited an RPD and noticed something funny. I am tryint to "automatically" create hierarchies, and noticed I am not able to on some tables, while others I can. For example For this table when I right click I have the option to create a hierarchy Whereas when I click on another table I dont…
-
Informatica Version compatibility for OBIA and DAC 11g
Upgrade to Informatica with DAC 11g Hello, Is Informatica 10 compatible with Oracle 12c and DAC 11g ..if not which is the highest available informatica version which is compatible with both Oracle 12 C and DAC 11g? Thanks!
-
Pivot Table Requiement
Hi There, My requirement is to get the report in the below format Am doing this using a pivot table. we have 2 more columns for age range 1. Age ranges and 2. Age Range Fact Column when am using this two columns my output is like: Can anyone help me out on this. Thanks, Nikhila
-
BI parameter declarations and error in xml report
I am running a query in toad and its giving a valid query has 3-4 parameters but as I give one parameter it accepts and give the output. while I am creating a data model in oracle bi publisher what should I do when I give all parameter it shows me file error xml output and if I give one parameter still it shows the same…
-
Column Formula Filter() ignore part of USING if variable not set
At the analysis level I know you can filter based on a presentation variable and enter a default value of % to show all values if no value is entered in the dashboard prompt, how do you replicate the same functionality within a column formula when using the filter() function as I can got it accept the following: and…
-
BIP Report is not getting Delivered to the User.
Hi All, I am using OBIEE Oracle Business Intelligence 11.1.1.9.0 version. I have created a BIP report and the output is getting generated with a excel file like 23 MB and that is not getting delivered to the user. User insiting only to get the data in the excel format. And also our mail box will allow 23MB file to be…
-
Refreshing tables when the users are accessing it
We have a few Aggregate tables in our DataWarehouse that are truncated and refreshed Fully for each ETL run. It takes about 10-15 mins for some of the tables to completely load. We have 24-7 usage and the users are impacted for those 10-15 mins when the tables are being refreshed. What options are there to keep a static…
-
WebLogic 12c Error
Hello everyone. When the WebLogic start is done, it displays the error. On one line the error presented is expired, but what password? Weblogic user? How to solve? Start is done directly in the script In the folder: F: \ Oracle \ Middleware \ Oracle_Home \ user_projects \ domains \ bi_domain Can you help me? Thank you
-
BIApps Version 11.1.1.7.160719 - ODI repository Password Change
Hi All, We are using BIApps Version 11.1.1.7.160719, which comes with ODI. Currently we want to Change password of ODI repository Schema from Database . I wanted to know where all i need to change the updated password ? I Know for for sure I would need to change it in ODI connection in Topology, but I am not sure about…
-
OBIEE and Active Data Guard
I would like to know when installing OBIEE and configuring Active Data Guard, how does the setup look? I'm guessing: Server 1: Primary Database Server 2: Standby Database and OBIEE, OBIEE connects to whichever is Primary. Please advise.
