-
OBIEE 12c Cloning the Production Environment to a Test Server.
Hi Guys, I want to know is there a way to clone my OBIEE 12.1.2.0 from production to test like we do in Oracle EBS. Please share a solution if you have done that. Regards, Farrukh Nasir Siddiqui
-
OBIEE - graph prompt taking way too long to display list of values
Hi All - We have OBIEE integrated with WebCenter Portal to display metrics for our end users. When we view these metrics within WebCenter Portal the analysis level filters are not showing us the full complete list, it in fact just halts and shows a running/loading cog wheel. Example - When we select the "Search...."…
-
BI publisher Add jdbc datasource is not working
Hi All, jdbc datasource was working fine. Suddenly jdbc datasource is not working properly. When i try to open the existing jdbc datasource. It is not opening. When i try to add a new datasource. Even add jdbc datasource is not working. Somebody has face this issue and anybody has any idea. Please assist. BI publisher --…
-
trying to group by a column in OTBI
Summary Trying to emulate the SQL Group by below in OTBI Content Select pt.task_number, sum(peia.projfunc_raw_cost ) FROM pjc_exp_items_all peia, pjf_projects_all_b ppb, pjf_tasks_v pt Where ppb.project_id=pt.project_id and pt.task_id= peia.task_id and task_number='001' group by task_number Code Snippet Select…
-
Grand Totals are yielding incorrect totals in Analysis
We built an analysis with multiple dimensional attributes and few measures.Then added a new calculated measures as A+B. We get the incorrect grand totals using the Default Aggregation? Also, the default Aggregation in RPD is set to SUM. However, when we set the aggregation to SUM for this new calculated field, it does…
-
OBIEE product discontinuation
Hi All, As per Oracle OBIEE will be discontinued and OAC will be available as the going forward BI presentation layer. I am eager to know more on the OBIEE discontinuation and how to migrate to OAC or using Oracle Data Visualization Desktop tool will be a better option.
-
OAC5 - where are the 'measure analysis' tiles?
Content In previous versions I have loaded up a data set, created a project, clicked on 'Prepare' and then clicked on the 'Data Tiles' and looked at the data attributes profiled by the measures in the data sets. I've probably not articulated that very well, but I can't seem to find that in the latest OAC or DVD. What am I…
-
OBIEE Bar Utility issue
Hi Guys, I have used the BAR utility to migrate my Production Server data model, security model and authorization model to a Test Server. The process completed successfully, however even though my analysis were trasnfereed successfully but the repository and users that i have created were not transfered. Can you tell me…
-
OBIEE 12c PROD and DR sites should refer to the same SDD
Hi, We have two OBIEE 12c installation for PROD and DR. Both are separate linux servers and separate OBIEE 12c installation. SDD (Singleton Data Directory) is NAS Drive path. After copying the entire 'bidata' in the '/user_projects/domains/bi/' directory (from PROD node) to the NAS drive, updated the config file…
-
Display Current Month / Year in heading
Summary Display Current Month / Year in heading Content i am in OAC - Biz Intelligence (what was the old OBIEE now in cloud), and on my dashboard // "Print & Export Options" // Edit Header // i want to display the CURRENT MONTH or better yet, the PREVIOUS MONTH AND CURRENT YEAR. i can click on INSERT FIELD --> DATE and i…
-
Will Extended Support for On-premise Essbase end on Dec 2021?
Summary will Extended Support for On-premise Essbase end on Dec 2021? Content Happy Thanksgiving everyone. Will Extended Support for On-premise Essbase end on Dec 2021? This document is 2 years old: https://www.oracle.com/us/assets/lifetime-support-middleware-069163.pdf It states that Extended Support for On-premise…
-
OBIEE 12c Migration from Exalytics to Exalogic
We have a data center migration for OBIEE from Exalytics to Exalogic. what are the best possible approaches ? Did anybody have done this kind of migration before ? if yes what are the issues faced ?
-
ETL taking too much of table space that it crashes on running full load.
Hi All, I have a fact table named viewership. It contains about 130 million records. I have written ETL such that first I import the data from the external database server to BI database server in a stage table, then I have created a mapping which puts the data into the actual fact table. The problem that I am facing is…
-
Prompt Values are not displaying the values in OBIEE 12C
Hi All, I am new to the OBIEE 12C.Today morning strangely, I could see in production instance that one of the prompt is not displaying the values in OBIEE12C dashbaord and also its throwing an below error. Failed to load(There was a problem retrieving the response data:\nInternal Server Error (500). <!DOCTYPE HTML PUBLIC…
-
Hidden filter in dashboard URL
Hi Is there a way to have a Hidden filter in dashboard URL to filter on certain products for example so whatever value I have in the URL filter then the report (s) will display only that product value? It seems other BI tools outside of Oracle such as Microsoft can do that, I was watching a video for Microsoft and the…
-
How to do it (2 fact table in 1 analyze)
Hi I have 2 fact tables in RPD (payments_operation_f; cash_operation_f). Fact tables connect on fisical and business layer with one dimension table (client_d). And now i want in one analyze get for client count operations: -count payment operation -count cash operation client_NAME (from client_d)count(payment_operation)-…
-
OBIEE 12.2.1.2.0 - Page breaks between Title, Static Text and Table in PDF --> Why?
Hi everyone, i've Problems with OBIEE Answers, Version 12.2.1.2.0. In the past i used 11.1.1.7.150120 and i had a lot of analysies. I exported my whole catalog and imported it to my new Environment 12.2.1.2.0. Now i have in some analysies page breaks between every object (for example title, static text, tables) and in some…
-
Date Formats in Data Visualisation within BIC
Summary Change Date Format from dd/mm/yyyy to dd-mmm-yyyy Content I have a user who is trying to change the date format in a data source. Currently in the data source the date is in the format dd/mm/yyyy eg 01/11/2018. They want to change this to dd-mmm-2018 ie 01-Nov-2018. NB Currently they are using the DV part of BIC…
-
BI Publisher Desktop Add-in for Excel Preview shows incorrect report
Summary Reinstalled app but get same results Content No matter what excel file I open and load sample data, I get a Preview of a different report. It is always the same report but not the one I have open in Excel. Has anyone seen this before? Version 12.2.1.4
-
Customizing the OAC header
Summary Looking for instructions on how to customize the OAC header links Content I want to customize the OAC header links in order to meet requirements by our business analytics team. The first requirement is to redirect the Home link to a custom dashboard page. I found instructions on how to do this in an on-prem OBIEE…
-
OBIEE Agent Failed
Hi , I created an agent on top a report.The report is working fine and generating output.When I am creating an agent on op of it.I am getting the below error.Could you please let me know how to fix it and run the agent free of errors.
-
Prompt value is set to default
Hello Experts, We are facing an issue where prompt value is getting reset to "select values" whenever we are selecting the other prompt value. Detail issue:- We have a month prompt > constrained on Quarter and Year - (default value is showing as current month based on SQL result) Quarter prompt > Constrained on Year -…
-
BI Pub Template Builder 12.2.1.2 0 (32-bit) fails with subtemplates
Summary When previewing after using the Content Using BI Publisher Template builder 12.2.1.2.0 on Windows Server 2012R2 with Word 2007 32-bit. The problem I will describe did not exist in earlier (11g) versions of the template builder on this system. I have a subtemplate located at c:\users\administrator\desktop\BI…
-
Can anyone tell me why my "Inbox" on this site is suddenly blank?
My apologies if this is the wrong place to ask. Please re-direct me if that's the case. Thanks!
-
Prompt value is set to default
Hello Experts, We are facing an issue where prompt value is getting reset to "select values" whenever we are selecting the other prompt value. Detail issue:- We have a month prompt > constrained on Quarter and Year - (default value is showing as current month based on SQL result) Quarter prompt > Constrained on Year -…
-
RPD errors with RedShift database
I'm trying to setup a connection to Amazon RedShift database. I imported several tables. Now I am trying to save RPD but getting this error: nQSError: 28021 <BIN_SUPPORTED> is an invalid feature. I saved an offline copy of the RPD, then deployed it online. So far so good. But when I'm trying to view data, I'm getting this…
-
Release - best practices
[OBIEE 12c] Could you share with me a list of steps to deploy changes on PRD and analytics side? I would like to know the best practices of implementing changes.
-
Sub-query in the select of OBIEE
Hello, Trying to figure out how to add a sub-query in the select part of OBIEE generated query. We have two tables which cannot be joined due to some modelling issues in snow flake schema set up. We need to take one value from the second table using a sub-select. Select Reference,Amount,Currency,(select additional…
-
OBIEE 11g Set up steps required to configure same like other environment
Hello Experts, We have a requirement to install and configure OBIEE 11.1.1.7.150120 in a new Redhat Linux 6 version. We already have the same OBIEE version using but the customer want to have another instance same like the existing one. We already installed OBIEE and it was working fine with default sampleApplite RPD but…
-
Count leaf node in level-based in hierarchy
Hi all I have level-based dimension Employee Division->Department->Employee I have to count how many employee in each department an each Division is. How to do it ? So i try formula: SUM(CASE WHEN ISLEAF("DIMENSION"."HIERARCHY") THEN 1 ELSE 0 END) but this is incorrect , because on parent level= (Division) i have 0. Is it…
