-
Time Hierarchy
Summary Time Hierarchy Content Can we have Time Hierarchy in Oracle DVD version 12.2.5.0
-
OAC Client Tool Versions
Summary Is there a new version numbering scheme for OAC Client tools? Content The link for OAC client tools shows the current version numbers. Last week, there was a 19.1.1 version. Is there a new numbering scheme? https://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html Developer Client Tool…
-
Duplicate schema created in the RPD on OBIEE Version 12.2.1.4.0
Hi Team, While i am importing tables or columns in Physical layer, Duplicate schema got created in the RPD. Please find the below screenshot, Here i am imported table ABC_CLASS_TMP in physical layer and it's generated under duplicated schema ADW12_XX. the table should imported in the existing schema(ADW12_XX) and it under…
-
Filter By checkbox disappears
Hi, I'm new to OBIEE. We're on 12c. I have a time hierarchy which has two levels. First, is called year with the year and year description. Second is detail with code and code long description. Code long description is set to code for sort order column and descriptor id column. When I go to do an analysis and I select to…
-
OBIEE - Change permissions to file system folders created on BI catalog
We observed that each time we create a folder on the OBIEE Catalog, this is created on the file system (catalog folder) with following permissions drwx------ However our customer has developed some scripts that need to have the “read” permissions to folders for groups too. Do you know any way to change this behavior to…
-
Anti virus installation with OBIEE in on premise version
Using data visualization in OBIEE, an user can upload a file to do his own analysis. In our system we want to integrate an antivirus in such a way that when an user is trying to upload a file, before saving it to server file system, we want to scan it. If the file is infected or quarantine, bi server will respond…
-
AVG with DISTINCT on other column
Hi, I am using OBIEE 12C. I'm trying to accomplish the following scenario: I have an orders table & order status table, they are connected with order_id. In orders tables I have a COST column which I want to calculate its average. Example (tables): ORDERS ORDER_IDCOST110220 ORDER_STATUS FK_ORDER_ID STATUS…
-
OBIEE Grand Totals not Formmatting Correctly
I have an analysis that includes several detail lines, along with a subtotal and a grand total. The amount fields in the detail are properly formatted to include a currency symbol ($) and commas. The subtotal also has the correct format. However, the grand total does not have the same format. There is no currency symbol…
-
Oracle Data Visualization Cloud service stuck in Initialized state
Summary need assistance bringing this service online Content Not sure if this is the correct forum. I have created data visualization trial service which is stuck in initialized state: docs (Data Visualization) Subscription: Trial (Initialized) Region: US Commercial 2 Identity Domain: cecqa I'm an oracle employee so…
-
Obiee analysis row count
Hi All, In OBIEE is there a way where I can show the total row count after running the analysis. . Thanks.
-
use dynamic table column to perform an operation and generate a new calculation
I need to make a division between the data of 2 columns in a dynamic table, that is, the column CUP_VALUES with respect to years 17 and 18 is 16 and 23, we need to divide ((23/16) -1) * 100), Can this be done with a calmed metric with a dynamic table? and if it can be like? Versión del Producto Oracle Business Intelligence…
-
New Version of DV Desktop Available
Content 12.2.5.1 of DV Desktop is now available for download. It installed smoothly for me. https://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html Mark
-
What other application/system databases are you joining using OAAC?
Summary What other application/system databases are you joining using OAAC? Content Besides Oracle Cloud products, what other application databases do you have experience in joining into OAAC? I am particularly interested in Financial systems.
-
Usage tracking data updation
Hi All, Please let us know what type of data is inserted in usage tracking, below is what i have observed as of now... Clicking on dashboard tab will be a hit on each report present in Dashboard page Refresh browser will not consider as hit as refresh will display the results based on what displayed already Report opened…
-
DxD will miss recognize Non-English voice search as English after upgrade iphone to iOS12
Summary DxD will miss recognize None-English voice search as English after upgrade iphone to iOS12 Content In iOS 11, DxD can recognize voice search as phone language setting. but after upgrade to iOS12, even change the phone language setting into None-English, such as Chinese, DxD voice search will also think the voice is…
-
How to migrate an Agent-only 12c instance using BAR file
This concerns 12.2.1.4.0 on Oracle Linux Server 6.9. We have an instance which is dedicated to running agents. There are nearly one thousand running agents on this instance, with non-trivial integration into other parts of our infrastructure. Our problem is that we do not seem to have a painless way to migrate this…
-
Prompt Value change automatically changin on other prompt value of same nature
Hi All I have 4 tab pages on my dashboard, when I change value of prompt from one page then it automatically change the value of prompt on other page. Prompt is based on same dimension/ field. I want to get rid of this issue, please guide Fig.1, at start Year value is 2019 Fig.2, Value of Slider is 2019 Fig.3, I have…
-
OBIEE 11.1.1.7 security migration to OAC
Summary OBIEE to OAC Security Migration Content Hi, how to migrate security from OBIEE 11.1.1.7 to OAC specifically below parts Identity Store Policy Store Credential Store Key Store weblogic's SAML SSO BI Publisher Roles Can someone help with steps for these Regards, Paresh
-
Data missing in random columns after in-place upgrade to 12.2.1.4.0
Note: this is a follow-up to this older discussion:Data missing in random columns in Analyses (12c 12.2.1.2) , intended to document a new bug with the 12.2.1.2 - 12.2.1.4 in-place upgrade. We had a bug back in 2017 regarding data missing randomly from analyses after upgrading from 11g to 12.2.1.2. See the discussion above…
-
Patch/upgrade OBIEE using OPatch
We are using Oracle Business Intelligence Product Version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit). We would like to patch/upgrade to the latest version using OPatch tool. What will be the best way to do this? Is it enough to download bundle patch for 12.2.1.2.0 and apply it using OPatch, or should we download all of…
-
Analysis should be blank without prompt values
Hi All I have a requirement to show blank analysis until someone select the values from prompt, my analysis is working fine when I select some values from prompt but at start when I open my dashboard, analysis show all the data (Fig.1). However when I select some prompt value then it filter as per prompt value (Fig.2).…
-
[nQSError: 26014] Near '.': Qualified names shouldn't have a space between names.
Hi, I am getting error while making joins in between tables in the Rpd.Can anyone help to resolve this. Regards Manjupriya N
-
OEM13c BIP - Database Performance Report - ADDM 30 Days
Summary How to change default 24hr sql query in dataset for addm Content I'm using OEM13c and integrated BIP and trying to modify the ADDM report section in the Database Performance Report to generate an ADDM report for the last 30 days, or anything other than the default 24hrs. I've tried other gc$metric variables but…
-
Modifying Database Location
We are in the process of migrating our databases so the names and location will change. Is there a way to modify this in OBIEE 12.2.1.3.0?
-
OAC - Usage tracking
Content Hi Everyone Is it possible to implement "usage tracking" in customer managed OAC. I have tried to follow similar steps like on-prem 12c but it did not work. As soon as I set NQSConfig.INI with Usage tracking option "yes", BI presentation server gets locked. Thanks for help. A
-
where to download OBIEEContentExportApp.ear
Im trying to export OBIEE 12 dashboard to shared drive though agent and would like to install OBIEEContentExportApp.ear but cant find anywhere where can I get this ear file for download. please help where can I get this ?? please advise Archi?ve/Export OBIEE 11g content to Shared drive by creating Agents and Invoking Java…
-
Can .csv files be used as source to OBIEE RPD and Reports?
I am trying to import the CSV file trough the OBIEE RPD and use this as source for Reporting, Instead of going via database. How can I do this in 12C. Also with any updates in files should also be auto update in obiee reports. If anyone has done this, pls help. regards, Abinash
-
Data Model throwing Error as 'Failed to Load XML' while viewing sample data.
Hi All, Data Model throwing Error as 'Failed to Load XML' while viewing sample data in BI Publisher. any reason behind this? Regards, Abinash
-
BIP is very slow when developing Data Model / Report
Hi All, We are using OBIEE 12.2.1.3.0 version on VMware, when we work on RPD, analysis, dashboards it is working fine but when we develop data model/ BIP report on same product then it is very slow, it has been observed that CPU resources usage is normal. Please guide
-
Removing/Disabling unwanted options from Export functionality in OBIEE12c
Dear Guru's, We are using the OBIEE12c for the our client. We have proper Development, UAT and Production environment on exalytics machine where OBIEE12c is hosted. Client is very much strict to provide only four export options like, PDF, PPT, XLS & CSV. Apart from these four they wanted to remove/hide other options like…
