Display Oracle BI Folder Contents
There was a question in Oracle Cloud customer connect forum about fetching all the report names and report path in a given folder. It is rather cumbersome to manually list the report names and path for each and every report in a given folder. In this post I want to show you the two different […]
Load Data From Oracle Cloud ERP to Oracle EPM using PowerShell
Before we start, I am assuming that you have some knowledge of PowerShell and EPM Automate commands. I am also assuming that EPM Automate is installed on your system and that you have setup the import jobs in your EPM instance to import the data file. In this post we are looking at how to […]
Python and EPM REST APIs
One of the best things that have happened over the last few years for Oracle EPM consultants is the availability of REST APIs. I have written about it in my previous post on using Groovy and PBCS REST APIs. However, today I wanted to present my experience on using Python and EPM REST APIs. This […]
How to Pass Default Value to Date Parameters in BI Reports
Hey guys this is a quick post about how we can Set default value for date Parameter in the Data Model Pass a default value for the date Parameter while scheduling the BI Report Set Default Value for Date Parameter in BI Report Create a data model and add a parameter to the data model […]
Oracle SQL and PLSQL Beginner Resources
In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!! Oracle Dev Gym Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections: Classes: there are some really […]