-
JDBC connection to SQL Server
Summary JDBC connection to SQL Server Content Hi, I'm using XML Publisher 12.2.1.2 and trying to establish a JDBC connection to SQL Server 2012. But, I keep on getting errors and couldn't figure out how to do it. See below for error message. The account works fine because I could connect using ODBC and SQL Server…
-
File Size after Dataflow Merge or Aggregation
Summary File Size after Dataflow Merge or Aggregation Content I have been testing some data with both the MERGE functionality (union all option) and also a simple aggregation of all columns by 1 agg field. In each test case, the new dataset file size was exponentially larger than the original dataset - 80MB to 200MB as an…
-
Data model cannot be executed because of an error
Summary Data model cannot be executed because of an error Content Hi, My Data Model fails from time to time and sometimes it does work without any apparent changes. When I open the Data model I get this error before the parameters loads "Data model cannot be executed because of an error". I attached the message logs and…
-
DXE compiler error. No table 'row' found in DXE.
Hi all, I am using obiee 11.1.1.7.150120 When I run the report It throws below error. Error Codes: YV3KVTDM Location: saw.hypercube.dxeApi, saw.views.dashboard, saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver,…
-
Prompt variable in new analysis (Simple SQL_Statement)
Hi, I have problem when I create new analysis with Simple SQL Statement. SELECT "Nombre de situations", "Nom", "ID_DOSSIER", "Prénom", "Adresse", "Date naissance", "1er rdv", "Date entrée CER", "Date fin CER", "Nombre de mois couverts", "Nb d'entretien en face à face", "Nb d'heures d'accompagnement (accueil, entretiens…
-
Using abbreviations for axis labels
Hello, I am preparing a bar graph showing performance across different master's programs. The program names are quite long and hence I would like to use their abbreviations as labels. The data table doesn't have a column for abbreviated names. Is their a way to use abbreviations as axis labels? I am using 12c version.…
-
Merging templates in BI Publisher based on condition
Summary Merging templates in BI Publisher based on condition Content Hi, I was unable to find any documentation or examples for merging reports in BI Publisher. I am wondering if it's possible to merge two or more .rtf templates in BI Publisher based on a condition, for eksempel if in Document 1, parameter "Merge" is YES…
-
Send XSL BI select list distribution for OP
Summary Send XSL BI select list distribution for OP Content Good Morning, I want to send an excel through a distribution list that I get from a OP. I found this document https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=269045951942383&id=1080837.1&_afrWindowMode=0&_adf.ctrl-… but does not explain how to send…
-
OBIEE12c - Reports downloading issue in PDF format
Hi Guru's, There is a requirement in my current project where many OBIEE12c reports having more than 30+ fields. They want to display only few fields on analytics screen out of 30+ fields, but they need all 30+ fields in the report while downloading into PDF format. They need all these 30+ fields should be place in…
-
OBIEE agents to multiple recipients are failing with the below error
When i schedule an agent and add recipients more than one, agent sent mail to one random recipient and fail to deliver the same to rest. Below is the error message. Working in OAC environment, Version : Oracle Business Intelligence 12.2.4.0.0 I have tried both the option by adding mail ID's and by adding Users in the…
-
Catalog Archive
Hi, OBIEE 12.2.1.0.0 I have a requirement to archive old unused OBIEE Analysis from Catalog and need to do this periodically. I am thinking around preparing some Linux scripts (something like Tar with Remove files option) along with runcat utility. What would be the best approach for this? do I need to take any extra…
-
RTF - Chart - How to add elements labels and spacing between graph lines
Summary RTF - Chart - How to add elements labels and spacing between graph lines Content Hi, I created an RTF template and added a chart. How do we add the elements labels beside each graph line. In other words, if the first line graph represent the Value 1 as an amount on the x axis, how do we display the element name…
-
Unable to find details of Report Job run using Web Service
Summary Unable to find details of Report Job run using Web Service Content Hi Team, I am facing an issue with the following: When I'm running the report using BI application (see the Screen_Shots.docx), I'm able to find the reference of the job in the following tables: 1. FUSION_ORA_ESS.REQUEST_HISTORY 2.…
-
Issue in Subtemplate Path of BI Publisher report
Summary Issue in Subtemplate Path of BI Publisher report Content Hi Team, I have a BI/XML publisher concurrent program which has data template(.xml) file and RTF template(Main template). The output type is PDF. Now I am trying to attach Subtemplate to Main template. My subtemplate has CommonHeader and CommonFooter as shown…
-
LDAP connection for authentication
Hello Experts, I am trying to connect to connect to do the LDAP authentication for new environment. Environment - OBI12c Cluster - NO EM roles - Imported via .bar file Created a new provider and done the same configuration similar to dev, but whenever I am trying to save and connect, its through me an error:-…
-
BI Publisher 12c - left outer joins
Summary BI Publisher 12c - left outer joins Content Hi, Does anyone know if it's possible to create LEFT OUTER JOINS in BI Publisher data models using multiple data sources? I have sources from Oracle and SQL Server, but the data from Oracle isn't always available. I'd still want to return everything from SQL Server side.…
-
Google Chrome unable to open action links
We have a rather large report on a page (100 rows). We have an action link which opens a new page with a set of graphs corresponding to to time period, geographic location and 3 metrics. When I click the action link in Chrome, nothing happens. No error message, no system change. It's as if you click on an inert part of the…
-
Catalog Backup to another server?
We are trying to copy the catalog for the OBIEE 11g from the production to a dev environment; Does anyone suggest any recommended method? We want to make sure the security structure stays intact. Linux copy process seems to be working. However, when I try to replace existing users it's failing. Also, Oracle don't recommend…
-
Dashboard sometimes loads in ODBC error state
Hi everyone, So i've been dealing with a very strange phenomenon with our dashboards. We are on 11.1.1.7.150120 and hitting a sql server db, heres our setup: We have a dashboard that is automatically triggered by agents which send out via email to run at 4:30am daily. Sometimes theres no issues but sometimes the email…
-
Unable to provide source connection details in BIAPPS 11.1.1.10.2
Hi i am facing difficulty in connecting bi apps to EBS instance. Facing above error. Can any one help me.
-
OBIEE Logical Query and Physical Query bug or not?
Hi Everyone Can you help me I take out Query log on BIEE 12.2.1.2 but i get somethin wrong about query on database, First on logical Query BIEE filter about Date is available beside other filter, but when on Physcal Query on Database filter about date is missing beside other filter. It's Normal or not? Thanks Dje
-
Force prompt input to Uppercase in OBIEE 12c
Hi All, Is there a way in obiee on how to force prompt input values to be always in Uppercase and do a equals to search when it gets passed to report. Thanks, Swathi
-
Report is failing intermittently.
Problem Summary --------------------------------------------------- Report is failing intermittently. Problem Description --------------------------------------------------- Report is giving display error in irregular intervals. It is working for sometime without any issue and failing all of sudden after some time.The…
-
Assign Value to an Element in BI Publisher
Summary Assign Value to an Element in BI Publisher Content I am new in using BI Publisher and I am wondering how to assign a value to an element of BI Publisher Data Model if it's null. For example in my .rtf template I have <?AMOUNT?> which is a variable. If it's null in the database, I would like to define a default…
-
How to create a string formula in BI Publisher from joined Data Sets
Summary How to create a string formula in BI Publisher from joined Data Sets Content In BI Publisher I have a Data Model with Data Sets from different systems (Oracle & Sybase) that are joined via elements. Is there a way within BI Publisher to create a formula that includes elements from both datasets? I want to check if…
-
Converting Crystal Rpt with subreport to BI Publisher. 2 separate PS query data sources in 1 report?
Summary Converting Crystal Rpt with subreport to BI Publisher. 2 separate PS query data sources in 1 report? Content Hi All, I'm not sure if this is more of a peoplesoft question or a BI Publisher question.. I apologize if this is not the correct forum... I'm confused about how the BI Publisher sub templates work within…
-
segoe ui symbol fonts will not display in pdf
Summary segoe ui symbol fonts will not display in pdf Content I can add font to form but I can not preview it as a pdf. Can anyone tell me what to do or to look for?
-
INSTR in IF Condition or Conditional Row display with INSTR in XML Publisher
Summary INSTR in IF Condition or Conditional Row display with INSTR in XML Publisher Content Hi, I have below requirement. The report picks data based on specific date criteria on Due date, which categorizes the Order Status as "Past Due", "Today", "Today+1" .. Today + 9 For example based on data consider the variable…
-
BI Publisher Configure Report Definition to Print if no Email is found
Summary BI Publisher Configure Report Definition to Print if no Email is found Content Hi all, I apologize if this is not the correct thread - first post. I am looking for some information regarding BI Publisher delivery behavior. I have currently configured a BI Publisher Report Definition to burst & email the output…
-
Access Database Connection (ODBC) & OData
Summary Access Database Connection (ODBC) & OData Content Hello- I'm new to the Data Visualizer forum. I was hoping someone may be able to steer me in the correct direction. I would like to connect to two different data sources and I am having some trouble. 1. Sharepoint List - I need to connect to a Sharepoint List. 2. I…
