-
How can we implement briefing book Navigation link in OBIEE12c ?
Hi, How can we implement briefing book Navigation link in OBIEE12c ? I could not find that option. Is there any way to implement this ? Thank you, Steel.
-
Can we point the source to new table/subject area in an analysis?
Hi, I have a case where I have created an analysis on a table which has sample data. Now, I have a new table with complete data, How can I able to change my analysis point to the new table? Thank You,
-
error in obiee 12c analyze
hello everyone I use obiee 12c i just create a cube with just one dimension in awm but when i want to create a analyze in obiee i get the following error: in my workspace (sample) I have 7 cube and 12 dimension . all of them work fine apart from this!!! Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P…
-
How to Freeze Rows in Pivots and Tables within OAC?
Summary Freeze Rows in Pivots and Tables within OAC? Content Hi, I have been doing some research to see if there is a way to freeze top rows and/or columns within pivot tables/tables, etc similar to how I can in Excel. I have searched through the manuals and forum and haven't had luck finding anything on this topic. Is…
-
OBIEE Analysis - Calculate Years of Service Formula
New to OBIEE. I have an analysis that I need to add a column that shows the employee's actual years of service (as of current date), for example, 4.3 years or 2.7 years. The field I'm using is "Workforce Management - Worker Assignment Real Time"."Worker"."Enterprise Hire Date". I would like to use a formula on the field to…
-
BIP 12c Publisher Bursting issue when we have two datasets in one report
Hello Experts, Bursting issue when we have two datasets in one report Oracle BI Publisher 12.2.1.0.0 (build:20151008.1303) We have two data sets in one report. Dataset 1 : All products purchased and purchase amount Customer ID : 1 Customer Name : Jack Product No Items Total Amount Laptop 3 3500 Smartphone 10 7000 Charger…
-
BI Admin tool font size
Is there a way to increase the font size in the BI Admin tool? I realize that the screen resolution of the PC has an impact, but I need to see the text in the Admin tool even larger than it becomes by changing the screen resolution. Thanks!
-
OBIEE BI Publisher reports not executing as per schedule
Hi Everyone, we have scheduled the BI Publisher reports at 9:50AM daily. But Job not executed on jan 30th, 2020 as per schedule time and It ran at 10:00AM . Why not executed as per schedule? Any idea? See below screen shot. Please help me on this. Thanks in advance Thanks, Kavya.
-
Does OBIEE 12.2.1.4 supports cookie based authentication with CRM.
Hi, Previously I have integrated obiee with ebs via cookie based authentication which is supported by oracle. I would like to know if we can use the similar set up to integrate with CRM. can someone point me to Enable cookie based authentication for OBIEE with CRM application. Appreciate your help.
-
Can I integrate obiee 12.2.1.4 which is installed on RHEL7 with IIS.
Hi, I have installed Obiee 12.2.1.4.0 on RHEL7.6 machine.we have our 11g in windows and authentication is happening via IIS. Can I use the IIS to authenticate the Obiee 12c which is installed on Linux. Appreciate your help if you can provide any oracle document link to configure. Thanks in advance.
-
OAC Dashboard Prompts
Summary How can I create multiple dashboard prompts on the same Dashboard page that work independently of each other? Content Hi, I created a dashboard page where I have a prompt at the top of the page that controls the visuals I see in graphs in the top section, and I want a different set of prompts that control the…
-
How to Rename a Dashboard Within OAC?
Summary Looking for help on how to rename a dashboard within OAC Content I am unable to locate information on how to rename an OAC dashboard. We just finished some preliminary costing results and have identified a few issues in the data so I want to rename the dashboard with some descriptors that the data is preliminary so…
-
OBIEE - Add a column and populate it with customized text
I'm new to OBIEE, simpler is better please. I have to add some new columns to an Analysis and populate them with our company address. I have added a field called "Address Line 4" (that we do not use) to the analysis five times as shown in the image below. I want to populate the columns with Employer Name, Address, etc. How…
-
OBIEE 12c: Tnsping Utility Executable On Solaris Zero Bytes
Do we have steps for Solaris OS similar to Doc ID 2181368.1 tnsping utility is of zero byte on solaris OS as well. OBIEE 12.2.1.3 Thanks in advance.
-
Bi publisher word template builder error
Hiii, any advice on this issue would be appreciated. whenever I try to use the template builder insert a few fields and then preview the file an error comes up with this message: javaw -Xmx256M -jar "C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\jlib\RTF2PDFv2.jar"…
-
SSL options for HTTP Header SSO IIS -> OBIEE
Morning, Mark this day in red in you calendar for I have a question for you all :-) OBIEE 12.2.1.4.19.1015, IIS 10.0.14393.0, both on Windows 2016 Servers. Trying to configure HTTP header SSO between IIS and SSO, but over HTTPS. Normal HTTP works fine but obviously isn't what we're after. So the iisproxy.ini is fine. The…
-
OBIEE 12c - Update Connection Pool
Hi all, Does anyone know if there is an issue with the UpdateConnectionpool process listed here: https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-2A5F25A5-5E16-4EF0-97FF-3F378B740DA7.htm#conn_updt_pool_cmd We have two environments (Prod and Disaster Recovery). Both of which are the same (Hardware spec, O/S, config…
-
Pointing two obiee 12c apps to the same xmlp data
Hi all, We have a prod and dr application whereby the Bar file is migrated nightly to Dr to keep them in sync. In Prod, we have the quartz scheduler turned on. In DR, it's turned off. In a Dr scenario, we'd like to be able to just switch the scheduler in Dr on and have all bip jobs pick up the slack. We have looked at…
-
How to override NULL values with existing values
Summary 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 "Column Formula" box in "New Calculated Measure" if I want to create a new column where null values are override with existing values? For example, in the…
-
Reg. OBIEE 12c to OAS up-gradation process.
Hi Team, Any body aware of the OBIEE 12c to OAS up gradation process?? if yes, can you provide me the process to follow the same. Thanks in Advance!! Mallikarjuna
-
How to override NULL value
When building an analysis in OBIEE, what would be the code to enter into the "Column Formula" box in "New Calculated Measure" if I want to create a new column where null values are override with existing values? For example, in the enclosed screenshot I have the analysis shown on the left. My goal is to fill the Null…
-
Live Analytical Reporting through OBIEE/BIP
How to do Live reporting from OBIEE(12c) or BIP(12c) where the data source is Oracle or Microsoft SQL Server DB? Abid
-
OBIEE 12.2.1.4 - obis1 starting error
Hi all, I have an error when i am trying to restart OBIEE 12c. The error is coming at the obis1 starting process with the foloowing error message : Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error: NMProcess: ORA-12504, TNS:listener was not given the SID…
-
Use a filter in a dashboard prompt
Hi there! I'm a OBI 11.1.1.9.160419 user. I have a question for you about a personalized dashboard prompt: WHAT I HAVE NOW: I have a dashboard that shows some KPIs for a group of machines. In the first page of the dashboard, I have a prompt with 2 filters: year and month, and those filters affects all the dashboard pages.…
-
Integrate obiee 12 with chatbot
Hi, I would like to know if we can integrate obiee 12c with chatbot. if anyone has done on that can you please share info on that.. how can we do that
-
Oracle obiee 12c location adress line edit
Hello. Is there any chance to use copy and paste in location adress line? Now i can't even mark adress line. Some config need? Where?
-
Hyperlinking BI content to Title chart
Hi, I have a case where I need to hyperlink a BI content report to the title of an analysis in the dashboard. Is there ar way to do it? Similarly, can we do hyperlinking to Performance tile?
-
select one value from between date dashboard prompt
Hello, I have presentation variable that is build based on between dates dashboard prompt (so user chooses two dates from calendar), I can assign only one variable to this prompt. Then I am passing this presentation variable to column filter, this works fine however two values are being referenced whereas I only want the…
-
The report dont update the data
Content I created a data module and a report template in Oracle Transactional Business Intelligence that fetch invoice notes. But when I create a new line of invoice or just change the status, that information dont appears in the report. Only after some minutes the report presents this information. If I check the data…
-
obie 12c security issue
Dear Experts, After upgrade form obiee 11g to OBIEE 12.2.1.4.0 , in my system-jazn-data file I can see the missing role groups in the obiee 12c system-jazn-data file. Obiee 11g ( I can see all the role groups in the 11g) ===================================================== <app-role> <name>BIAuthor</name> <display-name>BI…
