-
How to apply shorting on Water fall report in OBIEE 12 C
Hi Experts, We have report like below: Dim1 measure1 seq union Dim2 measure2 seq union Dim3 measure3 seq where in seq we are giving values like 1,2,3 etc. and shorting working fine on Seq in case of table/pivot view . But in Waterfall view its, shorting automatically on Dim1 values.We tried with result column shorting…
-
Add HAVING clause to reports
Hi, i have developed a simple report in OBIEE and now i would add a HAVING clause. There is a way to add it to the report? Maybe in Advanced tab? Thanks
-
How can we add multiple year hierarchies in OBIEE pivot table?
I have a report requirement as below : Report should have respective Year Hierarchy on the respective measure column as below. Image 1: But when I try to add the Years(2016,2017,2018) as hierarchies, it is showing up as below. All measure columns are getting added under every hierarchy as below. Report should have 2016…
-
All column values - turn off greying out?
We are using OBIEE 12.2.1.2.0 and have been asked a question by one of the users. When you choose "All column values" in a prompt it selects all of the values but greys the options out, so you can't unselect certain ones. The only way to do this is to go into More/Search... and move them all across to the selection window…
-
Federating Essbase & Relational with Parent Child Hierarchy in OBIEE
Does anybody have experience of federating an Essbase and Relational source in OBIEE (currently on 12C but hopefully it's not a version specific thing)? We have an enterprise Essbase cube with a Management Unit dimension 10 generations deep which is ragged and skipped level; in the relational database that we need to…
-
Mongo DB Connection
Summary Mongo DB Connection Content I am unable to connect to a Mongo DB database from the latest version of DVD. Looking at the diagnostic log I see the following error: [nQSError: 16001] ODBC error state: S1000 code: 11008 message: [Oracle DataDirect][ODBC MongoDB driver][MongoDB]Error establishing socket to host and…
-
Connect DVD to get data from Taleo Recruiting OTBI
Summary Connect DVD to get data from Taleo Recruiting OTBI Content Hi all, Has anyone needed to connet Data Visualization Desktop to get data from Taleo Recruiting OTBI? I could connect in Fusion Applications using the URL for example: https://hcmi-test.hcm.us2.oraclecloud.com/analytics But if I try to create a new…
-
DAC 10.1.3.4.1 Supports in Informatica 9.6 or not ?
Summary DAC 10.1.3.4.1 Supports in Informatica 9.6 or not ? Content Here, I need to know about - 1. Informatica 9.6, supports DAC 10.1.3.4.1. or not ? 2. If not supports than which version of DAC supports ? 3. That supported version is downloadable or not and Licences required or not ? Thanks Vivek
-
End of support for Oracle Business Intelligence EE 11.1.1.9.0
Does anybody have an official document about the end of support for Oracle Business Intelligence EE version 11.1.1.9.0 ?? Thanks.
-
Hide Global Header for a specific Dashboard using java scripts in OBIEE 12c
Hi, Is it possible to disable Global Header for a specific Dashboard using java scripts in OBIEE 12c? Regards, DJ
-
Disable Navigation History links at the bottom in OBIEE 12c
Hi, OBIEE 12c has Navigation History links at the bottom left side of the OBIEE page. Upon clicking these links OBIEE takes the users back to the previously accessed page. However is it possible to disable this feature for specific dashboards? I am exposing this dashboard in another application using iframes & go-url and…
-
Saved Customizations
A few weeks ago, I started reviewing Saved Customizations in OBIEE. I even created one successfully and tucked that knowledge away for future use. Today, I noticed I have a "Selections" subfolder in my catalog under my Dashboard. I did not immediately recognize what it was, but after some research, it dawned on my that…
-
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurre
Hi Everyone, Could you please help in finding the solution for the below error. We are getting below error while running report from user machine. The underlying reports are fetching from MS SQL server and the environment is cluster env. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general…
-
Define my Local machine in the Shared folder
Hello All, is there any way to define Define my Local machine in the Shared folder im using OBIEE 12C thanks
-
Report Name as parameter for default pkg
Summary Report Name as parameter for default pkg Content Hello again I´ve been searching for system variables and there is none with the report name (only username and locale settings - https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-2A6E4B9B-ABCD-4CF0-A458-59B89F2443A1.htm#BIPDM221 ) But i would like to send the…
-
Export File - PDF
Summary Export File - PDF Content Hello everyone. I'd like some help if anyone has. Always when a report is downloaded (pdf) through a system, the output file is .jsp (should be .pdf). Apparently it's some permission in OBIEE, would that be it? If yes, where can I give permission for the file to be exported correctly?…
-
XML Publisher - PDF Report - How to Update Metadata
Summary XML Publisher - PDF Report - How to Update Metadata Content Hi , By XML publisher bursting one of the PDF output send by email to the customer. So by modifying the RTF template, i am able to implement the security (Dynamic Password). http://www.quest4apps.com/password-protect-pdf-output/ But I need to Update the…
-
Change Sender email
Summary Change Sender email Content I have created a report using RTF template, i want to send it using an email-ID other then the one configured in Delivery Configuration. How can i achieve it?
-
Oracle BI Publisher 10G/11G/12C , dynamically renaming the output BI Publisher PDF file while saving
Summary Oracle BI Publisher 10G/11G/12C , dynamically renaming the output BI Publisher PDF file while saving it. Content Hello All, I have a requirement to dynamically rename the output PDF files in BI Publisher when saving it based on the logged in user in the BI Publisher report. For example, I have a BI Publisher report…
-
OBIEE 12c Assessibility Mode URL parameter
Hi, We have an application that launches OBIEE using a URL and does a Single Sign in. The calling app sets a value for the &Lang parameter so OBIEE launches in the correct language. Does anyone know if there is a similar parameter (like &Lang) which is used to set the accessibility mode on/off which we can pass in the…
-
Can we refer a value from view selector in OBIEE Analysis filter?
I have four different pivot table views with project details like "Project view", "Summary View", "Year View" and "Realty View" and I am using view selector to select the required view. My requirement is when I select "Realty View" from the view selector, It should only display "Realty" projects, should not display "Not…
-
Create a Logical Column to Sum one column for distinct values in another column
I have a column A, that I want to sum, but since the rows repeat, I only want to sum the values for the distinct values of column B. Said another way - In the table, there may be many rows for a given value of B, but I only want to sum the value in A for distinct values of B. I am certain that the value of A will not be…
-
BI Query not giving same results as Database Query
I have a query in BI that populates the default value on a prompt. Recently it stopped populating the correct value. When we run that same query on the database (we are using Toad), we get the correct answer. Any ideas why the query works fine on the database, but not in BI? Thanks! Dennis
-
Portal Page Navigation
Hi All, Our team is trying to implement the Portal page navigation function as per steps below.. But after executing the steps - not able to see any functions listed on 'Invoke browser script' https://www.rittmanmead.com/blog/2012/07/navigating-to-bi-content-in-obiee11g-and-passing-multiple-parameters/ Tried restarting but…
-
Connection issue with Essbase from OBIEE RPD
Hi All, Essbase 11.1.2.3.500 OBIEE 12.2.1.1.0 We use OBIEE as reporting tool and connect to Essbase to pull some data via OBIEE rpd. Recently we are receiving below mentioned error in random while running the report. Report ran fine for majority of the users, some users receive this error message randomly. I have attached…
-
Handling null values in bi publisher rtf template
Summary Handling null values in bi publisher rtf template Content My requirement is replace all zeros with - sign <if:<?sum(current-group()/BUDGET)=0?><?'-'?><?endif?> but it throws error
-
How to create Percent of total in OBIEE
Hi I have a requirement to create percent of total for one of the column. I have created couple of logical columns from Order Date and Ship Date in RPD i.e., 1. Days to Ship Actual - TimeStampDiff(SQL_TSI_DAY, "ORDERS"."ORDER_DATE" , "ORDERS"."SHIP_DATE" ) // Which gives No of Days information 2. Days to Ship scheduled -…
-
OBIEE MAPS
Dear All, I have implemented maps in Obiee 11g, now i am stuck at a specific requirement. Client wants that whenever street level data is displayed in maps, all the street must connect with each other to form a route. Below is the sample screenshot: Anyone has any idea about how to achieve it? Any help will be highly…
-
How to Add total or Average of a particular column in Taleo OBIEE report
We are trying to print sum of particular column in a Taleo OBIEE report. Please let us know if anyone has worked on such a requirement.
-
Changing the export text delimiter?
Hi, We would like to change the text export delimiter from "," to ";" in OBIEE 11g, when exporting in text format. We "googled" without success :-( Any suggestion? Thanks
