-
Duplicated selects by iBot delivering direct SQL analyses
Hello guys, our client is using iBot delivery to export db tables (we know it is wrong idea, but client demands it). The iBots are delivering analyses and dashboards based on direct SQL. When we check V$sql_monitor, we see that session is opened, executing select. After some random time, the SQL statement is done with…
-
Filter Drop-Down Creates Count Distinct On Degenerate Dimension
I have degenerate attributes in the RPD that are not available in a proper conformed dimension. When using the drop down functionality while creating a filter on analysis with an attribute from the degenerate dimension OBIEE sends a "select distinct attribute from fact". While this make sense it is causing havoc on out DB.…
-
Can we export AD configuration using BI Application Archive (BAR) Files?
Hello peeps, I am trying to export and then import BI Application Archive (BAR) Files, but I am not able to import AD configuration. Does there is any method to import the AD configuration from existing environment to the newly created environment along with the RPD, Catalog & Security model metedata? Apart from that,…
-
Time Card Required - BI Answers
There are two Time Card Required fields in 'Manage Payroll Relationships'. They are both listed under different sections of Payment Details. I am able to find one in BI Answers to report out on but unfortunately, it is the wrong one. Can someone please direct me to the Subject Area/Folder for each one of these Time Card…
-
first day of second quarter of previous year in OBIEE
Can someone help in writing first day of second quarter of previous year..or at least first day of second quarter for current year timestamp function in OBIEE Thanks Surabhi
-
Enable Writeback based on the selections on dropdown
Hi We have a requirement like we will have a dashboard page where we will have 3 prompts with dropdown and based on those selection we have to insert data. Now we have to insert back in DB table both slected values and inserted values. I have idea like how to insert directly in DB table using writeback option, but i am not…
-
Issue in BIACM with fact group while creating load plan
While generating a load plan from BIACM getting the error : Fact table not found with fact group list =[Custom FG]for source=[EBS_12_1_3]. Can some one help me if you face similar issue? Thanks Lina
-
Incremental Load Bi Apps
Hello All, We have done the BI Apps configuration for FIN, SCM and Proc & Spend. And finished the full load and the data for these modules are populating correctly on Analytics. The issue i have is, the following loads after the full load is also taking the same time as full load which is about an hour for each module.…
-
OBIA Upgrade Path
Hello All, We are currently using OBIA 11.1.1.8.1 PB-6 with some customization in ODI. We are looking to upgrade to latest version of OBIA (which is 11.1.1.10.2 as of now) along OBIEE 12c and Database 12c. As per Oracle documentation below is the upgrade patch. * OBIA 11.1.1.8.1 - PB6 --> OBIA 11.1.1.9.2 --> OBIA…
-
OBIA: Are there advantages to using GL Detail Journal Entry posting (EBS R12) in the ETL vs. Summary
What are the differences in how OBIA works using general ledger transactions that were posted in detail journal entries as opposed to using general ledger transactions that were posted in summary journal entries?
-
Show the grand total as vertical line in bar graph
Hi, Were have a requirement like need to show the grand total also in bar graph. Please let me know is this functionality available in OBIEE or not. Thanks in Advance..! Thanks Ramesh
-
OBIEE 12.2.1.3 Upgrade Drill Back Button Issue
Hi, OBIEE Version- 12.2.1.3.0 JDK Version- 1.8.0_161 FMW Version- 12.2.1.3.0 After upgrading OBIEE to 12.2.1.3.0, while accessing drill down based reports, on clicking the second level drill down back button, the first level drill does not load. Was not facing this issue while using OBIEE 12.2.1.0.0. Making use of <a href…
-
How to Create 2 Y-Axis graphs in OBIEE
i created direct data base request and created a report. the Above graph has accrual and Member_count, my requirement is to one Y-axis should show Member_Count and 2nd Y-Axis should show Accrual as below graph Anyone please help to create 2 Y-axis graph for Direct database Request. Thank you
-
What is the highest version of JAVA that DAC 10.1.3.4.1 will support?
What is the highest version of JAVA that DAC 10.1.3.4.1 will support?
-
ODI jobs gets errored with "ORA-20000: Error creating indexes in parallel"
I am getting below error and it's random and happens for different tables in different days. any help would be highly appreciated. example : ODI-1519: Serial step "Start Load Plan (InternalID:53661525)" failed because child step "Global Variable Refresh (InternalID:53662525)" is in error. ODI-1519: Serial step "Global…
-
Fiscal Period not reading 'Symbols' in Presentation Variable
Hi All, I have an OOTB Session Variable for default current fiscal Period (may be irrelevant but could be a clue) I also have a Presentation variable for Fiscal Period. In my dashboard I have views using two subject areas (thus the need for a PV) Where the Fiscal period is 'Prompted' Reports run absolutely fine. Where the…
-
Oracle Baseline Validation Tool Licenses
Experts, do we need to procure new licensing for BVT. We are in process of upgrading from OBIEE 11.1.1.9.12 to OBIEE 12.1.2, I saw that BVT comes as part of OBIEE 12c client tools, but we are currently in OBIEE 11g and in process of upgrade to 12c. In this scenario, do we need to have licenses procured till we move on to…
-
EBS 122 Receibavles
Team Our internal EBS team mentioned that table ra_customer_trx_all and ra_customer_trx_lines_all is where the AR module tracks the items. Does any one on the forum have background to whether these details are extracted to BI reporting in the BIAPPS as part of the AR ? regards ra_customer_trx_lines_all
-
Adding a letter in "Edit Column Formula"
Hi, I was wondering if I can add a letter like a $ before or after a Formula within "Edit Column Formula" window? So for an example: Column Formula: ("Measures YTD"."Giving Donor Count Fiscal YTD") + ("Measures YTD"."Giving Donor Count Fiscal YTD") So the value should have a $ sign in it. PS: I know you can set it up…
-
OBIEE 11.1.1.7 + Office 365 sharepoint iFrame
Hi All, We want to display office 365 content on OBIEE Homepage. Is it possible to display office 365 share point content in OBIEE like iFrame. Or is there any other feature which works same like iFrame. Thank you,
-
OTBI - Count of a number field
Hi, Please, see the image below: I'm not able to get the count of the column "ID Registo". I want that for "Gestor de Conta "Sílvia Ganhão" it sums up 3, because there are 3 "ID Registo" related. The formula on the "COUNT ID Registo" is just a simple Count of the field "ID Registo", nut it gives no return value. Can you…
-
User/group creation role missing for administrator in 12c after upgrade from 11g
Dear all, I have successfully migrated the 11g environment to 12c environment of OBIEE. However after the migration the default user weblogic don't have any option to create the new User/Group permission options. i have verified the following things I checked the user permission using the weblogic console for the user…
-
When I try to access http://myservername:9502/analytics I receive "This site can't be reached".
Have this same issue with BI Publisher, Fusion Middleware, and Weblogic Console. It worked after the install, but one day later it started doing this. I have made no changes in oracle or on the windows 2012 R2 server from the time it did and did not work. Very puzzling. Thanks
-
How to stop auto run of reports in Dashboard
I am trying to find a way to stop reports from running when you first visit the Dashboard. It works when I gave a fake value to a prompt but then it returns a tacky message which I would rather not display.
-
R13 - Analytics - Getting info about Competitor in 2 ways
Hi, Let me try to explain: 1 - On Account object, we've created a child object, where we put information about the Sales Competitor object (Dynamic choice List for Competitor Name, and number and text fields; 2 - On Account Profile page we've created a Dynamic Choice List for Competitor Name that is related to the Sales…
-
Using excel from front end for reporting in OBIEE
Hi All, is it possible to use Microsoft Excel to generate report in analytics with out importing Excel file in RPD. Basically we don't want to use any connection pool in RPD related to this excel. We like to use this Excel to create graphs, tables, pivots in the dashboard. Thanks
-
OBIA Index creation parallelism
Hi, I am running OBIA on an 8 CPU DB server. THe DOP is subsequently 16. When the indexes of certain high population tables are being rebuilt, we get login timeouts of the ETL load plan. I beleive that if I can reduce the parallelism from 16 to say 8 (or so) for the indexes concerned, the issue will resolve itself. Is…
-
Analytics OTBI - Get YTD, Previous Period and Previous Year Period values
Hi, I've attached an excel with examples of what I want to achieve. In OTBI I want to achieve columns: 1 - VALUE YTD; 2 - VALUE PREVIOUS PERIOD; 3 - VALUE PREVIOUS YEAR PERIOD. For example: 1 When: jun-2018 Expected: Value of jan-2018 + feb-2018 + mar-2018 + apr-2018 + may-2018 + jun-2018 2 When: jun-2018 Expected: Value…
-
SQL Statement Execution Failed XQuery Not Supported Use XMLQuery
We are in the process of implementing NetSuite and in order to synchronize the data we are using an ODBC tool called Data Virtuality. I have been able to connect OBIEE (12c) to the Data Virtuality as an ODBC source (Import Metadata) to get the structure of the tables for modeling. However, when I go to access the data in…
-
Hi What is Oracle Road Map on OBIA release?
Hi What is Oracle Road Map on OBIA release. Last version is OBIA 11.1.1.10.x. Do Oracle have a plan for next release in Onpremise or cloud version of OBIA? Please clarify?
