-
Fact table data loading.
HI All , I am here posting one question about the data ware house concept I would like to know that . I am working on the OBIA 11.1.1.10.1 in this I have seen that while data is loading from source to ware house i.e in extraction of data from source and then loading the data in the ware house though the ODI .The data is…
-
Scheduled Load Plans not Executing OBIEE 11g/OBIA 10.2.
I have an environment that we have OBIEE 11g/OBIA10.2 functionality installed. The load plans execute fine when run manually, but when we define a schedule, they don't run. I have tried bouncing the servers, creating the schedule from BIACM, creating the schedule from ODI designer, and of course executing/submitting the…
-
HR self Service in OBIA
Hello, in OBIA 11g is there any subject area / Tables or reports regarding the HR self service. Thanks
-
how to integrate google map with obiee in 12c
I want to activate map option for my analyses with obiee in 12c. i have no any idea about the activation process. please help me. thanku
-
OBIEE Upgraded from 11g to 12c, the rpd of 11g is giving errors in 12c
Hi there, obiee is upgarded from 11g to 12c where 11g rpd i tried opening through 12c Administration tool, when i check the consistency it is throwing the following errors. please share your inputs to solve this issue. 38197] Data filter expression "Core"."Dim - Customer"."Hierarchy Based Login" =…
-
Obiee 12c date drop down for dashboard
Good Morning, I am trying to create a prompt that will save the current instance of my dashboard page daily . The idea is that the user should be able to choose if they want to view the current dates data on the dashboard or that of a previous day's, from dates listed in a drop down menu. I am not sure how to go about this…
-
Urgent : Excel Template is having issue with Bursting
I am having issue with BI Publisher excel template when I use the Bursting option to schedule. The same excel template is working fine for Single parameter when more than one parameter is being passed in bursting , the template is delivered partially. Otherwise the complete bursting fails for more than one parameter being…
-
Solution for 'NoneType' object has no attribute 'group'
Hello , Regarding Doc 2304033.1 the solution is https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=95035309471173&id=2304033.1&displayIndex=2&_afrWindowMod… "In a previous report of this error, the solution was to regenerate the Lineage source files and rerun the load." How exactly can i regenerate the Lineage…
-
Documentation around OBIEE HCM Dashboards like Workforce Deployment
Hi, We are in the process of loading data into the Workforce Deployment dashboard. If there is any documentation available around how the dashboard looks(various tabs) so that we can give business a feel of how it will ultimately look. Any help would be appreciated. Prachie
-
OBIEE Dashboard Prompt Variable
Hi, I have created a Dashboard prompt which gets its value from another Dashboard prompt but doesnt get updated till I click on the "Apply" button... Is there a way to have this prompt updated as soon as I select the value from the previous prompt?
-
How to Configure GCC VAT in OBIA?
Hi Everyone, I’m looking for how to inherit GCC VAT implementation from ORACLE EBS system to BUSINESS INTELLIGENCE APPLICATION (OBIA). What are the configuration steps required to be done in current OBIA system, kindly share me reference guide/link for the same. OBIA Version : 11.1.1.7.1 OBIEE Version : 11.1.1.7.1 Thanks…
-
Smart import not working
Hi, When i am trying to export for UAT environment, and import in PRODUCTION environment, it is throwing me below error. Smart Import from UAT to Production is failing . oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException:…
-
Data Load started from BIACM is failing in ODI because of Duplicate Rows and Unique Constraint.
Hi All, Greetings for the day. I am working on the Data Load for Finance Module through BIACM and it is linked with ODI already. When I am trying to do Full Load, all the tasks are executing since I am monitoring through ODI but one table has issue and it raises the below mentioned error: ODI-1228: Task…
-
How to import the Essbase cube "obiafa" from the server to Essbase studio client?
We are using OBIA 11.1.1.10.1. We are in the process of populating the Essbase cube "obiafa". ODI is pushing the data to the cube but the rules files are returning errors. I am not able to edit the rules file (in the server) bcos it tell me "need to edit using Essbase studio". How do I import this OBIAFA Essbase cube in…
-
How to add custom image on home page of OBIEE 12c
Hi All, I'm trying to place an image on the home page of OBIEE 12c. I have tried by placing the image on several location but not able to make it visible on the home page of obiee 12c. Can someone please suggest what are the config files and their location where I need to make changes and what are the locations where I…
-
Generating Level 0 members dynamically in an OBIEE 12c report
We want to know if it is possible to pull the level 0 members in a report ? We have found this blog: Oraculam: OBIEE: Generate Level 0 members dynamically for an Essbase upper level member . We tried to use the Solution 1 but we aren't able to get the syntax to work.(EVALUATE('Descendants([@{PV_Entity}],…
-
OBIA 11g ETL Load failing in ODI due to java.sql.SQLException: ORA-01427: single-row subquery retur
We are running a ETL Full Load using ODI for OBIA/BIApps, against Peoplesoft database (Source). It is failing with the below error: Is this anything to do with the Code being run against the target database or any changes to the Interface in ODI studio ? All that the Load is run is against the pre-packaged code, no…
-
add environment instance to report
Hello all, Have a client that would like to display the environment instance and/or server name on each report created in BI Answers. How do I add this information. For example , they would like to see if report was generated from test instance or dev instance, etc.
-
Help! Is it Possible to Embed Financial Reports from Hyperion FR Studios in OBIEE 12c Dashboard?
Is it possible to embed Financial Reports from Hyperion FR studios into an OBIEE Dashboard??
-
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.dat
Hello everybody, somebody asked me to develop BI Publisher report using a database template. I was able to reproduce the XLS template I used for this report. When I'm seeing the report on-line it seems we have no problems, until I change the type of output. It gives me the exception in my title. I'm using BI Publisher 12c.…
-
can we import biapps knowledge modules into the standalone odi12c
can we import Biapps knowledge modules into the standalone odi12c, if it import in any case does it will work fine. please suggest me the process. please ASAP
-
OBIEE/BI Publisher 12c - Bypass Login Possible?
I recently upgraded from 11g to 12c, and am going through testing with my end users. Apparently in 11g, my end users were able to "bypass" the login screen by using a certain URL Namely this one http://<hostname>:9704/analytics/saw.dll?bieehome&startPage=1&NQuser=<userid>&NQPassword=<xxxxxxxx> So it looks like they fed the…
-
OBIEE 12c rcu hang
when i go to config when i reach to this page and press next installation hangs what i do
-
nqserver has stopped working
hi while i am installing OBIEE 12c on windows 2012 R2 nqserver has stopped working i did what i read in websites but problem not solved please help
-
OBIEE login page is displayed after login through EBS integration.
Hi All, I have my application integrated with EBS and SSL was done but after login through EBS it is again asking for Login. I have got Doc ID 2257835.1 but in my system "In EM, in Business Intelligence > Security tab, SSO option was disabled ". So it could be some other reason for this navigation. Can you please help. My…
-
How to add a common prompt for a dashboard having two different analysis using different subject are
Hi, I have created two seperate analysis : -First analysis containing Payables Invoices Transactions Real Time, Supplier is added as a prompt here -Second Analaysis containing Supplier Supplier real Time, Supplier is added as a prompt here I created a dashboard Prompt( Column Prompt) for "Supplier" using Payables Invoices…
-
OBIEE 12c rcu
when i go to config when i reach to this page and press next installation hangs what i do
-
OBIEE 12 hang
i am trying to install obiee 12c i goto oracle_home\bi\bin\ config open and create domain when i reach to this page when i press next hangs what i do please help me
-
OBIEE 12c rcu
when i go to config when i reach to this page and press next installation hangs what i do
-
Data Lineage objects removed from OBIA RPD
Hi All - I recently completed the steps to configure data lineage for OBIA, per: https://docs.oracle.com/cd/E63231_01/doc/BIASA/GUID-8E9904B5-E498-40E7-88BB-6F36B309CF37.htm#BIASA24666. The data lineage ETL completed successfully. However, I am encountering some errors when trying to view the dashboards. I opened an SR for…
