Smart View in the Cloud

Paul Hoch

February 21st, 2017

EPM in the Cloud is fast becoming the new normal as Oracle continues to add to its suite of Cloud products. As companies transition Planning applications to the Cloud, they often have questions about how things like existing spreadsheets, reports, and processes going to work once they migrate.

Oracle has made migrating existing Planning applications relatively straight forward using LCM and importing applications. How about your Spreadsheets? The good news is Smart View is fully available and supported with Cloud applications. The only major difference you will encounter is that the log-in is slightly different. You will see a secondary pop-up that asks for your authentication information. Once you have logged in however, you will have virtually the same experience navigating against your cloud applications that you have in an on-premise world.

The good news is Smart View is fully available and supported with Cloud applications.

One thing that you might need to take into account is that if your on-premise solution includes “Full Use Essbase” and you have users connecting to Planning databases with an Essbase connection, that is NOT available in (E)PBCS so you will need to get used to the Planning Ad-Hoc connection instead of a native Essbase connection.

With that one caveat, you might be curious about using VBA to automate your spreadsheets or perhaps you have existing VBA automation in your on-premise applications and you want to be sure that they are supported in PBCS. The answer is, for the most part, yes VBA is supported in PBCS. The best source of information is to review the Oracle Smart View for Office Developer’s Guide. For each VBA function, the supported provider type is listed. For instance, in the examples below we set certain options. If we review the Developer’s Guide we will see the following:

And from this help document we can see that the HypSetGlobalOption is supported for the Oracle Planning and Budgeting Cloud provider.

The current version of this document is available here: and you should evaluate your current spreadsheets and code against the supported features listed in this document to make sure your transition to the cloud goes smoothly.


Paul Hoch

About Paul Hoch

Paul Hoch has over 18 years of EPM and Hyperion experience, specializing in Essbase and Planning. He has successfully completed large-scale EPM implementations for clients in industries ranging from retail to government and financial services to health care. Paul has served as solution architect and team lead for implementations and he has developed and delivered advanced team training. He also blogs and presents regularly on EPM topics, including Essbase, Planning, Hybrid Cloud implementations, PBCS, EPBCS, Smart View, Calc Manager, migrating to the cloud, and more.

Leave a Reply

Your email address will not be published. Required fields are marked *