-
Data Sync Error when updating the job
Summary Data Sync Error when updating the job Content HI There, this is what I got when i tried to update the job. what is this persist error? MESSAGE:::persists error: Enterprise Performance Dashboard DEV Cloud Replication Error while trying to create record. MESSAGE:::INSERT INTO W_ETL_DEFN(ROW_WID, LAST_UPD, NAME,…
-
Exporting and Sharing visualisation files (.dva) without connection label and Prompting for connecti
Summary Exporting and Sharing visualisation files (.dva) without connection label and Prompting for connection during import Content Hi there I have built a series of dashboards and am sharing the '.dva' files amongst our team. What I've realised is that the '.dva' file also carries the connection string along with the…
-
Taleo OBI
Summary Taleo OBI Content Hi, Taleo OBI agents / scheduled have by default the from address as "defaultuserobi@invalidemail.com" and alias is "Oracle Business Intelligience". Can we change the alias alone by having same mail id? Thanks, Harish C
-
BI Publisher Environmet 12.2 Audit Activity
Summary BI Publisher Environmet 12.2 Audit Activity Content Hi community, We have an Oracle BI Publisher environment without the Business Intelligence part deployed. (Version 12.2) We need to have something similar to Usage Tracking but in a environment without a deployed RPD. Does anyone know how to consult the Publisher…
-
BICS - Read only user, how to refresh data in report
Summary BICS - Read only user, how to refresh data in report Content We are demonstrating to a top 10 pharmaceutical company the ability to send data from the Oracle mHealth Connector to BICS. We created a separate BICS account for users with limited privileges (read only privileges) to view the reports. The read only user…
-
Unable to configure SQL connection using Windows/MSAD authentication protocol
Summary Unable to configure SQL connection using Windows/MSAD authentication protocol Content Hi all, We are currently trying to configure individual user instances of DVD, using individual MSAD accounts for creation of a SQL Server Database Connection. Unfortunately, it seems like DVD will not accept anything that isn't a…
-
Cannot merge two data sets with added column.
Summary Cannot merge two data sets with added column. Content Dears, I have two sample data sets: Dataset1: Dataset2: As You can see the only difference is the second dataset has an extra column with a Type: Number and Attribute: Measure (Counter). I'm trying to do a simple merge using a Data Flow: In a merge the number…
-
OBIEE - action links for drill down and across purposes
Hi All, I have a dashboard which includes many analyses that will have the ability to drill across and down (hierarchy created already in the database). Problem is when I drill across a certain report (action links), the initial report disappears and the drilled across report displays. Is there a way to freeze the initial…
-
Doc for LDAP, SSL and SSO after upgrading OBIEE from 10g to 11g
Hi We are upgrading our OBIEE application from 10g to 11g. Now we need to implement LDAP, SSL and SSO. Can anyone help which steps or document to refer to achieve above 3 activities? Below are the system detail OBIEE 11.1.1.9.0 Database : IBM DB2 UDB 10.5 UNIX OS will use custom certificate for SSL provided by client…
-
User are faing issue in run the report
Hi All, I am facing issue that i never saw that before and i need your help, When the ran the analytics report in OBIEE and simultaneously i am check the log for this query in Administration-->Mannage Session.And between 1 to 2 mins i can see in the log report will show finished ,but when i came back to front end its keep…
-
Scrolling Pivot table issue
Hi All, Currently building a Dashboard for an OBIEE 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) install. The browser I'm using (Predominantly) is IE 11.0.9600.18920 although I have also tested using Chrome 66.0.3359.139 I have an issue with a Pivot table with scrolling content. When you scroll down the pivot will load,…
-
OBIEE Data Model --> Event trigger with date parameters failed
Summary OBIEE Data Model --> Event trigger with date parameters failed Content Hi, I am developing a report with Event trigger in OBIEE, in that i would like to pass the date parameters which are provided during report refresh to the function in default package. How to pass the variables to this function, please help on…
-
OBIEE 12c Analytics Login performance issue
Hi, we have created user credentials in console. it is extremely slow while logging into obiee 12c analytics. it is taking 15 to 40 sec to launch home page. Can anybody help on this. Thanks in advance Pani
-
Data Duplicates when Joining header table to Detail table
Hello, I have a Fact Header table and Fact detail table from which I've to create a single report. Whenever I Join the two tables the data is getting duplicated. Header amount is nothing but the sum of detail amount by ID. I've the data as shown in the tables below. Please Suggest me how to model this in OBIEE and can you…
-
Can OBIEE favorites be changed en masse?
We've set up an OBIEE demo environment (12.2.1.1.0), with a bunch of canned dashboards and analyses. Originally, the demo team asked me to set up a number of analyses as favorites for all the users, so I did so. Now they've changed their minds--they just like the dashboards which are listed in the dashboards folder, so…
-
Report finishes yet still spinning...
Hi All, Has anyone noticed a report showing as complete in their sessions view yet still appears as searching on the dashboard? I checked the log after noticing the dashboard wasn't as fast as usual and apparently the report completed after 21.6 seconds yet in the view there was just the search button. Upon clicking cancel…
-
Can you bring data from 2 different sources oracle and sql server and create a report in OBIEE
Hi All, can you bring data from 2 different sources oracle and sql server and create a report in OBIEE 12c. I have only windows authentication to SQL server DB. If that work ? Can I import tables from SQL server using windows authentication ? If not any work around for this ? Please suggest.
-
Can I display a ragged hierarchy in DVD?
Summary Can I display a ragged hierarchy in DVD? Content More than a year ago Oracle stated that they are working on adding support for hierarchies in DVD. Until this capability is delivered, has anyone been able to arrange data to enable a Tree Diagram to show such a hierarchy? When I use the tree diagram, it always wants…
-
Bursting: java.io.FileNotFoundException (No such file or directory)
Summary Bursting: java.io.FileNotFoundException (No such file or directory) Content Hi All, My Bursting program completes in error with the exception --Exception /slot/ems3321/appmgr/apps/apps_st/appl/xdo/12.0.0/temp/1559614.xml (No such file or directory) java.io.FileNotFoundException:…
-
BIP Export Issue
Summary BIP Export Issue Content I have a BIP report which when I filter after the report renders on the dashboard then I export to Excel I lose the filters. The whole report exports. Is there any way of export just the filtered dataset?
-
GeoSpatial Analytics in Oracle Business Intelligence
Hi, We are planing to setup GeoSpatial Analytics in Oracle Business Intelligence, Can you please share the relevant step by step documents to implement the same. Thanks, Surendra
-
OBIEE report to Excel
I have a report that will only export less than 5K lines. Any more I have to use CSV. What limitations are there in Excel as far as export. I know about the 65K default limit. This report has about 33 columns and alternate color style.
-
Oracle BIP Report Error oracle.xdo.XDOException: java.lang.NullPointerException
Summary Oracle BIP Report Error oracle.xdo.XDOException: java.lang.NullPointerException Content Hi, So i was having this error (oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.lang.NullPointerException) randomly on a report which works fine if i have a bigger/full set of data. But when i try to limit…
-
Export the filtered data from interactive reporting to excel/pdf files without using parameters - BI
Summary Export the filtered data from interactive reporting to excel/pdf files without using parameters - BI Publisher (Enterprise) Content I have a BI Publisher (Enterprise) report in which I am filtering the data using the interactive features like pivot table, like I click on a department of employees on pivot table and…
-
How to custom Home Page in Data Visualization (12.2.1.4)
Summary How to custom Home Page in Data Visualization (12.2.1.4) Content Hi all, We're trying to custom the homepage for Data Visualization (http://server/dv) in order to omit or reorder some contents. We were able to do this to a specific user (following the steps below), but what we need is to do this change in the…
-
Error 401--Unauthorized From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
Hi All, On loading my OBIEE 12c dashboard page, I get the following error: Error 401--Unauthorized From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: And then pressing F5, i.e on Page refresh, the error is gone and dashboard loads successfully. Can anyone please provide a solution how to fix this error? Great Thanks,…
-
Dashboard is not working as expected in OBIEE 12c
Hi All, I have created dashboard in OBIEE 12c which is working as expected in Test and not working in Prod environment. Dashboard contains 3 reports , one prompt with default value (Published) and based on condition reports will display (I mean condition in section in dashboard) and individual reports are working fine.…
-
Can we run multiple agents at once by creating one Job
Hi All , Is is possible to add multiple agents to one job and schedule the job to run in OBIEE 12c ? Thanks , Bharath
-
Is OBIEE capability to handle 32 Union sql
Hi All , I have requirement in my project that need to create a report based on 32 union sql. Is OBIEE capability to handle 32 Union sql ? Please let me know. Thanks , Bharath
-
OBIEE - Connecting to SQL Server DB issue
Hi All, I have a requirement to create report using SQL server DB. have created ODBC connection and imported required views in the physical layer of the RPD. I am able to see row count but when I click on view data I could n't see the data and observed that column names are coming as values. please see below screenshot…
