-
Connect OBIEE to PBCS
Hello. My question is, can I connect from Oracle Business Intelligence Enterprise Edition 12 c (OBIEE) to Planning and Budgeting Cloud Service (PBCS)? And if you can not currently, will you know when it can be done? Regards.
-
BI Publisher Report - Schedule to Email
Hi All, Facing issue while trying to schedule the BI Publisher Report - Delivery to Email. Requirement: If a user XX belongs to regions A,B,C then the user has to see A,B,C region data only, and user should get three different region level PDF report to his Email. I have crerated a datamodel using SQL Query and applied…
-
OBIEE 12c ADF BC as data source
Hi I am trying to use Oracle Business Intelligence (12c) integration with ADF Business Components to generate reports on data within my ADF application. The steps that I am following are mentioned https://docs.oracle.com/middleware/1221/biee/BIEMG/adf.htm#BIEMG3568. However when I try to import metadata using the BI Admin…
-
OBIEE 11g 11.1.1.7.0 HTML Agents with no format
Hi All, I have an issue in OBIEE 11g 11.1.1.7.0 I create an agent, with format HTML and Deliver results directly in the email. The problem is that the data comes in ok, but without any table format or anything. Any ideas on what may be the issue? Is there any css that might be missing? Any catalog configuration file?…
-
New blog article: Source Control and Automated Code Deployment Options for OBIEE
Source Control and Automated Code Deployment Options for OBIEE: https://www.rittmanmead.com/blog/2016/12/source-control-and-automated-code-deployment-options-for-obiee/ This builds on the presentation that I delivered at UKOUG recently:…
-
Weblogic user is login failed, retry. Oracle BI Publisher 11.1.1.9.0 with integrated with IDM suite
Dear team, We have installed OAM 11g r2 ps3 with BI publisher 11.1.1.9.0 (integrated). We are unable to login to the application with weblogic user credentials. Please let us know any post steps we have to perform to access the BI application. I see below URL also but not working..2147881.1 -Many thanks........
-
Custom Data format
i want to display 0.00 for null values in pivot view.so i used customer format - #,#.0;-#,#.0;0.00 to display it. but issues is when i export report output to 2007+, all values which are updated with 0.00 from null are showing as text. Anyone suggest me how can i fix this?
-
Is there a way (without formatting) to display date and time value in dd/mm hh:mm format?
Hi, We are on OBI EE 11.1.1.7.0. There is a datetime column that displays date and time values in dd/mm/yyyy hh24:mi:ss format. User wants the values to be displayed in dd/mm hh24:mi format. First, I tried changing data format. However, when the results are exported to a csv file, then the values are exported in dd/mm/yyyy…
-
OBIEE : Not able to get rid of Contextual Menu ICON and (Action Link) text in Dashboard report
Hi, I’m having an issue in the presentation of the report by using new Custom OBIEE responsibility. Some reason, inherited properties are not hiding like Contextual Menu Icon and Action Link hyperlink. But this is not happening when I’m using other OBIEE responsibility. I tried all the Catalog privileges and tried…
-
Shortcut for adding attribute column and filter menu dialogue box doesn't work in new patch 11.1.1.9
Just upgraded to Patch OBIEE 11.1.1.7 to 11.1.1.9. When I create an analysis and choose attributes from my subject area I used to be able to use the shortcut Ctrl+Shift (highlight chosen attribute) to add the column to the layout and create a filter menu dialogue box at the same time. This shortcut no longer works with the…
-
BI Publisher SSO not working.
Hi Team I am unable to login using weblogic user when navigating from OBIEE 12C to BI Publisher after migrating the code from 11g version. Although with the same code I have Bi publisher running in other instance. Below are few errors that I got in the log: Authentication error. Invalid session ID or session expired Path…
-
How to add second Instance of Secondary server in cluster OBIEE11.1.1.9.0 for SAMLConfiguration
Customer has done Horizontal Clustering. He has done SAML 2.0 Configuration in OBIEE11.1.1.9.0. Following the below document. https://blogs.oracle.com/pa/entry/obiee_cluster_web_sso_adfs And customer created “ Identity provider partner” with the Name SAML. ANd provided the details of the for the BiServer_1 in the Console.…
-
OBIEE or BIP authentication error
Getting this errors while I try to start bi_server, though bi_server is running, cannot authenticate through OAM,LDAP. Cannot get xmlpserver page running. How can the application get start as root user? Someone tell me how this got in this state. Some reason application got started as system root, instead of application…
-
OBIEE 11.1.1.7_Export Multiple compound layout in Excel
Hi All, I am working on OBIEE 11.1.1.7 and have a requirement to export detail and base data in a single excel sheet ,Is there any way to export multiple compound layout created in analysis in excel 2003 or 2007? Note: Requirement is to export analysis not dashboard pages. Any help here will be appreciated. Thanks &…
-
OBIEE 11g : An error occurred during connect to "10.10.10.80:9810". Connection refused [Socket:13]
Hi Techies, OBIEE Environment was working till few days back,I have changed Java heap value as per Oracle White paper "Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 11g Release 1 (11.1.1.6, 11.1.1). From then on, getting following error: 016-12-06T05:06:45.000+01:00]…
-
BI Publisher 10g to Oracle 12c Connection not working
Hello All, We are facing a connectivity issue from BIP to Oracle 12c in Exadata appliance. Error Message : couldnot establish connection. We are using JDBC thin client(jdbc:oracle:thin:@10.0.100.200:1521:PRDDB) which is working fine with oracle 11g connection from BIP. Database Driver Class :…
-
OBIEE 11g Dashboard Drill-Down Analysis replacing one column's data with another column
All, I am a novice 11g user and am experiencing an issue I'm hoping you can provide help with. I have a dashboard that has a pivot table that allows for drill down by agent name. The drill-down calls a separate table analysis that shows raw ticket data. This table contains only 8 columns of ticket data, all from the agent…
-
Results Tab not working
Hi all! We recently upgraded two servers, a Windows machine and a Linux one. Both from 12.2.1.0 to 12.2.1.2 skipping 12.2.1.1. Windows machine went successful, no issues, made me want to praise Oracle greatness. Linux Machine, was a disaster. Made me want to start a rampage of anger. When creating a new analysis, working…
-
Error on checking JMS Configuration (Oracle BI Publisher)
Hello, I've successfully configured BI Publisher report and want to deliver it by email, using Task Scheduler built-in WebLogic server. I get an error during delivering. So I check Scheduler Configuration at BI Publisher Administration section. Test JMS result: I search the Internet for that error but don't find anything…
-
OBIEE upgrade to 12.2.1.2.0 in Cluster
Hi All, I am trying to upgrade my cluster environment from OBIEE 12.2.1.1. to OBIEE 12.2.1.2. I don't see instructions anywhere for Cluster environment upgrade ? If anyone has one can soem one post it? Damm documentation Thanks Venkat
-
OBIEE 12.2.1.2.0 wlst importService issue
Hi, I'm trying to import the metadata from a previous instance to my recently upgraded 12.2.1.2.0 and I get this error: java.lang.RuntimeException: java.lang.RuntimeException: Exception in reading bar: Illegal char <:> at index 39: content/catalog/root/users/user005/btw:+rh+worker+counthead/ The command I executed inside…
-
Issue with number format in excel in xml publisher
Dear All, When i am getting output from xml publisher report in excel format one column having negative numbers and positive numbers with decimal numbers(like -9075.000, 460.000 , 0.000 ). When i select the column it should show the column total and count. But i am getting count only not sum of the column. How can i get…
-
SAP/BW on obiee answers - Unable to load the dll
Hi All, I have successfully connected to SAP/BW from BI Admin tool (11.1.1.9; on 11.1.1.7 it was not working although it is said to be new feature of 11.1.1.5) installed on my Win7. I was able to move created repository to repository of BI Server 11.1.1.9 on Linux on VM (package from oracle). In OBIEE Answers I kept…
-
Creating an Updateable Briefing Book Subject to Dashboard Prompts
Hi All, I am using OBIEE 11.1.1.7. and have a requirement to generate various PDF versions of a dashboard subject to pre-defined prompts to facilitate scheduling. Given this is not possible using Agents we are looking at using briefing books however I can not see how this can be done based on the prompts required. Is it…
-
Sending a report (by agent task) to more than 1 email address.
Hi, when I select in my agent task more than 1 recipient, I got an error message that I do not have enough rights to select another recipients than my own. And I'm not able to change something in the security because I do not have any user (ecven weblogic) with a link to the administration. And in the settings from my own…
-
BI Publisher Bursting
HI, We have a BI Publisher Report built using RTF Template. when the user clicks on the Apply button on the dashboard it should download the report by ID.For the below example it should download 3 reports for 3 IDS.We can use BIP bursting concept to burst to a location.But I need to mimic this user experience.Is there any…
-
OBIEE 12c:Logical drill graph level-'to': '#######' - does not exist. SQL: '{call NQSGetLogicalDrill
Hi I am getting the below error in my OBIEE report: Logical drill graph level-'to': '5148760.5323540.5523236' - does not exist. SQL: '{call NQSGetLogicalDrillGraph('[EPM] Sales - Backlog Lines','%','5323540','%')}' Error Codes: KZDX4O6Q Location: saw.views.evc.activate, saw.httpserver.processrequest,…
-
RPD file gets moved into a "purged" folder under Repository folder. Why does this happen?
In OBIEE 11.1.1.7.0, I've observed that when i execute "startManagedWeblogic", my RPD get moved from repository folder to "Purged" folder under Repository folder. I wanted to know why repository get moved into purged folder? and how/where to disable this purged option?
-
SSO - Web portal to OBIEE
Hi , The existing setup is : The users navigates from web portal to EBS . In EBS the users selects responsibilities (roles) and can navigate from EBS to OBIEE page with assigned newroles Note: the authentication is happened through SSO - ping identity New Setup The user requirement is to navigate from web portal to OBIEE…
-
Schedule OBIEE Report using webservice to checkIn in WCC
Hi All, We have generated reports in OBIEE engine & have set WCC as output location to checkIn the report files in WCC post running the job. Would like to know how to achieve the schedule report , create job & run that report to checkIn in WCC programmatically using webservices. Below document have been referred -…
