-
OBIEE 11g :: Need to create a user for deployment only.Should not login to analytics
Hi , I have one requirement. Need one user who should have below properties. 1. He should login to EM and console only. 2. Should not login to analytics. 3. Should have access to deploy catalog and RPD. Can you please suggest me the suggestion. Thanks Srinivas
-
OBIEE Catalog Manager, modifier column not showing correct name
In Obiee Catalog Manager there is a column against objects which shows Last modified time and Modifier (name). However, I have found out that if the report is edited and saved (modified) by a user, his name is not updated in modifier. Any help regarding this is much appreciated. BI version: 11.1.1.7 Catalog version:…
-
Calling OBIEE Reports through SSO.
Hello guys, I got an requirement where I have two Applications CRM as IDP and OBIEE as a service Provider. In IDP Application, I have a html page where I will give the parameter details which are required to run the Report from Obiee. As user doesn't want to prompt again the same parameters in OBIEE, I should pass the…
-
biee12c [43065] The connection with Cluster Controller ::ffff:10.0.0.1.43814 was lost.
Today i can't login in the analytics, the username and password is right, it prompt please contact your administrator. In the obis1-diagnostic.log, i found this error: The connection with Cluster Controller ::ffff:10.0.0.1.43814 was lost. How to solve this problem?
-
Obiee 11g w/ Teradata: CREATE TABLE priv fail after upgrade
Hi Fellows, After a successful upgrade from OBIEE 11.1.1.7.x to 11.1.1.9.x, we started to have problems with reports using Teradata ConnectionPool. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query…
-
Bar Graph issue in OBIEE
Hello Team, I have facing issue in following scenario: A graph contains a bar chart which displays the count based on month/year column which is present in X axis of the graph. While navigating by clicking on any month of the graph for ex if clicking on June/2016 month In the second level page we are expecting to see the…
-
OBIEE Hovering Issue in Bar graph -
We are not able to display the values of those columns on hover which are not part of the graph although those columns are the part of the analysis. Could anyone guide me on this. Thanks,
-
How to pass column values to prompt in another dashboard page.
Hi, Do we have any option or feature in OBIEE 11g that we can pass column values in report to another dashboard prompt.Prompt will receive values from report and prompt also should display other values.
-
Performance issues - OBIEE 12c
Good afternoon, I was just checking if anyone has noticed slowness of OBIEE 12c. For instance, on a new dual E5 xenon 16Gb server , the default setup (SampleApp) is very slow. After going through the tuning guide and fixing recommended items, such as Heap Size, ThreadPool etc. - I'm still not happy about performance - 11g…
-
Filter function not restricting values for the Dimension...
Requirement is like, I have I am using 3 dimensions.. (1).Year, (2).Supplier, And (3). ‘test’ column that contains values like ab, bc, cd and dc. I have created a fact column for the test is like, count(“test”) as test_1 in the RPD. Sum %Not Usable= ( ab + bc )/( cd + dc ). As per formula I have created the following…
-
Creating analysis issue.
Hi Experts, I have a table has 2 columns: CUS_ID #_OF_TXN. id_1 1 id_2 2 ....... I want to create a report as below: TXN_SEGMENT NO_OF_CUSTOMERS (Count distinct CUS_ID) 1 TXN x 2 TXN y >2 TXN z i can not use PIVOT table here since the data has millions of records and always throw error: exceeded maximum allowed (though i…
-
Need to customize agents , Hide a few columns from users.
We need to customize agents , do we have any specific blog or document around that . We basically need to edit text maybe for few options available to users and also hide a few options from Users. I understand basic OBIEE customization using "customMessages/l_en/messages" a little. but need specific to Agents. Regards…
-
BI Publisher 11.1.1.9.1 Prompts issue !
Hi All, I have a issue in BI Publisher 11.1.1.9.1, I created a Data Model with parameters (Prompts) and placed the report in the dashboard here when i try open the report i m not able to see any prompts but when i open the report from catalog i can see the prompts. I don't know why its not showing up promtps ? Need help…
-
How can we add a Signature to OBIEE Agents automatically , whenever an Email is sent out
Hi, We need a signature getting added automatically, whenever a user creates an Agent and sends an E-mail out. Signature something like "Please do not respond to the email, for any queries contact xx@xxx.xx". I hope i am making my point clear. Need help, i cant find any configuration for this. Regards Prakhar
-
OBIEE 11.1.1.9.160419
Hello! In my version 11.1.1.9.160419 of Oracle OBIIE my write back functionnality does not work. I want to describe the strange behavior: when i want change a value and i write in the textbox of my table, the focus of textbox is lost. I study the function about the focus obipswb.Grid.Focus in js wbpivotview.js , but i…
-
OBIEE 11g Map Drill Down
I'm trying to create a drill down in OBIEE to drill from country to city on a map. The dimension is already setup and the drill down functionality works in the table view: Country w/ Count drill down to City w/ Counts for a country when I select on it. Here is what I done so far: * I create 2 layers in the Administration…
-
How to disable discoverer report
Hi ... Our need is to disable to discoverer reports. We do not want to delete report as in future, if needed, we can just enable the report. Please let us know if we have an option to disable discoverer reports. Below Discoverer version we are using. Oracle BI Discoverer 11g (11.1.1.7.0) Operating system : x86 Windows 7 6.1
-
How to upload RTF File into BIP Report
Hi Friends, My Client given me a RTF template file for seeded OBIEE Report and we need to show existing OBIEE Report data through that RTF File. I have created BIP Data model using OBI Analysis as source and chosen one existing OBI report. Then changed the column names as database/RTF File columns as shown below. Below is…
-
Issue when implement SQLGroupProvider in OBIEE 11g.
Hi All, I'm using OBIEE 11.1.1.7. I have done integrating AD Provider and AD users now can log into BI system. I want to use external DB table for assigning Groups to users, and implement SQLGroupProvider as instructions here http://docs.oracle.com/cd/E28280_01/bi.1111/e10543/privileges.htm#BIESC6128 But when starting the…
-
OBIEE 11.1.1.9.0: Domain Creation failed
Hi, For OBIEE HA installation on Linux x64 server with two nodes, We are following the below procedure. Installed Weblogic Server 10.3.6 Installed OBIEE 11.1.1.9.0 - Software Only OBIEE Configuration from Oracle Home: /app/local/Oracle/Middleware/Oracle_home/Oracle_BI1/bin/config.sh Domain Home is in Shared Mount Directory…
-
Dashboard prompts not seeding BI Server cache
TLDR Our dashboard prompts aren't seeding the BI Server cache, yet running the same logical SQL (as generated by the dashboard prompt) as an Analysis does seed the cache. Background We have a clustered OBI environment running 11.1.1.7.150714 with caching enabled. According to the Usage Tracking, about 30% of requests on…
-
Custom Images not displaying after upgrade to 11.1.1.9 from 11.1.1.6.12
All, using Fmap to display custom images into reports, after upgrade to 11.1.1.9 unable to find the images folder path to place custom images. place the custom images under OBIEE11g\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1 Not found the below path in 11.1.1.9…
-
OBIEE Filter with "contains all / like" and multiple values in presentation variable
Hello, I´m looking for a solution to create a filter with "contains all" from a presentation variable. But I need not a compare with a list, I need the like-operator. Example: column "foo" to filter: "A,B,C,D" (all values in one column as string) selected values from dashboard prompt: "B" and "C" When I use this in filter:…
-
show prior calendar month up to 5th working day of the current month
Hi If you can help please. I want to have a formula that allows me to do the following- image attached. Any day I run the report within the period of time between May 09 and June 08 then I get data for May 01 until June 06 ( 5th working day of the month) and so on...so if I run the report on June 07 then I get From June…
-
OBIEE 12c goes on strike
This isn't a question, but a description of something that happened to us today with OBIEE 12c. During class, our OBIEE system stopped responding - cold. I tried to check the status of the services, but the process said that the NodeManager was not running. Upon rebooting the server and attempting to start services, the…
-
Problem with the display of graphs and scorecard
Hi, I have problem with display graphs and scorecard in some browsers. I'm working on Oracle Business Intelligence 11.1.1.7.131017. Some users use Mozilla Firefox 46 and they can't see the graphs on dashboards. Are there any requirements to charge the charts? In single-user I updated the Adobe Flash Player, and the problem…
-
OBIEE Reports Aggregation Question
In the following table: M1, M2, and M3 are the measures. I have include them in the same fact table. The real case is that I have more than twenty of those measures. To simplify my question, I only included 3. What I want to do is an average of M1, M2 and M3 when they are not equal to 88 or 99. Example: average of (M1),…
-
What are the policies for BI Content Author and BI Consumer profiles?
What are the policies for BI Content Author and BI Consumer profiles? for example, the policies for BIServiceAdministration profile are: What are the values for class of permitions, Resource Name, Resource Type, and permision Actions Set for BIContentAuthor and BIConsumer profiles? Thank You any help,
-
Erroring On click of Schedules Tab
Hi, We are on BI Publisher Enterprise 10.1.3.4.2 and Siebel 8.1.1.10. When trying to click on Schedules tab in BIP: I get 'An internal error happened. Please contact administrator.' And the XDO.log says: [051216_133259155][][STATEMENT] ToplinkDataHandler.queryOutput() : calling executeQuery().…
-
OBIEE integration with web services
I am trying to access a report in OBIEE through the SAWSessionService by passing a username and password for which I get a sessionID back. Next I use this sessionID to the executeIBotNow method of the IBotService using SOAPUI <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"…
