-
OBIEE 12c - run agent from shell script
Hi community, I need to run some agents from shell script. My purpouse is to run an agent when some procedures are done...and I never know the right timing. I knew since OBIEE 11 some utility was provided...I cannot find anything for 12c. I tryed to inspect a little bit agents from dev tools; and I found this POST request…
-
Temp Files are created and utilizing large space in OBIEE 11g
OBIEE is installed in Linux machine, when Report is exported or agent is running Temp files are created in /temp folder which is utilizing more space. This is happening from 1 month. Please suggest. Thanks, Nikhila
-
DV Visual Filter Top 10
Summary I need to filter for Top 10 for just one of the reports in my canvas Content Looking for How-To place a top 10 filter on the record count of just one of the Visual reports in my canvas. I do not want this filter to effet the others. Version 18
-
Q4 and All Other Qs
Hi All. I have a requirement that in a single analysis I have to create two views. One will show quarter 4 data based on quarter selection in DB prompt. So, if I select anything related to 2018, say, 2018Q1, the result should show 2018Q4 data. The other view should show only selected quarters. How do I go about it. I have…
-
OBIEE12c Front Page customization...!
Hello All, I got a requirement to change OBIEE home page Next to oracle logo instead of business intelligence i need to change to some other name. Can you let me know how i can achieve that. Thanks Uday P
-
Data Lineage in OBIEE 12.2.1.4.0 - Can this be automated ?
Hello Experts, We have installed OBIEE 12.2.1.4.0 on Linux server. We have about 90 dashboards used nationwide by different regional groups. Our current need is to design a data lineage solution that can serve us the technical development group to assess impact analysis whenever there is a change in the data warehouse. We…
-
Initialization blocks in OAC
Summary OAC capability for custom table authentication using Init blocks. Content Hi All, We are yet to start upgrading from OBIEE 11.1.1.9 to OAC. In OBIEE 11.1.1.9, currently customer using external table for additional row level security. This was implemented using Init blocks. This is very critical requirement and the…
-
OAC- Classic in myservices
Summary Not able to see OAC- Classic in myservices Content Hi Gurus, I am trying to provision a OAC - Classic instance. We have universal credits and wanted to use that to spin up a OAC- Classic - Customer managed instance. I am not able to see that in the myservices . PFA the screenshot. Version NA
-
How can i use case statement to solve for this scenario
I am working on a requirement that requires me to find whether an employee applied to the same job name more than once. If they apply to job name A with a job number 123 and the hiring manager decides they are more qualified for say the same job name but say a different job number , then I need to assign a flag of N…
-
Reg:oracle BI 12.2.2.0.0 version client
Hi Every one, Good Morning !!! We want to install oracle BI 12.2.2.0.0 version client in our machine unable to find this version, do we need to apply patch’s for lower version to get this version can anyone suggest on this. Thanks in advance,
-
OBI11.1.1.9 Dynamic database source
HI I would like to offer a dynamic way to connect within the RPD to two diff sources - one Oracle (using OCI) one non-Oracle (Connect via ODBC). Both sources are identical in structure & data. When connecting to each source with it's own RPD - everything works fine. Now we'd like to have only ONE OBI server (one RPD) and…
-
OBIEE 11.1.1.9 HFM integration - Failed to find environment variable COMPONENT_NAME
Hi I've installed OBIEE in a distributed server environment. I want to integrate OBIEE to HFM which is on a separate server. I've installed financial management ADM driver on the OBIEE server by installing Financial Management SDK and configured FM. I have also included the EPM_ORACLE_HOME and EPM_ORACLE_INSTANCE variables…
-
12c: Graphs not showing anymore
Hi guys, first of all I want to state my versions I am using for the upcoming scenario / question / problem: OBIEE: Version 12.2.1.1.0 OBI Administration Tool: Version 12.2.1.1.0 Oracle Essbase: Version 11.1.2.4.008.28 Server OS: Linux RedHat Enterprise Edition 6 This morning my colleague has added some new KPIs within…
-
The selected request cannot be performed because it references an unknown subject area named
Hi All, I have changed the Subject Area name in the presentation layer in OBIEE from Sales to Sales (Mobile). Post that change whenever I make a report in Analytics I see the error message: Subject Area named Sales I request you to let me know if there is any fix to it. Thanks, Karthi
-
Reports showing NULL values post migration from 11g to 12c
Hi, I have recently migrated from OBIEE 11g (11.1.1.9.0) to 12c (12.2.1.3). Post migration, a report which showed correct values in 11g , is now showing NULL values in 12c. Not that all the cells are NULL, there are values in few cells. I'm trying to develop a report with 2 fact tables and 5 dimension tables. Both the…
-
Cache Purge Scheduling
Hi , I am using OBIEE 12.2.1.2.0 I would like to knoow how can i schedule cache purging every day at like 7:00 am I found this article Business Intelligence : Purge Cache Automatically in OBIEE 11g They say That i have to put my current RPD name as my DSN, and analytics credentials. I do that and when i try to run the…
-
User changing his own password in OBIEE 11G
Is there any way to let the user chgange his own account password with logging into WLS console. I faced this issue in OBIEE 11g and 12c
-
OBIEE 12C Drill up issue
I am facing an issue with the drill up in analysis or graph as when you drill down to a lower level you can't go up again until you refresh the hole page in order to reset the hierarchy. Your soonest reply is highly appreciated
-
Does OBI Admin Client 11.1.1.9 work on Win 2016 server or Win 10?
Hi, Has anyone been successful to install OBI Admin Client 11.1.1.9 on Win 2016 server or Win 10 machine? Thanks.
-
Returning All Values
Hello, I am new to using OBIEE(Oracle Business Intelligence 12.2.1.3.0). I am a front-end user. I am creating a report using two tables. How do i create an analysis to return all values in Table A if not found in table B. E.g Table A have 20 records Table B have 10 records I need to return 20 records with the matching 10…
-
MDX YTD formula
Summary not able to calc YTD members Content Hi All, we have a req. where we need to get the YTD value of current member(Select Member), so have a alternative Time hier which is called YTD attached the hier, EX: if users select SEP month, we need to get data for YTDSEP data and calculate a member, so I tried almost all the…
-
plotting by latitude and longitude in Oracle Data Visualizer maps
Summary Is is possible to plot by lat/lon? Content Trying to plot geo-spatial data on a ODV map. The data has latitude and longitude and it would be nice to use just that data instead of being forced to do a reverse geocode from lat/lon to an arbitrary 'neighborhood code'.
-
BI Publisher and forms integration
Simple question Following this document How to Call a BI Publisher Report from Forms 12c Using RUN_REPORT_OBJECT (Doc ID 2235962.1) This document keeps referring to a virtually mapped directory eg the final line says The report pdf output is placed in a virtually mapped directory and then called using WEB.SHOW_DOCUMENT().…
-
Subject Area Folder not Visible in OBIEE
We have a subject area defined in the presentation layer of the RPD. Within that subject area, there are multiple folders. When we sign in to OBIEE, some of these folders are not available for selection within that subject area. Is there a flag or a property somewhere in the RPD that makes these folders invisible? Thanks,…
-
Comparing date columns for analysis
Hi all. I have the table with some order information (id, description, order date, ...) and I have a time data-table for using as dimension with info about years, months and its start and end dates. ORDER_ID ORDER_DATE YEAR MONTH START_DATE END_DATE id1 15.03.2018 2018 JAN-18 01.01.2018 31.01.2018 id2 25.02.2018 2018…
-
RPD Connection TNS when multiple environments
Hi All We have three different environments and every environment has different TNS DEV This is used for the development of RPD and analytics by the Software engineers QA This is used for the testing by quality assurance department Production This is used by the end users i.e. managers, supervisors etc. Whenever we deploy…
-
Change password by user in OBIEE 12c
Hi Guys I'm interested to know if there is any way to users could change their password independently ?! I have read some articles regrading to develop java class by calling change password method from MBean server and deploy it on BI Server (https://www.rittmanmead.com/blog/2011/10/changing-your-password-in-obiee-11g/),…
-
After 12c migration problem
Hi everyone , I have a problem . I used data model in 11g but I don't use this model after migration OBIEE 12c. Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code:…
-
BIPS Data Model - how to handle a date parameter with a text based list of values
BIP Publisher in Fuision Financials - data model problem - so OBIA version 11.1.1.9 as my issue is entirely in the cloud. I am trying to work around a prebuilt data model which uses a package to populate its data, so there is a lot that I cannot touch / change. I need to use an existing prompt with LOV to apply an extra…
-
Please ignore - Test thread for mission test
Please ignore - Test thread for mission test
