December 10, 2018

|

by: Mike Fuller

|

Categories: Analytics, Data, OBIEE, Snowflake

How to dynamically set a Snowflake virtual warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouseinstance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in one […]

October 25, 2017

|

by: Michelle Kolbe

|

Categories: OBIEE, Oracle

I have a report that works fine in OBIEE 11g but when upgraded to 12.2.1.2, it gives an error stating: [nQSError: 22025] Function TimestampAdd is called with an incompatible type. This report has a SQL Expression in a filter that states: TimestampAdd(SQL_TSI_HOUR, 4.5, CURRENT_DATE) The problem is that we are trying to add hours onto […]

March 31, 2017

|

by: Phil Goerdt

|

Categories: Exalytics, OBIEE, Oracle 12c, Tips

Red Pill Analytics recently performed the installation of OBIEE 12c on an Exalytics machine for one of our customers. There is no option to use the Domain Management Utility for installing OBIEE 12c… that’s still only capable of installing OBIEE 11g. Therefore OBIEE 12c is a manual install on Exalytics, but it’s very similar to installing OBIEE […]

March 22, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Red Pill Analytics' Tips, Tips

Let’s pretend that you need to change ports within your OBIEE 12c instance due to new applications that natively install into ports that OBIEE is running. Or maybe you want to have the ports be the same as the OBIEE 11g ports. Whatever the reason, how do we go about changing the ports within the […]

Oracle Analytics Cloud (OAC) is generally available (GA) today, and I’m excited to be included in this OAC blog hop welcome wagon. So I’m slumming it with a bunch of Essbase professionals, as you can see from the list of contributing authors below. It’s fascinating to see just how stoked the Essbase community is for […]

March 7, 2017

|

by: Phil Goerdt

|

Categories: OBIEE, Oracle 12c, Tips

Recently I had to verify the version of an OBIEE installation for a client. As I was already ssh-ed into the Linux machine, I figured there was a way to determine the version without having to log into the presentation server. Turns out, I was right, but for thoroughness sake, I’ll cover both approaches. Using […]

January 11, 2017

|

by: Phil Goerdt

|

Categories: Analytics, Data Science, OBIEE, Oracle

As I’ve been discussing in my last few blogs, it’s possible to start using OBIEE for analytics, rather than the standard operational reporting and BI that is commonplace. Data science has been quite the buzz the last few years, and no doubt about it, data scientists can bring great value and understanding to an organization, […]

0
0
without
https://redpillanalytics.com/wp-content/themes/vanguarda/
https://redpillanalytics.com/
#b63524
style1
paged
Loading posts...
/home/redpil9/public_html/
#
on
none
loading
#
Sort Gallery
on
yes
yes
off
Newsletter Input text
off
off