-
BIACM Adding wrong Table maintenance task in Load Plan
Hi, We are having an issue only in production environment , where BIACM is adding table maintenance task for W_PARTY_ORG_DS in W_PARTY_PER_DS dimension group. This causes the load plan to fail, when the load plan randomly executes these SDE dimension groups in parallel. Can some experts please provide "pointers" where this…
-
Writeback functionality issue
Hi, I have enabled writeback functionality of a column in the BMM layer and deployed. Pulled this column in a new analysis. I am able to check/uncheck the writeback option from the column properties. However, I created another analysis using CREATE DIRECT DATABASE QUERY and added the same column in my sql query. The…
-
OBIEE Custom Page
Hi, I would like to create a OBIEE custom page / Dashboard which can be displayed should our ETL fails to load data into our warehouse. Any suggestions or experiences from anyone?
-
OBIA Finance Incremental Load
SDE_ORA_SLAJOURNALFACT, SIL_AR_TRANSACTION_FACT.W_AR_XACT_F interface leads to slow performance of load. The incremental load has gone from 4 hours to 10 hours. Folks Please help me out in this. Its Very urgent. Thanks Babu
-
Issue with Error() in informatica -- Need help
* 1. I have the below expression in output port: IIF(ISNULL( IN_ORG_DESC ), ERROR('ABC~W_INT_ORG_DS.csv~ORG_DESC~IS NULL FOR~'||IIF(ISNULL(ROW_NUM),'W_INT_ORG_DS.csv - ROW NUMBER '||ROW_NUM,''||ROW_NUM )), IN_ORG_DESC) * 2.The thing is, when i donot have any null values for field 'IN_ORG_DESC ' , all the rows are loaded…
-
Conditional Formatting in BI Publisher
I'm in need of converting a Crystal Check format to a check format in BI publisher. I need to know how to conditionally format a signature block to only print based on the value in the pymnt_amt field.
-
Display Custom message when we don't have data in table with include NULL in the analysis.
Hi There, Am not able to display the costume message when i don't have the data in pivot table.I have selected Include columns with only Null values in property of the pivot table.Am getting default message if i don't have the data. If i won't select Include columns with only Null values then am able to display the costume…
-
Conditional formatting not working in case of Direct Database request
Hello Experts, I am not able to use Conditional Formatting functionality in OBIEE report developed using Direct Database Request. Error code - ACIOA5LN However conditional formatting works fine when i create normal Analysis using Subject Area. Only when i try to create report using Direct database, it gives an error. I am…
-
Display all month names
Hi There, I have a requirement like within the selected Date Range, if we don't have data then also need to display the months in report. In my case i have taken Date_From - Date_To are 01/01/2017 to 31/12/2107, and i have the data in July and Dec only. But i want to see all the months which i don't have the data also.…
-
Impact of source system change for OBIA
Hi experts, We are exploring the scenario where an existing OBIA 7.9.6.x implementation has a change in its primary data source (such as moving from one ERP solution to another - potentially Oracle Fusion Cloud). Has anyone made any major changes (a replacement) to the data source of an existing live OBIA implementation…
-
W_ETL_LOAD_DATES - Prune Days
Hi All - Does anyone have clarity on the following columns in the W_ETL_LOAD_DATES table: LAST_MAX_DATE, ETL_LOAD_DATE, AND WIP_LOAD_START_DATE? I think that I may have a "fuzzy" understanding of them . Also, I am not totally clear on their relationship with the prune days parameter either. Here's my take: After recently…
-
Based on prompt selection display the reports
Hi There, I have three prompts A, B, C and 3 reports(Report 1, Report 2,Report 3). Based on prompt selection i want to see the individual report at a time by using section condition. Condition is: when i select the Prompt A value then i want to see Report 1 only.(B and C prompts defaults to All Column values) when i select…
-
Migrate Users from OBI(12.2.1.0) to Oracle Analytics Cloud (OAC)
Hi Team, Like we have Migrate option in OBIEE->Console->Security->My Realms->Migration, we export users and groups from one environment to another. Now we have a requirement of importing existing environment Users and Groups to OAC environment. How do we achieve this ! Any documentation for the same.! Regards, Naga.
-
Hide footer from first page of dashboard ?
Hi All, I have set up the footer option in my dashboard, when I print PDF it can be visible on all pages of the dashboard, even the main page in which we don't want it. Do you know how I could remove footer from this first page ? Thanks for your help
-
Urls of EM,console,Analytics
Hi I installed successfully OBI 12.2 in my laptop (Windows 7). This seems a very small one but trying hard to find what will be the URLs of Analytics, EM, Console I tried http://mycomputername:9500/analytics and http://mycomputername:9502/analytics - but not working http://mycomputername:9500/em or…
-
How to implement NOT EXISTS functionality in OBIEE 12c
Hi Experts, I am using "CREATE DIRECT DATABASE QUERY" option from OBIEE 12c to meet my requirement. My requirement : I need to identify the customers who bought product X1 from product X category and not bought product Y1 from product Y category. The data of Product X1 and product Y1 is available in the same column called…
-
Not able to use Analysis as datasource in 12c Visual Analyzer
Hi All, I am new to Visual analyzer. Trying to use Analysis as data source. I am able to create new data source and access the analysis on Select an Analysis window. It fetched the data elements too. But when I clicked on Add to Project button, it is displaying the error as "A general error was found" and the message is "…
-
MMM-YY format changing to MM-DD-YYYY format when exporting to csv
Hi, I have a field in OBIEE as Fiscal Period which will display data as 'Jan-17' but when we are exporting this to csv ,its exporting as Jan-17 but when i click on the data in csv its been chaning to '12/17/2018' which users dont like this. Is there any way to restrict that.I just wanted to display as Jan-17 in csv as…
-
How to Migrate Only RPD From OBIEE 11g to 12C
Hi, Is there any process to migrate only repository(.RPD) from OBIEE 11g to 12C. I know there is a process to migrate (Create bundle .jar file) the whole bundle which includes RPD,Catalog and security files etc but I don't want to migrate all those stuff. As we have done couple of times the whole bundle migration process…
-
OBIA Finance Anlaytics
Hello, The Current project I am working on has OBIA 7.9.6.3 implemented and the full load was run around 9 years earlier by an EP which was custom built having all the seeded subject areas from HR, FINANCE and SCM. We have custom ETL which populates almost many tables using custom workflows. Now particularly talking about…
-
Dashboard prompt performance
Hi, We have one choice list prompt that is exceptionally slow. It will take over a minute to show some values. I've tried recreating the query I expect the choice list would run but that returns the desired result in a few milleseconds. So what I would like to do in the first place is determine what is happening when BI is…
-
Apex and Obiee 11g
Has anybody used APEX to Integrate Projections into an OBIEE dashboard. Do you actually need a consultant. Any blog post?
-
Reading Siebel S_AUDIT_ITEM
Hi , We have requirement to read SIEBEL. S_AUDIT_ITEM table to capture the history of few attributes and load it into DWH. Informatica mappings issue queries with conditions like BUSCOMP_NAME='<>' and AUDIT_LOG like '%TABLE_COLUMN%' and OPEARTION_DT in between some dates. S_AUIDT_ITEM table currently has 27million records…
-
How to create a Change Capture Task in DAC
Requirement: We will store Member Details in One schema and Non Member Details in one Schema (table structure is same) We had created One Mapping and 2 Workflows respect to that mapping with different Source DB Connections In DAC Created 2 task for 2 workflows. The Tasks are running Fine when we run individually. When I…
-
How to Add New JDBC "Data Source" for DBCS in OTBI (Oracle Transactional Business Intelligence) in c
Hi, I want my "Reports and Analytics", OTBI to have a new data source which should be pointing to Database Cloud Service (DBCS). DBCS database instance is 12c version . I have the connection string from the my services for the DBCS instance. However in the Add "Data Source" option in the "Administrator" of "Report and…
-
Can we expose variable value in custom messages in obiee 11g to display load status in OBIEE home p
Hi, Can any one help in creating custom message in order to display my daily Load status in OBIEE home page menu bar ? Idea is to display the value of a variable through custom message . Thanks in advance,
-
Not able to connect/create schema using connection string and password after launching config.cmd -
Hi I have installed java version "1.8.0_151" I have installed Oracle 12c release 2 in Windows 10 PRO. Then I installed WebLogic from fmw_12.2.1.0.0_infrastructure_Disk1_1of1 which was successfully installed. Then I create repository using rcu.bat (which was also successful - Image attached) Then I launche config.cmd but…
-
OBIEE on Windows 2012/2016
Hello, Our server team is in the process of upgrading them to Windows 2012 (or 2016). Currently, they are on Win 2008. Our OBIEE version is 11.1.1.7.0 I would like to know the compatibility of OBIEE on Win 2012 (or 2016) Thanks everyone JD
-
Taleo connect client to Fusion HCM Cloud
Hi Experts, We have a requirement to integrate data from Taleo to Fusion HCM Cloud. We are using TCC client to get the data. We need to import the data to Fusion cloud. Please help me to know the feasible ways of moving a file to Fusion UCM server from TCC client. Is there possibility to invoke Fusion HDL from TCC Client…
-
OBIEE Vmbox setup
Hello, I have recently downloaded Vmbox setup for OBIEE 12c. I changed setting of VM machine to setup port forwarding so I can access my VM from my browser on my host machine. In settings-> adapter1, I am using NAT and following are the port forwarding rules I have put- Name Protocol HostIP HostPort GuestIP GuestPort BD…
