Oracle

Do you like being awakened by a phone call from an unfriendly manager because a system you are responsible for has failed? Do you enjoy a good old-fashioned scolding by an executive because a financial system you support is running so slow that the user community has become unproductive? Do you have so much time […]

Are your business data volumes growing rapidly? Are your business data sets becoming increasingly varied and complex? Do you get data from number of sources, and in different formats? Do you want to turn your data sets into meaningful information by taking advantage of automated data preparation and processing? Then Oracle Big Data Preparation Cloud […]

Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS) is a subscription-based service released in May 2016. There are numerous reasons why you should consider EPBCS, but I’ve outlined my top five reasons below. Value Out-of-the-Box: Oracle’s R&D spend is second to none as it competes with other SaaS vendors in this space. Customers are benefiting […]

Essbase substitution variables are placeholders that hold a value and can be passed in a calc script, load rule, reports etc. Substitution variables can be created at the Essbase server level, the application or at the database level. Forward slash / is the escape character that can be used if single quote is in the substitution […]

Oracle Big Data Discovery Cloud service is a single-tenant Platform as a Service (PaaS) offering in Oracle Public Cloud. It is a part of Oracle’s complete Big Data solution, available on-premises and in the Cloud for seamless Big Data management and analysis in any environment. Oracle Big Data Discovery Cloud Service is a set of […]

I recently wrote a blog post describing the process to create and download Oracle PBCS application SnapShots to local disks. Now I’m sharing a step-by-step look at the process of importing an application onto PBCS. In this article, I will describe how to remotely execute predefined commands to upload files and migrated Artifacts SnapShot. To […]

At Perficient, our SupportNet team uses a variety of tools for analyzing logs across the Oracle applications. There are a number of different file formats, which often makes parsing logs troublesome. We have adopted use of regular expressions to help parse the variety of formats that we have to routinely analyze. “A regular expression (regex […]

As soon as a planning application is created or a BSO Essbase cube, dimensions are tagged as either dense or sparse. The dimension of the type Account and period are tagged as dense by default and all others are sparse. A sparse dimension is one with a low percentage of available data positions filled. A […]

In my previous post, I talked about Oracle Big Data Cloud Service. Then, what is Oracle Big Data SQL Cloud Service? Like Oracle Big Data Cloud Service, Oracle Big Data SQL Cloud Service is a PaaS subscription model. Oracle Big Data SQL Cloud Service is Oracle’s breakthrough approach to simplifying access to big data sources. […]

Many shifts are happening today, with technology changing at such a pace, business users are relying on data to keep up with the industry and beat the competition. Business users are expecting more than dashboards and reports. They don’t want to be handed off with a set of reports and dashboards which are pre-built by […]

In my previous blog posts (Part 1 and Part 2), I reviewed the steps to configure the system, so it will read the bank transaction codes. Now I will review the import and upload process, which is the final step in manually loading your bank statements. The process is very simple because it is similar […]

Oracle Big Data Cloud Service is a PaaS subscription model with a pre-configured Oracle Big Data environment. This includes a complete installation of the Cloudera Distribution including Apache Hadoop (CDH) and Apache Spark. When we talk about Big Data we are often talking about massive volumes of unstructured or semi-structured data such as web logs, […]