-
Filter Controls icon - missing in DVD 12.2.3.0.0-20170621001724
I have a running copy of Data Visualization Desktop, version 12.2.2.2.0, as shown in the screenshot below. Notice the presence of the Filter Control icon (circled). That icon is missing in my installation of DVD 12.2.3.0.0-20170621001724. Is this a known issue?
-
Custom Calculation in Pivot table
Codesumalternate Sumxyz 514(Sum (abc+pqr))abc811(Sum(xyz+pqr)pqr613(Sum(xyz+abc)) Hello Friends, I have a pivot table like above. Now I need to calculate the Alternate Sum for the above table in the following way for the Code xyz Alternate Sum = Sum(abc+pqr+.....) for the code abc Alternate Sum=Sum(xyz+pqr+.....) for the…
-
After upgrade to OBIEE12c : [nQSError: 46168] Operation RawFile::checkSoftLimit failed, it'll exceed
Hi, We get the following error in a dashboard after having upgraded from 11g to 12c. We haven't changed anything in config file like instanceconfig.xml, NQSconfig, ... Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error…
-
Connecting oracle data visualization desktop to apex.oraclecorp.com
Summary Connecting oracle data visualization desktop to apex.oraclecorp.com Content Hi, I have an application with some data hosted on apex.oraclecorp.com Can I connect data visualization desktop to apex application hosted on apex.oraclecorp.com? If yes, how?
-
All Column Values in BI Publisher
Summary All Column Values in BI Publisher Content Hi All, I am OBIEE 11.1.1.9. I am trying to embed a BI Publisher report on APCC Dashboard. I am trying to use OBIEE Prompt to pass the values to BI Publisher report. It works fine if I am passing single value or multiple values, but it doesn't work for 'All Column Values'…
-
Data Grouped For Each Product
Summary Data Grouped For Each Product Content Hello, I am using XML Publisher (RTF) report, MS Word BI Publisher plugin I would like to have the output as shown in the enclosed screen shot, but I am not sure how to put for-each when I put for-each at the top, Product Number is getting repeated for all the details.…
-
BIP Reports Metadata
Summary BIP Reports Metadata Content Hey, Is there a way to extract the metadata information from BIP reports. 1. We are using OBIEE 12c - 12.2.1.2.0 2. DB is Oracle 12c 3. We require the column names to be precise. Any other information extract is great too 4. We need to be able to extract all column names. this is for a…
-
OBIEE 12g - No option to change the orientation of Pivot Tables with sections from row to column
The now archived discussion (started way back on 10g in 2010 --- https://community.oracle.com/message/12506211#12506211) provided a solution to change default section orientation from row to column. Still no option exists today in 12g (as for as I can tell). Here's an updated solution based on the original solution that…
-
Modelling customer and a fact
Hello All, We have a customer table and Loans fact table customer table custid custname country Loans custID ParentID GroupID loanamount. Currently we have created 3 alias table for customer and joined with loans on the keys in loan table customer.ID = Loans.custID groupCustomer.ID=Loans.ParentID…
-
OBIEE 11g: Configuration Assistant Fails to Run with Error: "Exception in thread "AWT-EventQueue-0"
Summary OBIEE 11g: Configuration Assistant Fails to Run with Error: "Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException: Invalid value specified: null" (Doc ID 1664854.1) Content i found the below error while running configuration assistant while updating BI domain. When attempting to run the…
-
DVD Certification Matrix
Summary DVD Certification Matrix Content Where is the certification matrix for DVD? I need to know certified data sources and its version.
-
Obiee12 csv file export issues with caching
In our production enviorment, we have problems when exporting csv-files. If the analysis is updated(refreshed) alle the correct data is shown on the screen in the analysis, but when we export the data to csv, it shows old data/not refreshed data. Is there any solution that will help us to always showing refreshed/updated…
-
How to navigate to child report based on value in parent report.
Hi all, I have requirement to drill to another report (which is in Subject Area B) from Parent report (Which is made of Subject Area A). The below report data build on Subject Area A. As when i click on Agreed Spend amount then it has to take to the below report (Built on Subject Area B) . It has to show only one record…
-
OR condition with Date Parameter in OBIEE
Hi, I have a requirement to bring records where ship date is NULL along the date range parameter passed in OBIEE 11g Analysis. Trying to put two filters with OR (e.g. SHIP DATE is NULL OR SHIP DATE is prompted) this is bringing only records where date is populated not those where Date is NULL Thanks in advance, Regards,…
-
When REPORT AGGREGATE Works And How To Disable
Hello, I building a report with counting customer IDs. I have a column formula like "COUNT(CASE WHEN "DIM_DATE"."AS_OF_DATE" = DATE'2017-08-24' THEN "DIM_CUSTOMER"."CUSTOMER_ID" END)". While usually OBI aggregates the report on DB level with a group by but in this particular report OBI chooses to aggregate on report level.…
-
how to build dynamic week/month relationship in time dimension/hierarchy
I have a requirement in which a dynamic calendar is needed. For example, 2012week 5 belongs to month 2 for current year report (report month sales in year 2012), but the same 2012week 5 will belong to month 1 in the last year metric (report month sales in year 2013). This is because 2012 has 53 weeks and it has to be…
-
Link to the catalog in mobile app
Hi everyone! Is it possible to make a link in the dashboard that would lead to the "Catalog" section in the mobile application. i`m using oracle bi 12.
-
OBI Administration Tool 12.2.1.2 online mode import metadata nQSError 17002
I installed OBIEE 12.2.1.2 and migrated my catalog and the repository from 11.1.1.7 to the 12c. Everything runs fine except when I was trying to import metadata to the RPD in online mode. OBIEE Installation: Red Hat Enterprise Linux Server release 6.4 Database Version: Oracle 12c for warehouse, Oracle 12c for…
-
Number of columns in BI Publisher
Summary Number of columns in BI Publisher Content Hello, We are trying to migrate a 79 columns SSRS report to BI Publisher, I had a hard time including these 79 columns in one layout in terms of controlling the column width; I divided the report columns among different layouts in the publisher but then there was no way to…
-
ago function does not use sequence number
I provided both absolute and relative sequence number in each level of time hierarchy. However when I run the report, the OBIEE still used rand function to generate the sequence instead of using the sequence that I provided. Did I miss any step? The obiee tutorial did not tell anything about the sequence number.
-
List of Repository Variables
Hello Everyone, Is it possible to create a report in BI analytics to list all the repository variables ? If so Please let me know or shower some ideas on how to get a list of repository variables. Thanks, Ary
-
Urgent: XML Bursting program is running longer
Summary Urgent: XML Bursting program is running longer Content Hi Experts, Need your help to understand why our XML bursting program running longer. i.e >30 minutes This is in production and quick help is really appreciated. We're in Oracle EBS R12.1.3 XML/BI Publisher Version : 5.6.3 I have attached 1. Bursting program…
-
Finding my SQL statement
Summary Finding my SQL statement Content I have created my first visualization in DVD and I want to see what my sql statement looks like. Is this available in DVD and if so can someone point me towards where I would find this information? Thanks!
-
Pertamini Pengertian dan Penjelasan Lengkap
Summary Pertamini Pengertian dan Penjelasan Lengkap Content Pertamini merupakan merek dari para penjual bensin eceran atau BBM (Bahan Bakar Minyak) yang memakai alat pompa manual (Pertamini Digital Elektrik) dengan gelas takaran. Pertamini bukanlah para penjual bensin yang berada di tepi – tepi jalan dengan memakai jirigen…
-
Oracle DVD 12.2.3.0.0 - OBIEE 12.2.1.2.0 - Visual Analyzer - Export Import
Summary Oracle DVD 12.2.3.0.0 - OBIEE 12.2.1.2.0 - Visual Analyzer - Export Import Content Hello, I have OBIEE 12.2.1.2.0 in Oracle Linux 7.3 (Red Hat Enterprise Linux Server release 7.3 (Maipo) ) , I have checked in the OBIEE12.2.1.2.0 certification matrix and this is supported. The installation was clean without any…
-
Can you run an ESS job to run a BI Bursting query to burst to a SFTP server
Summary Can you run an ESS job to run a BI Bursting query to burst to a SFTP server Content I have a very specific issue/question; The customer wants to use the out of the box ESS job 'Print Receivables Transactions' to run the BI report 'Invoice Print Transactions Template'. Included in this BI report is a custom bursting…
-
got Error "Client driver version greater than '2.0.0.0' is required. HSQLDB server version is '2.3.
Summary got Error "Client driver version greater than '2.0.0.0' is required. HSQLDB server version is '2.3.0'" while saving Mongo connection Content When I try to save connection to Mongo there is an error in log: " Aug 24, 2017 5:34:40 PM oracle.bi.datasource.logging.ODLLoggerWrapper error SEVERE:…
-
Oracle BI Admininstration Tool: Variables do not update
Hi guys, we have the problem, that our specified dynamic repository variables within our Oracle BI Administration Tool do not update anymore. The value within the first variable "PriorDateEB" should be "02.07.2017". The variables do not update since last Saturday (01.07.2017). We used to have this problem only a couple of…
-
Mail server configuration in scale out mode OBIEE 11g
Dear all, My name is nee. I am newbies OBIEE admin. Currently i setup cluster OBIEE 11g by using scale out method, and every thing seem to be working fine. But when i try to run the scheduler job to send an email to users, it can be submit but don't know the result and the job history also not showing. whom has experiences…
-
To get week ending dates from week number in obiee report
I have a report which shows calculated data in pivot tables for last four weeks i.e, 30,31, 32, 33 (week number as heading ). I just have week number column in the presentation folder . I do not want to * Make any changes in repository or ETL * Also, I do not want to put CASE statements with 52 statements for 52 weeks as…
