Parse File Names Using Regular Expressions

Recently I needed to parse a full path to a bunch of files to get just the name of the file. To do this I had to use a regular expression and some string manipulation. In doing this I found the use of regular expressions in Oracle Analytics to be very powerful and I thoughtContinue reading “Parse File Names Using Regular Expressions”

Tips and Tricks and When to Use Oracle Analytics Desktop

Oracle Analytics allows customers to get insights on data with a couple key deployment options; cloud (OAC) and on-premises (OAS). This should cover most needs, but there are a couple of specific reasons for a desktop version. First, if you just want to try things out you can download the desktop version. One great wayContinue reading “Tips and Tricks and When to Use Oracle Analytics Desktop”

Show the Latest Data

Sometimes you need to just show the latest data. This is often the case for metrics like inventory or some percentages where adding things up just does not make sense. Most analytic tools like Oracle Analytics allows authors to pick from various aggregation methods as a solution, but when building a project you don’t alwaysContinue reading “Show the Latest Data”

Be ‘Responsive’ to a Point

By default Oracle Analytics data visualization projects are responsive by default and this is great so authors generally don’t have to worry about device, device size, or screen resolution. Right? Above is an example of some to the beautiful screenshot I see on social media showing off an authors work, but this sort of layoutContinue reading “Be ‘Responsive’ to a Point”

Setting the PORTALPATH for OAC 5.5 and Above

For years our Oracle Business Intelligence customers have been using an RPD session variable to redirect end users to a specific dashboard when they hit the URL for their analytic platform. https://hostname/analytics This has served us well but fast forward to Oracle Analytics and this approach needed to change.  Starting with OAC 5.5 this isContinue reading “Setting the PORTALPATH for OAC 5.5 and Above”

Oracle Analytics on Chrome 80 (now 84)

Google had put the brakes on this update back in March but now it is back, and rolling out as we do this update. All the same details below still apply just a few months later. https://www.chromium.org/updates/same-site In February Google will roll out an update to Chrome (80) that will implement a secure-by-default model forContinue reading “Oracle Analytics on Chrome 80 (now 84)”