-
BIP reports and internationalization
Summary BIP reports and internationalization Content What is the recommended way to pass on the locale when running reports using RESTful services? I could not find any examples on how to pass on a locale in the POST message to run a report.
-
Multiple Installations of OBIEE - 11g and 12c on same Unix Servers?
Hi - Have a customer looking at a "fresh" or "out-of-place" upgrade, from 11g to OBIEE 12c. Thinking we can have both 11g and 12c in the same bare-metal servers as transition ... During my search, I saw this statement - "... you can have multiple installations of OBIEE running on the same server, but they need to be…
-
OBIEE 12c configuration
Hi, While installing obiee122120, I have come across two locations where the config.cmd present. Location1: <OBIEE_HOME>/bi/bin Location2: <OBIEE_HOME>/oracle_common/common/bin What is the difference between them? I din't find any details in Oracle regarding Location2. Can anyone please suggest.. Thanks, Anilesh
-
OBIEE 12c : Agents page is loading forever when trying to edit
Hi , we have migrated to Oracle Business Intelligence 12.2.1.2.0, all the agents moved as part of migration. Once we gave access under Manage Privalages tab. User are able to enable & run their agents. But a strange behavior is when we try to edit a Agent it taken forever to load. But this is not reported by all the users,…
-
MyAccount-Preferences-Starting Page not loading for users in obiee 12c post migration
We have many users who have customized starting page/landing page in previous obiee server. We migrated everything to obiee 12c current version. But user are seeing default page instead of their landing page. My Account->Preferences-> Starting Page: Default ( This is not default in 11g) Previous version: Oracle Business…
-
Remove full drill path from chart label
We have a dashboard that shows a pivot table and a chart that has a drill for a location. The top level of the hierarchy is the region (i.e. Asia/Europe etc) and we can then drill down through various levels down to a city and then a building. The customer is not keen on how in the charts when you drill it shows the full…
-
It takes too much time when run calculate form with yeartotal
Calculate form is running on save, it takes approx. 10 minutes to run. While it takes only seconds when I run it on the same form but with level zero members for period dimension. any help ?! Is the problem in the yeartotal member and the quarters. Note: Period dimension is a dense dimension.
-
Presentation Variable in Column Formula
Hi All. I have this requirement to show multiple values of presentation variable in separate rows in a table or pivot. For example, if I select three department names from dashboard prompt, the table/pivot will populate three rows representing a department. The column I am trying to populate is not modeled, it's…
-
BIP installation
Summary BIP installation Content Hello everyone, BIP newbie question: I have ADF application, weblogic domain, etc... I now want to embed bip reports into ADF like : http://www.oracle.com/technetwork/middleware/bi-publisher/oracle-bip-adf-integration-2549495.pdf To install BIP is it mandatory to install the full OBIEE…
-
Lower level granularity selection jumps to second view on the Analysis.
Hi, I am using SampleApp V607 which has OBIEE 12.2.1.1.0. I have a dashboard page which has a couple of prompts and one Analysis. Time prompt accepts four levels - Year (Default), Half Year, Quarter and Month. Product prompt accepts four levels - Brand (Default), LOB, Type and Product. Based on the selection, the Analysis…
-
OBIEE vs OBISA
Hello Can anyone tell me the difference between "Oracle Business Intelligence Server Enterprise Edition" and "Oracle Business Intelligence Server Administrator" I would also like to know the product that includes OBIA modules such as Financial Analytics. Does "Oracle Business Intelligence Server Administrator" includes BI…
-
OBIEE 12c - Enterprise Manager Application Role - Adding member Name and Display name mismatch?
This is a bit out there, and I tried to search but couldnt find anything. Before creating a service ticket I was hoping to see if anyone else has seen this issue. I just installed OBIEE 12c and went into Enterprise Manager -> Application Roles -> Edit Here I click on [Add] I select the user [rosem] with display name…
-
BI Publisher reports with Excel Data Set
Dear All, I have created data set with excel source.Report is working fine but I am not able spool report with parameters . Expression is getting valid successful but the same not working in report level. I have tried like G1.MTH_NAME (: Month_Name) but it is giving error. Thanks in advance,
-
BI Presentation Service
Hello, I came across some links (Sathya's Tech Blog: Oracle ADF BI Integration , https://raviteja8.wordpress.com/2015/02/07/obiee-integration-with-oracle-adf/ ) to integrate reports/dashboards/analyses into ADF applications. I was following the tutorials but trying to do that for Oracle BICS, but seems to me that only…
-
Logical drill graph level-'to': '462.660.2380485' - does not exist
Hi Experts, Getting below issue in OBIEE 11g(11.1.1.7.160719) while creating PIVOT table. " Logical drill graph level-'to': '462.660.2380485' - does not exist " Could you please help me to resolve. Regards, Pavani
-
BI Publisher - RTF Template - Auto-Merge Identical Cells
This is a BI Publisher question.
-
Number to word conversion in RTF Template
Summary Number to word conversion in RTF Template Content Hi, In a rtf template i am doing a running total, after the running total i want to show that amount in words for this i have used the below statement then it is showing in words, but i have a requirement is like before it need to show as 'Rupees' and after to show…
-
OBIEE 11.1.1.9.0 - Analytics Report issue
Summary OBIEE 11.1.1.9.0 - Analytics Report issue Content Hi all, i have a report created with the Oracle BIEE Analytics. The report works fine until i try to add a specific column. I get the error: Unable to get property 'getAttribute' of undefined or null reference. Please contact the system admonistrator The version of…
-
Sequence Generation
Summary Sequence Generation Content Hi All, I have a very weird requirement, 1. Create a sequence (Oracle Sequence ) in query template. 2. Pass sequence as parameter in ReportTrigger which will insert some data into temporary table based on key. 3. Retrieve inserted records using the key. Any ides how to implement.
-
Creating an Org Chart RTF Report -- Help!
Summary Creating an Org Chart RTF Report -- Help! Content First, thank you in advance for your help. I'm trying to create an Org Chart BI Publisher RTF (version 11.1.1.9) report and running into issues building dynamic columns. My sample XML looks like this: <?xml version='1.0'?> <query numrows="24"…
-
OBIEE 12.2.1.2.0: Presentation Layer "No Access" is not reflecting in analytics
Current Situation: - Testcase using SampleSalesLite In RPD, Presentation Layer, i have marked "No Access" to Products table for BI Developer application role. This role is a custom role, which is created through a policy called BIDeveloper and it has the below privileges. To ensure that the user is not gaining access…
-
BIEE12c --- hide the TAB page, the other TAB page shows abnormal problems
***Modertor note (Timo): User, this ins an English language forum! Please post you questions in English language.*** ______________________________________Translation via Google______________________________________ Environmental information: BIEE Version: 12.2.1.2.0 (Build BIPS-20160923092103 64-bit) Operating system:…
-
Reg: OBIEE 11.1.1.7.1 in Windows 10
Hi All, I need to install OBIEE 11.1.1.7.1 version on windows 10 64 bit machine can anyone help where I can get software for and installation steps. Thanks,
-
OID groups not mapping to OBIEE 12c application roles
Has anyone had any success with mapping ldap groups in OID with application roles in OBIEE for authorization? We are running 12.2.1.2 on OEL linux 6.8 and for some reason our LDAP group membership in OID are not mapping back to the associated OBIEE application role in Middleware even though we can see and add the ldap…
-
OBIEE12c: Formatting date mask for dd/mm/yy
Hi, I want to format a date in OBIEE answers to dd/mm/yy in the users locale. The nearest I can get is using the custom formatting mask of [FMT:dateShort] i.e (dd/mm/yyyy) in column properties -> data format. Anyone know if there is a formatting mask which formats to dd/mm/yy in users locale? Thanks
-
OBIEE 11g Agent with Invoke a Java Method not working after migrating from DEV to TEST
Hi Team, Customer created an Agent with java invoke method and it working fine with environment base (where they create agent eg : If created in dev, its working fine in dev). When they try to move dev to Test or Prod it shows error because under Agent XML it showing dev url <saw:server-jndi-url> If they modify xml then…
-
Bursting (XML Publisher Report Bursting Program) Error
Summary Bursting (XML Publisher Report Bursting Program) Error Content Hello, I am having the error below while calling the XML Publisher Report Bursting Program from a concurrent program (Report). XML/BI Publisher Version : 5.6.3 Updating request description Retrieving XML request information --SQLException…
-
how to handle Superscript in xml publisher reports
Summary how to handle Superscript in xml publisher reports Content How to Handle superscripts(a²) in XML publisher Reports, Propgram completed with warning due to this special character. Please suggest.
-
OEM BIP_cluster
Summary OEM BIP_cluster Content Can anyone please help me to understand difference between below BIP on OEM 12.1.0.5? Thanks, Shital Modi
-
Create Report - Catalog Manager in OBIEE12C
Hi ! [OS - Windows 8 | OBI Ver - OBIEE 12.2.1.0.0] [ Using Catalog manager in offline mode] Problem : It is about Catalog Manager Create Report utility. The output is not getting saved in Excel format even after selecting the Excel option. When you explicitly try to save the file in xlsx or csv format, the output in the…
