-
org.xml.sax.SAXException
Now I'm trying to use BIEE Web Service to operate BIP Reports,but there are always problems that can't be solved. This is my java code package urn.oracle.bi.webservice.v6.test;import javax.xml.namespace.QName;import org.apache.axis.client.*;public class Test {public static void main(String[] args) {byte data[]=null;String…
-
강남오피 홍반장-《hong43-com》강남오피-강남op-강남키스방-강남건마
Summary cannot be connected to the Internet? Content 강남오피 How can I install Advance Analytic into a computer which cannot be connected to the Internet? My computer for some reason 강남오피can't be connected to the Internet. Can I install advanced analytics? Has anywhere a install package for advanced 강남오피analytic? 강남오피…
-
OBIEE 12c: Delivering Content to SQLAuthenticator Groups
Hi, I'm using the authenticator provider BISQLAuthenticator to bring users and group infomation from oracle database tables into OBIEE (12.2.1.2.0). The BISQLAuthenticator is working well as I can map the groups from the database to OBI application roles and permission correctly what the users can see on the UI. However…
-
weblogic server issue
Hi Experts, Facing issue with below error I tried all the mechanisms but I can see still this issue, Please let me know your suggestions. <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: weblogic.security.SecurityInitializationException: Authentication denied: Boot identity not va lid; The user…
-
Errors in RPD after adding new LTS and column
Hi, Not sure if it is normal behavior, but I'm not sure how to proceed. In physical layer I have created new alias. Created all the required joins. After adding it to the BMM as LTS, I have removed all not needed column mappings. And when saving the RPD, it gives error about missing data source mapping between logical…
-
Can't see plugin in DVD SDK UI on macOS
Summary I've followed the tutorials to create a plugin in Data Visualization Desktop, but I can't see the plugin when running DVD in SDK mode on macOS Content I've followed the tutorials in this article and on this video, but when either of those resources says I should see the plugin in the DVD SDK UI, I don't see it…
-
Unable to Connect db through RPD OBIEE 12 C
Hi All, I have created one connection and trying to connect DB through RPD in Online mode but i am getting below error. Also i have added TNS entry in tsnnames.ora The connection has failed [nQSEerror: 17014] could not connect to oracle database. [nQSEerror: 17001] Oracle error code : 12170 , Message ORA-12170 TNS: Connect…
-
Unable to start obips1 in obiee 12c
Hi Team, I am not able to start obips1 after restating the server and I am facing the below errors. [2018-12-09T11:32:10+04:00] [OBIPS] [NOTIFICATION:1] [] [saw.csf.cache] [ecid: ] [tid: ] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Using credential store provider configured in jps configuration file…
-
Rolling 12 Months Calculation
Summary Rolling 12 Months Calculation Content I need to figure out how to get a rolling 12 months on my report. I was using MSUM function, but the numbers seem close but not quite right. I also saw a PERIODROLLING function, i tried that, but i must not be doing something right. Which of those two should i be using, or…
-
Getting a Month over Month Visual
Summary I have a months view of data and need to get a Month over Month calculation added Content Based on the image I need to create a calculated field taking comparing October to November. The formula would be November/October -1. Need it for each of the pay channels listed. How can that be created in the calculated…
-
Unable to load XML data to template builder for MS-Word
Content My data contains special character (ampersand) and am unable to load this into template builder to create layout. Error No: -1072896749: Whitespace is not allowed in this location Line No : 2 Position : 7441 File Pos : 670535
-
Migrating Oracle discoverer 11.1.1.7.o to OBIEE 12C
Hello We are running Oracle discoverer 11.1.1.7.0, our EUL version is 5.1.1.0.0.0; we have to migrate to OBIEE as part of this migration we installed and configure OBIEE 12c. My question is can We migrate our EUL 5.1.1.0.0.0 using Oracle discoverer Metadata conversion assistant tool ( MigrateEUL.exe) that comes with OBIEE…
-
Fusion Middleware security Configuration in BIP 12c
Summary IMplementing Data level security for BIP Reports Content Dear All, I have configured Data Level security in OBIEE 12c and its working perfectly fine. I have one BIP report which is using OBIEE logical query as data source , now when user login to OBIEE and access the BIP report the data level security is not…
-
Create a dropdown to include or exclude a bunch of column values
Summary dropdown to filter on column values Content Hi all, I have a dashboard(in BI Answers) where I am looking to add a dropdown-to include or exclude a bunch of column values. If the user picks include, I want these bunch of values(all from one column) included in the analysis. If they pick exclude, the values should be…
-
OBIEE - Mandatory Dashboard Prompts - Hints to the user
HI All, In OBIEE dashboard prompts, if a prompt is required the apply button is not highlighted unless the user selects a value for the prompt. I want to know in OBIEE is there a way to hint the user with a pop up "select the required prompts", if the user clicks on apply without selecting the required prompts. Thanks
-
Oracle Data Visualization Desktop to Mojave Macos
Content Do we have an version compatible with Mac OS Mojave? there it is an ETA?
-
Essbase - anyway to make it hierarchical in OBIEE?
OBIEE 11.1.1.9.0 Modelling Essbase data source ASO Cube into OBIEE and it all works but the lack of difference between level 0,1,2,3,4 etc members makes it really hard to use for report design. Is there anyway to bring some of the Essbase look and feel into OBIEE so it is at least obvious when you are looking at level zero…
-
Data set in Data Model which doesnt work
Summary Data set in Data Model which doesnt work Content Hello, I'm working on an RTF template on which I want to display certain information of a table called "shipment_stop_debrief". Fyi I didn't create this data model from the start, i'm new at this. I created another Data set with this content: SELECT…
-
Smart View and OBIEE
Summary Using Smart View to Download OBIEE Dashboard on Excel Content Hi, I was able to set up smart view to access OBIEE. There is already a dashboard created in OBIEE and the dashboard comes with dashboard prompts. When I tried to download the dashboard to excel, the data is downloaded but there is no prompts for me to…
-
Call BIP job from a database
Summary when some data is inserted in a database at the same time id like to call a BIP job to create output Content when some data is inserted in a database, at the same time id like to call an BIP job to create output based on this data e.g. 1. Data inserted in Table 2. SQL calls a BIP job 3. PDF created by BIP step…
-
Oracle DV Tips and Techniques Videos
Summary A new playlist was created on Oracle DV tips and techniques Content Check out the playlist below, it's growing with several recordings of tips and advanced techniques to make the most of Oracle DV ! https://www.youtube.com/playlist?list=PL6gBNP-Fr8KUDSPC-EFQALQgtNHNF8TRB
-
Obiee Start Failed
Hello, Our company wants to change the ip adresses of obiee server. So, yesterday we stopped all services (./stop.sh command), then change the ip addresses and give required telnet priveleges. However it does not start again. Node manager failed and still we can not open the system. Can you help me please. Following errors…
-
Data Visualization on top of Essbase
Summary Feedbacks for Data Visualization on top of Essbase Content Dears, As a small poll, could you please provide your feedbacks and use cases about Oracle Data Visualization (Visual Analyzer or DVD) on top of Essbase or OACS Ess. Are you using it in your organization? Is anyone in this board satisfied about it and…
-
Clear cache by button in Oracle BI 11
Hi everybody, i'm quite new to oracle BI and its inner working. I've read that it's possible to clear the cache with command "call SAPurgeAllCache();" . Another method it's set time cache on table in physical layer (Admin Tool --> Repository). Is there a way for the end user to clear the cache for a single dashboard by…
-
Error Codes: UH6MBRBC - Unable to print to PDF in OBIEE 12.2.1.2.0
Hi All, I see the below error when I tried to print to PDF from a OBIEE dashboard. I am able to print to PDF for other dashboards. Please suggest. Thanks. Sax parser returned an exception. Message: Entity 'nbsp' was not found, Entity publicId: , Entity systemId: , Line number: 221, Column number: 152 Error Codes: UH6MBRBC…
-
OBIEE smtp auth via kerberos
Hello We have OBIEE 12.2.1.2 instance with LDAP (ActiveDirectory) authorization. And we have SMTP configuration for our mail server (Exchange) with authorization. We use OBIEE on Linux. Everything work fine..but mail admins wants to close SMTP auth by NTLMv1. We try test to switch to NTLMv2- but fail. OBIEE 12.2.1.2 dont…
-
Error when adding display extensions in OAC
Summary I have a problem loading the display extensions in my new instance of OAC, I must restart to use them and after a few hours they are no longer available Content When adding the extensions downloaded from the following link: https://www.oracle.com/solutions/business-analytics/data-visualization/extensions.html It…
-
User folder/Saved Queries
Hi All, Is there a way to access the folder/objects of a user that is no longer in the system (e.g. removed from the WLS LDAP)? The intent is to access some saved queries, and copy them to a shared location for others to use. OBIEE 11.1.1.9..x | OBIA 11.1.1.10.1 Regards, Charles
-
Conditional column headings
Goodmorning, I have a question on the possibility to create column headings with conditions. There are many discussions on creating dynamic ones based on a prompt, but that's not what I want. I have the following example, where based on the names of the supplier, the first column either gives harvest or FC kg and the…
-
Calling a Rest Service from BI Publisher
Summary Calling a Rest Service from BI Publisher Content Hi All, I have a requirement where I need to call a Rest Service from a BI Publisher Report, is this possible and if it is how is it done. Thank You Carin Webb
