-
Need to change metadata schema password in OBIEE 11g
HI Experts, I need to change metadata schema password in OBIEE 11g for Biplatform. Could you please guide me or share any documents if you have ? Thanks,
-
UNAVAILABLE FUNCTIONS FROM BRIO TO OBIEE 12c
One problem I encountered while migrating our Brio report to OBI. There is ColMax function within Brio to return the largest value in a column of numbers. e.g ColMax (Amount, State) as Computed State City Amount Computed AZ Tucson 112 112 CA Burbank 240 240 CA Glendale NULL 240 NY New York 490 490 NY Rochester 180 490 Is…
-
BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud
Summary BIP Reports to Extract Sales Order and related fields from Oracle ERP Cloud Content Hi Experts, I have requirement to pull Sales Orders information for analytics purpose where I need to show total numbers of Sales Orders grouped by Statuses, customers, type of items, regions etc. I am looking for if there is any…
-
BI Enabled Descriptive Flexfield not showing in Project Subject Areas
Summary Trying to report on BI enabled Flexfields in Project Foundation ran all steps still not showing Content I have gone through steps of BI enabling I have enable BI for flexfields Import Oracle Fusion Data Extensions for Transactional Business Intelligence I found a note about deploying the KFF did that ...….. Re-Ran…
-
Obiee Dashboard Export Limited Only Selected Rows (seen on the page)
Hi, I have a question on obiee. When I try to export dashboard page to excel, it only download seen records on the page (like snapshot) However, when I use analysis export option, there is no such limitation. It doenload all the records. How can I solve this problem? Can you help me please. Regards, Dilek
-
OBIEE 12c with MySQL Database Connectivity
Hi All, We are having 5.7.12 MySQL Community Server is our development database where all the DW tables resides. Now, I am trying to import and develop some OBIEE reports but seems like my server is connecting to MysQL. Does anybody help me on this configuration. My OBIEE version: 12.2.1.3.0 (Installed in AWS Server)…
-
Best way to do it in OBIEE
Hello! So i have fact table with "ISSUE" with columns <date_create_issue> <date_close_issue>I have to analyze what issue opened & closed in days. In common <date_create_issue>!= <date_close_issue> and of course <date_close_issue> sometime is NULL Now i create 2 calendar alias (CALENDAR_CREATE_DATE, CALENDAR_CLOSE_DATE) on…
-
Obiee 12C rpd live copy
Hi Everyone, In 12C if I download a rpd copy using datamodel.cmd or take a copy as from online rpd using BI Administration tool is it the same? Thanks.
-
BI Publisher for-each-group skip null columns in RTF template
Content Hi All, I have a scenario in RTF template, I need to perform for-each-group based on four columns. <?for-each-group:G_ROWS;./COL1;COL2;COL3,COL4?> COL1,COL2 and COL3 can be null but COL4 will not hold null values. When I have null values in the COL1, COL2 or COL3, I need to skip that specific column in the…
-
filter data on present in data virtualization desktop
Content Dear all, how to i can filter data on present in data virtualization desktop. Regards Abdelrahman Version 12.2.5.0.0-20180829155113
-
ODI Temp Size Issue causing etl process to go in error
Hi guys, I am facing a problem guys. A particular fact had multiple updates, upto 36 million records were updated. When the ETL process executed it went to error giving the error Unable to extend temp segment by 128 in tablespace TEMP. I have tried increasing the size of TEMP but it fails again and again. My current TEMP…
-
Upgrading obiee 11.1.1.6 to 11.1.1.7, error when updating BI Domain-> INST-08066: Weblogic cluster
During the upgrade process to obiee 11.1.1.7, I encountered a problem. I was able to run the installer for 11.1.1.7 and it was complete. Then when I was running E:\OFMHomeDev\Oracle_BI1\bin\config.bat, it error out. I have attached the details screenshot and log files. Every time I tried it give slightly error which mostly…
-
More than one listener seems to stop Master-Detail events working.
I have an analysis A that sends master detail events on a channel called country_chan. I have another analysis B that listens to the country_chan and will update its display if I change to a different country on a bar chart on A. When I add another listener (Analysis C) neither analysis updates in response to changes on A.…
-
Export the Data flow
Summary Export the Data flow Content Is there any way to see the data flow structure in data diagram in Projects in Oracle Data Visualization Desktop.
-
With publisher excel addin and multisheet, chart is the same for all the sheets
Content hello, A chart is created on the layout template xls,when the data is splitted across multiple sheet, the chart is the same as the first sheet regards jm
-
Pivot table formatting question
Is anyone aware of a formatting method that would provide vertical dividers within a pivot table? I am working in 11.1.1.9.5. The horizontal line show below is simply a subtotal with a font size=0 and a bottom border. When I try that with a column subtotal, I get a column several pixels wide. (shown at right), with…
-
OTBI report not displaying correct Raw Cost for a contract
Summary Project Costing - Actual Costs Real Time does not display correct Raw Costs against a Contract number Content Hi I have built an Analysis using Projects - Cross Subject Area Analysis Real Time and have joined it with Project Costing - Actual Costs Real Time Subject Area. The Raw Cost field in Project Costing -…
-
How to wrap the table column in RTF
Content I have RTF template and generating a PDF by using this template. In the template there is table and in the same table columns are dynamically increasing. Now need to wrap the table column after 15 columns. For ex: let my table has 32 columns, first 15 columns will display first then next 15 columns and after that…
-
Drill in and Drill out
Hello, I'd like to know if there is a way to customize/define a Drill in functionality (Hierarchy) based on a specific column and values, within the OBIEE Cloud solution ? For example once i click on Itinerary than it will shows me the service provider, source and destination location ... Thanks and regards.
-
Does it require to Refresh the Physical, Business and presentation layer after any changes in Databa
Dear Experts, I am new in Oracle BI, i have encounter an issue where one fact table data was not showing in the report. later i have identified the issue which is associated with the FACT Aggr View , now Fact Aggr has been correct in database, but in Obiee its not reflecting.. my question is do i need to refresh the entire…
-
Need to understand a logic
Hello Experts, Can you please let me know what does this where condition query means:- case when not concat(DIM_USERS.USER_ID, '.') is null then 'Restricted' end = 'Restricted' and case when not concat(DIM_CUSTOMERS.CUSTOMER_ID, '.') is null then 'Limited' end = 'Limited' and case when not concat(DWF_EVENTS_SUM.USER_ID,…
-
OBIEE Visual Analyser
Hi Guys, I am exploring the BI option of Visual Analyzer. Could you please guide me the purpose of this feature and any documents where I can learn more. Thanks in advance. Regards, Farrukh
-
Query Stiching in OBIEE 12c
Dear All, I am creating report using 2 fact tables and with confirmed dimensions, when i am running the report i am getting data as inner joins of these 2 queries rather then Full Outer Join. I checked the logs and can see 2 queries of each fact in the logs , however its not showing any stitched query or full outer join…
-
Are BIP for Oracle SCM Cloud optimized?
Summary If Reports are called with input parameters, will those column be indexed for better performance Content Hi, If I create custom Data Model and Report on BI Publisher and provide input parameters like startDate and endDate where StartDate and EndDate will apply in Last Modified Date of a certain table. Will Last…
-
Dynamic repositoy variables are not being refreshed in obiee12c(12.2.1.2.0)
I created one dynamic repository variable through admin tool in obiee12c.The underline init block query is returning correct records but variable are not being refreshed.I tried to verify variable's values from the manage - > session in admin tool but there as well I noticed that variables are not being refreshed as per…
-
Keep only Specific Members
Hi All, Currently working on OBIEE 12c (12.2.1.2.0). I'm trying to allow users to 'keep only specific members' using selection steps as opposed to filter prompts. This works fine in the results screen of the analysis, but not on when ran in the dashboard. I've set the views Run-time Options to "All Interactions" within the…
-
Problem with create System DNS in ODBC 64 for BI 12.2.1.3.0
Hi, I am using Windows Server R12. I want to install bi_client_12.2.1.3.0_Windows.x64 and configure ODBC for him to connect rpd ONLINE. I installed Admin Tool - he is working ok. Now I want create odbc for him. Open ODBC64 , System DSN and ADD and select: Oracle BI Server-OBI12Client (12.02.01.03, Oracle Corporation,…
-
create a report that would give the list of reports that has that filter condition
Hi All, A user had made few changes in filters of some reports in some dashboards...what she wants now is to create a report that would give her the list of reports that has that filter condition Is this achievable? Thanks
-
OBIEE - passing dashboard prompt into multiple analysis
Hi OBIEE gurus, I am stuck on a specific problem (scenario provided below). I want to be able to pass my dashboard prompt values into 6 separate analysis. Example - users will select a "Region" in the dashboard prompt (which already has 6 states pre-set for each region in the USA) and will render 6 analysis to show revenue…
-
Replication from one OBIEE instances to another (mainly data visualization contents)
I want to replicate everything like catalog,rpd,data visualiztion (connection with password,dataset,dataflow,sequence,my folder contents of all user) from one obiee instances to another. Is there any way to replicate in real time or one time?
