-
OBIEE Column Width problem in PDF Exports
There are many limitations to controlling what an Analytics-to-PDF export looks like. I just wanted to share a solution to a very specific problem that was a result of my own habits. I work in 11.1.1.9.5 and frequently use html to "stack" columns, in order to reduce overall width and white space, as shown in the…
-
tracking employee immunizations
Is there a way in Peoplesoft to track employee immunizations, or would this be a feature clients would have to develop? In HCM I found the following: Workforce Administration / Personal Information / Medical Section Data, but this only allows me to enter a note for an employee. Is there any kind of medical tracking of…
-
BIAPPS with ODI12C OR BIAPPS new version release any update?
Hi Team, Does any one has any update the BIAPPS new version? will it support ODI12C?
-
ODI Client Setup
Hi Team, I have installed ODI 11g on the Windows 2012 server. But if we want to develop any interfaces or some other, Our developers always connect to ODI studio in the Server. Instead of that is there a way we can install the ODI studio in the Developers machine/system then start building the interfaces from…
-
OBIA 7964 WITH OBIEE 11.1.1.9.0
Hi Experts, Our operating system expiring in few months i.e windows 2008 --> we wants to move windows 2012 R2 we have to install software freshly. Our current versions in windows 2008 Oracle Business Intelligence Applications 7.9.6.4 Data Warehouse Administration Console 11g (DAC) version 11.1.1.6.4.x MS SQL Server 2008…
-
OBIA 11.1.1.10.2 - Payroll data is not populating into warehouse
Hi @Sheikh Zakirulla and @Venkata Yaswanth Ramisetty I am encountering the same issue with payroll data as you mention in this post. can you please help out on this. OBIA 11.1.1.10.2 HR payroll configuration issue I have configured on OBIA 11.1.1.10.2 HR analytics with Oracle EBS 12.1.3 as a source. After completion of…
-
OBIA 11g - how to run full load for HR load plan only
Hi All, I configured OBIA 11.1.110.2 Financial and HR analytics and the source system is EBS R12. created 4 separated loads for each analytics as below 1. Financial domain only 2. financial SDE and SIL 3. HR Domain only 4. HR SDE and SIL Kindly advise how to run a full load for HR analytics?? is there any impact on finical…
-
OBIA Configuration
I have a client that has a possible requirement for Initiial Extract Date. Can you configure separate Applicaitons (financials, projects, etc) to have different Initial Extract Dates(i.e. Financials pulls in 3 years worth of data, and Projects pulls in 4)?
-
Inline Prompt Issue
Hi, I was trying to display an inline prompt on top of an analysis and it works fine using Presentation Variable but if the Prompt is not selected then it leaves the variable name as is "@{PTable}" which Users dont want so is there a way to not show anything if not selected OBIEE Version: 12.2.1.3.0 Thanks, Kash
-
Unable to upload RPD in OBIEE 12c
Hi, We are using OBIEE 12.2.1.3.0, the issue is we are unable to load new RPD using uploadrpd command. 1) All BI servers are up and running. 2) command used C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bitools\bin>datamodel.cmd uploadrpd -I [RPD path \Test.rpd] -U weblogic -P PW -SI ssi there is no error seen…
-
Identifying Reference Designators for items in ECO pending state
Hi, I am generating a report to access the reference designator for an item in ECO pending state. I am able to pull the latest revision for the item but between EGP_Components _B and the EGP_Reference_Designators there is only the component_sequence_id that links between the two tables. However linking just by this id will…
-
Cannot load metadata into Hyperion Planning using ODI 11.1.1.7
Hi Gurus, I have a problem with loading MetaData into Hyperion Planning 11.1.2.4, i use ODI 11.1.1.7, scenario compled with status good but into logs i see error, That's the error message: Cannot load dimension member, error message is: RemoteException occurred in server thread; nested exception is:…
-
How to print special symbols in RTF template BI Publisher
Good day! Tell me how to correctly print special characters in the template BI Publisher (format: RTF). From Oracle database you need to display in the report for example"$". As the sign is stored in the database in UNICODE?
-
BI APPS will support ODI 12C?
Hi Team, Out team would planning to have the BI APPS application before wanted to know whether ODI 12c support BI APPS ? Please confirm, if not then what we have to do . Currently our project using ELT as the ODI12c. Thanks,
-
OBIEE CSV Export file cannot be found
I run a report in OBIEE (12.2.1.3) and when I export the file as CSV, I get the message that the file has been exported but neither I get the message on the bottom of the browser (Chrome) nor do I see it in my "Downloads" folder... Anybody has any ideas?
-
DAC (OBIEE) Execution plan start issue with Indices
Hi All, I am new to DAC environment, when i start execution plan it is getting failed with the following error. Error while loading nodes. Error while loading nodes.com.siebel.etl.database.DataSourceNotFoundException: Error while executing :SELECT COUNT(*) AS COUNT_RESULT FROM USER_INDEXES WHERE INDEX_NAME =…
-
Unable to Install DVML
I installed Oracle DVD successfully but when trying to install DVML it is saying unable to download file even though Internet connection is there and I am able to access the https://oss.oracle.com/ from web browser. Also, I downloaded the https://oss.oracle.com/DVML/DVML-1.0.0-win.zip but that file does not open. Could…
-
Export of entire OBI dashboard fails on first attempt
When exporting the entire dashboard to Excel in OBIEE, the Excel file does not include all the rows on the first attempt. The dashboard has 4 tabs and one of the tabs is missing rows. When the export is retried it succeeds. What could cause that?
-
OBIEE 12c Access to Mobile App Designer
Hi All Having an issue accessing Mobile App Designer through OBIEE 12c home page and url(http://ip-address:port/mobile/ ). Error is Unauthorized Access: Either you do not have the privilege, or you have not signed in. I have edited Managed Privileges - Access to Mobile as specific users and roles but no user can see…
-
An error occurred while trying to generate drill down query
Hello again, this question is about the drill function inside a BI Dashboard. The following error is raised, if the dashboard contains more than 9 dashboard prompts and the user tries to drill down: Error Codes: OAMP2OPY:E4BHSJTH:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PAn error occurred while trying to generate drill…
-
OBI 12c pivot table excel export
Hi there! As we recently moved from the (not longer supported) Oracle Discoverer to the BI Suite 12c, I wanted to ask if there is any way, to get the old behavior of exporting pivot tables to excel sheets. While the excel export itself is working as expected, I'm missing the advanced features in the generated sheet, like…
-
DAC - Execution Plan, Subject Area, Task Group and Task
Hi Everyone, I am not sure if I am asking my question in the correct place.If so, please let me know where I should ask it. I am new to Informatica / DAC and trying to better understand our main Execution Plan. In our DAC, we have some Execution Plans, many Subject Areas, Task Groups and Tasks. Is there a way, from SQL, to…
-
Oracle BI Analysis not in TOP function union IS IN TOP 10
Hi! I have a requirement to see top 10 Balances Cost Center wise with sum of other remaining records AS "Others". To fetch top 10 record i have used filter IS IN TOP 10 function. now i want to add Others as a sum of all remaining records. Scenario can be seen in the attached image. Regards,
-
Date Column when exporting to excel changing to previous day in OBIEE 12C
In OBIEE 11g i did not specify a default timezone tag in instanceconfig.xml then analysis export is shown date column as for example 01/01/1957 12:00:00 AM for the same case in OBIEE 12C analysis export is showing 12/31/1956 7:00:00 PM but in OBIEE 12C results it is showing correctly as 01/01/1957 12:00:00AM.How to fix…
-
Filling CSV Files
Hello Everyone Kindly if anyone has information on filling CSV files specially the below two as i'm not able to find anything on the internet file_fa_category_segment_config file_fa_location_segment_config for OBIA 11.1.1.9.2 Thanks
-
Can data filters applied in application roles overwrite the data filters applied at content level of
I have created a session variable and used this variable as filter condition in content level of logical table BMM level . Create an application role and used another session variable in data filter on the same logical dimension table.For example w_gl_segement_d is the dimension table then content level filter condition is…
-
LinkedIn Lead Gen Form
Hi, can you help me please ? I instaled the LinkedIn Campain Manager app, then select the fields (credentials, LinkedIn Lead Gen Form, the mapping and the sync frequency, sync until) and saved, the message is the next: Right! Configuration saved correctly The wrong is the on run test: The message is: Error! Error:…
-
In ODI sde phase dimension and fact stage is independent of each other but still in load plan they r
in ODI SDE is dependent on source system , dimension and fact stage is independent of each other but still why out of the box load plan run these dim and fact stage in serial ?
-
Purchasing Order
Hi When I try send to approve a purchase requisiton it show me a next error "FRM-40202 field must be entered" someone know why its ? Regards
-
UNION OBIEE 11G- 2 rows
Hi The image below shows how the union is done- the final result is creating 2 rows for that specific order I am filtering on my reports and I need the order channel to be on the same row as the rest- I tried creating additional column by adding result column and use the MAX(saw_2 by saw_y) etc but did not work- any idea…
