-
Issue in RPD migration 11g
Hi All, I have merged RPD by using 3 way merge in Administration Tool after that i have deployed the same rpd through EM. After that i have observed some security setting changes. 1.We dont have Advanced tab options to users 2.After deployment user able to see Advanced Tab in answers. Could you any one let me know what…
-
Reg: Agent getting failed from other user id
Hi Every One, We have few Agent's created in Administrator user id those are running fine. When we are trying to run the same Agent's in another user id, that user id also having Admin rights but we are facing below error. Can anyone suggest on this. Version :OBIEE 11.1.1.7.1 Thanks in Advance,
-
Visual Analyzer error 500 when displaying table columns
Hi i'm having some troubles when creating visual analyzer projects. I could load a repository from my Oracle Database, but when i select it in va and want to display the columns of a table i get this error: I search de browser console and it says this: OBIEE is running on Red Hat Enterprise Linux Server release 7.3 (Maipo)…
-
Merge two different RPD
Hello, I have some problem with merge repository. Actually, we are upgrading our BI system. At now we have: Oracle Business Intelligence 11.1.1.7.131017 with Oracle Business Intelligence Applications 11g Release 1 (11.1.1.7.1) ---> OracleBIApps_BI0003.rpd (this rpd has many our changes) New version: Oracle Business…
-
Data Visualization Cloud Service
Summary Data Visualization Cloud Service Content What are the system requirements for Oracle Data Visualization Cloud Service?
-
OBIEE Report Based on Member and there sales%
I would like to generate a report of this kind. In which I will select a month from the dashboard prompt and the respective graph should display Top 1% of the customers who contributed for highest amount of sales and vice versa for the rest.
-
OBIEE RPD 12.2.1.2 How to disable certain Consistency Check Warnings
Since we upgraded to 12c, there are additional RPD consistency check warnings and it is cluttering up the warnings I can't do anything about. E.g. [39099] Level "ABC"."XYZ" has at least one display key that contains multiple columns. Only the first column of a display key is displayed when drilling. [39100] Logical column…
-
OBIA 11.1.1.10.2 with OBIEE 12c
Hi I am implementing OBIA 11.1.1.10.2 and would like to try OBIEE 12c. But as I don't have a proper documentation, can anyone suggest if OBIEE 12c is compatible with OBIA 11.1.1.10.2 and ODI 11.1.1.9.0 ? Any supporting documents justifying the point would also suffice. Thanks for the help. Regards V
-
Configuration problem of OBIEE 12c in Solaris 11 system after installation.
Dear All, I need a quick help to solve this issue. We installed Oracle Solaris 11.3 Live Media in a system. We tried to install OBIEE version 12.2.1.2.0 in this OS (Solaris 11.3). We have installed Weblogic server (Infrastructure) and OBIEE in this OS. We have done a perfect installation and RCU creation without any error…
-
JDK version for OBIA 11.1.1.10.2
Hi I am implementing OBIA 11.1.1.10.2 on Solaris 11 VM. The VM already have a jdk 1.8 version installed. As per certification matrix it is told OBIA 11.1.1.10.2 supports JDK 1.7.0_80+. Please clarify me if JDK 1.8.0_60 will be compatible for the installation or should I install 1.7 separately. Any help would be…
-
EVALUATE_SCRIPT
Summary EVALUATE_SCRIPT Content Try to use standart R-script and has the mistake/ What is wrong with it?
-
How to send a URL of dashboard in E-mail with parameters prompts
Summary How to send a URL of dashboard in E-mail with parameters prompts Content Hello, I would like send in e-mail a URL of dashboard with filters parameters populated. I'm trying to use this URL…
-
Reg: Changing Admin password
Hi All, We need to change the Administrator password, some of the users are aware of the password. Can anyone share the steps for changing the password. Whether we need to take any backup if we change the admin password, will it impact any other things in the application please let me know and suggest on this. Thanks in…
-
Configuration problem of OBIEE 12c in Solaris 11 system after installation.
Dear All, I need a quick help to solve this issue. We installed Oracle Solaris 11.3 Live Media in a system. We tried to install OBIEE version 12.2.1.2.0 in this OS (Solaris 11.3). We have installed Weblogic server (Infrastructure) and OBIEE in this OS. We have done a perfect installation and RCU creation without any error…
-
OBIEE managed server not starting
llo All, We have manually stopped it once and after that it is not starting ..... Failed when we tried to start from console. when we trid to start Erro Message in Biserver1 [2017-08-20T09:40:15.620+03:00] [bi_server1] [ERROR] [WSM-02313] [oracle.wsm.resources.policymanager] [tid: [STANDBY].ExecuteThread: '37' for queue:…
-
Displays Error:javax.management.InstanceNotFoundException: Unable to contact MBeanServer in BI EM Lo
Hi All, Recently I enabled SSL to OBIEE environment through keytool utility using JCEKS. OBIEE version:12.2.1.2 After making all the necessary changes, brought Admin and BI Services up and running. While bringing up system components like BI Presentation Services, BI Servers etc in Enterprise Manager of OBIEE, I see below…
-
How to Call BI Publisher 12c report from URL
Summary How to Call BI Publisher 12c report from URL Content Hi, Im trying to follow this link but fail. https://blogs.oracle.com/xmlpublisher/user-creds-on-a-url http://127.0.0.1:9704/xmlpserver/HR Manager/W2/W2.xdo?id=Administrator&passwd=Administrator Any body can help me to achieve this. I'm using oracle bi publisher…
-
DVD for MAC released
Summary DVD for MAC released Content DVD for mac is released and available for downloads. Happy days for mac users.
-
How do I install DVD for Mac Advanced Analytics?
Summary How do I install DVD for Mac Advanced Analytics? Content Would like to use my custom R scripts for DVD on Mac, where is the advanced analytics installer?
-
Master Detail Report - XML output is incorrect.
Summary Master Detail Report - XML output is incorrect. Content Hello, I have the following contents in the datatemplate.xml <?xml version="1.0" encoding="UTF-8"?><dataTemplate name="PRODS" defaultPackage="" version="1.0"> <parameters> <parameter name="p_prod" dataType="character" /> </parameters> <dataQuery> <sqlStatement…
-
OBIEE query returns ora-942 after erp db upgrade
Hi Experts, we have and obiee 11.1.1.7 connected to oracle10g that run the following query fine. when we upgraded the db to 11.2.0.4 it started to return ora-942 searched oracle support and check DBFeatures.INI,several bugs bugs like YTD bugs but could not find exactly the same scenario when running query using sqlplus it…
-
Maps in OBIEE 12c
How to integrate maps in obiee 12c to create analysis with maps. Is there any oracle documentation available with detailed steps and configuration settings?
-
how to automate otbi webcatalog archive process
Summary how to automate otbi webcatalog archive process Content Hi, I would like to create daily backup of Shared folders. Is it possible to automate this process ? Thank you, Ark
-
How to Authenticate Oracle BI Publisher(Enter Prise) username and password from oracle data base
We saved username and password in database and we authenticate these from database for other apps. From a table of users column username and password. I want to authenticate users from data base . Please guide me.
-
Usage Tracking - Need more precision in Date columns in S_NQ_ACCT
* In S_NQ_ACCT, the START_TS column is defined with a datatype of DATE, which limits us to zero decimals of precision after the number of seconds (i.e. seconds are the lowest level of granularity for a DATE column). * A TIMESTAMP column can have up to 9 decimals of precision for seconds, with 6 being the default. * I…
-
how to configure rollovers of graphs
Hi There, I would like to configure the Graph Rollover in the second image just like in the First image. To be clear, even though the no of columns are same in the Layout tab for the both the graphs the output isn't same. For instance, the rollover in the first image has only two measures where as in the second one it is…
-
Connection for Pool "data source" has been closed
hi, please do find adminserver log as below:- ####<Aug 17, 2017, 11:01:23,201 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH4FSvU6uH65vNl3iX000OCT00DLf6> <1502982083201> <[severity-value: 64] [rid: 0:3:1]…
-
Remove Blank Page End of Report
Summary Remove Blank Page End of Report Content Hi, I am running a report in xml publisher. The output of the report prints 2 pages, one page with correct report output and other page is a blank page with header details. I want to avoid this blank page. Is that something wrong? Please help. Thanks!
-
Patch for oracle BI publisher 11.1.1.9
Summary Patch for oracle BI publisher 11.1.1.9 Content Hi, I have Oracle BI publisher 11.1.1.9, i would like to apply the minor patch version . Kindly share the patch detail and doc for my related version. I check the support but i can able to find the patch for BI publisher Enterprise 11.1.1.9 Regards, Ove
-
Create Payrol Report through Pivot Table
Summary Create Payrol Report through Pivot Table Content Whenever I add a new element it give us a new sub total with should not come. Total should come in the end only for the One time and Screen shot is attached herewith. Yellow highlighted total is not required. Regards, Javed Iqbal