-
General Error when using Analysis as a data source in Data Visualization
Summary General Error when using Analysis as a data source in Data Visualization Content Hello, I am a newbie to data visualizer and only a developer so I don't work to much on the backend. I am trying to help resolve an issue I am having with my Contract support. I am work with Data Visualizer and I can create a…
-
Downloading File as CSV losing its headings
Summary Downloading File as CSV losing its headings Content I am looking at machine learning and combining confusion matrix's from a few models in the same project. I am opening the confusion matrix for each (which opens in a new project) and then downloading the file which is in CSV format. Is there a way that I can keep…
-
Not showing all files in shared option in the datamodel file selection
Summary Not showing all files in shared option in the datamodel file selection Content Hi Gurus, i have placed my excel file in demo source name in BI publisher, when i am trying to access that file with shared option. It is not showing my excel file. Its only displaying all xml files. but local is working for me but in…
-
Error when executing the BIP report
Summary Error when executing the BIP report Content Hi All, I have created a BIP report with RTF template, which works fine most of the time but suddenly stops working with the below error: Checked the log but it contains the same Warning with not much details. Any pointers to why and when we get this error? The template…
-
12c Direct SQL Query from Multiple Sources
Hello Everyone. I know how to create direct sql query type analyses. You first specify your connection pool and then write down your sql. What about a direct sql query that's built on multiple databases? Sort of "Cross-Database Queries" as specified in this-…
-
Using one agent to trigger another to start, not to run?
Hi, I have a need of running a bunch of agents that are supposed to send a report if the condition is met. The problem is that the analysis with the condition sometimes doesn't get updated in the morning because the server had down time. So I want to make sure that the agents run again later in the day if the condition is…
-
Microsoft Active Directory Integration issue with OBIEE12c on Secure Port (Port# 636)
Hi Guru's, I have a requirement in y project to configure microsoft active derectory with OBIEE12c for the user authentication. So, All the AD users should be able to login OBIEE analytics page. Existing microsoft active directory using port 636 ( SSL). I am getting following error after saving details under Domain…
-
OBIEE12c Clustering on two exalytics VMs
Hi Gurus, In our current project, we have received one exalytic physical server with two VM's. How best we can utilize this setup to implement OBIEE12c clustering? Can we perform horizental clustering of OBIEE12c based on this setup. If not, how to achieve high availibility based on this setup. Your early reponse would be…
-
DB upgrade for OBIEE
Hi, We are upgrading the database from oracle 11g to 12c for OBIEE12c and ODI 12c. we have mapviewer in obiee as well In order to test the connectivity of the new database, where are the changes to be done. i appreciate what are the files to be taken as backup before the database moving. Thanks,
-
Custom Print and Export Layouts
Hello, In the 'Edit Dashboard', 'Print and Export' options, you can do a "Create a Layout". When I do that with my dashboard page it redirects me to BI Publisher. I have experience creating a BIP report from scratch using XML templates and Word templates, etc. But I do not have experience with the format I'm redirected to.…
-
Oracle business intelligence standard edition Virtual machine
Hello experts, Can i download oracle business intelligence standard edition one pre installed in a virtual machine? similar like sampleapp vm in oracle linux
-
BI Publisher 11G and 12C, report creation is very slow however xml file creation is quick
Summary BI Publisher 11G and 12C, report creation is very slow however xml file creation is quick Content Hi all, I'm experiencing an issue with BI Publisher where it has degraded in report creation performance over time for seemingly no good reason. The query and the xml file is loaded very quickly however the actual…
-
Not able to open pivot table view
Hello expert I have developed an analysis in analytics portal. When i am trying to open Pivot table view, it is giving me following error. What could be reason for this? I am using OBIEE 11g in virtual machine for learning purpose. I checked, al the services are running. There was a problem retrieving the response data:…
-
Server error when using CASE WHEN
Hi all, We are currently using OBIEE 11.1.1.7.171017 and have just started to notice a strange issue when trying to use the CASE WHEN formula inside analysis formulas, prompt SQL and BIP data models. The error returned is as follows: We also get the following error message in Chrome Tools: Failed to load resource: the…
-
Time series functions
Hi all, I've a curious behaviour on time series functions. I'm working on 12c (12.2.1.2.0) version. My fact table is at day grain, my time hierarchy is correctly set up (chron K are present). Trying to build a simple report MONTH | REVENUE | AGO (REVENUE,MONTH,1) For some months the ago function is not working properly.…
-
Count multilplies by 3
Hi I am using OBIEE 12 c and I have a following isssue. I have one formula columnn that says Count(my_column) and in the analysis it gives me the values that are multiplied by 3. If the real count is 9 i have 27 and so on... Does anyone know what could be the problem?? Best regards, Matija
-
Oracle DVD 4.0 - Data Action on Image
Summary Oracle DVD 4.0 - Data Action on Image Content Hello Everyone, I am working on an assignment with my customer where in the requirement is to establish guided Navigation from Image. I am aware that we have "Data Action" in Oracle DVD 4.0 Will Data action work on Images in Oracle DVD ? ( Either b/w canvas or projects…
-
Oracle DVD - "Filter Using " - Is this function working properly ?
Summary Oracle DVD - "Filter Using " - Is this function working properly ? Content Hi, I am trying to use "FILTER(Measure USING Attribute condition) in Oracle DVD. But its not showing me filtered value. Instead it shows me total measure value only. May I request you to kindly help or advise me on this please. Thanks,…
-
Publish Reports on DV Desktop
Summary Publish Reports on DV Desktop Content Hello,... Im new self learner for Oracle Data visualization tool for desktop and I end my first report I found a Share which share with 3 ways... Email, File or Cloud... I also have a Weblogic Server is there a way to upload an extracted file to with .dva to the weblogic server…
-
Cannot import sample ML projects from Oracle Analytics Library to OAC
Summary Cannot import sample ML projects from Oracle Analytics Library to OAC Content I've tried to import the three different machine learning sample projects from the Oracle Analytics Library (attrition, numeric, heart disease) but they fail with the same error: It looks like we did something wrong. Please try again, but…
-
Change default WCC content type in BIP
Summary Change default WCC content type in BIP Content Hello Experts, We are using BIP (11.1.1.9.0) and WCC (11.1.1.6.0) in our business solution to store reports/invoices. In WCC, we have custom data type i.e Invoice for all invoice related documents which is triggering invoice profile and rule. Post BIP-WCC integration,…
-
Oracle DVD - Any Performance Tune options ?
Summary Oracle DVD - Any Performance Tune options ? Content Hi Everyone, Oracle DVD on my machine is facing a severe performance impact. RAM : 8 GB Total Data Sets : 12 Total Projects : 8 Total Data Flows :2 I cant able to work continuously more than 30 minutes. The Product become very slow to handle ( I am having 5 to 8…
-
Break line create another row in Excel output.
Summary Break line create another row in Excel output. Content Hi guys. I have a excel problem... I have a report, which source is a varchar field. So, many people writes with jumps. And same text in report output don't shows break line. ok, i can live with that. But when i export to excel file, add a new row-cell.…
-
Odd behavior on OBIEE subtotals
I have this column on an analysis. The underlying formula being used is CASE WHEN ."Value1" >0 THEN "Value1" ELSE "Value2" END Basically I have two numeric columns for each record. I want to report whichever one is greater than 0. The detail of the report is correct. I have three lines with these values; 2, 5, 2. The first…
-
OBIEE 12.2.1 Mapviewer
Hello, We have moved the whole OBIEE database, which not only includes repository tables but catalog etc. After moving the OBIEE to different database, OBIEE and Mapviewer stopped working, I was able to fix OBIEE as only the connection to the new database had to be made in the Administration too and some EM changes. But…
-
OBIEE 12C RPD Warning 39099
Hello, We are upgrading from 11g to 12C . In 12C admin tool i am getting warning (Error No - 39099) but not in 11g This is my logical Dimension Can anyone let me know what will be workaround to display both keys when Drilling Down??
-
Automatically embedding javascript code in each dashboard
Hi, We have a javascript code that we'd like to include in every dashboard page of our OBIEE environment. Currently we are doing this by manually embedding it in every dashboard of the server, but it's going to become messy when external developers also have to incorporate their own dashboards. * Is there a way to include…
-
XDODTEXE - Concurrent request is slow
Summary XDODTEXE - Concurrent request is slow Content Hi, I have a concurrent program using XDODTEXE to process one of the data templates. It worked just fine but is slow to start processing the template. (around 14 minutes) . After this the concurrent is fast. Extract from the log... Please note that the Current system…
-
BI Publisher Excel Template Issue
Summary BI Publisher Excel Template Issue Content Hey, I want to fetch run time user values from excel fields and use that field's value in calculation so that when user will enter the value in these columns then calculation will automatically done based upon user values and will display the result.Can you please tell me…
-
BI Publisher shows zero when is null
Summary BI Publisher shows zero when is null Content Hello, I have a report in bi publisher (layout builder not RTF) with a pivot table, when i run the report publisher sets as zero when the data does not exists. Send a image with the example. How can i change it ?? Thanks a lot.
