-
How to fetch values in OTL fast formula for custom time layout
How to fetch values in OTL fast formula for custom time layout?
-
Help with added column in obiee 11g
Hi The subject area I am working with does not have quota so I need to create a new column in my analysis and have the quota in it so I have created a case statement to say that if region is NAMER then 1000000 when region is EMEA then 2000000 etc and that will display a number beside each region if I have 2 columns…
-
Custom Grand Total in Oracle Analytics
Hi There, I have a requirement like we have to calculate custom grand total in report level. Example: I have 5 members ,spend and visit for corresponding members. At row level we are calculating spend/visit, but need to calculate [sum(spend per visit)/ no of members] at grand total level. Please help me, can we do this…
-
Pay Balance Measure domain mapping in BIACM for OBIA 11.1.1.10.2
Dear Experts, I am configuring OBIA HR Analytics and I got stuck in HR Payroll where I need do mappings in BIACM for Payroll balkance measure. There are 140+ Source domain member to be mapped with around 40 Target domain members. Client is not aware about the list of source domain members and they don't have idea how they…
-
Meaning of system columns
Hi All, I have been trying to understand the meaning/purpose of a few system columns in the data warehouse. Particularly: EFFECTIVE_FROM_DT, EFFECTIVE_TO_DT, SRC_EFF_FROM_DT, and STC_EFF_TO_DT. I already reviewed https://docs.oracle.com/cd/E25054_01/fusionapps.1111/e16816/namingconv.htm (section 4.6) ... but, still can't…
-
Need to call .env file in xml bursting file
Hi Team, I need to call .env file variable inside .xml file (Bursting file). I'm not able to call .env file inside .xml. Is there any way to call .env file variable inside .xml file. This .env file is not system environment file it is an user created .env file placed in an particular path in database. Is it is mandatory to…
-
preview failed error at time Generating report using BI publisher Desktop
I typed in the following statement <?import:file:D:///PMAR2/cover_rst.rtf?> <?start:body?> Page 1<?call@inlines:cover?> <?end call?> <?end body?> and then clicked on pdf generation link available under the preview tab in bi publisher add-on. ConfFile:…
-
Analysis_Last 10 days Update
Hi every one, I have created a Dashboard in OBIEE which contain 5 analysis. I need to have all the updated information for last 10 days. Which solution will you suggest me? I have used filtering option on Time filtering (Order by last 10 days) I am new to this amazing BI Application. Please Help me to grow:-) Thank you so…
-
OBIA 11.1.1.10.2 HR payroll configuration issue
Hi Experts, I am working on OBIA 11.1.1.10.2 HR analytics OOTB data load with Oracle EBS 12.1.3 as source and ODI 11.1.1.9.0 as ETL tool. After successfull completion of dataload, I analysed that HR Payroll reports are not showing up data. Before running the full load, I added the payroll balance to the balance group using…
-
Domain Configuration in BIApps
Hi All, While doing BI configuration for warehouse Domain values, instead of editing the OOTB source warehouse range domain values we have added new Domain value/code set. Which has resulted in multiple warehouse domain for a domain code. For E.g., For POW(Period of Work) warehouse domain, instead of editing the OOTB…
-
OBIA Environments - Looking for Recommendations
Hi, I am with a client that is looking to set up four separate environments with OBIA 11.1.1.10.2 (DEV, SIT, UAT, PROD). The have a full OBIA OBIEE(12c) stack in DEV and SIT, but they want to just have OBIEE 12c in UAT and point the repository to the SIT DW. What are the advantages of having them do a full OBIA…
-
OBIEE 11g - Line Graph - Dynamic Scale - Abbreviation Error - 1,000K
OBIEE 11g - Line Graph - Dynamic Scale - Vertical Axis Abbreviation Error Most of the time it's okay but sometimes for ranges bellow 10,000,000 the dollar values on the vertical axis are abbreviated in a very strange way. I would normally expect $6,000,000 to be abbreviated as "$6M" but instead it is abbreviated as…
-
Conditional formatting on Data visualization of OAC
Hi all, We are getting requests about where to set the conditional formatting on table data for example. I am aware of this functionality in the classic view, but can t find it on data visualization Thanks
-
Oracle BI Publisher Access to Export
Hi Dear, Good day! I am working on a requirement for GDPR where it involves exporting of reports with Personal Identifiable Information. Oracle BI Publisher reports enables users to view report and export reports. The requirement for GDPR of our client states that not all roles should be able to export or download report…
-
OBIEE
This is related to OBIEE reports. Is it possible to use a text file as a paramter? Let me explain. In the report, there is an input parameter. For the input parameter, I want it to automatically open the csv file and read the account numbers. These account numbers would be selected as comma seperated values. Example if…
-
Oracle Golden Gate (OGG) details Required
Hi, We are planning to setup the OGG for BiApps of Version 11.1.1.10.2 & the Ebs source system application is on the version of 11.5.10.2. Can you please suggest which version of OGG suits for biapps Version 11.1.1.10.2 and Steps to install and configure the OGG for BiApps. Please note that, In Biapps Version 11.1.1.10.2…
-
Hide Column Based On Pivot Table Prompts in Oracle BICS Analysis
Hi! I have a pivot table and i am using "Fiscal year number" and "fiscal period" dimension in pivot table and a prompt that is "Fiscal year number". When i select fiscal year 2018 it shows record for 2018 and shows no data for 2019 and other years that is having data but does not hide those columns on the basis of prompt.…
-
Error Viewing Dashboard
Receiving a "Error Viewing Dashboard" prompt in Oracle Business Intelligence Analytics. Error code is ARTR85DS. The dashboard works when I login as the weblogic user, but when I login as normal user it gives this error. Seems to be a user permission error. But even when I give the normal user full access it still gives the…
-
SmartView Error: XML Load Error: End tag 'BODY' does not match the start tag 'hr'
Hi Team, I am getting below error message when performing Adhoc. Can someone please help me details of the environment as below. SmartView: 11.1.2.5.720 (Build 119) Thank you so much for your help.
-
AD User is not able to Edit the report after giving full control access to the report
Hello People, I am facing a strange issue in obiee 12c. I created a report using weblogic user in shared folder and after that gave the permission (full control) to a user for that report. But that user is not able to edit that report but he is able to run it. Can someone please suggest. Thanks,
-
Oracle Fusion Cloud Business Intelligence Student Guide
Hello Everyone, I need student guides for Business Intelligence of Fusion Cloud. Kindly provide me the link/source from where I can have these. Waiting for your positive response. Regards, Needy
-
DAC Issue: end-of-file on communication channel
Hi Gurus We after facing an issue in DAC were the image capture step abruptly fails by giving the following error ANOMALY INFO::: SEBL_80:SELECT SYSDATE AS CURRENT_TS FROM DUAL ORA-03113: end-of-file on communication channel Process ID: 188211 Session ID: 12805 Serial number: 22690 MESSAGE:::ORA-03113: end-of-file on…
-
OBIEE 12c: datamodel.sh updateconnectionpool doesn't work properly
Hello Experts We are facing strange problems, we have automated RPD deployment and we are using following command post deployment to update the connection pools online. datamodel.sh updateConnectionpool -C masterpassword.json -SI ssi -U weblogic -P ****** -N 9502 We are mainly facing 2 issues Issue 1: This issue occurs…
-
How to display graph and table dynamically using dashboard prompt in OBIEE 12c
Hi , below is the client requirement. Could someone let me know if this is possible in OBIEE. Dashboard prompt : Report has a prompt called Metric Report columns : Reports has a column Period(which would be a month Jan-18,Feb-18 etc) and 15 measure columns. Report contains a Line graph and table. User wants all these 15…
-
Issue after 12C upgrade
Hi Experts, Recently we have upgraded our environment from OBIEE 11g to OBIEE 12C, So here we are facing issues with data validation. For Ex: we have a report in 11g showing some 20 records then the 12C report is showing more/less no of records. We analysed and found query mismatch happening, so can you please let us know…
-
OTBI Setup
Hi, Is there any initial setup/ configuration required to access OTBI. Requirement is to able to view the standard reports available in GL, Purchasing etc.. & test with the available data in Dev instance. Thank you in advance Thanks, Sai charan
-
How to group a xml data in RTF Template.
Hi All, Below you can see the sample XML data which i need to work in RTF Template. Here i need to group a data as follow. First Group : PER_NUMBER Second Group : CATEGORY_NAME My expected result will be. i need to sum up the RUN value based on the category name and show the output for every employee. OUTPUT format will be…
-
Smart View- Error 'Invalid selection'
In smarview when trying to do the ad-hoc analysis and try to move member from POV to grid, I am getting below error message: 'Invalid Selection' Smartview version- 11.1.2.5.720 Hyperion Planing- 11.1.2.4.0.79 I will appreciate any advise on this issue. Thank
-
Install Oracle Business Intelligence Publisher 12.2.1.1.0 ( Oracle Business Intelligence Publisher )
Hi I want help to install oracle Business Intelligence Pulisher 12.2.1.1.0 in my windows 7 operating Sysem. I have already tried below Steps: 1.Downloaded BIP Sofware from edelivery.oracle .com 1.1 I have downloaded the below softwares: Oracle Business Intelligence 12.2.1.1.0 (Contain 2 zip folders) Oracle Business…
-
Hyperion Essbase Integration with ODI 12c
Hello I'm trying to do an integration in ODI 12c to load data from an Oracle database to HyperionEssbase. I am having problems with the RKM when performing the Reverse Engineering. My KM is composed of steps 1.Reset MetaData 2.Start the Reverse and 3.Set MetaData. The error occurs in step 2.Start the Reverse. The code of…
