-
BIEE 12C：the url for Vital monitoring of cluster system
version:12.2.1.2.0 on Exalytics OS:Linux x86-64 Oracle Linux 6 User setup a cluster configuration by using NW device for load balance. - Loadbalancers - Reverseproxy - Single Signon ### User wants to perform Vital monitoring of BIEE process. Currently they set the url for Vital monitoring like:…
-
BI Service Administrator Application Role is deleted in OBIEE 12C
Hi All, I was working on creating new application roles in EM, unfortunately BI Service Administrator role was deleted by mistakenly. I created the role again and added weblogic user but some how it was unable to get all the default roles and responsibilities before deleting, even it is not accessing to open repository in…
-
BIP report replaces the OBIEE interface with BIP interface, when run from OBIEE dashboard
I have a BI publisher report that I am embedding in a OBIEE dashboard using Embedded content option, but when I run the dashboard, the report runs and BI Publisher interface then replaces the OBIEE dashboard interface. Thus, I now do not have access to any of the other dashboard pages etc. Both the applications BIP and…
-
Trial Balance report - FSG Issue
Hi, We have a version of Trail balance report that uses FSG attribute based on Hyperion Reference (it is similar to Group Accounts mapping and uses GL Account Number & Cost Objective combination to map to a Hyperion Reference). Is there a way to bring this Hyperion Reference FSG into OBIEE ?
-
Pivot view calculation going wrong
Hi all, I have requirement where dashboard prompt have year(Pyear_pv) and month (Pmonth_pv) as filters. Report is as follows: 2016, 2015 columns are populating through presentation variables (heading also through PV ). The script for 2016 column is: case when "- Shipment Period Dimensions"."Year"=('@{Pyear_pv}{2016}') then…
-
OBIEE 12.2.1.2.0 - Slider missing on graphs
I'm running OBIEE 12.2.1.2.0 on Windows Server 2012. When I create this simple analysis in Sample Sales then try to create a graph with a slider, nothing shows up where the graph should be. Can anyone else confirm this behavior, or offer suggestions to remedy? I am seeing the behavior in both Firefox and IE. (If I use…
-
Refer to Oracle Reports parameter in Excel template
Summary Refer to Oracle Reports parameter in Excel template Content Hi All, I have a concurrent program in R12 with XML type. My template is an Excel Template and i want to display the values of some of the parameters in that concurrent program. But, these parameters are not produced in the XML generated( i.e. there is no…
-
Data model not pointing to DbaaS
Summary Data model not pointing to DbaaS Content I have my sampleapp data model connecting to the defaulf schema a service. I then changed the data model to connect to database as service, (see below) But when I do a new analyses based on a subject area in the sample data model, the data being pulled is still coming from…
-
add more rpd to obiee12c
hello guys, i have got a questions here, so i installed obiee 12c in linux and my administration tool in windows. and i have my rpd named repotest.rpd this is my default rpd after install obiee 12c: [oracle@vm02 domains]$ cd obiee12/bidata/service_instances/ssi/metadata/datamodel/customizations/ [oracle@vm02…
-
Analytics and BI Publisher hangs on sign in
Hi, We have an intermittent issue in which Analytics and BI Publisher hangs when a user signs in. After entering the username and password, the Analytics page just shows "Signing In.." while the BI Publisher page doesn't go anywhere. The sign-in pages loads fine, but when you click "Sign In", that's when it gets stuck. I…
-
Errors logged in Fusion Middleware Control Enterprise Manager
Hi, We just installed OBIEE 12c a week ago and it's empty. However, when I log into Fusion Middleware Control Enterprise Manager, I see a bunch of ERRORS logged. I have no idea what it means. Consequently, the logs are getting generated frequently and it doesn't seem like the purging process is working. Does anyone have…
-
OBIEE 12c users cleanup
Hi, I was wondering what are the proper cleanup procedures in OBIEE 12c should a user leave the company. I can only think of removing the user account in LDAP and deleting their personal folder. Is there anything else I should do?
-
BI Service Administrator Application Role is deleted
Hi All, I was working on write back option and accidentally deleted BI Service Administrator application role. Is there any way to recover it. Please suggest. Thanks MM
-
How to create logical column from two logical tables
Hello, I'm using oracle HR data to practice. I want to create a logical column in the fact table Employee called Estimate Work Experience(number of years since the employee's last job start date). Is this possible? Or is there other measures that I could create instead? Here is the calculation that I tried to do I use the…
-
Couldn't PastConfig my domain
Hi, I toke a copy from my domain successfully . Also I created a movement plan using the extractMovePlan script .I changed the resulting plan file to fit the target machine . One of the configurations that I changed , assign the password file path in the xml of the moveplan.xml file which is d:\dbpass this file has been…
-
how to change default format number in obiee
I need to changue the default format number for all exists answer. For example 100.000.000
-
Conditional display in Excel templates
Summary Conditional display in Excel templates Content Hi All, I have an xls template, where I need to display cell data (Egs Column A) only if another cell (Egs Column B) contains data. Is there a way to use <?if:condition?> <?end if?> in Excel templates similar to how we used them in RTF? If this is not the right format,…
-
Fusion:Why the data model is null?
Summary Fusion:Why the data model is null? Content
-
BI Publisher in RTF file show dynamic link issue using BI Publisher plugin in MS WORD .
Summary BI Publisher in RTF file show dynamic link issue using BI Publisher plugin in MS WORD . Content Hi All, I am creating a report template using .rtf file and bi publisher in MS Word which will be downloaded a pdf file in my apex application. I am able to create table and graphs successfully and pdf is also working…
-
bipublisher sftp setup
Summary bipublisher sftp setup Content Please assist i have working Oracle BI Publisher 11.1.1.9.0 and could like to setup a new sftp delivery connection. On the administration link on delivery > ftp tab > add server, i have correctly added the ftp server details i.e host ip address, server name, port, checked sftp box and…
-
Obiee 12c multiple rpd
hello guys, i have got a questions here, so i installed obiee 12c in linux and my administration tool in windows. and i have my rpd named repotest.rpd this is my default rpd after install obiee 12c: [oracle@vm02 domains]$ cd obiee12/bidata/service_instances/ssi/metadata/datamodel/customizations/ [oracle@vm02…
-
Error when creating pivot or table view in Visual analyzer 12.2.1.2
Hi , We have installated clusted obiee environment with visual analyzer in it. When we try to create a project with pivot or table view by selecting any field from subject area .Getting an error "A general error occurred, please contact system administrator". With blank view and when i check the biserver log found below…
-
How to refer data from OBIEE database to Oracle(EBS) database
Hi, I have to frequently refer OBIEE data (which is in a separate database) in oracle database (another database), both are in different database Please suggest me the best approach/suggestion (db links, clone data etc...) Thanks, Affy
-
Migrate Highcharts codes (JavaScript) to 12c
Hi, We are using OBIEE 11.1.1.7 in our company and we create the most reports by using Highcharts codes (JavaScript) inside narrative: We will upgrade OBIEE to 12.2, my question is there any impact in the reports that created by JavaScript?
-
How to define logical table key that joins with the fact table
Hi, I'm not sure if my question could solve my problem. I'm practicing OBIEE using Oracle HR data. I have a error as below. I realized that it automatically sets the key for the join between Table Department and the fact Table Employee. and I can't modify the keys as I do In the physical diagram. ERRORS: Business Model…
-
OBIEE 12.2.1.2.0 - Mobile App - Don't use slashes in column names
Just an FYI to anyone interested. If your subject area has column names that include slashes, such as Room/Board, or Tuition/Fees, those columns will throw errors when you attempt to drag them into a Mobile App.
-
Need help in building XSL-FO report in 12.2.5
Summary Need help in building XSL-FO report in 12.2.5 Content Hi, We have a requirement to build a custom report to display Terms and Conditioons. Terms and conditions are containing html tags and we are using XSL-FO template to replace the same. I am using the below template code but it is not replacing the html tags.…
-
Is there anyway to hide the YELLOW highlighted navigational links (especially on a dashboard)?
Please see attachment.
-
OBIEE Migration
Hello, I am working for a financial company. We are planning to migrate from Oracle 11g to PostgreSQL. There are over 100 reports we have created using OBIEE 11.1.1.7 version (Ad-hoc layer, Direct Database, BI Publisher). I wanted to know if there are any issues in migrate catalog from Oracle 11g to PostgreSQL I realize my…
-
Formating a text field column values in Obiee
Hi There, Hoping you are are doing good and get a quick min to answer my question below. I have a supervisor full name in this format 'LNAME,FNAME' . I would like to remove comma between last name and first name and have the data in this format LNAME FNAME How can I achieve this text field format in OBIEE? Thanks very…
