Friday, August 18, 2017

Smart View Release 11.1.2.5.710

Ah, yes, another version of Smart View for Office released .. 11.1.2.5.710

I tweeted about it the other day.. the zip file here that downloads from OTN is nice enough to tell you which version you are downloading



but unfortunately after the unzip the installer still leaves you unsure as it is still the SmartView.exe



Well, onto other news.

The documentation for this version can be found here -> https://docs.oracle.com/applications/smartview/710/index.html

And let's see what new features there are

  • Change the Solve Order of Members in a Calculation
  • Calculation Trace
  • Audit Trail


Well then, all new features for OAC! Guess I know what this guy with a broken foot recovering from surgery and still not able to walk is going to be spending time doing this weekend ;)

.. a song starts playing in my head .. Are you down with OAC .. yeah you know me... might have dated myself. ENJOY!

https://youtu.be/qdeH7QhGiRg















More posts to come about this version, OAC and the Cube Designer!!
And maybe even a little DV and more


Friday, August 4, 2017

Kscope17 Gary Interviews Gary About "The SV++ Utility Ribbon"

I still enjoy being able to look back at how much Kscope each year has to offer!


This year I was asked to be interviewed at the Social Media Lounge by none other then Oracle ACE Gary Crisci, ODTUG Board Treasurer. And at the time of the interview I was not, but while at Kscope17 in San Antonio I was honored to be accepted into the Oracle ACE program! I too also volunteer with ODTUG as the EPM Community Leader. Gary C. and I talk about the Smart View ribbon utility SV++.
  • Why the ribbon/toolbar came to be
  • Where did it start from
  • What are a few features, functions, etc.
  • How can you build your own?
  • Or just download a fully developed solution here


YouTube video
https://youtu.be/B8v8KMBN8Dk
....

Sunday, July 9, 2017

Oracle Cloud ERP and Maxl?

Lately, working on being able to directly connect FDMEE to an Oracle Cloud ERP! Fun, new, different and exciting. Or nerdy geeky, you decide. But I do know that it means it is time to learn more. And post along the way to be able to help others that are also taking this journey...

Facts in this case:

-   Oracle Cloud ERP R11 (soon upgrading to R12) and we already know that there is an Essbase cube prior post
-   FDMEE on-prem 11.1.2.4.210



After finally getting the FDMEE .210 on-prem connection to our Oracle Cloud ERP source!!









I was hit with the fact that the connection type was EPM-to-EPM. What did that mean? It meant that the connection being made was to the Essbase GL cube in the Cloud ERP! Perfect!

But not so fast.


There is still work to do. Future posts on this, but I wanted to prove that it really is Essbase. And what is driving Calculations, Allocations, etc. in the ERP are being done in the cube. Those mentioned are being created via the EPM Workspace ;) and the Rule Designer! But keep in mind that these are being done against an Essbase ASO cube. There is no EAS, or as told to me (the names are [hidden]), ".. there is no outline ..". And by stated by a friend, "..if there is no outline, then it isn't Essbase.."



Now, that first statement by the unnamed makes me scrunch my face, tilt my head and shake sort of like the way that my beloved Boxer named Zeus used to do. (pictured left)

RIP buddy. I miss you and your mom misses you but not all of your dog hair .. which she said she is still finding to this day! 

How did you think that eating 11 baby pacifiers was a good idea?! 







I know, don't tell me, but I have a hunch that your furry sister Athena had something to do with it .. (pictured left)











Back to Oracle Cloud ERP.


In needing to get not only the Values and Hierarchies PUBLISHED in the ERP.
It was apparent that more of a true and full hierarchy was needed.
Similar to what we see in our EPM applications-cubes, etc.
And so, now it is time to attempt to add that to the Cloud ERP.

Once the desired hierarchy(s) are PUBLISHED in the ERP, they also need to be DEPLOYED in the GL cube as well. After the job-task to deploy is executed. This is what we see in the log.

