-
OBIEE Error [39074] Logical dimension table has a source with aggregation content set to level 'Deta
I'm having an issue setting up my level based logical dimension. I have a dimension 'quote' with two levels. The top level is the 'quote' level, and the lowest level is the 'detail' level which contains all the line items included on the quote. I have one fact that joins to the detail level of the quote, and a different…
-
BICS certification details
Summary BICS certification details Content Hi Experts, Could you please provide the details of the BICS certification. Please provide the exam code. Thanks in advance!!
-
Where to download BI Publisher for MAC
Summary Where to download BI Publisher for MAC Content Hi, I am wondering where to download BI Publisher for MAC? From this downloading page: Oracle BI Publisher - Downloads | Oracle Technology Network | Oracle I can not find any info regarding how to install in MAC. Thank you for any input! -Liang
-
Lexical References to SQL Queries throws exception
Summary Lexical References to SQL Queries throws exception Content Hello All, We are in the process of migrating our custom reports from embedded BI Publisher in OTM to external BI Publisher 11g. While doing that we are running into issues with reports that uses lexical references in our SQL queries and it throws below…
-
Line break inside xml data is not displaying as separate lines in BI Publisher
Summary Line break inside xml data is not displaying as separate lines in BI Publisher Content There are Line breaka inside xml data but it is showing in a single line instead of displaying as separate lines in BI Publisher. Below is xml data screenshot below is the data coming in rtf template Please help. I have googled…
-
Invoke OBIEE Dashboard(With Prompt & Report) using URL
Hi Guys I have a request to invoke an OBIEE dash board, using a URL. So the dahboard has only a prompt (Which Sets Presentation variable) and A report (That uses the said variables). No i have tried approaches like https://gerardnico.com/wiki/dat/obiee/obips/navigate_to_url But this is not working for me as i have to set…
-
How to set currency in cloud environment
Hi All, I working on OBIEE reports in cloud environment and version is Oracle Business Intelligence 11.1.1.9.0. Initially i could not see the measures data in the report and later i found to set the My account -> Preferences -> Currency -> Entered Currency. After that i could able to see the measures data in the report. If…
-
OBIEE 11g Pivot Table sometimes not refresh automatically
Hi all, When I open an analysis in view mode my problem is the following: This analysis has a dinamic table. When I try to change some dinamics partition (ex: year) sometimes it does nor refresh by itself and I have to manually refresh the analysis. Do I need to modify some settings? Any help will be appreciated. Thanks in…
-
How to Set default Data Modeler in BICS
Summary How to Set default Data Modeler in BICS Content Hi All, Good Morning!!! I have an requirement like, need to merge two bar files in same instance(After referring some blogs, it is not possible. They gave the workaround like you can create the Modeler and Unarchive and Archive the catalogs). I did the same in my…
-
Why native user can't login when LDAP server down
Dear All, I've some doubt about OBIEE12c security configuration in 2 scenario, and please share your advise. Scenario1 We used OBIEE12c 12.2.1.x In case we configure external authentication with MS Active Directory And sometime MSAD Server have a problem or network problem , so OBIEE Server can't connect to MSAD Server to…
-
OBIEE Scheduling through SMTP Server
Dear All, I have configured SMTP server in production and configured agent successfully. User are getting mails daily at 10:00 AM. But from last 7 days on wards users are getting mails at 10:00 PM instead of 10:00 AM. I have started investigation about this issue and understood one thong, If the file size having below 400…
-
Obiee 11g date range report
Hi All, I have two prompts one is from_date and second is to_Date. My requirement is report should fetch only 4 days data. If users entered more than 4 days , report should be no results. In case date range is <= 4 days, report should generate data. I have achieved this in query level. but how to call these two prompts in…
-
Can system-wide data formats in OBIEE be configured outside of Answers
Does anyone know of a OBIEE configuration file in 12c, or a way to configure an OBIEE environment so data formats can be set system-wide in a configuration file, or .XML file? I know how to set system-wide data formats in column properties in an answers report. See screen shot below. But, when I spin up a new obiee…
-
Ragged - Level hierarchy in OBIEE
Obiee version - 12.2.1.1.0 o/s - Linux x86-64 I'm trying to develop a Ragged - Level hierarchy using our cost center data for our headcount activity. The issue is , there could be duplicate values in these generations in certain cases and there is no other column that I could possibly add to make it unique . I've attached…
-
Conditional formatting fact columns
Good afternoon, I have a table in BI that looks similar to the one below. My goal is to create a conditional format so that if the FACTS table for McDonald's and Burger King are equal to one another, it will be color coded green. It will return a red color if the numbers are not equal. I have read about using Bins and…
-
saw.dll TypeError: document.getElementById() is null ( after migration to 12.2.1.2.0 )
After migration to Oracle BI 12.2.1.2.0 when I click a link in a row tab on the left side of my dashboard to refresh a map on my right side I have this error in Firefox and in Internet Explorer: saw.dll TypeError: document.getElementById() is null. The sorce code is :…
-
Oracle BI Public Store
Summary Oracle BI Public Store Content Hello! Cannot connect to Oracle BI Public Store. "Sorry, we have the maintenance" i want to download Oracle R-plugins for Oracle DVD.
-
Support for Oracle DB 12.2 Analytic Views feature
Summary Support for Oracle DB 12.2 Analytic Views feature Content Hello! Is it planned to add support for Analytic Views semantic model during 2017 release cycle? Thank you! Regads, Kirill
-
Multiple two filed in xml template
Summary Multiple two filed in xml template Content I have to perform calculation in my RTF template, actually there are two filed like A1 AND AB. i WANT TO subtract AB FROM A1. Pls advise.
-
Alerts for metrics and KPIs in DV?
Summary Alerts for metrics and KPIs in DV? Content In OBIEE you can set up thresholds on some report metrics or KPIs for alerts when when they are exceedd. Typically you send an email to some user with a link back to the report. Is there similar capability in any of the DV platforms (desktop, cloud, or server)?
-
Export dashboard and pages name
Hi, How can I export only dashboards and their pages name? For example I have Subject Area: Manufacturing and I want export only dashboard name in this subject area and their pages. Example: Dashboard 1 Pages 1 Pages 2 Dashboard 2 Pages 11 Pages 22 Pages 33 ... Version: Oracle Business Intelligence 11.1.1.7.131017
-
OBIEE Connection Pool
Hi Experts, how to automate the connection pool password when we move from lower environment to higherr environment. Thanks Selva
-
How to change header brand name
Hi, I tried changing header name from "Business Intelligence" to custom message but in vain. Below are the steps that I followed based on the below mentioned link: OBIEE 12c - How to change portal header brand name (next to Oracle Logo) Steps: 1. Created customMessages in…
-
How to extract the last word in a sentence string in OBIEE ?
Lets say i have a character string, "This is a good day" and i need to extract the last word of the string and convert it to something else. How can i do that using OBIEE functions ?
-
BI Publisher Job Problem
Hello, I have a question about publisher jobs. In our company we send daily routine emails through publisher 11. I deleted one job a few months ago, however everyday warning email still comes saying; "Unsuccessful Process: Report definition not found:/Bilgi.Sist.Mud./EPID Gunluk Mail/v2/rapor/Epdk Günlük Rapor.xdo…
-
Index on RTF Template
Summary Index on RTF Template Content Hello everyone, I would like to use the Microsoft Word Index feature. Index feature inserts at the ends of the document a list of key words and the relative page number. Anyone had used it? Thank you, regards. Riccardo
-
OBIEE 12c prompt default value issue
I am using OBIEE 12C, facing below challange would be great if somebody able to help me. Having 3 prompt on my dashboard having values depending on each other like P1, P2, P3. Choose value from P1 then using SQL query to fetch value under P2 then again using SQL query fetching value for P3 prompt which taking input from…
-
Importing excel files into Obiee 12c
Hi, I am personnel in a small goverment organization responsible for do reporting related to our operations. Our data come from different sources. So, we've got obiee. We have only 1 IT person who could manage setting up the database and import data from other souces. We designed the dashboards, etc. I am not an IT…
-
OBIEE Patch - Error While Applying the patch 26092391
Hi All , Greetings !!!! We are in process of Applying the patch on our OBIEE Instance . While Running the command we got this message. Please advise. ==================================================================================================== appdev@dev(26330183)$ opatch prereq CheckConflictAgainstOHWithDetail -ph…
-
OBIEE Ad Hoc performance
Hi, 12.2.1.0.0 version My client is experiencing performance issues with OBIEE, I know that it sounds monotonous but I have to understand how to get there. What I understand as of now is not all the time this is happening with my OBIEE application, but during the peak times when most of the users are actively pulling the…
