Posts Tagged ‘Oracle’

Following my previous blog post on how to add a new Dimension to a Data Sync task, this post looks at how to add a Fact and perform a lookup on dimensions while loading the target fact table in a data warehouse using Data Sync. To refer to the blog post on adding a Dimension […]

In this and the following post, I will cover the steps entailed in adding dimension and fact tasks in Oracle Data Sync. The latest releases of Data Sync included a few important features such as performing look-ups during an ETL job. So I intend to cover these best practices when adding new dimension and fact […]

If you are already running OBIEE/OBIA on premises and wondering about your options to migrate to Oracle Analytics Cloud (OAC), you are not alone. Many are overwhelmed by this transition and might be asking themselves questions such as “What does it take to get migrated to the cloud? When should I make this transition? What […]

Oracle Internet of Things (IoT) Cloud Service helps you make critical business decisions and develop strategies by providing numerous applications that allow its users an inside perspective on their company’s facts and figures. Some of these applications include connecting your devices to the cloud and analyzing data and alert messages from those devices in real […]

Perficient’s Life Sciences practice regularly monitors the software release notes for several Oracle Health Sciences applications, including: Argus Safety Oracle Clinical/Remote Data Capture (OC/RDC) Thesaurus Management System (TMS) Generally speaking, we review release notes at the beginning of each month for the previous month. On occasion, there are no new releases and, therefore, nothing to […]

About EPM Automate EPM Automate Utility enables Service Administrators to automate many repeatable tasks,  including the following: Import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings Upload files into environments, list files, and delete files from the service Download snapshots, reports, and metadata and data files from the service Run business rules on data, and […]

One of the things that organizations tend to want or need during and after an implementation are application refreshes. In this blog post, I have two environments, PROD (Source) and TEST (Target), which I have developed a script to facilitate end users to refresh TEST environment. This script should be run where EPMAUTOMATE was installed […]

After completing a Hyperion build or upgrade, a logical next step is running Oracle EPM diagnostic utility validate.bat (validate.sh on Linux) to collect information on configurations, database connections, web connectivity, and product-specific tests. Each test gets a pass or fail result; failures are diagnosed to fix any underlying issues before running validate again to make […]

Perficient’s Life Sciences practice regularly monitors the software release notes for several Oracle Health Sciences applications, including: Argus Safety Oracle Clinical/Remote Data Capture (OC/RDC) Thesaurus Management System (TMS) Generally speaking, we review release notes at the beginning of each month for the previous month. On occasion, there are no new releases and, therefore, nothing to […]

Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE) allows the use of scripting in several locations: Import Event Custom Mapping Scripting allows you to work with the incoming data fields and strings to modify them as needed before the data is processed. Use of scripting at different points will allow you to take a […]

Rolling forecasts in healthcare are challenging because Key Performance Indicators (KPIs) are unique to each organization and market conditions are ever changing. MD Anderson Cancer Center (MDACC) needed a standard forecasting process, while still offering choice-based budgeting and forecasting for the various divisions and institutes.Perficient implemented a driver based rolling forecast planning application that is […]

Kscope18, ODTUG’s user conference known for providing a rich opportunity for networking and education on Oracle technologies, is just one month away and we’re excited to connect with you at the event. Perficient is proud to be a silver sponsor of Kscope18, which is being held June 10-14 in Orlando. Visit us at booth #312 […]