---log#.log---------------------------------------
.
creating am with: Name: oracle.apps.financials.generalLedger.ledgers.essbase.publicModel.applicationModule.LedgerEssbaseAM Config: LedgerEssbaseAMLocal

Created Application module instance
.
PublishHierarchyVersions: Independent request for Publishing tree versions fro cubes, given COA ....
getParameterValue: Start
Trying to retrieve param key submit.argument1
Retrieved value for param submit.argument1 as: #
getParameterValue: End
PublishHierarchyVersions: COA ID : #
getParameterValue: Start
Trying to retrieve param key submit.argument2
Retrieved value for param submit.argument2 as: {name here}
getParameterValue: End
PublishHierarchyVersions: COA Name : {name here}
getParameterValue: Start
Trying to retrieve param key submit.argument3
Retrieved value for param submit.argument3 as: <Seg#>
getParameterValue: End
PublishHierarchyVersions: Segment Code : <Seg#>
getParameterValue: Start
Trying to retrieve param key submit.argument4
Retrieved value for param submit.argument4 as: <Seg#>
getParameterValue: End
PublishHierarchyVersions: Segment Name : <Seg#>
getParameterValue: Start
Trying to retrieve param key submit.argument5
Retrieved value for param submit.argument5 as: <Val>
getParameterValue: End
.
publishTreeVersions(): start
publishTreeVersions(): *******valueSetId= #    *****segmentCode=  <Seg#>  *******coaId=  #
publishTreeVersions(): *****valueSetCode= <Val>  *****SegmentName=  {name}  *****coaName=  {name}  ****** listOfInsertVersionIds=,  ****** listOfDeleteVersionIds=,<Val>,  ****** detailedValuesOnly=null

publishTreeVersions()No. of  cubes to be updated 1
.

 ++++++++++++++++++++ publishTreeVersions():::  Application / Cube being updated: [App] / [db]
publishTreeVersions():::  Building Gen2 node :all dimension Values for dimension/valusetid/segmentSeq <Seg>
####################### publishTreeVersions()::: Maxl Command execution Start at Dt Mo Da HH:MM:SS UTC YYYY########
publishTreeVersions(): Executing cmd:alter application 'App' disable connects
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application 'App' disable commands
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter system kill request on database 'App'.DB
publishTreeVersions(): Result:true
publishTreeVersions(): Waiting for requests to reach safe point.... 
publishTreeVersions(): Executing cmd:alter system logout session on database 'App'.DB
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application  'App'  enable commands
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter database 'App'.db  unlock all objects
publishTreeVersions(): Result:true
publishTreeVersions(): Connecting to Cube now .... 
####################### publishTreeVersions()::: Maxl Command execution Finished and took 123.299 Seconds. ########
replaceAliasTableName() : cube outline is opened :: otl
.
 buildGen2DetailedlevelNode() : SQL string :
SELECT  ... 
FROM
WHERE
ORDER BY
.
 buildGen2DetailedlevelNode() : Building rulesfile for dimension ...:: <Dim>
#################################### 
buildGen2DetailedlevelNode() :Building rulesfile for dimension ...:: <Dim>
End and took 0.104 Seconds############################
 buildGen2DetailedlevelNode() : Rule file name  ... :: /tmp/SEGMENT.rul
.
 ####################################
.
buildGen2DetailedlevelNode(): START Building dimension  ... :: <Dim>
#################################### buildGen2DetailedlevelNode() :Dimenstion building for <Dim> Start
############################
buildGen2DetailedlevelNode() :Dimenstion building for <Dim> End and took 3.143 Seconds############################

<CUBE>App</CUBE>
    <DIMENSION>
        <DIMENSIONNAME>
        <OBJECT_ID></OBJECT_ID>
            <VALUESETCODE></VALUESETCODE>
.
.
buildGen2DetailedlevelNode()::: Building this  version completed.
 #################################### 
