-
OBIEE 11g (11.1.1.7 - Windows 2008 R2 - 32 bit) to OBIEE 12c(12.2.1.3 - Windows 2012 R2 - 64 bit)
Hi, We are on OBIEE 11g (11.1.1.7 - Windows 2008 R2 - 32 bit) and planning to move to OBIEE 12c(12.2.1.3 - Windows 2012 R2 - 64 bit). Can the migration be done from 11g - 32bit to 12c - 64bit directly or do I have to first move to 11g 64 bit and then 12c 64 bit? Thanks in advance, Raj
-
Obiee 12c installation, errors at RCU creation
Hi I am trying to install OBIEE 12c, the initial weblogic and OBIEE installs went fine, but during RCU setup, getting the following errors. 1. ORA 00955; name is already used by an existing object 2. ORA-00942 table or view does not exist Previously ran rcu installs on this database instance, but faced the same errors at…
-
oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Close
I am getting oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLRecoverableException: Closed Connection when i am running mapping using ODI12c. Below the error message. Please let me know how to fix this issue.…
-
Formula help with Percentage
Summary Formula help with Percentage Content i have a table, body_parts_injured, date of incident // body part 1/1/2018 // arm 1/3/2018 // arm 1/5/2018 // eye 1/6/2018// eye 1/6/2018 // eye etc. throughout the year of 2018. i want to create a formula to show count of body_parts_injured/total count for table so in my simple…
-
OBIEE Agent run on custom parameters.
Hi All, I have created an agent that sends a dashboard everyday to several people. The agent runs the dashboard on the default parameters. But now i face a new requirement as they want me to create an agent that would run on 5th of every month delivering the data of previous month for eg if its 5th of December 2018 the…
-
Why do I get display issues when hiding a column in a graph?
Hi, I'm using Oracle Business Intelligence 12.2.1.0.0 and I've created a graph that has the products on the x-axis and the total revenue on the y-axis. I want the products to be grouped by tier 1 but I want tier 2 to display. To do this, I've ticked the 'Hide' box under Column Properties - Column Format for the tier 1…
-
Performance issue
What kind of hard drives is recommended by oracle to OBIEE? Is SAS disk OK ?
-
OBIEE 11.1.1.6
Hi, I want to move from obiee 11.1.1.6 server to new created obiee 11.1.1.9. What have to do to move the dashboards, analyses, reports from the old one to the new one? Thanks in advance.
-
Connecting to OBIEE12C's Essbase instance using EAS
Hi, I installed a full OBIEE12C instance and I would like to create an Essbase cube using EAS console. Please refer to the following document which confirms the feasibility OBIEE 12c: What versions of Essbase Admin Services (EAS) , Essbase 12c can be used with OBIEE 12c (Doc ID 2226453.1) Which components have to be…
-
Link for BI apps 7964 with obiee 11.1.1.9.0
Hi Experts, Could you please provide the link for the BI apps 7964 with OBIEE 11.1.1.9.0 installation software's. Thanks!!
-
OBIA 7964 WITH OBIEE 11.1.1.9.0
Hi Experts, Our operating system expiring in few months i.e windows 2008 --> we wants to move windows 2012 R2 we have to install software freshly. Our current versions in windows 2008 Oracle Business Intelligence Applications 7.9.6.4 Data Warehouse Administration Console 11g (DAC) version 11.1.1.6.4.x MS SQL Server 2008…
-
BIP RTF formula? division and math formula
Content I'm trying to get a formula to work within an RTF template and this isn't working: ((sum(current-group()/PRIOR_EXP) + sum(current-group()/CURRENT_EXP)) div sum(current-group()/Budget)) * 100 The division piece seems to be failing but I don't know why: (sum(current-group()/PRIOR_EXP) +…
-
Creating a Logical Column using REGEXP_LIKE in BMM Layer in RPD
Hello Folks, I have a requirement with the following business rule (simplified for understanding), which I need to implement in OBIEE BMM (RPD)..Do I need to use 'EVALUATE' function ? If yes, could you please modify the below expression including evaluate that I could plug into by BMM layer to create a logical column.…
-
Do we have any work around to display inline prompt in the report window, so that we can change valu
Hello, Whenever we apply an inline (report) prompt, it will disappear and report will appear. Instead do we have an option to display inline prompt along with the report , so that we can change the values dynamically.
-
OBIEE 12.2.1.4 Custom Themes
Hello, Forgive me if someone already addressed this. I did a search but did not find anything related to my question/issue. I created a new custom theme and activated in the OBIEE 12.2.1.4 Administration page. I successfully enabled it by adding <EnableDynamicThemes>true</EnableDynamicThemes> to the…
-
Lexical parameter in Fusion BI Publisher Report ( SAAS)
Summary Lexical parameter in Fusion BI Publisher Report ( SAAS) Content We want to create a report using Dynamic table name. We had followed the Oracle provided document mentioned in the link below: https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-F9F844BA-5831-46E5-B085-44D82258A9A9.htm#BIPDM482 Using the lexical…
-
Import view error
Hi i am using OBIEE 12.1.2.1.0 Does anyone know why is this happening when i try to add a new view??
-
Essbase formula are going missing after the DBRefresh
Summary Essbase formula are going missing after the DBRefresh Content Hi, The essbase formula are going missing after the DB_refresh. Running the refresh 2nd time bring back the formula in Essbase. Is it a kind of bug? Version 11.1.2.4. Thanks,
-
incompatible sort order
Hi Team, I am getting error while running union reports in Obiee 11g .Below is the error message for the same State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59107] Set operation…
-
OBIEE physical SQL
Hi I am Using OBIEE 12.1.2.0 I want to knopw how to see Physical SQL that is run against the database. I go in Manage sessions , I took the query that is sent to BI Server, and paste it into Issue SQL, I raise logging level to 2(I tried every possible logging level) and still when i go to View log it does not contain…
-
OBIEE Report Performance Issue
Hi, We have just started supporting client with OBIEE 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) with Oracle data base version Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production There is weird performance issue with couple of reports. The reports works perfectly fine in DEV Environment, but…
-
Hide presentation column using "Hide object if"
Hi, Oracle Business Intelligence 11.1.1.9.0 In the Presentation layer, I want to hide a column from most of the OBI users and make it visible only for a certain list of users defined in a table. sql> select users from hr_security;USERS------------------jsmithjdoe For testing how "Hide object if" works, I was able to use…
-
Migrate OBIEE 12C Dashboard Sub-pages
Dear GURUS, I am working on migrating a few sub-pages created in the Dashboard. My environment details are as below: OBIEE: OBIEE 12.2.1.4 OS: Windows Server 2012 R2 Problem Statement: I'm unable to maintain the layout of the dashboard. I have created a Dashboard with 5 pages and this is live in QA. I have created a 6th…
-
How do I create a waterfall graph with a start and finish value?
Hi, I'm using Oracle Business Intelligence 12.2.1.0.0. I'm trying to create a waterfall graph that has last year's revenue at the start, this year's revenue at the end, and the difference in revenue by product in between to show what has increased and what's decreased. Is this possible? So far I've only been able to get…
-
Showing 0 on line graph for no data
Hi All, we have a line graph that does not go to 0 when we have 0 value (e.g. no revenue that week) instead it jumps to the next week that has data. For example: 5th to 6th week do not return any data from the query as there was no revenue. I need that line to go to 0 on 6th and 7th week as a real representation of what…
-
3-18820433991:OBIEE upgrade failed from 11.1.1.7.0 version to 11.1.1.9.0 at the step of deploying BI
Hi Team, Need your help/Inputs to resolve this below issue. Customer following the OBIEE 11g - How To Upgrade From OBIEE 11.1.1.7 To OBIEE 11.1.1.9 (Doc ID 2022915.1) to upgrade his OBIEE. And he ran successfully and he entered into running config.sh script. But unfortunately it got failed at the step of upgradenonj2ee ER…
-
Retail Analytics - OBIEE 11.1.1.5 - stop from creating large temp files in deliveries folder
Hi, I notice there is a large chunk of space being eaten up by files created under the below folder $OBIEEHOME/biee_i1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/Retail_Analytics/root/users/USER/_delivers/_deliveries Some searching shows me these are related to agents and destination…
-
Email frequency vs engagement
Hi all, We would like to see the email frequency with engagement like below, Number of emails sent 1, 2, 3, 4, 5, 6-10, 10+, 15+ and 20+ in a month AND Open rates/CTR AND Split that, or show the view for different BUs(campaign field). Please let me know if this custom report is possible in insight or do we have any other…
-
Export of maps view does not work in 12.2.1.2.0(SSL enabled)
Found a bug related to same issue for 11.1.1.7 version and claims to be resolved in higher versions. Users do not see maps in the export they just see a small triangle with exclamation mark(like a warning sign) in the export. The export is successful but of no use. It doesn't matter what format(PDF,excel,PPT) they download…
-
OBIEE 12c start up error
Hi Gurus, we have an issue when trying to start/stop the OBIEE instance. Below is the message upon attempting to start. Please share inputs. Thanks. ==================================================================================================================== [oracle@****** bin]$ ./stop.sh Stopping domain; Using…
