-
Kerberos for Hadoop
Summary Kerberos for Hadoop Content There seems to be no ability to enter kerberos parameters when defining a Hadoop connection. Without it, I would deem this data source unusable as it's missing a key security component. Do I have something wrong here? Regards,
-
OBIEE 12c Microsoft Office Integration
OBIEE 12c Is the Microsof Office Plugin still avaible to download in OBIEE 12c any longer. Smartview seems to be the only available option now.
-
I have a hang when i install BI 12c Configuration Assistant
I have server os - windows server 2012 R2 and i install oracle database (3 bases: pmdb,bi,ow), Primavera and today I would like to install BI and warehouse In the 4 step of 9 BI hang. I restart server and try install. Whis is my log : TNSping BI: C:\Users\test>tnsping bi TNS Ping Utility for 64-bit Windows: Version…
-
Parent Child relationship configuration
HI all I had an issue in parent child hierarchy as when I add the hierarchy the tree works fine but when I add the aggregated columns from another table it give me no data to review I checked the relation many times , but i can't see the error. I'm Building a parent child hierarchy for "ACCOUNT" table as Table1 :…
-
BI Publisher RTF Template Suggestions (Financial Report)
Summary BI Publisher RTF Template Suggestions (Financial Report) Content Hello, I'm trying to develop an appropriate BI Publisher RTF Template for a report that we need.. Basically the report will use a Tree structure and for each level of the Tree it will get some information from databases and sort them depending on tree…
-
conditional layouts in one rtf template in BI publisher
Summary conditional layouts in one rtf template in BI publisher Content Hi All, I need to develop rtf template which includes 2 layouts in one rtf file. Meaning, conditional layouts I am attaching sample doc for this. If CF_FLAG=’Y’ then layout should print header and footer details in every page. If CF_FLAG=’N’ no header…
-
RTF template PDF ouput issue when using for-each-group@section
Summary RTF template PDF ouput issue when using for-each-group@section Content Hello, I have building RTF template, where we have issue generating blank PDF ouput when using for-each-group@section. error message: "There was an error opening this document. This file cannot be opened because it has no pages". Details: We…
-
OBIEE 12c Security
Hi All, We are right now on OBIEE 11g (11.1.1.9.0) with OBIA 7.9.6.4. Right now our authentication is done by LDAP which is set in RPD while authorization is done using External table. For migration to 12c with VA we need to move LDAP to weblogic and also Authorization out of RPD. Have anyone done this? can someone point…
-
Requisition was showing in Taleo but now it's missing and there's no record in Taleo when I search r
Hello, We run an OBI analysis report weekly that lists all requisitions which have not been cancelled or closed. However, on the previous two reports a particular requisition number is displayed but when we attempt to search for this requisition number no record of it comes up at all (no history or anything). Also, it no…
-
Not able to import hive tables to OBIEE 11.1.1.9.0
Hi i have configured Hive drivers and added hadop apache at connection pool. But when i am trying import tables from hive to obiee rpd, have issue as database doesnot contain any CRM tables. If i uncheck and ask for import it is brining out empty database schema without any tables. can anyone please suggest as how can i…
-
upgrading jdk in OBIEE 12C
hi experts , I have installed obiee 12c on jdk1.8.0_92 and now I need to upgrade the jdk version to jdk1.8.0_121 of the same obiee 12c. Does anyone know how to do it and please give me some proper steps by steps procedure . Thanks
-
OBIEE 12c repository permissions
Hi, I'm trying to figure out how the repository permission works. I have a folder, "RRE" under my subject area. I am trying to revoke access to the user, "gli_author" be setting it to "No Access" explicitly. I bounced the servers and the user still can access the RRE folder. Any suggestions?
-
Where are OBIEE analysis reports physically stored?
In our OBIEE environment, we have a number of analyses created. Where are these physically stored? Mostly I am asking for documentation purposes. I can see the list in the OBIEE application itself; but let's say I wanted to copy this list to Excel or notepad. How would I go about doing that? I haven't been able to find an…
-
Report access issue intermittently
We are facing a strange issue where the user looses access suddenly to the reports they were previously having access to. Below is the only log that shows any warning/error during the time frame when the user logs in. Appreciate any help. The error Does not say much. nqserver.log: [2017-01-26T11:24:47.512-06:00]…
-
Snowflake vs star
Hi everyone, can I ask a generic dimensional modelling question. I know we should choose star schema if we can as star schema offers better query performance and simplicity. My question is when to use snowflake? when dimension table is too large? or when we want to solve many to many relationship? What's the difference…
-
Page break on page with both one column and two columns in word
Summary Page break on page with both one column and two columns in word Content Hello, I'm using BI publisher for desktop and I need to make a report where I have a title with some variables and a two columns with a table. When i publish the report it makes a page break between the section with the title and the two…
-
RTF to XLSX Produces Final Merged Row
Summary RTF to XLSX Produces Final Merged Row Content PeopleTools 8.53 BI Publisher 11.1.1.7 When I create an RTF template that is just a table and output it to XLS or XLSX in Word or PeopleSoft, it creates a merged row right below the final row of data. This seems to be because word always makes an non-deletable empty row…
-
Positive Pay File Trailer Line - Count Function and Total Payment Amount
Summary Positive Pay File Trailer Line - Count Function and Total Payment Amount Content I have messed around with different codes on this file for over a week now. Any help would be greatly appreciated. I need to create 2 functions: 1. A function 10 characters long that will count the number of outbound payments in the…
-
Open BAR File without importing into target service instance in OBI 12c
Hi I am wondering how can we open BAR file without importing in to service instance. I have gone through below oracle doc about importServiceInstance command but this command allows to import into a target service instance, which i dont want to do it before knowing whats in that BAR file. 9 Managing Metadata and Working…
-
Bar-line-area chart in OBIEE 11.1.1.9 or Obiee 12c
Hi Gurus, I know there is no view currently in OBIEE to get a bar-line-area chart. But can this be achieved by using any third party tools? Also can this be done in BI Publisher? Regards, Deep
-
Filter on Sparse Lookup Column 'Unspecified'
I have a column which is based on a lookup value. This lookup value translates a code column into a display value. I'm using a sparse lookup, because the code column can be null. If null, the displayed value must be hard coded to 'Unspecified'. The formula of the column is thus: LOOKUP(SPARSE "Lookup Table"."Display…
-
OBIEE11g vs 12c ( where are .xdo, .xdm ...report files in 12c OBIEE ) ?
I created a report in OBIEE12c. But I dint find and .xdo, .xdm, xdo.cfg .... file in any of the folders. In OBIEE 11g they use to be there in some repository directory. Where and how OBIEE 12c stores catalog objects/repositories.
-
Writeback issue
I tried to implement writeback feature using below link on OBIEE 11.1.1.7, but i am getting error when trying to hit on Apply button. Link - OBIEE: Write Back Setting in OBIEE 11G http://obieetutorialguide.blogspot.in/2015/04/write-back-setting-in-obiee-11g.html I checked the bi server diagnostic logs and found below error…
-
OBIEE 11 vs 12 Backup and Recovery Differences?
As I am looking into upgrading from our current 11g instance to 12c I am also looking at the differences (if any) of the backup strategies. If i understand the documentation correctly, it looks like in 11g entire directories were backed up, then a few specific files Introducing Backup and Recovery - 11g Release 1 (11.1.1)…
-
Moving external datasets (XSA) between environments
We are using export service instance and import to move between environments, and setting option to include user runtime data (user's catalog data). However, even with this option, XSA files are not being imported into the target environment. Therfore, the VA projects are moved, but their dataset is missing in the target…
-
OBIEE 11G: BI Publisher issue with fragmentation content
Dear Support, We face a potential bug with BI Publisher in OBIEE 11G when the logical table sources use the "fragmentation content" feature. The example of the bug we have is with 2 logical table sources: - The first one has the fragmentation content YEAR >= 2009 - The second one has the fragmentation content YEAR < 2009…
-
how to print BLOB images in the xml reports,Oracle apps
Summary how to print BLOB images in the xml reports,Oracle apps Content Hi Friends, I need to show the employee images from PER_IMAGES table . Please provide me any suitable solution if any one come across this kind of requirement . Regards, BH
-
BI Publisher Integration with EBS Responsibility
Summary BI Publisher Integration with EBS Responsibility Content Hello All, Can we access BI Publisher reports using EBS Responsiblity? Please let me know if this is possible. And also please point to me the right document. Thanks, Deep
-
Can we extract data from share point using OBIEE11G?
Hi All, I got one requirement in that I have to extract data from share point using OBIEE 11G. Can any one help me how to extract data from power point. Thanks, LakshmiNarasimha.
-
CAC authentication issue
Hi everyone. I'm having an issue with Oracle Business Intelligence 12.2.1.1.0 that I'm hoping someone could help me with. Thanks so much in advance for your feedback. Background: I successfully moved from OBI 11g to the 12.2.1.1.0. I opted to do a fresh install of everything rather than using the various migration scripts…