publishTreeVersions():: # ::Setting the dimension : <Dim> to MULTIPLE_HIERARCHY....
publishTreeVersions():: 2 ::Setting the dimension : <Dim> as LABEL ONLY....
publishTreeVersions():  Version details ::  Tree Code: <HIER>, Version Name: <VER> , Version ID : #
publishTreeVersions(): Updating/Creating Tree-Version :: <VER>
.
Clear the Generation Names - START
Clear the Generation Names - END
Setting the dimension Generation Name as : <Dim>
Gen2 as : Tree Filter
Gen3 as : Level Code
######################## publishTreeVersions(): end incremental build for dimension start at Dt Mo Da HH:MM:SS UTC YYYY  ###########################
######################## publishTreeVersions():  end incremental build for dimension <Dim>  END and took 15.625 Seconds ###########################
publishTreeVersions() : cube outline is opened :: otl6
publishTreeVersions() : cube outline is closed :: otl6
publishTreeVersions(): Executing cmd:alter database 'App'.DB  unlock all objects
publishTreeVersions(): Result:true
publishTreeVersions(): Executing cmd:alter application  'App'  enable connects
publishTreeVersions(): Result:true
publishTreeVersions():::  Building/deleting versions completed successfully for the cube
#################################### publishHierarchyVersions() :publishTreeVerCall End and took 178.933 Seconds############################
PublishHierarchyVersions: Versions published successfully for Chart Of Account : [COA] and Segment <Dim>
Publishing versions for the [COA]  completed

Releasing Root AM...
.
---log#.log---------------------------------end---


Yes, there are many typos in the actual log file itself. i.e. fro, Dimenstion

And yes, there IS an outline!!
It says so in the log .. "cube outline is opened :: otl" and many more references of an outline. There is a rule file! .rul and the Maxl to open, edit. Set the dimension as Multiple, Label Only, etc.

Make sure to check the checkbox to Deploy and be able to see your desired hierarchy(s) in your Cloud ERP Essbase cubes.

More posts on this subject.
Stay tuned.



DOUG - Detroit Oracle User Group

After going to Kscope17 this year I came back & started a Meetup group.

The name of the Meetup is DOUG - Detroit Oracle User Group!

https://www.meetup.com/DOUG-Detroit-Oracle-User-Group-Meetup/

















This is a group for anyone interested in anything and all things Oracle, EPM, Hyperion, OBIEE, Database, Big Data, Cloud & more. All experience levels are welcome. This group was started to meet other technology enthusiasts!

If you are in the metro-Detroit area, or even just in town for any reason and we are having a Meetup. Come and join us!

...
Are you ready to #GetInvolved with ODTUG? Want to start a Meetup near you?

Learn more here -> http://www.odtug.com/page/meetup




Friday, July 7, 2017

PSA - Microsoft Add-Ins Don't Load

- PSA -

This is a Public Service Announcement to all of you with Add-Ins in Microsoft Office products. More specifically 2016 and Add-Ins that don't or will not load when opening the program application (Excel, Word, etc).

It came to my attention that the add-in utility SV ++ that is available on this blog was not loading for some users 
- thank you Kyle B. & Peter.

Seems that there was an update issued by Microsoft. It was a security related patch and the fix can be found here but the curious part is that this was issued over a year ago, and then there was another update about 6-months ago. So, not really sure why no impact then .. and now all of a sudden. But no worries, hope this fixes the issue now if you run into it.

Below is the way to solve the issue per the superuser blog:

"With this update, we changed the behavior of Excel so that it will not load certain file types (including .xlam) when they are untrusted. The easiest workaround is to find the add-in that is causing you trouble, right-clicking on it in Windows Explorer, and checking Unblock"

"An easier approach is to simply place the add-in in a Trusted Location (in Excel, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations), such as the following folder, and load it from there:
C:\Users\%USER NAME%\AppData\Roaming\Microsoft\Excel\XLSTART"


Hope this PSA helps if you run into the issue.


