-
biee 11g: Attempt to synchronize unknown keys: viewportSize
Dear Everyone I met a strange problem,like the blew screenshots before this ,i reset dev_biplatform,dev_mds password and restart all bi service(including weblogic,manager server) I hope you help me. thanks regard
-
What is the recommended file system for OEL 6 OR 7 FOR OBIEE12.2.1.2.0
Hi experts, What is the recommended file system for OEL 6 OR 7 to install OBIEE12.2.1.2.0 Pls let me know... Thanks, Anilesh
-
ODBC connect to OBIEE 11g RPD using openrowset opendatasource linkserver from SQL
Has anyone attempted to install the BI Administration client onto a SQL Server 2016 hosted server - to create an ODBC means to use either OPENROWSET, OPENDATASOURCE or LinkServer on a SQL server to connect to an OBIEE 11g RPD for ad-hoc query on MSSQL.
-
OBIEE 12C (12.2.1.2.0) integration with Essbase (EAS Server)
Installation and Setup: We installed OBIEE 12 C and included the Essbase component during the OBIEE installation. According to the below Oracle reference, EAS 11.1.2.4.008 and later is supported with our release of Essbase. http://docs.oracle.com/cd/E66975_01/doc.1221/readme/essbase_122120_readme.html EAS Server was part…
-
OBIEE 12 c Auto Refresh
OBIEE 12c I have a requirement where the user would like the dashboard page to auto refresh every 60 seconds without having to click on the "Refresh" button. Is there a way to do this.
-
Unknown "inconsistency" in RPD for SampleApp Connection Pool in 11.1.1.9
I just upgraded my OBIEE system from 11.1.1.7 to 11.1.1.9. The Connection Pool associated with SampleApp is generating this Warning in the consistency checker: ADF Database 02 - SampleApp Xml Data has a Connection Pool SampleApp XML Connection that contains non xml inconsistenecies. (Their misspelling, not mine.) The only…
-
Rearrange objects in Presentation Layer
Hi, I am working on the presentation layer of a new subject area and having problems on the arrangement of the objects in the presentation layer. I have provided an example below. My main folder Employees contain 3 columns (Column 1, Column 2 and Column 3) + 2 child presentation folders (Sub-folder1 & Sub-folder 2). By…
-
Analyze OBIEE WebCatalog
Hi All, Has anyone implemented a way to analyze an OBIEE Webcatalog? I want to implement an OBIEE Analysis to see what roles are assigned to a catalog folders? I am not a linux/java script expert probably to write this. Any assistance would be appreciated. Lerata
-
Rows to Column in OBIEE
Hi All, I have a requirement where i have to convert my rows into columns(different obviously ) So my data is Id Region City 2 NAM NYC 2 NAM Washington I have to display like this: Id Region City1 City 2 2 NAM NYC Wash.. is it possible to do it in OBI? i don't have access to OBI backend or repository
-
Tree View in OBIEE 11g
Is there any native view in OBIEE like the one in the following links : *http://www.sandeepvenu.com/2013/11/google-organization-chart-in-obiee-11g.html *https://www.primefaces.org/showcase/ui/data/organigram.xhtml If yes, could you please share the steps to do or any known docs? Thanks in advance!
-
OBIEE 11.1.1.7.141014 generate huge sql-query
Hi Team, Customer has reported that his OBIEE report is generating huge SQL for which he is facing performance issues both in OBIEE and in Database. Later on he has informed that he changed his report column filter formula which has resolved the issue as of now. But is not satisfied with the OBIEE behavior and is keeping…
-
Duration To Hourly Buckets
Hello Everyone, We have the below requirement of bucketing the duration into hourly buckets. SHOP_CODEPUNCH_IN_TIMEPUNCH_OUT_TIME11114/17/2017 12:004/17/2017 12:0011114/25/2017 12:004/25/2017 12:00111211/19/2016 9:0011/19/2016 13:25111211/19/2016 14:1011/19/2016 17:4011134/10/2017 9:004/10/2017 14:0011134/17/2017…
-
I have an data issue when useing custom Level-based Hierarchies
ear Members, There is no data issue when I run the report without custom Level-based Hierarchies. But after adding custom level-based hierarchies to dimension , the data shown wrong data as below screenshot . What could be the reasons for this issue? Regards, Ali Mostafa
-
Historical overview
Summary Historical overview Content I have a table similar to the one below. I would like to show progress overtime. For example, has the number of customers increased or decreased? same for ARR. Any idea how to do it? I like the use of colored arrows to show progress (see below), but a chart is also an option. I am quite…
-
BIP reports and internationalization
Summary BIP reports and internationalization Content What is the recommended way to pass on the locale when running reports using RESTful services? I could not find any examples on how to pass on a locale in the POST message to run a report.
-
BIP 10g : Scheduled Jobs does not execute
Summary BIP 10g : Scheduled Jobs does not execute Content Good Day, Jobs scheduled in Oracle BI Publisher 10g remain in scheduled state. The job is scheduled to run once immediately and deliver to an FTP location. The FTP location is accessible and files can be transferred to it manually. The following steps were performed…
-
Auto-Merge Identical Cells using RTF Template
Summary Auto-Merge Identical Cells using RTF Template Content
-
In BI Publisher report's output excel columns are shrinked
Summary In BI Publisher report's output excel columns are shrinked Content after submitting concurrent request of a BI publisher report for Excel output format the columns in report are appeared in shrink format i.e. column's width is too narrow to see the full column name and have to do it manually, Any advice how to…
-
Multiple Installations of OBIEE - 11g and 12c on same Unix Servers?
Hi - Have a customer looking at a "fresh" or "out-of-place" upgrade, from 11g to OBIEE 12c. Thinking we can have both 11g and 12c in the same bare-metal servers as transition ... During my search, I saw this statement - "... you can have multiple installations of OBIEE running on the same server, but they need to be…
-
OBIEE 12c configuration
Hi, While installing obiee122120, I have come across two locations where the config.cmd present. Location1: <OBIEE_HOME>/bi/bin Location2: <OBIEE_HOME>/oracle_common/common/bin What is the difference between them? I din't find any details in Oracle regarding Location2. Can anyone please suggest.. Thanks, Anilesh
-
OBIEE 12c : Agents page is loading forever when trying to edit
Hi , we have migrated to Oracle Business Intelligence 12.2.1.2.0, all the agents moved as part of migration. Once we gave access under Manage Privalages tab. User are able to enable & run their agents. But a strange behavior is when we try to edit a Agent it taken forever to load. But this is not reported by all the users,…
-
MyAccount-Preferences-Starting Page not loading for users in obiee 12c post migration
We have many users who have customized starting page/landing page in previous obiee server. We migrated everything to obiee 12c current version. But user are seeing default page instead of their landing page. My Account->Preferences-> Starting Page: Default ( This is not default in 11g) Previous version: Oracle Business…
-
Remove full drill path from chart label
We have a dashboard that shows a pivot table and a chart that has a drill for a location. The top level of the hierarchy is the region (i.e. Asia/Europe etc) and we can then drill down through various levels down to a city and then a building. The customer is not keen on how in the charts when you drill it shows the full…
-
It takes too much time when run calculate form with yeartotal
Calculate form is running on save, it takes approx. 10 minutes to run. While it takes only seconds when I run it on the same form but with level zero members for period dimension. any help ?! Is the problem in the yeartotal member and the quarters. Note: Period dimension is a dense dimension.
-
Presentation Variable in Column Formula
Hi All. I have this requirement to show multiple values of presentation variable in separate rows in a table or pivot. For example, if I select three department names from dashboard prompt, the table/pivot will populate three rows representing a department. The column I am trying to populate is not modeled, it's…
-
BIP installation
Summary BIP installation Content Hello everyone, BIP newbie question: I have ADF application, weblogic domain, etc... I now want to embed bip reports into ADF like : http://www.oracle.com/technetwork/middleware/bi-publisher/oracle-bip-adf-integration-2549495.pdf To install BIP is it mandatory to install the full OBIEE…
-
Lower level granularity selection jumps to second view on the Analysis.
Hi, I am using SampleApp V607 which has OBIEE 12.2.1.1.0. I have a dashboard page which has a couple of prompts and one Analysis. Time prompt accepts four levels - Year (Default), Half Year, Quarter and Month. Product prompt accepts four levels - Brand (Default), LOB, Type and Product. Based on the selection, the Analysis…
-
OBIEE vs OBISA
Hello Can anyone tell me the difference between "Oracle Business Intelligence Server Enterprise Edition" and "Oracle Business Intelligence Server Administrator" I would also like to know the product that includes OBIA modules such as Financial Analytics. Does "Oracle Business Intelligence Server Administrator" includes BI…
-
OBIEE 12c - Enterprise Manager Application Role - Adding member Name and Display name mismatch?
This is a bit out there, and I tried to search but couldnt find anything. Before creating a service ticket I was hoping to see if anyone else has seen this issue. I just installed OBIEE 12c and went into Enterprise Manager -> Application Roles -> Edit Here I click on [Add] I select the user [rosem] with display name…
-
BI Publisher reports with Excel Data Set
Dear All, I have created data set with excel source.Report is working fine but I am not able spool report with parameters . Expression is getting valid successful but the same not working in report level. I have tried like G1.MTH_NAME (: Month_Name) but it is giving error. Thanks in advance,
