-
import OBIEE 12c
Hi, how can import bar file from OBIEE 12c to another without disable agent or without agent ?
-
Can I use a table in BMM layer without any joins
Hi All, I have a requirement to pull an independent table into BMM layer which does not have any joins. And expose the same table into presentation layer into an existing subject area. When I tried doing this and checked for consistency. I got the message "Business model is not consistent. Do you want to mark it as…
-
Hidden prompts not allowed on Sub Pages?
Hello all, I haven't found any references to this issue on this site or in "googling" it. I'm in OBIEE 12.2.1.3.0. I don't use hidden prompts very often, but they can be useful at times. I am unable to install one on a dashboard subpage. In Dashboard Properties, the Filters and Variables icon becomes grayed-out when you…
-
(OAC)- Oracle database cloud service, DB cloning
Hi Friends, I was asked to refresh OAC lower environment with data from PROD. To refresh application tier I will use OAC Console and Snapshots. But I wonder how to refresh database! Do I have to ask for that DB admin? Can I use "Oracle Cloud My services"... I found there Snapshots under "Oracle database cloud…
-
OBIEE YTD difference calculation
Version: Oracle Business Intelligence 12.2.1.3.0 Hello Board, What would be the easiest way (formula) to calculate YTD difference from last year? is there an easy way to do this in the criteria tab? thanks, Cameron
-
Edit an attribute column formula in Oracle DV
Summary Edit an attribute column formula in Oracle DV with an expression builder Content hi, Is there a way that we can edit an attribute column formula in Oracle DV with an expression using subject area and dataset fields? For example i would like to write a case statement for a column. Please help and thanks in advance.…
-
Share option disabled in OBIEE dashboard after embedding Oracle DV projects into OBIEE
Summary Share option disabled in OBIEE dashboard after embedding Oracle DV projects into OBIEE Content hi, I embedded Oracle DV projects into OBIEE dashboard (OAC). though i can see the "Share" option, but it looks disabled. 1) how can i enable the share option 2) if share option is not possible, is there a way that we can…
-
pass prompts from obiee dashboard to Oracle DV reports - OAC
Summary Pass prompt from obiee dashboard to Oracle DV reports and projects Content hi, Can anyone help me guide me thru how to pass prompts from OBIEE dashboard(OAC) to Oracle DV projects and reports? I already embedded the Oracle DV reports into OBIEE dashboard(OAC) using embedded content and url links. Now need to pass…
-
"Get more rows" message in OBIEE pivot table
Hi everyone I get a "Get more rows" message at the bottom of a OBIEE 12c pivot table. 1000 Rows are displayed by default and I have to click on this message in order to display more rows. How do I disable this message or increase the number of records to be displayed before it appears? This is the contents of the…
-
Limiting the number of sessions per machine in OBIEE 12c more than once
I want to prevent users to login in Oracle BI12c with the same "username" more than once. also, I checked many documents and see parameter like "Max Session Limit" but it's not what I want.
-
OBIEE 12c running and docker, container, OpenShift Cluster
Hi all, I need more information regarding running OBIEE and docker, container, OpenShift Cluster: - Image? - Best practice and - Oracle Docs are there available from Oracle side? Thanks in advance, Moh
-
Employee Hierarchy: Total for Manager includes self
Hello, Experts! We are running on OAC 12.2.5.2.0, and I have a custom, level-based, ragged employee hierarchy that I am otherwise happy with. The issue is that the totals at each level include the parent of the level; e.g., in the example below, the headcount for Bossy Person should be 6, not 7. The issue isn't…
-
How to configure logout url in obiee 12.2.1.4.0 after sso enablement
Hi All, We have enabled siteminder sso in our obiee 12.2.1.4.0 But when we are clicking on the sign out url from obiee it's showing us this error message : Not Found The requested URL /bi-security-login/logout was not found on this server. Please let me know where the logout url can be configured?? I tried editing the url…
-
Client Environment Requirements for Oracle Business Intelligence 10.1.3.4.1
Hello, What are the Web Browsers supported by OBIEE 10.1.3.4.1 and which client operating systems are supported (are windows 8 and 10 supported) Best regards
-
OBIEE 12c third party authorization
Hi guys I am looking for some solution to figure this scenario out. I have third party HR system and external LDAP, I configured myrealm for authentication part and wanted to configure authorization steps with HR system. The HR system has REST to pass user information to any other system, I want to send username and…
-
Agents for dashboards with saved customizations
Hi All, I'm trying to confirm if it is the case that if an agent runs a dashboard (with prompts) that has a saved customization (set as the default), the dashboard content will be delivered with those prompts selected? It looks like it was doing that when I did some testing earlier, but I want to make sure that I am not…
-
OAC OBIEE page that contains HTML markup
Hi All, I'm working in OAC (version. 105.1.1-14) OBIEE (12.2.5.1.0) and getting below error when trying to save analysis with some description in HTML: You do not currently have sufficient privileges to save a report or dashboard page that contains HTML markup. This HTML might be present in column headings, table headings,…
-
Cache sharing for dedicated users in OBIEE 12c
I need to use dedicated usernames in OBIEE connection pool (no single technical user can be used as per requirement). At the same time, I have enabled BI Server cache and would like to share cache entries between users (in case somebody runs a specific query in the morning and there's another person that runs same/similar…
-
OBIEE 12.2.1.4.0 - Can we place a custom message instead of "Exceeded configured maximum number of a
Hello Experts, We are using OBIEE 12.2.1.4.0 on Linux. We have been encountering errors whenever the predefined limits (in instanceconfig.xml) have exceeded due to users' running for reports that fetch large data sets. We have tried to communicate with our user community to run reports in a restrictive way in order to…
-
DATA-SYNC 2.5 Question
Summary Run sql scrips in sequence not parallel Content Is there any way to control the order of the calls made during the Job run? We have 25 rows/call in our one job(see screen shot). We can see that it runs more than one at the same time. Can we set it to run them in sequence not parallel? Version Oracle Analytics Cloud…
-
Need better way to show OTBI subject areas in DV data set
Summary When creating a dataset from an OTBI connection, subject areas names are truncated Content When create a dataset from an OTBI connection in DV, the display of subject areas has truncated names that make it difficult to figure out which one is the correct one. Yes, there is a search option but it would be better to…
-
OBIEE Dashboard retirement
OBIEE version : Oracle Business Intelligence 12.2.1.3.0 Hello Board, Is there a way to hide whole dashboards? I have a handful that need to be cleaned up off of the drop-down list (in order to make the list shorter for executives who complain about scrolling down). I know about hiding dashboard pages and how to do it, but…
-
OBIEE license cost
HI All, May I know what is the cost of OBIEE license per year ? Thanks!!
-
OrientDB connection to Oracle BI Publisher 11g
We are trying for an POC to establish a connection to OrientDB in BI Publisher to access data and create report. But we are not seeing any orientdb drivers to create a connection, please help on this if any one come across in this situation. Also, Let us know Is there any feasibility to generate OBIEE/BI Publisher 11g…
-
Write back functionality in OBIEE Essbase cube
Hi experts, We are using Essbase cube as source and business want to implement writeback functionality on Essbase cube . We already implemented the write back on the relational database but not sure about Essbase cube. How we can achieve it.
-
Install Data-Sync 2.6 (Upgrade from 2.5)
Summary Password not accepted when installing 2.6 Content I am trying to install Data-Sync 2.6 and the password I have for my DEV enviornment is not working. I do have a running copy of Data-Sync 2.5 on the same box. What can I do? Thanks Version Oracle Analytics Cloud Data Sync (2.6)
-
OBIEE 12.2.1.4.0 - Can we Cache queries for some analyses only, instead of turning it on Globally
Helllo Experts, We have OBIEE 12.2.1.4.0 installed on Linux. A vast majority of our system contains Dashboards using one or many analyses on each of the dashboard pages. We are trying to explore options to improve the performance of the dashboards in terms of response times. Is it possible to configure query caching for a…
-
OBIEE 12c and SecureAuth
Has anyone successfully integrated and configured OBIEE and SecureAuth for two factor authentication?
-
11.1.1.9.190416 (Patch 29492717)
Hi All, -->Installed obiee 11.1.1.9.0 and applied the latest patch 11.1.1.9.190416 (Patch 29492717) --> After done the patching I went to analytics administration tab I can see the version Oracle Business Intelligence Product Version 11.1.1.9.0 (Build 190206.0500 64-bit)..is it corect --> I was expected this Oracle…
-
Settings to connect to Job Manager in OBIEE 12.2.1.3
Hi all, Im new to Job Manager in 12c. What is the port used to connect to it? and is the Machine Name setting the same as the server name? Is it: https://my.server.machine.name:9503/analytics/saw.dll or just my.server.machine.name ?