Again, to learn more, you can visit here

This is a message from the cloud.

Saturday, June 10, 2017

Lowest Supported OAC Smart View Version

I was very excited to start to working with OAC .. Oracle Analytics Cloud - Essbase the other day!

In a prior blog post here I mentioned that the documentation had been updated in 11.2.5.700 with a section called -> 'Smart View and Oracle Analytics Cloud - Essbase'.

I was wondering what was the minimum version of Smart View that could be used (supported) for OAC. In doing research on a slightly different topic I happened to find out the answer. That answer is OAC is supported per the documentation on an earlier version of Smart View for Office, that being 11.1.2.5.620.

Good to know that 11.1.2.5.620 is the lowest version of Smart View that Oracle supports for OAC.

Have a great weekend!

New Features
https://docs.oracle.com/applications/smartview/620/SVSTW/toc.htm#smart_view_11125620_readme_145

Friday, June 9, 2017

Getting Ready For Kscope17

I CAN'T WAIT! I CAN'T WAIT! FOR KSCOPE17

According to my countdown app or the Kscope17 app, as of today we are only 15 days, 12 hours, 39 minutes and a handful of seconds away. Or rounding up to the day, only 16 days away! Or rounded down, 15! :)

In preparation, required documents have been loaded to the site. My slides, are approximately ~77.7% done to date plus or minus a few percent ;)

Not sure I am going to have a ton of time, but excited to get deeper into OAC - Essbase Cloud Service!




I already connected and was able to connect via Smart View and 'Install'ed the Cube Designer Extension!



There is now a static fixed Ribbon that always shows when Excel opens. I have submitted an Enhancement Request to make a slight edit to this feature and turn this into a contextual ribbon, similar to the other products (Essbase, HFM, Planning, OBIEE, etc.).




This is what the actual Cube Designer ribbon itself contains




And of course, @GaryCrisci created The Beverage Company (TBC) application everyone knows and loves, Sample Basic!

Also had to add the ASOSamp to the mix and there they are below.




More to come. I have visions of OAC and posts to follow this summer and beyond!

See you in San Antonio! @Kscope17

Saturday, May 13, 2017

Oracle EPM 11g Grace Periods for Error Correction (Doc ID 1590676.1)


Actions Index - Document 1590676.1

  • Hyperion Analytic Provider Services
  • Hyperion BI+ Financial Reporting
  • Hyperion BI+ Foundation Services
  • Hyperion BI+ Interactive Reporting
  • Hyperion BI+ Production Reporting
  • Hyperion BI+ Web Analysis
  • Hyperion BI+ Workspace
  • Hyperion Business Rules
  • Hyperion Calculation Manager
  • Hyperion Data Relationship Management
  • Hyperion Disclosure Management
  • Hyperion Enterprise Performance Management Architect
  • Hyperion Essbase
  • Hyperion Essbase Administration Services
  • Hyperion Essbase Integration Services
  • Hyperion Essbase Studio
  • Hyperion Financial Close Management
  • Hyperion Financial Data Quality Management
  • Hyperion Financial Data Quality Management, Enterprise Edition (formerly FDM + ERPI Adaptor)
  • Hyperion Financial Management
  • Hyperion Installation Technology
  • Hyperion Performance Scorecard
  • Hyperion Planning
  • Hyperion Profitability and Cost Management
  • Hyperion Shared Services
  • Hyperion Strategic Finance
  • Oracle Crystal Ball
  • Oracle Essbase Analytics for HFM 
  • Oracle Financial Management Analytics
  • Oracle Hyperion Tax Provision
  • Oracle Quantitative Management and Reporting for Solvency II
  • Oracle Smart View for Office


Smart View 11.1.2.5.710 coming soon per Bug 25908011

Smart View 11.1.2.5.710 coming soon - Bug 25908011

Bug 25908011 : SMART VIEW OBIEE PIVOT REFRESH FAILED

Bug Attributes

