-
Unable to do Smart Update in Offline Mode
Hello Gurus, I am facing some issues while trying to apply patch for Weblogic for BUG 13351178. Currently I am using Weblogic 10.3.5.0 The issue is I am unable to get the details of the extracted file in Smart Update GUI. The details are as below: OS: Windows Server 2008 R2, 64 Bit Patch extracted at:…
-
OBIEE 12c - Generating a correct row count when using a percentile filter
I am not finding a way to generate an accurate count of rows when using a percentile filter. The following XML will generate an analysis from the Sample Sales Lite subject area, and it works properly. There is no filter in this analysis. The running row count and the total row count both work correctly. <saw:report…
-
[OBIEE 12c] Can't access analytic site via default port 9502.
Hello, I tried to configure SSO using this guide: https://blogs.oracle.com/pa/obiee-12c%3a-configuring-kerberos-sso-for-obiee-12c . I did everything but I wanted to roll back changes as I did. But now I can't access analytic application via default port 9502. Using 9505 I can access application. What is wrong with…
-
How to convert the first letter of each word to UPPERcase in OBIEE 11g
How to convert the first letter of each word to UPPERcase in OBIEE 11g Not by using the Evaluate. Requirement: I need the data in my column("Country"."Country Name") as below UNITED STATES OF AMERICA -> United States Of America
-
Create a map view into obiee analytics 12.2.1.2.0
HI Guru's, i need to implement analyse with map view, i don't know how i do that, please send me a tutorial for this
-
Manually change depth of the tasks in a Job in Data Sync
Summary Manually change depth of the tasks in a Job in Data Sync Content HI, Can we create or modified depth of the task in a Data Sync Job. When i created a Job with 2 Task, my task depth is always same "0". But what i am looking for is Task1 Depth should be "0" and Task2 Depth should be "1", so after Task1 completion…
-
OBIEE 12c - External Table Authentication and Authorization - Browser options are inconsistent upon
I have implemented table-based authentication and authorization. When roles are changed in the table, the browser does not always reflect the changes properly. Example: A user starts out as a BIConsumer. At the first sign-in, the user is definitely a BIConsumer. Only the proper options and links are present on the Home…
-
SSO between APEX on-premise and DVCS
Summary SSO between APEX on-premise and DVCS Content Problem Description --------------------------------------------------- It is possible to Single Sign On between a Cloud Product (DVCS), and an on-premise product (APEX ON PREMISE) ? Just to explain use our user story : We have an apex application (on-premise), this…
-
12.1.3 - xlsx output from XML Publisher
Summary 12.1.3 - xlsx output from XML Publisher Content Hi I am trying to export from XML Publisher to an excel spreadsheet with multiple sheets I believe this cannot be done from an xls output, it has to be done from an xlsx output. Is there anyway to force an xlsx output via XML Publisher? I also believe it can be done…
-
Create Event triggers
Summary Create Event triggers Content hi Team Can somebody help in creating Event triggers in bi publisher oracle fusion as it looks like now default oracle package is also required and till Rel 9 it was not there. Can somebody help with some sample to understand the flow. Like we can do triggering report if some failure…
-
Is there an API for synching WLS Groups with FMC Roles?
If we had a table that contained a cross reference of the relationships between WLS groups and FMC roles, is there any API that could read that table and automatically populate the FMC roles with the member WLS groups?
-
OBIEE 12c Bi Search/Bi Ask setup
Hi All, in my 12c (12.2.1.2.0) environment I see the folowing situation TEST environment - standard install Crawler is ok, I can see all my SA and catalogue folders on BI search setup: PROD Environment - clustered install Crawler setup is empty; I cannot see any of my object. All other components in production env are…
-
HTTP 500 Error
Dear all, I'm recently facing the folowing error on my 12c (12.2.1.2.0) install but I cannot figure out why: ID messaggioHTTP-500Livello del…
-
Dealing with the list of subject areas and dashboard as your environment grows
Hi Legends, Has anyone figured a way to manage the long list of dashboards to those users who are working across many subject areas. For example within finance the business managers have access to all modules AP, AR , GL and PO. We have created multiple dashboards to facilitate their day to day work and month-end reporting…
-
Installing Pentaho PDI on Oracle VM
How to install Pentaho PDZ. I am using Oracle VM and Oracle DB Developer VM already installed. Honestly, I am lost with instructions on how and where to install PDI? Class forum is pretty unresponsive. Can anybody help me with this? Please, take into consideration that I am very new to VMs and Pentaho. Thank you for…
-
Passing Date Parameter in Different Date Tables, in Same Dashboard
Hello, We are Using OBIEE 11.1.1.7.150120. I have a requirement where we have two Different Date Dimensions(ADate, BDate) on the same Dashboard. Date Column from ADate Dim is being used in prompt where user enter values. Now the user wants to pass the Date Values in the prompt to Date value of BDate Dim used in another…
-
OBIEE 12c customizations don't work with SSO
I have implemented OBIEE 12.2.1.2 with SSO and for some reason all my customizations from my shared folder deployment (analyticsRes) don't work anymore. In Fact, all the graphics and images are gone and only text-based screens are visible. It's basically unusable in this state. However, if I bypass SSO and log in as…
-
Error in invoking target 'client_sharedlib_svr_tool'of make file - OBIEE 11.1.1.9.0
Hi While installing OBIEE 11.1.1.9.0 in Solaris 11 I receive the following error at 93%. Searched in community for any related posts but I couldnt find any post that is solved. If anyone could help ? Regards Vyshak
-
Filter on drill down does not work
Hi, I have a couple of analyses, one base analysis and the other one is for drill down. In the base analysis, when I try to drill down based on a column in a pivot table, the filter does not work as expected. The column is 'Month' which is one of the Selected columns in both the analyses. I have edited the formula for the…
-
Counting Instances in a Column
Hi. I was given a very useful formula in Excel that I am trying to replicate in OBIEE. In short, it counts (attaches the value 1) to every discrete instance in a column. In the case I'm working on, I have a long list of dates and countries. I need to isolate the countries as instances - so in 2010 we had 48 different…
-
Unable to find BI publisher tab in Excel 2016
Summary Unable to find BI publisher tab in Excel 2016 Content Hi All, i had install bi publisher plug-in for creating rtf template in Word. i could access and work BI publisher tab in Word easily. now i need to create some templates in excel format but unable to location bi plug-in there in excel. please find below, .exe…
-
String Functions in RTF template is not working in our EBS environment.
Summary String Functions in RTF template is not working in our EBS environment. Content Dear Experts I am having an issue with XML Publisher in EBS where I need to build an RTF data template to sit over seeded XML produced by the Oracle Price Book. Within this template I have a need to only display certain rows using an if…
-
如何解决在ODVD上安装高级分析失败的问题
Summary 如何解决在ODVD上安装高级分析失败的问题 Content 我在windows10系统上安装DVDesktop-12.2.3.0.0版本后，安装高级分析时总是失败。 错误提示如下： trying URL 'http://cran.us.r-project.org/bin/windows/contrib/3.1/timeDate_3012.100.zip' Content type 'application/zip' length 807624 bytes (788 Kb) Runtime exception caught mainNoExit java.lang.RuntimeException: Script…
-
Drilling on column value causing BIServer crash
Obiee Version: 12.2.1.2.0 We are facing weird issue where when performing drill down operation on any column value , BI Server is getting crashed. Screenshot : Since the error showed it was related to network , i tried to check the connectivity of BI Server port to the server by telnetting it. After 30 secs of showing…
-
How to impliment this in OBIEE-Change OBIEE generated query
Hi Experts, We have Dimensions D1 and D2. Fact F1. D1 and D2 are joined to F1 and confirmed dimensions. 1. D1 to F1 left outer join 2.D2 to F1 is inner join. When we apply any filter on D2 then the left outer data(i.e. all data from D1) is not appearing in report.Because where clause apply at end of query. How to design if…
-
Invoke SOAP Webservices in Data Sync
Summary Invoke SOAP Webservices in Data Sync Content Hi, Good Morning...!!! I have a requirement of calling a SOAP Web Service (with parameters) and load the data in local oracle DB using Data Sync. I haven't found any related documents regarding web service call in Data Sync. Kindly help me on this whether it is possible…
-
Page Break for Heading & Sub Heading
Summary Page Break for Heading & Sub Heading Content Hello, I have output as shown in the enclosed screen shot of an XML Publisher report. As you can see the third sub heading which is Prod Main Seq : 30 is visible at the bottom of page 1. I would like to have a page break for the sub heading.I have tried as below, but…
-
How to pass parameter from one report to another report using Action Links
Hi Friends, We have a dashboard with a page, in it we have prompts and a single summary report. This summary report has an action link on an Acct number, which opens a detail report. Now, I have created new report which should open when I click on the Acct Number of summary report passing the Acct Number to new report. So…
-
OBIEE 12c Dashboard Page and Subpages
I am trying to create a consistent template across all subpages of a Dashboard Page. Has anyone figured how to move a subpage to a different Page. Copying and Pasting a subpage in catalog makes it page, losing reference to the parent page. Thanks W
-
Presentation variable and left function
Hello to all, How can I run a string function like "left" to extract only a few large ones from a slash-by-slice presentation? For example, I wrote the following: "FL_L_IN_SAP". "PARTITION_KEY" IN ('ERP _ @ {LEFT (PartitionEntity, 6)} .... But without success. Thanks a lot to everyone, Livio
