-
After upgrading to OBIEE12c getting odbc driver error
After OBIEE upgrade I am facing "Odbc driver returned an error (SQLExecDirectW)" All reports are erroring out
-
How to fetch the @{dashboard.caption} variable into the RPD to use like VALUEOF(NQ_SESSION."DASHBOAR
Hello All (11.1.1.7 user here), I am trying to use the system session variable called @{dashboard.caption} to drive the data filters defined in the RPD (Identity Manager -> Select Role -> Permissions'). On a really simply level, what I am entering into the expression builder is the below syntax: CASE WHEN…
-
How to design correct OLAP model for drill down & drill through reports in multiple data stages?
Hi Gurus, I need conceptual help in designing OLAP data model (one or multiple star schema) for the purpose of developing drill down reports and drill through reports. Let me give you some idea what we are trying to do. There are many financial data hops we currently have in the organization. All financial data starts at…
-
Baseline Validation Tool 11g
Hello, I have some questions regarding the BVT. 1) Can you use the tool to compare between 2 11g environments instead of between 2 12c or between an 11g and 12c environment? 2) Do you need a specific licence to use the tool. eg.: Can it be used if you don't have a 12c licence but only a 11g licence? Thanks, Regards
-
Enable web query (.IQY) in Obiee 12c
Does any one enable the web query file (.IQY) feature that went missing when you save the analysis in 12c. It used to be there in 11g but seems to be missing in 12c.
-
Oracle Database 11g Express Edition compatibility for OBIEE 11g
Hi Experts, We are new to OBIEE. We want to develop reports on OBIEE 11g. Could please let us know whether OBIEE (11.1.1.7.160719) and RPD version 326 (11.1.1.7.150120) are compatible with " Oracle Database 11g Express Edition " . Regards, Meena
-
RTF TEMPLATES
Summary RTF TEMPLATES Content Hi All, I have wrote an procedure for po details for approved status and incomplete status and saved the xml file and need to design an single rtf template and output of pdf should be in 1st page approved Po's and 2nd page should be incomplete Po's and 3rd should repeat for Approved Po's and…
-
Row Level Security by Org
Summary Row Level Security by Org Content Does anyone have any good practice to share on applying row level security against users who belong to different business units. To date we have implemented a simple 1 to many user creds to orgs tables and managed through ApEx and applying a filter on the fact and dims in the BICs…
-
BI Publisher Report from MS Access
Summary BI Publisher Report from MS Access Content Team, Need info on ways to connect to MS Access to develop a Oracle BI Publisher report (OBI 11g). Looks like one way is to use Oracle DB Gateway for ODBC, Would like to know if we have any other options. Regards, Srikanth
-
MySQL JDBC connection
Summary MySQL JDBC connection Content Hi, I am having trouble finding documentation around setting up a BI Publisher to use a mySQL JDBC data source in BIP 11, could anyone point me in the right direction?
-
How to remove data model linked to Disbursement Payment File Formats
Summary How to remove data model linked to Disbursement Payment File Formats Content A data model was linked to the Disbursement Payment File Formats in the BI Catalog which produces an error when formatting payment files. It needs to be removed but there is no delete option. Does anyone know how to remove that?
-
Oracle BI HRMS
Summary Oracle BI HRMS Content Hey all, i created report for performance management , but i have some fields like shared goals , i can't find the tables that related to the shared goals ,so i need the help to find them !
-
BI Publisher Bursting Output Different From Report Output
Summary BI Publisher Bursting Output Different From Report Output Content I have an existing custom report that uses XML Publisher in EBS to generate output. I made a change using a flag in the XML output to suppress some fields when the flag = Y. The output pdf looks correct when I run it through the BI publisher plugin…
-
OBIEE 12c bi_server1 starting in Admin Mode
Hi Experts, We are having problem with starting up the services. Admin Server, OBIS and other services are getting started, but the bi_server1(managed server) is starting in Admin mode. We are having this issue after migrating a new rpd. Rpd didn't get uploaded and got an error saying 'Metadata lock couldn't acquired'. So…
-
How can I hide 0 value data labels in stacked bar Chart?
I would like to hide data labels on a chart that have 0 as a value. Data table : Market Product 1 Product 2 Market A 0 3 Market B 5 0 With this data source, stacked bar chart is display: But I would like this chart: Notice the 0 labels are hidden and are related to different products and markets. How I can do this? Thanks!
-
OBIEE slider misbehaves when spinner option is enabled?
I have a slider which takes values - 0 to 4. The values can be decimal values (2.5, 3.2 etc.). It works well when spinner option is not enabled. When I enable the spinner option, it starts rounding off the slider values. (i.e. 2.5 becomes 2 and 3.2 becomes 3 etc.) Is it a bug of OBIEE? How to avoid this problem?
-
OBIEE 12c JDK requirements?
Hi, We are doing a fresh install of 12.2.1.2 and wanted to see if we could use JDK 1.7 instead of 1.8.xxx. I tried looking up the certification in the excel files on the certification page but it seems to send me back to the page and I seem to be going in circles I also checked out the requirements and specifications page…
-
OBIEE Score Cards Enable Comments and Override Status
hi guys, Can any one guide me to enable comments and override status in Score cards, i'm using obiee 11.1.1.9 Version. I've searched Oracle Docs, i got infomation about BSC Connection pool. but which schema i need to use to connect through this connection pool. Thanks in Advance, Uma Mahesh.
-
Contact Owner in Scorecards
hi guys, I'm new to OBIEE scorecards, i'm using OBIEE 11.1.1.9, Can anybody tell me how to configure "contact owner" feature in score cards. Is there any option to enter mail id's in contact owner section? Thanks in Advance, Uma Mahesh.
-
Create a custom function to use in data models
Summary Create a custom function to use in data models Content I am converting a legacy Discoverer report to a BI Publisher report and I need to know what the best way is to convert the functions used. Below is the function used in the legacy report. CREATE OR REPLACE FUNCTION GRP_USER."CNL_PD_PARAM" ( p_period…
-
difference between active directory implementation and oracle internet directory in obiee 11g
Hello Gurus, Recently in my organization there is replacement of AD is started with OID. I know that in the mechanism of external database authentication , we have tables which are called at rpd and we do authentication , this was in OBIEE 10g. Second type of authorization method we followed which is LDAP , it could be any…
-
Oracle BI - Report on MAP
Hi, I have oracle bi 12c. I need to do map related reports. I don't know how to do it. Is it possible to tell me the steps? I'm not sure how to start. I don't have any spatial data etc. I only have Customer table, it contains the City and Country column. It have the names of city and country. exp: CustomerX, Paris, France…
-
Migration of OBIA with SSO to Oracle e-Business suite - authentication issue
Hi, I have come to this later, so I am not certain exactly what has been done, but a working OBIA environment 11.1.1.7 with SSO set up to facilitate use of e-Business suite users / responsibilities has been migrated and the repository / catalogue changed, with change of rpd password, and now the authentication does not…
-
OBIEE11g: Session Timeout Warning
Hi, We are using BiApps 11.1.1.10.2 (OBIEE 11.1.1.9). One of the requirements is that users should get a warning when their session has ended. Now the page just freezes and they can't click in the application. We already informed them to refresh the page, which will lead them back to the login page. But it would be easier…
-
OBIEE VA Language
Oracle Business Intelligence 12.2.1.0.0 How to change the VA'S default Language from English to the others
-
Workspace landing page customization
Hi Guys, I have requirement from my client to customize the workspace landing page to show it in different background color for each environment(Dev, Test, ProdQA.. etc) and to display some text with environment name on the workspace page. We are using 11.1.2.4.xx. The requirement is to intimate the user on which…
-
Embed OBIEE Dashboard in a Webpage
I am trying to embed a sample OBIEE Dashboard in an existing web portal using onclick fucntion. Below is the code i am using and when i click on the link i created to open OBIEE dashborad is redirecting to obiee. My requirement is to open the dashboard with in the webpage as an embed content instead of going to obiee page…
-
How to get BIP reports logical or physical query like Blob_text in S_NQ_ACCT table
Hi All, I need BIP reports logical or physical query. I have configured BIP Audit database but I am not getting to query. The same I am getting for OBI reports. I want to trace users parameter filter values like from_date and to_date or product etc. By using this we can trace huge access data. For OBI reports we are…
-
Suppress Version Update on Deployed DVD Software
Summary Suppress Version Update on Deployed DVD Software Content We manage the remote deployment of software to corporate workstations and have packaged the software for 12.2.1.2.0. With the release of 12.2.2.1.0, users are now getting prompted with the following pop-up on application launch: Version Update A new update…
-
Data Visualization Funnel Chart
Summary Data Visualization Funnel Chart Content I have a Customer who attended the Oracle Open World last Year and during the Data Visualization Session he capture a Funnel Chart The Customer attached me the screen shot and i am forwarding to you so the customer Mentioned The chart i uploaded is the from the oracle open…