Type B - Defect Fixed in Product Version 11.1.2.5.710
Severity 3 - Minimal Loss of Service Product Version 11.1.2.5.700
Status 80 - Development to QA/Fix Delivered Internal Platform 233 - Microsoft Windows x64 (64-bit)
Created 18-Apr-2017 Platform Version 2008 R2
Updated 25-Apr-2017 Base Bug N/A
Database Version N/A Affects Platforms Generic
Product Source Oracle Knowledge, Patches and Bugs related to this bug

Related Products

Line Enterprise Performance Management and Business Intelligence Family Enterprise Performance Management
Area Common Products Product 4407 - Oracle Smart View for Office

Hdr: 25908011 N/A OBIEE 11.1.2.5.700 PRODID-4407 PORTID-233
Abstract: SMART VIEW OBIEE PIVOT REFRESH FAILED

*** 04/18/17 12:31 am ***
Issue:
======
[Insert as Excel Table] with OBIEE Pivot or table view, which created from 
Japanese subjectarea name. 
When press the smart view [refresh] button, the following error occured.

"OBIEE:Analysis View definition has changed on the server. Please try Replace 
View option".  


But if use English subjectarea name create pivot is OK.
And If use [Insert] is OK.

Product Version:
================
OBIEE version:12.2.1.1.0 (also 12.2.1.2.0)
Smart View version: 11.1.2.5.700
Excel 2010,2007

Reproduce steps:
================
1.Create a connection with Oracle BIEE using the following URL:
http://celvpvm06089.us.oracle.com:9502/analytics/jbips

2.Using [Insert as Excel Table] insert the following pivot to Excel.
Shared folders/test/pivot/pivot1

3.Click [Refresh] button

Related Bug:
=============
Bug 25770431
*** 04/18/17 12:31 am ***
*** 04/18/17 12:34 am ***
*** 04/18/17 07:18 pm ***
*** 04/18/17 08:24 pm *** (CHG: Sta->60)
*** 04/20/17 11:23 am *** 
*** 04/20/17 11:23 am *** (CHG: Sta->80)
*** 04/20/17 11:23 am ***
*** 04/24/17 07:23 pm *** 
*** 04/24/17 07:23 pm *** 

Smart View PSU 11.1.2.5.701

Interesting to me that there is another new version of Smart View available in such a short amount of time; 10-MAY-2017. Only a few bugs fixed in this release and no new features.

Patch 25886581: Patch Set Update: 11.1.2.5.701 Oracle Smart View for Office

The next release was slated to be 11.1.2.5.710 so wondering why this made it in between.

These are the bugs fixed:

Defects Fixed in This Patch - Patch 25886581

Defect Number | Defect Fixed


  • 25851994 | After upgrading Smart View, Financial Reporting reports now import correctly.
  • 25886581 | Oracle EPM Cloud. Smart View now supports single signon across Office applications for cloud products within the same domain.
  • 22835235 | In Smart View, when the Planning User Preferences Display Setting option, Indentation of Members on Page, is set to “Indent Level Zero Members Only,” hierarchy members in the form POV are now properly indented.
  • 24483712 | The Smart View add-in no longer causes Excel to terminate abnormally when closing.
  • 25655219 | On Windows Surface Pro, Smart View no longer stops responding when right-clicking in succession on members after several zoom in operations.
  • 25740683 | Oracle Enterprise Performance Reporting Cloud. Excel and Word no longer randomly terminate when uploading or checking in a doclet.


From the list of the bugs fixed above in this PSU, I am going with Defects 24483712 & 25740683 being fixed being the main reason for this PSU.


Tuesday, May 2, 2017

SV ++ Has At Least a Few Fans

So, I wasn't sure how to take the email that I received late last week on Friday, it was a great email.

Let me share the heart of it

"... Your ribbon is fantastic by the way!
I was wondering whether this ribbon is available to purchase on a per seat license..."

