-
Dimensional modeling - deposit entity
Im folow bus matrix by Ralph Kimball There is 2 bank business process: - Get deposit from client in some currency - Prolong deposit and i highlight some dimensions for bus matrix: -Deposit (dim$deposit) -Client (dim$client) -Currency (dim$currency) -Product (dim$product) - cause some type of deposit we have after all i…
-
WID syncs change when FACT table updates
Summary When we update a FACt table we lose our WID links with DIM Table Content When we update a FACT table we lose our WID links with DIM Table in DVD Version 18 , Cloud
-
Maintain integrity in DIM/FACT WIDs
Summary Looking for the best way to maintain links/joins from DIM & FACT tables Content All DIM tables have a Warehouse ID number (WID). Joins are added to the Target FACT tables to link said DIM table in Data-Sync. When/If changes (Add/Drop) columns or refreshing data back to initial load status are done. This resets…
-
BI Publiisher Template Builder for 11.1.1.9 with Office 365
Summary Missing BI Publisher add-in menu option after Installing Template Builder for 11.1.1.9 on Office 365 Content My application is OTBI 11.1.1.9. My OS is Windows Server 2016 Datacenter. My MS Office installation is Office 365 32-bit, downloaded and installed today (Monday 5/27/2019). After downloading and installing…
-
OBIEE 11g: changing the default line width in graphs to 1px
I need to change the default line width in OBIEE 11.1.1.9 line graphs to 1px. I have seen the question answered in several places, but the answers don't work in our installation. This post says to edit the file “..\Middleware\Oracle_BI1\bifoundation\web\msgdb\s_blafp\viewui\chart\dvt-graph-skin.xml”, but I do not have an…
-
Fusion ERP data in DV
Content Hi , I see only the seeded oracle subject areas in Fusion ERP comes up in DV. But I have a custom subject area in Fusion ERP. That doesn't show up. Is there any other ways to bring in Fusion ERP data to DV because the subject areas in Fusion ERP doesn't give me all the neccessary data. I need to have my own custom…
-
Remote data connector on weblogic
Summary Remote data connector on weblogic Content Can the obi-remotedataconnector.war file be deployed on a weblogic server that comes integrated with EBS ? We have two servers running EBS. First server has weblogic integrated with EBSt, while the second server has EBS with application server, no weblogic. I am wondering…
-
Create a Dashboard Template in OBIEE 12C
Dear GURUS, I am working on OBIEE 12.2.1.4. We are having a requirement where we have to create a Dashboard with a section added to it. This section contains a Narrative View/ Text View as shown below. The question is: Can we create a template for the Dashboard and save it so that whenever a Developer is going to create a…
-
OBIEE 12c how to implement case statement in Narrative view based on prompt value
Hi Gurus, We have a dashboard with a prompt that has drop down values as Daily, Weekly, Monthly, Quarterly and Yearly. Now my report is a pivot table with a narrative view. Requirement is when user selects Daily, then i need to show "Previous day" in narrative view. If user selects Weekly then narrative to show "week to…
-
Write-back Error in Oracle Analytics Cloud
Hi, We are trying to configure write-back in oacs environment and followed below link: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/deploying-write-back.html Have completed all the steps but still getting write-back error The system is unable to read the Write Back Template 'WriteBack_Template'. Please…
-
Migrating full webcat from prod to dev
Hi, We have requirement to migrate full webcat from production to dev environment. Can you please tell me what is the best way to do that. Thanks Anirban
-
OBIEE 12C Graph Display Issue
Hi, I have OBIEE 12c and applied the latest patch 29112070;OBI BUNDLE PATCH 12.2.1.3.190416 . I am still facing that the graph axis is appearing and that means i dont have flash play issue. attached is a screenshot for what is appearing where no lines or any type of line inside the graph.. I exported diagnostic file and…
-
upgrade obiee 11.1.1.7 to 12c
Hi, Can you please let us know, how to upgrade obiee 11.1.1.7 to 12c. Is there any document for That? Thanks Anirban
-
OBIEE 12c - not every charts on dashboard are displayed
We are using OBIEE 12c. We have dashboard with few tabs which contains tables and graphs (line, bar, pie charts, etc). We are experiencing issue with graph display. It happens that not all graphs are displayed. And it is not stable that always same graph is not displayed. Have you experienced anything similar? Any…
-
Error!! Could not deliver the output for Delivery channel:null . Please check the Log for error deta
Summary Bursting error on EBS 12.1.3 Content Hi, I hope somebody can help me, I have a test environment, and my bursting process is not working I tried sending an email from unix and it worked echo "THIS IS A TEST EMAIL" | mail -s "Test Subject Email" dpastrana@........com I also logged in into EBS and executed a…
-
Socket communication error in obis1-diagnostic
We are experiencing that OBIEE 12c (newest patch) is down on random occasions. When it happens, OBIEE is down for a few minutes, then it gets back up. we are seeing the following message in obis1-diagnostic: [2019-05-23T12:20:15.657+01:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 170c] [nQSError: 12002] Socket…
-
OAC / DV with Oracle NoSQL?
Summary Native connectivity to NoSQL vs via Big Data SQL? Content Is there, or will there be any native connectivity to Oracle NoSQL database from OAC / Data Visualization? I understand it is possible to access NoSQL via Big Data SQL, but was hoping native connection may be possible. Thanks so much!
-
Error when importing CSV files separated by semicolon and decimal separator colon
Summary Error when importing CSV files separated by semicolon and decimal separator colon Content A customer is getting data from an external provider in the following format: * CSV file with semicolon as column-delimiter and comma as decimal separator Issue description: 1. When importing as new data set within DV the…
-
Learn new features on Oracle Analytics
Summary Please feel free to leverage self-paced learning now available for Oracle Analytics Content We are pleased to provide quick and self paced learning on Udemy, free! There are couple of courses already launched and are very well consumed by thousands of users! Thank you all for great feedback and awesome ratings!…
-
How to check reference of Physical columns in OBIEE 12c reports
Hi All, I am new to OBIEE .. Can anyone help me with the below question: How can I find the reports that has reference of a particular physical column or presentation column in obiee? Is there any way to find the report names .. Please guide.. Thanks, Anumita
-
Throws ODBC error in OBIEE?
Hi, I have an analysis with year 2018(data is present),if i open result pane in analysis it throws ODBC error.How to solve this issue? Best Regards Raviteja
-
Can we have a formula on an upper level member on ASO cube?
Summary Can I place a formula on "YerTotal" on an ASO cube Content Hi, I have a problem when we move data from Essbase to an ASO cube. The FTE data is not supposed to aggregate on YearTotal. I need to calculate the Total based on some conditions. Can I apply a formula to a rollup member in ASO?? If not possible, I will…
-
obiee 12c: dashboard date prompt - how to change date display format
HI Gurus, i have a dashboard prompt for date, right now it displays drop down values in the format "05/22/2019", how to force the prompt to display values in "05/22/19" format ? Please share any inputs. Thanks.
-
Unable to Create report using Template Builder for Word
Summary Unable to Create report template using sample xml from BI publisher 12.2.5.0 Content Hi, I have successfully created a data model using the web service of OIC in BI Publisher. I am following this article for creating the data model in BI Publisher. I am using the sample.xml generated in Data Model to generate an…
-
OBIEE 11g - Listing user's groups and application roles
Hello, We need to list specific users' assigned application roles and catalog groups. (Which groups and roles is user XXX in?) Is there an easy way to get a report like this? Thanks Hakan Tekinaslan
-
Supress 'Evaluating Condition' for conditional sections
I have an analysis that uses a bit of Javascript to refresh the analysis every minute (data is streaming into the database every minute, and I want the analysis to be on a dashboard page and refreshing frequently). That works great. Now I have placed that analysis onto a dashboard page. I only want that analysis to appear…
-
OBIEE 12c upgrade to 12.2.1.4.0
Can anyone suggest or guide me how to upgrade the OBIEE 12c version 12.2.1.1.0 to 12.2.1.4.0.
-
OBIEE12C installation on Oracle database 12.2 + , 18c as RCU
OBIEE 12.2.1.4 installation fails with the error message 64254: Encountered error: oracle.mds.exception.MDSRuntimeException: MDS-00003: error connecting to the database java.sql.SQLException: ORA-01017: invalid username/password; logon denied When RCU database version is Oracle 12.2 + , 18C installation will not succeed.…
-
Essbase Server Logs
Summary Essbase Server Logs Content Hello All, We have an issue with Essbase services, tried to start services multiple times but it did not start finally we noticed that database is down and informed database team to fix the issue from their end, but DB team is asking to show some evidence that Essbase services are down…
-
OBIEE: After migrating from 11.1.1.7 to 12.2.1.4 "UNKNOWN" datatype in aliased tables
We are in the process of upgrading from OBIEE 11.1.1.7 to 12.2.1.4 on a Linux server I've migrated my repository/catalog with the Migration Tool When I run the consistency check using the BI Admin Tool, I literally get 100's of errors with UNKNOWN datatype in my aliased tables in the physical layer. Is there an easy fix?
