A quick one that took a while to fix the issue, assuming it helps the needy.
The customer was running on EPBCS on version latest version. While running the database refresh it did throw the following error message,
Cube refresh failed with Essbase Cube: Cube Name,
In OCI (Gen 2) environments, you can list available backup snapshots archived by Oracle in the Oracle Object Storage Cloud.
You can then restore available backup snapshots (copy them to the environment), To restore backup snapshots in OCI (Gen 2) environments, see Restore Backup. After copying the backup, you can archive it or use it to restore the current environment by yourself. After copying the backup, you can archive it or use it to restore the current environment by yourself. With the List Backups and Restore Backup APIs, you no longer have to create a service request to request a backup from an OCI environment.
This API is version v2.
Welcome back to my Blog. Hope you find this one useful & informative.
I did present this topic in KSCOPE 21 - and as promised during the session will be posting all the programs and the code that is used during the presentation.
In this post, I will post the EPM Automate program and the Groovy Program to automate security management.
Also, you could find my presentation here.
REST API allows running the Data Management rules using the following two job type methods
Migrating
Data Maps between PBCS/EPBCS instances
This is applicable only for the data maps created by the Admins/Users, Not for the system created ones like the following
Navigate to the Tools
We all have loaded non-numeric (Text, Date & Smartlist, etc..) using the Data Management (FDMEE cloud). I thought I will reiterate the common mistakes done while loading the All data types data.
The first step to verify the Import Format is set to Multi Column -All Data Type or Delimeted- All Data Type as Numeric data will not load Date format data.
In this screenshot, i am loading the Date to the member OCX_Purchase Date
RUNBUSINESSRULE EPM AUTOMATE COMMAND
- CHANGE OF BEHAVIOR
Starting with the 21.05 update, the runBusinessRule EPM
Automate command will no longer let you run a ruleset against Planning,
Planning Modules, Financial Consolidation and Close, and Tax Reporting
applications. Instead, you should use the runRuleSet command
to launch business rulesets using EPM Automate.
If you currently use scripts that use the runBusinessRule command to launch rulesets, you
must modify them to use the runRuleSet command.
I came across a request to copy data between versions for an EPBCS application, absolutely a common request but this is for an ASO Cube. We all have done 100 times this on a BSO cube but for me, this was the first request on an ASO cube.
Let I narrate the process to copy data in an ASO cube between members of the same dimension
This blog will cover the
important changes effective from Jan or later in 2021, I will share this again….
REDWOOD USER EXPERIENCE
As part of the new Redwood experience, we are introducing the Dynamic Tabs feature only within the Redwood theme in the 21.02 update. Dynamic Tabs will allow you to open tabs on the fly, both from a list view or from an existing navigation flow tab to perform related actions. Some use case examples: view drill through from a form in a new temporary tab; view a form in design mode; open Web ad hoc from a form or dashboard; open forms from right-click menus; open dimensions on the fly to view how members are calculated.
Its
been a while I blogged due to my work schedule, but thought I will share this with
all on a great handy option that surprised me.
It’s the “Format Code” in the Calculation Manager. This is the definition from the document When you Format Code, the lines of the script are grouped together and are indented, and blank lines are removed.
To explain how this works this is my code written before formatting the code,
Note:
You cannot use this command to sort members of
Period, Years, and Currency dimensions.
This command works only for Planning.