The email made think, yes, that did just a little bit, to think ;)

Seriously, I was excited to know that the utility that I originally created so many years back at least had a few people out there, that (1) use it, and, (2) enjoy using it at that. That was the main reason and the purpose of WHY I created it. So that not only did I have a utility to use but that others could use it as well. I too was a Classic Add-In user and wanted to enhance the experience for any and all users, period.

When I first developed the ribbon, which was a toolbar by the way in MS Excel 2000, the Msg Box at that time stated, "This toolbar was developed with the end user in mind. The intention was to enhance the currently available Smartview functionality and ultimately the end user experience!"

Now you notice that back then I didn't know any better and spelled Smartview as 1 word, not 2. The proper way is Smart View and if you follow me on twitter @gadashek you will notice from time to time that I use the hash tag #LotsOfSmartView2Words

Back to the email. Yes, it was a very nice, flattering and humbling email to receive. I never would have thought that about 7 years ago I would develop something that someday someone would offer to pay me to buy on a per seat basis .. and a few hundred of them at that!

I did reply back to the sender after a few days. I let them know that as much as I enjoyed the email, the offer, etc.
The SV ++ utility is currently available to download for FREE.

It still is available to download here -> http://adashek-epm.blogspot.com/p/blog-page_24.html

So please, please .. please! Download the utility, use it and by all means, enjoy using it and I hope that it enahnces your Smart View experience!

Side note: The SV ++ utility still works on the latest version available in GA today 11.1.2.5.700! :)

Saturday, April 29, 2017

Essbase Was Invented by Who? When?

With a filing date of April 5, 1990 - Google Patent listing

It appears that there were co-inventors: Wesley C. Sampson & Michael J. Olan


Take a look at a few of the images! Looks like a cube to me!








Let me clear with this post. In my mind there is a difference between who invented Essbase versus who founded/established Arbor Software Corporation.


The Arbor co-founders were Bob Earle and Jim Dorian in 1991. Their company shipped the first version of Essbase (or eSSbase) Online Analytical processing OLAP software. Their company became publicly held on the NASDAQ by 1995. In 1997, Arbor acquired Orlando, Florida-based Appsource. In 1998, Hyperion Software merged with Arbor and combined the company, and renamed it Hyperion Solutions. They sold products called Essbase, Hyperion Enterprise and Hyperion Pillar. In 1999, Hyperion acquired Sapling Corporation, and added products called Hyperion Performance Scorecard and Hyperion Business Modeling. In 2000, Hyperion introduced 2 web based packaged products, Hyperion Planning (same name as today) and Hyperion Financial Management (same as today HFM) and also partnered with WebTrends Corporation along the way. In 2002, Hyperion introduced a new product called Hyperion Business Performance Management Suite. In 2003, Hyperion acquired Brio Technology (which started with DataPivot on the Apple Macintosh.. why has "Hyperion" not given love to the Mac community yet!), Data Prism as well as The Alcar Group. In 2005, Hyperion acquired Razza Solutions (today we call it DRM). In 2006, Hyperion acquired UpStream (today we call it FDMEE). In 2007, Hyperion acquired Decisioneering (Crystal Ball). And also in 2007, Oracle announced the agreement to acquire Hyperion for $3.3B.

Saturday, April 8, 2017

It's Here! Smart View Release 11.1.2.5.700

Well, just randomly today I tried the URL .. https://docs.oracle.com/applications/smartview/700/index.html

And it looks like it is available :)

The Read Me is available, let's see what it has to say.

Looks like my HFM friends are getting some new features and functionality for Journals, journals, and more journals!

New Features in this Release - Subtopics

  • Inserting Charts Based on Planning Forms
  • View Journal Reports in Smart View
  • New VBAs to Support Oracle Journals Extension
  • New HsAlias Function
  • Additional Provider Support for HsDescription
  • New Cell Styles Category for Oracle Profitability and Cost Management Cloud
  • Additional Features for PowerPoint-based Report Packages

