Journals Overview During a financial consolidation and close period, when data was submitted to the system, additional adjustments might need to be entered. This is where the Journal Entry comes into the picture. We can also assign workflow and security for journals. This post will be mainly focusing on using Data Management and Excel…
If you are using a Planning application, you may need to use additional custom cubes to meet the specific business requirements. However, the number of cubes for a planning application has limitations. Let’s dig into the details in this post. The Planning application comes with two SKUs, the New EPM Planning and the Legacy…
The Clone Environment feature came to PCM first earlier this year, then it came to Planning, FCC, and other EPM solutions. In this post, let’s take a look at some migration ideas for both the on-prem and cloud solutions. On-prem LCM When talking about EPM migrations, Lifecycle Management (LCM) is commonly used for an…
Quick question, when using Smart View, from the log-in page, if you use SSO/company sign-in and have selected “Remember My Choice”, how would you go back to the original page to change the domain name and username/password? We will take a look at this situation in this post. When using Smart View to…
In EPM Planning, we can now apply cell level security (CLS). It is finally here. It is surely exciting news. The CLS can deny access to cells that a user would normally have access to due to their regular security. It is defined as an exception to the existing member security. Historical…
The September patch (20.09) releases a new dashboard version, the Dashboard 2.0. This brings the JET technology into EPM solutions. Background Info The dashboard 2.0 is available for the following EPM solutions: Planning Financial Consolidation and Close Tax Reporting Dashboard (1.0) and Dashboard 2.0 are using different backend technologies. Dashboard—Existing dashboards using Oracle ADF…
Enterprise data management has slightly different security settings comparing with other EPM cloud solutions. There are 3 levels of role access. We will take a look at these levels in this post. First Level Role – Service Roles from My Services The first level role is set up on the My Services page. When…
When deploying an on-prem Hyperion planning cube, a native Essbase cube, or refreshing planning cloud database, you may get the following Essbase error. “Cannot restructure cube. Essbase Error(1010004): Total possible blocks of database [xxx] exceeds the limit, which is [2^52], or [4.5036e+15], for each of two dimension groups.” If you check Oracle support…
When it comes to aggregation, there are a few ways to achieve this. Let’s consolidate a few options and see what are the differences and benefits among them. AGG The most common one is AGG. It consolidates the database values ignoring all member formulas. Keep in mind that it works for sparse dimensions. The…
Profitability and Cost Management (PCM) got released during the OpenWorld in September 2016 as the software-as-a-service (SaaS) replacement for its on-premises Oracle Hyperion Profitability and Cost Management (HPCM) solution. PCM is a great tool to analyze costs, revenue and profitability. We often receive questions about the similarities and differences between PCM and HPCM, and the…