-
Dashboard prompt oracle BI
Hi there, I have a problem and I was wondering if I am the one on earth having this issue or not! I have a repository which includes a session variable, let's say that this variable is the year. I have created an analysis based on that repo and I assign a value to that session variable through a dashboard prompt.…
-
Configure RCU, Middleware, OBIEE Error!!!!!!!
Hi! I'm new Oracle BI 12c, I have installed Oracle DB 12cR1 and OBIEE 12cR2 on the same Centos 6.8 server successfully. But when i configed RCU, MiddleWare, OBIEE, It launched errors as attached log file and image. >>>>LOG ERROR: [2018-01-11T16:15:39.090+07:00] [bi] [NOTIFICATION] [] [oracle.bi.install.ui.basepages] [tid:…
-
Can we create comlplex combo charts & Pivot charts in OBIEE 12c
Hi All, Is is possible to create complex combo charts and pivot charts in OBIEE 12c ? Please refer attached chart(created using Cognos BI tool) which I want to create in OBIEE 12c. Thanks in advance.
-
NEW!!! INSTALL ORACLE BI 12C ON LINUX!!!
Hi! I’m new Oracle BI 12c. I have installed Oracle BI 12c , but then i realized i didn’t install Oracle DB 12c, so i'd like to ask you some questions: 1. Could I install Oracle DB 12c(12cr1 or 12cr2 ???) on the same server (Centos 6.8 server: 10.0.18.130) which I have intsalled Oracle BI 12c??? 2. If impossible, Must I…
-
Obiee 11.1.1.7.0 missing filtered prompts values
hi friends, i am new on obi platform. I have a question about dashboard prompts. I created a dashboard that contains five prompts. When i filtered some column prompts and hit the ok button.a result comes to my screen. but i have noticed that i gived a wrong filter so i must go back the dashboard screen.But i see that all…
-
how to connect to kerberized hive?
Hi gurus, i have a problem when connecting to kerberized hive in oracle data visualization. right now i'm able to connect obiee to kerberized hive via RPD, but when it comes to ODV, i have no idea how to solve this, since there is no like advanced button to pick authentication method (like system DSN ODBC in windows). I'm…
-
Error in launching oracle universal installer
Hello All, I am installing obiee 12.2.1.0 in lunux 64 bit machine. I have installed jdk "1.8.0_151". when I am trying to launch the oracle universal installer, I get the below message and I do not see any progress java -jar fmw_12.2.1.0.0_infrastructure.jar Launcher log file is…
-
Multiple Text Value Presentation Variable
Hi Experts, I am facing a strange situation and need your comments . I have two Pages on my Dashboard, Page1 and Page2. Ttrying to pass the Prompts values selected in Page1 via Narrative View to Page 2, do not want to show two separate page hence controlling the flow via Narrative View. Now target report prompted for…
-
oracle weblogic admin console 12c : assigning users to groups
Hi , I am trying to set up different security permissions for users when accessing obiee 12c. I have read about it in various documentations and other discussions, but for some reason I am running into trouble. I know that when setting up the permissions you have to first assign the user to a group on web logic ( ie:…
-
Arithmetic overflow error converting expression to data type int
Hello, I'm working obiee 12c with sqlserver datawarehouse. I get this error in a calculated column when i run the analysis. [nQSError: 16001] ODBC error state: 22003 code: 8115 message: [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error converting expression to data type int.. when i see the datatype…
-
Data flow changes are not affecting
Summary Data flow changes are not affecting Content Hi Everyone, I have just started exploring and working on DVD with OBIEE as my primary skill. I was trying to create simple data flow using few of tables from oracle database. Let me put it in this way.... I have added few tables as data sets from Oracle database. Created…
-
DVD on Mac: missing features
Summary DVD on Mac: missing features Content Hello everyone, I'm using DVD on mac, which runs quite smoothly. Good job. Except that I'm missing some features compared to the Windows DVD version: * Connector Types: only 4 available: Applications, DB, Essbase and Talent * Export functionality on the data elements is not…
-
How to display image in excel output through rtf file from MS Word 2013
Summary How to display image in excel output through rtf file from MS Word 2013 Content How to display image in excel output through rtf file from MS Word 2013
-
OBIEE - Google Hierarchical View missing the first time
Hello I have included the Google chart api for dispalying a Hierarchical View. It works. However when I display the report in the Dashboard for the first time with some new data it (most of the times) is missing, then i have to move back to revious selection or edit the report containing the tree and then return to the…
-
How to recover forgotten password of rpd in OBIEE 12c?
Hi Guys, I want to open an rpd in offline mode but do not remember its password. Can anyone please tell me how to retrieve the rpd password in OBIEE 12c? Thanks, Dolly
-
Installation OBIEE on Redshift/Postgre Database
Hi guys, did anyone try to install OBIEE on top of postgre/Redshift databases. I tried to search in knowledge docs could not find any. Any pointers will be helpful. Thanks, Sai
-
Conditional format in Direct Database Request in OBIEE 12c
Hi, Can we use conditional format in Direct Database request Obiee 12c.? Regards, Sudhakar
-
Invoke a external webservice REST API in OBIEE 12c
Hi All, Is it possible to Invoke a external application web-service REST API in OBIEE 12c ? Or is there a way to save OBIEE report in a database as a BLOB / CLOB column snapshot automatically using any service and agents. I want to integrate or schedule OBIEE reports to get delivered to an external application using REST…
-
Config action BI Configuration failed in OBIEE12c
Hi Team, Please help me to resolve on below issue.
-
W_MCAL_DAY_D table dropping W_CURRENT_MCAL_PERIOD_CODE = 'Previous' Rows
Has anyone had the issue where the W_CURRENT_MCAL_PERIOD_CODE = 'Previous' rows are dropped from the W_MCAL_DAY_D table? We notice that some reports that used this to get Previous Balances are no longer working, It looks like it started after the 1st of the year. Is there a system setting that controls the Previous rows…
-
Report cannot be rendered because of an error, please contact administrator error seen without any c
Summary Report cannot be rendered because of an error, please contact administrator error seen without any cause Content This issue was seen in BIP report in Oracle Business Intelligence 11.1.1.9.0. I did see other threads with the issue of report not rendering but each one of them had a certain cause associated with them.…
-
Permissions option under Tasks section under a Catalog folder is not responding.
Summary Permissions option under Tasks section under a Catalog folder is not responding. Content Hello, I am currently having an issue in BI Publisher under the BI Publisher Security model where the Permissions icon when clicked returns no pop up window. The click returns a blank response. It is no greyed out and is shown…
-
Desktop version for Mac OS Sierra is not available yet?
Summary Desktop version for Mac OS Sierra is not available yet? Content
-
BI Publisher - error when calling Report (with Excel template) from Analytics - javax.xml.ws.soap.SO
Summary BI Publisher - error when calling Report (with Excel template) from Analytics - javax.xml.ws.soap.SOAPFaultException Content Hi all, Currently on Oracle Business Intelligence 11.1.1.7.150120 (Linux). Using Analytics we have a Dashboard containing an analysis and prompt. The Dashboard works OK and produces the…
-
Convert number to hh24:mi:ss
Summary Convert number to hh24:mi:ss Content I have a field which has seconds in number format. I have to convert it into hh24:mi:ss. For example select to_char(to_date(10000,'SSSSS'),'hh24:mi:ss') num_time from dual; gives time as 02:46:40. Now i want to do this rtf template. I tried…
-
Failed to Load Pdf Document in Bi Publisher
Summary Failed to Load Pdf Document in Bi Publisher Content hi , i am unable to load pdf report from .rtf file .iam using bip 11g and tried in different browsers . also the data source is properly configured from my end .
-
BI Publisher report with a parameter does not return any data when the parameter is hidden
Summary BI Publisher report with a parameter does not return any data when the parameter is hidden Content Hi, I have a report with one parameter, with three possible options from a drop down list, which works fine when the parameter is displayed. If I un-tick the Show box to hide the parameter then the report does not…
-
Stop During installation bi 12.2.1.3.0
Summary Stop During installation bi 12.2.1.3.0 Content I'm try to install BI version 12.2.1.3.0 version of weblogic = 12.2.1.3.0 version of BI = 12.2.1.3.0 During the installation it stop during "generating Libraries" The only thing is that i have installat on a weblogic where there is previously installed FORMS /…
-
Silent/Unattended Installation for BI Publisher v. 12.2.1.3.0.
Summary Silent/Unattended Installation for BI Publisher v. 12.2.1.3.0. Content Hello - I am trying to install BI Publisher v.12.2.1.3.0 silently. I know how to create a rsp file. However, when I go to Oracle's website to download the BI Publisher, the downloadable file is BIPublisherDesktop32.exe (for the 32-bit). In order…
-
parameter values not working for admin
Summary parameter values not working for admin Content Hi, when I login as administrator unable to view lov values in parameter for all the reports. Can you help me come out of this.