Guess it is time to install, if I could only locate it. Everything so far takes me to downloading 11.2.5.620.


Keep looking. Oracle Docs shows .700 listed -> https://docs.oracle.com/en/applications/?tab=8

Elapsed time between that previous sentence and the next was close to 8 minutes!

Phew, that took forever. But I think that I may have finally found it on Oracle Support -> here.

Looks like I am the second All-Time to download at the time of writing this post. But also guessing that I am the 1st to Blog about it ;)

Why it says 11125000 in the file name, I still don't really understand???


Time to install!!

Downloaded Zip file. Extracted. Looks like 11.1.2.5.700, and yesterday was the day that it was packaged for GA release. Just after 8AM in sunny California.


Msg Box says it installed successfully .. and .. time to start up Excel and find out ..


Well, there it is. Oracle Smart View for Office Version 11.1.2.5.700!

Time to go take it for a test drive vvvvvvrrrrroooooomm vroom

Noticed a new section in the documentation for OAC - Essbase

Finding a new Member Name Display setting???
I don't remember this being there before.
Options/Member Options.Distinct Member Name Only



And, well, that is because that is a setting for Oracle Fusion Financials GL Essbase. From one of my prior posts -> here

On that, I am working on a follow up to the Fusion GL blog post. Continue to stay tuned.


Sunday, April 2, 2017

Smart View for Office 11.1.2.5.700

Smart View for Office 11.1.2.5.700 will be available in early April, 2017. Stay Tuned.

This is according to the Oracle Planning and Budgeting Cloud April 2017 Update.

http://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/pbcs/1704-pbcs-wn.htm#_Toc478544601

Per the Update - NEW SMART VIEW FOR OFFICE VERSION
Smart View for Office 11.1.2.5.700 will be available in early April, 2017. This version will contain new features such as PowerPoint chart support for forms, and a new HsAlias function. Additionally, it extends HsDescription function support to Oracle Planning and Budgeting Cloud. The Smart View 11.1.2.5.700 Readme, available on the Help Center, contains a complete list of new features in this version.

Saturday, April 1, 2017

Oracle Fusion Financial GL is an Essbase Cube!

Let me start by saying.
I am only slightly surprised at the time I am writing up this blog post.

Why? Good question. I found that there is little to no talk, chatter, blog, twitter, media buzz or hype about this topic.

But, back in the spring of 2007, Oracle bought a company called Hyperion or more formally Hyperion Solutions Corporation and known on the NASDAQ as HYSL for approx. $3.3B. Press Release - Oracle. Many would, can and will continue to speculate as to the answers of why. But this blog post is going to focus on one good reason as to why Oracle bought Hyperion. And this EPM guy is happy to share.. let's take a closer look.

Setting the stage and getting into the background. We are going to look into the Oracle Cloud ERP. Stop! Yes, I said ERP and NOT EPM! But please, keep reading, because I think that you as an EPM-er, just like me, will get a kick out of what I am going to share.


Basic facts. A search on Oracle.com of this phrase "Oracle Fusion Financials Release 11" returns 1 result. Huh? Stop the presses, 1 result. Not sure why.

Anyway, if you follow the link there is an Implementation Guide, wonder what is in there? Nothing I found very interesting in the "Common Implementation Guide".
Let's keep looking. And I am going to look at the "Financials Implementation Guide".

Well, look at that, in the Overview section, there is something called "Financial Business Intelligence Analytics", and has a sub-section "General Ledger Business Intelligence Analytics" .. wonder if there is more on this???

Going back to the Contents, this is interesting, "35 Define Financial Reporting", what is this?

This is it. I am hooked in. Hook. Line. And Sinker!
Like an FDMEE fish swimming upstream >o
*wink* <insert EPM joke here> *wink*

