-
Displaying OBI EE Alerts in a third party App/Dashboard.
Hi, Our BI application consists of two technologies: OBI EE 11.1.1.7.0 and Microsoft Silverlight. The OBI EE Dashboards are called 'reports' and the Silverlight framework is a wrapper for these reports plus near-real time reporting UI. Collectively, it's called a dashboard. When the end users are viewing the near-real time…
-
WARNING: Error while registering Oracle JDBC Diagnosability MBean
Please help with this: Weblogic is throwing error when tried to connect via JDBC thin. Where does the application look for Ojdbc drivers? I tried to update the domain using config.sh, same error. Jul 07, 2016 2:15:38 PM oracle.jdbc.driver.OracleDriver registerMBeans WARNING: Error while registering Oracle JDBC…
-
HCM Workforce Succession Planning - to get Successor and also Position details together
Hi All, I am trying to show both successor's details as well as position holder's details together in a BI report, but even when I choose details from different HCM subject areas still im not getting desired output.The report layout should be: POSITION HOLDER'S ID | POSITION HOLDER'S NAME | POSITION NAME | SUCCESSOR COUNT…
-
Oracle RTD Questions.
Hi, We are on OBI EE 11.1.1.7.0. We are trying to explore Oracle RTD. I have a couple of questions, if someone can answer those or let me know the right forum to post my questions to, that will be appreciated. 1. Does Oracle RTD have features like Thresholds and Alerts? 2. Can Oracle RTD display real time or near real time…
-
as you can connect with hadoop OBIEE?
as you can connect with hadoop OBIEE? try connect with odbc of hive and impala, but in admin tool for do the rpd. i have problems, because i cant see the tables this is the problem:
-
Unable to find all the users with Active Directory SSO implementation
Hi ALL, Does any body has the solution t for this. Iam implementing the SSO and had done all the configuration settings and it could able to retrieve only few users in respective domains Is there any settings i need to do to retrieve all the users . Thanks & regards kumar
-
Scheduler Permissions on OBIEE 12c
Hello, We have an OBIEE 12c installation in which the security was migrated from an 11g environment. We have a Role that doesn't have scheduler permissions of BI Publisher. It only has this policy applied: oracle.bi.publisher.runReportOnline But not the following ones: oracle.bi.publisher.scheduleReport…
-
in 10g We are using SSO. We are validating the users using Database table.how to confiure it in the
Hi all, We enabled SSO and we are maintaining the users in the table (not maintaining password). Please guide me how to enable sso and which providers i have to select? how to get users to access to anlytics..? in 11.1.1.9 Please reply..
-
Unable To Authenticate The Embedded LDAP 'weblogic' User After Configuring MSAD
Hi Fellows, I'm having the above issue, identified in the Doc ID 2135130.1. As noted in the doc, i should make changes to the username.attr attribute, removing the sAMAccountName and change it for 'cn'. Indeed, this makes the embedded LDAP users able to login again, but the MSAD users not anymore. Since the login attribute…
-
Web Service example using Action Link in OBIEE 11.1.1.7 does not work
I'm trying to reproduce an example of BI Publisher Web Services described here Rittman Mead Consulting » Blog Archive » Web Services in BI Publisher 11g but instead of using SoapUI I want to use Action Link on BI dashboard. So I created new dashboard, dragged and dropped Action Link, chose 'Invoke a Web Service', pasted a…
-
not able to login into analytics
Dear Experts, I had to reset weblogic password. I done it via WLS script. After that I have started to recreate BISystemUser following article: https://jyotithakur.wordpress.com/2014/03/28/obiee-11g-bisystem-user-role-got-deleted/ at the end I setup username and password in oracle.bi.system -> system.user. Restarted all…
-
OBIEE 12c - Customising Skins
Hi, We are looking into customizing a Style and Skin on OBIEE 12c and I'm following the oracle doc http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG9185 Section 17.9.5 Customizing Your Style; Table 17-10 Application Resources Folder Contents Folder / Filename = sk_Custom the 3rd paragraph states…
-
How to improve response times when getting the first n results of an analysis via the XMLViewService
Hi Everybody, I created an analysis in Obiee 11 which results I consume with an external client using the "Oracle BI EE XMLViewService Presentation Service" (see:https://docs.oracle.com/cd/E21764_01/bi.1111/e16364/methods.htm#BIEIT335). To be precise I'm not using the XMLViewService directly. Instead, I send my requests to…
-
Show weekends in Calendar view
Hi, I need to created an OBIEE analysis that shows (This is based on BI Apps on Peoplesoft, but the question is not BI Apps related): Per Month (Dashboard prompt): - Row: Person Name - Column: Gregorian Calendar Date - Fact in Cell: # Absence Occurrences And the columns that correspond to a weekend should have grey…
-
Pop Up Error: ReferenceError:_GFPGetPromptValues2Alt is not defined...
Hi folks. Sometimes I get this error randomly in my OBIEE Answers environment ReferenceError:_GFPGetPromptValues2Alt is not defined. It seems more of an annoyance and does not appear to be causing any functionality issues, or at least anything that is noticeable. It seems to be appear on any dashboard page (prompts or no…
-
Hive table are not visible while importing in Adimintool
Hi, i Created a Hortonwork HiveODBC. I tried to import tables I am able to connect the Hive server and goes to the default database. But table are not visible under default database. I tried manulally in physical layer its working. but I have big table to add manually it will take lot time for me. pls advise.
-
Drill down icon
Hi All, I have an issue with drill down icon (for hierarchy) in Answers. We have a report which uses it (level-based hierarchy). We start it at a certain level (say level 6) with 2 values (e.g Revenue and Expenses). We then add members of the next 3 levels (7, 8 and 9) . This is fine. However, closer inspection shows that…
-
Customize GL Balance Fact
Hi, I have GL reporting requirements to create Balance sheets and P&L reports. We also need to provide ability to end users to use all segment hierarchical prompts to analyze and group data. The idea is to transform financial statement generator reports from the source into BI reports. We designed a custom solution around…
-
How to show last year next nth number of weeks in obiee 10g?
I would like to know how to retrieve data for last year next 4 weeks in obiee 10g. I only want to make changes at the front end and don't have permissions to make any changes in the back end in rpd. Attached is the columns under our table dimension. I am new to obiee so please be as descriptive as possible. For example,…
-
Filters on the report and columns
Hi , I have requirement where in i need to filter all the report columns except one. for now, i have removed the report level filters and made them at the column level. This is a union report and the performance became very slow as we are also using on the fly calcualtions using the presentation variables. is there any…
-
I have upgraded from OBIEE v11.1.15 to v11.1.19. The timestamp in the exported excel reports is not
The timestamp in v11.1.1.5 is centre aligned wrt columns and right aligned in 11.1.1.9
-
Weblogic user password change has affected not to get restarted of any of services(Admin/managed/opm
Hi All, I have done weblogic password change by following below steps and caused any service not getting started. Make sure all the services are down * change directory to <Middleware_Home>\user_projects\domains\bifoundation_domain\bin cd <Middleware_Home>\user_projects\domains\bifoundation_domain\bin * Source the…
-
Can not Enable Authorization Init Block in OBIA 7.9.6.4 using OBIEE 12c
Hi everyone!! I try to migrate security from EBS to OBIEE 12c using the corresponding Authorization Init Block. I use the following SQL SELECT DISTINCT 'ROLES', RESPONSIBILITY_KEY RESPONSIBILITY_NAME FROM FND_USER, FND_USER_RESP_GROUPS, FND_RESPONSIBILITY WHERE FND_USER.user_id=FND_USER_RESP_GROUPS.user_id AND…
-
OBI11g irregularly crashing with java.lang.OutOfMemoryError: Java heap space
Hi everyone, my OBI 11g server crashes irregularly - once per month or so. Since this crash doesn't occur often or during development (but during 'normal' use) and there's quite a few users using it so it is pretty much impossible to find out from user side what would be the cause for the crash. In bi_server1.log I get…
-
OBIEE 11.1.1.9.0, Reports not working when InIFrameRenderingMode is set.
As we upgraded our OBIEE version from 11.1.1.7 to 11.1.1.9 some of our reports are not displaying and the drill downs never load when the iframe rendering mode is set to allow. Drop downs like dashboards, favourites keeps loading and never displays. We are calling the obiee analytics through a jsp used in our application…
-
How to pass "AllColumnValues" into direct db request using presentation variable?
Hi Guru, How to pass "AllColumnValues" into direct db request using presentation variable? i've tried below approach but still it's not unable to password "All Column values" 1. select * from Table_name where table_column in ('@{PV_Var1}{SINGAPORE}') 2. select * from Table_name where table_column in…
-
Is BI Scheduler Service on 10g required to be running for OBIEE 10g to 11g Upgrade process
Hi, We are in a process of upgrading Siebel Analytics 7.7.x to OBIEE 11.1.1.9.0 As per the upgrade document, we upgraded from SA 7.7.x to OBIEE 10.1.3.4.1 successfully (ie RPD and webcat upgraded without issues). However BI Scheduler Service is not coming up on our 10g environment. The error is as follows : [68008]…
-
Parameters' transfering in BI Answers
Hi all, I've got a question and will be very grateful if anyone could help me with it. There are several reports which are linked each other by 'drill out' connections, and with parameters passed between these reports. Every of that reports based on it's own tables (tables linked by keys, which are these mentioned…
-
Unable to start BI_SERVER1 on OBIEE11g
Hi, I'm able to access EM and Console. But, unable to start BI_SERVER1. Could anyone help me to resolve this issue ? Attaching BI_SERVER log. < pre class="code codeBlock" spellcheck="false" tabindex="0"> <Jun 6, 2016 5:13:33 AM MDT> <Info> <WorkManager> <slc10xyd> <bi_server1> <[ACTIVE] ExecuteThread: '2' for queue:…
-
Issue with Advanced Aggregation in Pivot - Weighted Average Headcount Totals
The issue I'm having relates to calculating weighted daily average headcount - totalling by Qtr, Year, by Site. The Data is stored at the Contract Grain, Monthly. The Hierarchy looks like Site -> Customer -> Contract., Time is by Year -> Qtr -> Month. Using our Business Model we're trying to build Weighted Hc - by month,…
