In part two of this blog series, I went over using Repository, System and Presentation Variables to make reports dynamic for any series of time. In part three, I am going to talk about making reports dynamic for periods of time using built in functions within Answers itself.
While it's a lot more efficient to create Repository Variables to use in filters and prompts for time dimensions, sometimes it is simply not possible. (more...)
The Performance Analytics application is a collection of open source technologies that aids users in: identifying performance bottlenecks, identifying causes for slow report execution, discovering areas for performance optimization, and gathering meaningful insights into the health of an OBIEE environment.
This post focuses on lessons learned after a successful Performance Analytics application installation, where within one day of being operational it enabled us to identify and isolate a long-standing memory issue. Here's how.
So it’s the end of the month, or maybe even the end of the quarter. And you’ve found yourself faced, yet again, with the task of pulling whatever data will be needed to produce the usual standardized budgetary and / or finance reports. You’re dreading this as it will probably eat up most of your day just getting the data you need, combing through it to find the metrics you need, and plugging them into (more...)
OBIEE has some very powerful features and capabilities when it comes to how we visualize and present our data. There are some features which almost everyone uses (filters, prompts, rename columns ect.) and then some that are less common. In part, I think there is a lot of "noise" that surrounds the explanation of some of these features. Another reason, and probably the most likely, is that a lot of report developers may just (more...)
Last week, during a quiet working morning, my colleague Robin Moffatt sent me a link that changed my working focus for few hours.
The link was to "OBIEE 11g: Required and Recommended Bundle Patches and Patch Sets (Doc ID 1488475.1)", a document containing the latest bundle patch (patch set) available for every major OBIEE release.
He spotted that for the first time, the new bundle patch released on 17 Jan 2017 was for (more...)
Recently we have been getting lots of traction on BICS , existing OBIEE customers been asking for BICS . In nutshell :
BI Cloud Service enables organisations of all sizes to quickly and cost effectively deploy business intelligence with the simplicity of the cloud..
Silent features of BICS :
- No need of software installation
- No need of software maintenance
- No upfront costs, low monthly subscription
- Customers can get started in hours
- 100% cloud based
- Robust reporting (more...)
Oracle BI 12c has been released for some time now. There are a few changes in the way it is installed compared to the previous 11g releases. This post is about installing and configuring OBIEE 12c with detailed step-by-step instructions(Linux x86-64 in this case).
You can start with downloading the media from OTN :
1. Download and install JDK8(at least 1.8.0_40)
2. Download and install Weblogic Server
Happy New Year everyone. I wish you a prosperous 2015!
Time is passing by too fast. I had a dynamic 2014 with a couple of interesting projects. It’s not time to recap now but it is definitely time to refresh my blog.
For me with the new year comes the new beginning too. I switched from contracting to permanent job because I’ve always wanted to work for an Oracle partner in the UK with big (more...)
Sometimes it can happen that user profiles within a web catalog become corrupted for any number of reasons. In order for these user profiles to be correctly re-initialized, there's more to be done than just drop /users/JohnDoe from the web catalog.
All in all there are three distinct places which need to be cleaned:
This is really important since especially the third place contains the translation between the userid and the effective (more...)
I recently ran into the situation where the primary mount for a Linux tech account running an OBI install was just way too small to get OBIEE 184.108.40.206.140114 through.
Prerequisite check "CheckSystemSpace" failed.
The details are:
Required amount of space(17499.766MB) is not available.
So with a bit of hacking I got around it by displacing the ./patch_storage directory and forcing opatch to stop doing a file system check (basically no (more...)
Among the questions I receive and that frequently come up on OTN, treated in blog posts etc. are questions pertaining to: How do I change a part of the GUI of OBIEE? Now in this post you'll find the answer to that specific question, but the point here today isn't simply to say "do X in Y", but rather "how do you get to know that you need to change X in Y?".
by Victor Fagundo
The argument over why Businesses should abandon Excel in favor of more structured tools has been raging for as long as I have had more than a casual exposure to Oracle products. From the standpoint of an IT user Excel appears to be a simplistic, flat-file-based, error-prone (more...)
Not too long ago Oracle released Oracle Business Intelligence Enterprise Edition (OBIEE – 220.127.116.11.0) and Oracle Business Intelligence Applications (OBIA – 18.104.22.168.1) on version 11g. As you might know, OBIA is basicly an addition to the OBIEE where you get
This MOS Note will help consultants to find the exact Version and Patch level for installed components. This is very useful when you are logging an Oracle Service Request.
OBIA: How to Find Software Versions and Patches in an Oracle Business Intelligence Applications Environment? [ID 1519745.1]
Since a few months, a new book has appeared in the Oracle Business Intelligence landscape. This is good news for the Oracle BI community because it gives us a new middle of communication and discovery. The book provides a more comprehensive approach that articles or blogs and gives a privileged and direct access with the [...]
People love charts and graphs. They are intuitive, less intimidating (compare with big fat spreadsheet) and more informative. However, every now and then, I've seen people force data into unsuitable charts, not for revealing business insight purpose but for just having some color and graph on their BI reports. In those cases charts provide no value add but duplication or confusion, in terms of analysis. In this post, I will examine a few OBIEE chart types which I believe are important but sometime not used in the most appropriate way by end users.
Lines work better than any other means to make (more...)
If you are not going to use RTD (Real Time Decisions) uncheck the box during installation:
This avoids extremely difficult discussions with Oracle over the license fee.
Till Next Time
We had to do a POC on some MS-SQL data. Instead of bringing an extra Oracle DB we used an existing MS-SQL instance.
1. Create a repository database:
We called ours “Repositories”
2. Enable case-sensitive collation
ALTER DATABASE Repositories COLLATE Latin1_General_CS_AS
3. Enable Row versioning
ALTER DATABASE Repositories SET READ_COMMITTED_SNAPSHOT ON
4. Allow TCP/IP access to the database:
(Bounce the service if you changed it!)
4b. If you have a firewall running check if the ms-sql port is open (1433 for a default instance)
5. Create a user (fi: REP_OWN)
6. make the default database repositories:
7. Set (more...)