Well, and now you had me at hello .. Smart View! My dear, dear, good ole' friend. I didn’t know you also spent time with the General Ledger, ERP??!
Who is this that you have not told me about??
But even better, many of your other EPM reporting friends are here with you! Financial Reporting, Financial Reporting Workspace, Financial Reporting Studio.. tell me more!

Components

Financial Reporting Center is comprised of numerous components:
  • Financial Reporting: Financial users and analysts access live reports and books or published snapshot reports and books from previously scheduled batches in a variety of formats. Other functionality includes:

    • Refreshing report data using runtime points of view or parameters
    • Drill through capability from parents to other parents
    • Drill down to detail balances, journal lines, and subledger transactions.
  • Smart View: Financial analysts view, import, manipulate, distribute, and share data from your Oracle Fusion General Ledger balances in Microsoft Excel.
  • Account Monitor and Account Inspector: Financial analysts monitor and track key account balances in real time at every level of your dimensions and hierarchies. These tools provide multidimensional account analysis and drill down capability.
  • Financial Reporting Workspace: Reporting administrators create, open, save, and delete folders and store report objects, reports, and snapshot reports.
  • Financial Reporting Studio: Report authors use an object-oriented graphical report layout with report objects, such as text boxes, grids, images, and charts, to design reports.

Okay, so now we are done. Not yet. Although this led us to a little bit of a dead end. I am working currently on Oracle Financials Cloud Release 11. And what I just found makes me want to find out and learn more!

Wonder what is new for Oracle Applications Release 11? Video Spotlight on Financials


Am I seeing this right in the video!? Multidimensional analysis..

And at 2 minutes and 37 seconds of this video, did i hear what I think I just heard?!?! ".. these are based on multidimensional cubes.. they can be updated on demand..".

And then a minute later at 3 minutes and 30 seconds, ".. with Release 11 we are also delivering powerful modern reporting and analytics.. analytical applications for mobile devices using BI mobile app designer.."

And then we get to the "Analyze | One Location for Reporting and Analytics" at approx. 3 minutes and 55 seconds. ".. reports based on .. BI Publisher, Oracle Transactional Business Intelligence, Hyperion Financial Reporting, General Ledger Sunburst, and BI mobile App Designer.."

Also, an interesting fun fact to note. The name of the Application that is used in that video is the same as .. well .. this one! :)
Which one is that you ask since you didn't click on the link to watch the video.
That was the video for Oracle PBCS. Yes, I said. PBCS! The sample application for PBCS is called Vision.

PBCS: Vision




Fusion Financials: VISION


Well, that is fun, nice and interesting all at the same time.

But I am not easily getting to the rabbit that I am chasing.. until I stumble onto, this, the "Financial Reporting Center: How It Works". I am mentally turned around for a second because for a brief moment I forgot if I was researching an EPM something or another, and remember that I was looking into and researching Fusion Financials Cloud ERP. And notice, it uses the word "cube"!



This to me is the EPM Hyperion reporting toolset that I am familiar with, plain as day. The configuring Financial Reporting section is all of the classics that I have seen for years before, Hyperion Financial Reporting (HFR) Studio, BI Publisher, Smart View, words like Workspace.

Now, being a Smart View kind of guy. I had to see or try to see if I could see this for myself. We have an Oracle Fusion Cloud ERP, so why not try.

I already have Smart View installed, latest version 11.1.2.5.620. Now what do I need? The Configure Smart Client View for Users says that I should be able to take the Workspace URL that ends in /workspace/index.jsp and replace that ending with what I know to be the common Smart View suffix of /workspace/SmartViewProviders

And, there you have it. Open the Smart View Panel. Click on the Shared Connections. After the login. The Panel choices look like this..



I am going to pick my friend Oracle Essbase. And this is what I see..



And sorry for the blur but I have to make sure to protect the innocent.


This is only the first post of many on this topic as I have only scratched the surface.

Hint: If you now know that the GL Balances are in an Essbase cube. And you have many of the same reporting tools to use. What other shared bits are there between this Cloud ERP and the EPM world.. stay tuned!