Weekly Offenders – Week Ending 8/3/2017?

Introduction to Weekly Offenders

This week was so light, I thought I would wait a few days to see if we might get a few more contributions.  We finally had a few more posts, so here goes!

Weekly Offenders - Kscope17

Cameron’s Blog for Essbase Hackers

Cameron has a post about his guest post on Mark Rittman’s site.  Check out the actual post here.

EPM Junkie

Keith has a very interesting post on installing the EPM stack on Linux with SQL Server…for Linux.  What?!

Essbase Down Under

Peter continues where he left off with the REST API for PBCS.

Glenn Schwartzberg’s Essbase Blog

Glenn takes on the question of commentary in Essbase.  He uses Linked Reporting Objects in OAC.  I find it extremely interesting that OAC supports LRO’s as I thought they were being depricated.

Jason’s Hyperion Blog

Jason gives us a post about time period conversion using Drillbridge.  I need to get back to doing some Drillbridge blog posts…

More to Life…

John Goodwin shows us how to create a custom scheduler for FDMEE.  This should help with some of the shortcomings of the stock solution.

Oracle Business Analytics – Proactive Support Blog

The Proactive Support Blog has posted a variety of patches, mostly for cloud services:

The Unlocked Cube

Vijay has a post showing us how to restart the ODI Standalone Agent with a Groovy script.  Cool stuff.  Pete also contributes to the same site and has a post on JavaScript and DRM.

Be On the Lookout!

That’s it for this week!  Be on the lookout for more great EPM Blog content next week!


Weekly Offenders – Week Ending 7/22/2017

Introduction to Weekly Offenders

A bit of a light week…

Weekly Offenders - Kscope17

Essbase Down Under

Peter gives us a heavy does of the REST API in PBCS after Kscope17.

Exploits in Hyperion

Sibin has several posts this week.  He starts off with a post about digging into the XML of an LCM export.  He also tells us that UAC is very bad for a Hyperion install.  Keeping with his previous installation post, he also tells us about the dependency of IIS for EPMA.

DEVEPM

Rodrigo shows us how to install the ODI 12c Standalone Agent.

Oracle Business Analytics – Proactive Support Blog

The Proactive Support Blog has a set of OBIEE patches this week:

Woman in EPM

Opal has a quick post on how to access the OAC log files.

Be On the Lookout!

That’s it for this week!  Be on the lookout for more great EPM Blog content next week!


Weekly Offenders – Week Ending 7/15/2017

Introduction to Weekly Offenders

This week was a bit busier than last week.  We even had a few more posts about Kscope17 this week.  What new this week?

Weekly Offenders - Kscope17

Adeshek EPM

Gary has a pair of posts this week.  First, he went and started his own Oracle User group for the Detroit Area (DOUG).  He also dives head-first into the Essbase behind Oracle’s cloud ERP.

EPM Marshall

I continued my series focusing on Essbase Performance.  This week we started talking about physical vs. virtual Essbase performance.

Exploits in Hyperion

Sibin started off the week with a post about keeping your downstream systems in mind when making changes.  He then has a post re-capping his series on Universal Data Access in FDMEE.

More to Life…

John Goodwin has an excellent post showing off the new clearcube functionality in EPM Automate and the REST API for PBCS.  Finally…ASO clears can be executed via batch!

Oracle Business Analytics – Proactive Support Blog

The Proactive Support Blog brings us news of just one on-prem patch this week.  Oracle Hyperion Tax Provision 11.1.2.4.202 has been released.  Perhaps this is exciting to someone?

The blog also provides us with news of an HFM patch (11.1.2.4.205).  While a variety of new features are listed, they are generic to the .2xx series of HFM patches.  This appears to be mostly bug fixes.

Oracle – Hyperion Labs

Celvin had a busy week starting off with a re-cap of Kscope17.  He then takes a detour away from Oracle in general and focuses on an OLAP tool named Mondrian (Open Source ROLAP tool).  Pretty neat.   Finally, he also has a post about new PBCS features.  The focuses on the ability to actually get audit information from PBCS.  I just recently mentioned in a demo that we had been waiting for this…now I can demo it!

Real Tri Geek

Sarah has a pair of posts this week starting out with a post on understanding Candlestick graphs.  She continues on this theme and also tells us how to read and understand Box Plots.

Tim Tow’s Hyperion Blog

Tim tells us how to get TLS 1.2. working on Java 1.6 (the version that ships with Oracle’s EPM stack).  Pretty interesting.  For those of you wondering what TLS 1.2 is…it’s basically a more recent version of SSL.

Woman in EPM

Opal is back this week with a pair of posts.  First she has a quick tip on restarting your Essbase Cloud instance.  She finishes out our week in review with her re-cap of Kscope17.

Be On the Lookout!

That’s it for this week!  Be on the lookout for more great EPM Blog content next week!


Weekly Offenders – Kscope17/Holiday Hangover Edition

Introduction to Weekly Offenders

Last week I started by up my weekly review of EPM blogging.  There was quite a bit of content with Kscope17 having just finished up and everyone seemed excited to contribute to the community.  Between the holidays and everyone recovering from Kscope…last week wasn’t nearly as productive.  However, it was an odd week with a holiday in the middle of the week.  And luckily, Oracle had a few on-prem patching to keep things interesting.  Here we go!

Weekly Offenders - Kscope17

Adeshek EPM

Gary has a PSA for us regarding Smart View in Office 2016.  Microsoft broke something…

Cameron’s Blog for Essbase Hackers

Cameron wrapped up his coverage of Kscope17.  He takes a lot more pictures than I do…I should work on that.

The EPM Lab

The EPM Lab is a new addition to my EPM Blog List.  Jun has a post this week showing off the new Strategic Modeling portion of EPBCS.

EPM Marshall

I had a pair of posts this week.  First I wished everyone in America a Happy Independence Day.  Next, I posted my first set of actual Essbase benchmarks since releasing EssBench.

Exploits in Hyperion

Sibin has a pair post again this week.  He first discusses the configuration of FDMEE using an Oracle DB table as a source.  Next, he continues down the Oracle DB and FDMEE path by showing us how to create an import format and actually load some data into the workbench.

Oracle Business Analytics – Proactive Support Blog

The Proactive Support Blog brings us news of a few on-prem patches this week.  First, we have an update to Hyperion Financial Reports.  The 11.1.2.4.706 patch appears to solve a number of defects, but I don’t see any new functionality.  As with all future FR patches, Oracle reminds us that the desktop Financial Reporting Studio is dead.

The blog also provides us with news of an HFM patch (11.1.2.4.205).  While a variety of new features are listed, they are generic to the .2xx series of HFM patches.  This appears to be mostly bug fixes.

Oracle – Hyperion Labs

Celvin takes an in-depth look at some of the Simplified User Interface (SUI) features in PBCS.  He touches the new dimension editor and composite forms in navigation flows.

Be On the Lookout!

That’s it for this week!  Be on the lookout for more great EPM Blog content next week!


Weekly Offenders – Kscope17 Edition

Introduction to Weekly Offenders

I had a lot of luck doing a weekly update about the blogging community in the Oracle EPM space.  You may have all noticed that I had a lot less luck doing a monthly update.  I found that everyone posts too much content to keep up with doing an update just once a month.  So…back to weekly!  Now that Kscope17 is in the rear-view mirror, I can finally get back to bogging more regularly.  As part of that, the week in review is back!  To keep with the corny theme of my newly branded website, welcome to the first in a weekly series I’m naming Weekly Offenders.  For the first post back, we’ll put particular emphasis on Kscope17-related blog posts.  Let’s get started!

Weekly Offenders - Kscope17

Cameron’s Blog for Essbase Hackers

Cameron has a LOT of posts regarding Kscope17.  Thanks for the coverage!

EPM Junkie

Keith also has a lot of posts about Kscope17.  He also sneaks in a post about splitting multi-period load riles into single period load files:

EPM Marshall

I had a pair of posts this week.  First a quick wrap-up of Kscope17…and then the introduction of my EssBench project.

Eric Erikson’s Oracle HFM and FCCS Blog

Eric was at Kscope17…but instead he posted about FCCS!  Specifically, he shows us how to replace your logo.  At least he used a Kscope17 logo?

Exploits in Hyperion

Sibin has a pair of non-Kscope17 posts.  First he covers connecting to Oracle databases using FDMEE.  While on the topic of FDMEE, he also goes into importing adapters.

Glenn Schwartzberg’s Essbase Blog

Glen discusses Kscope17 while blogging about Smart View and issues related to Office 2016.  He gives us a nice round-up of Oracle articles about the topic.

The Hyperion Doctor

Ludovic has a pair of posts about Kscope17 as well:

The I.T. Side

Eric has a post on two divergent topics.  He covers the future of On-Prem and then…talks about SaaS products coming from Oracle in the Data and Meta-Data Management space.  On a more Kscope17 related not, be sure to congratulate Eric on winning a Best Speaker aware for Business Content.  Congrats Eric!  I guess you didn’t need more gong after all. 😉

More to Life…

John Goodwin doesn’t let Kscope17 taking place get in the way of more great content.  He starts off with a continuation of his EPM Cloud series on Managing Application with Smart View.  He also gives us a public service announcement about the new 11.1.2.4.018 patch and new behavior that has been included.

Only Hyperion

Dayalan has a post about using substitution variables in a direct page link to a form or dashboard.  I love stuff like this…

The Unlocked Cube

Last…but not least, Vijay has a piece on using ODI to import data from Essbase produced using a calculation script.  I feel like I’ve noticed this before…but I was never smart enough to write it down.  Thanks for the reminder that hopefully Google will find for me next time!

Be On the Lookout!

That’s it for this week!  Be on the lookout for more great EPM Blog content next week!


Hyperion EPM Month in Review: December 2016

HyperionEPM.com Month in Review

The Hyperion EPM Week in Review has clearly become more than I can manage on a weekly basis.  So, I’ve decided to do a monthly update for the time being.  If things slow down, I’ll get back to a weekly update.  So, welcome to 2017 and the review of Hyperion EPM in December of 2016!

As part of this change I’ll also be structuring the posts a little different.  Because over the course of a month many of us post more than once, I’ll be adding sub-heading for each of the contributing blogs along with a link to their main site.  I welcome any feedback everyone has.

Adashek EPM

Garry had three posts last month.  First he announced that he was selected to present at KScope17.  Congrats Gary!  He also lets us know about the new 11.1.2.4.704 patch for Financial Reporting.  This is a particularly important update given that Oracle will no longer support the desktop client soon.  While he’s updating us on patches, he also has a post about the new 11.1.2.4.210 patch for FDMEE.  This includes a whole host of new features including text-based data loads.

Cameron’s Blog for Essbase Hackers

Cameron gives us the update on the most resent Boston meetup.  It looks like a lot of fun was had!

DEV EPM

The DEV EPM crew continues their series on Dimension and Cubes in ODI 12c.  The topic of the day is loading data using surrogate keys.

EPM Junkie

Keith has a post on extracting UDA’s…using Python.

Eric Erikson’s Oracle HFM and FCCS Blog

Eric, much like Gary, as a post on the 11.1.2.4.704 patch for Financial Reports.  This seems to be a popular topic.

Exploits in Hyperion

Sibin had another busy month of blogging.  He starts off by taking a peak at the backend tables of Shared Services.  He then moves on to showing us how to create a relational data source for an Essbase rules file…on Linux.  Speaking of Linux, he also has a guide on installing HFM on Oracle Linux.  I’m pretty sure this is only supported on Exalytics…but hey, cool guide.

Jason’s Hyperion Blog

Jason has a re-cap of his most popular blog posts of 2016 to finish out the year.

More to life than this…

John continues his awesome content to finish off the year.  He has a post on loading data to multiple years and periods with FDMEE.  He also has part one of his series on FDMEE and the REST API.

Fishing with FDMEE

Francisco has a post on the 11.1.2.4.210 patch for FDMEE at a glance.  He the digs deeper into the patch.

Only Hyperion

Dayalan has a post on loading data into PBCS using the HsSetValue and HsGetValue functions.

Oracle – Hyperion Labs

Celvin, who I had the privaledge of hanging out with over the holidays, has a number of posts in December.  He has an amazing family and it was great to spend some time away from Kscope with some fellow Oracle nerds.

First he has a tip on ADFS Federation and Signing Certificate issues.  Next up he has a quick tip on deleting members and shared members more rapidly in PBCS.  Finally, he has a post on adding a time value to a webform.

Real Tri Geek

Sarah has a post on error 10058 in Data Visualization Desktop (DVD).  While on the topic of DVD, she also covers plug-ins.

The I.T. Side

Eric has a great post showing off the new and hopefully eventually released Essbase Cloud Service.

Woman in EPM

Opal has a post on opening up more than one instance of the Oracle EPM Cloud.


Hyperion EPM Week In Review? November 26, 2016

Welcome to the Hyperion EPM Week in Review!  And look at that…it has only been a week!
Hyperion EPM Week In Review

Hyperion EPM Patches and Updates:

Essbase 11.1.2.4.014 has been released.  This is a nearly complete patch for the suite with everything getting a patch but EAS.

The December 2016 cloud updates are about to drop:

ARCS looks to have a few new features, including Transaction Matching.

EPRCS also gets an update in December.

FCCS will be getting another update as well.  This update includes new alternate hierarchy functionality in the Entity dimension among other things.

PBCS gets an update as well with a lot of new features around sandboxing and a new web-based version of predictive planning.  Also of note…workspace has an official date of death…December 2017.

PCMCS gets a few minor updates as well.

Hyperion EPM Blog Posts:

Opal has another post in his ODTUG Member Series.  This time she focuses on the former ODTUG Marketing guru, Lori Lorusso.

Sibin has a five-part series on using ODI to load data from a flat file into an Oracle table.  Check out part 1, part 2, part 3, part 4, and part 5.  He follows that series up with another ODI post on handling NULL values in ODI.

Peter has an extremely detailed post on conditional FIX statements in Essbase.  Love the details and explanation.

Jason hosted a webinar this week on the Dodeca Excel Add-In.  This is a pretty cool tool for all of you out there that either refuse to make the move to Smart View or have VBA code preventing the move.  Jason also has an update on his Thriller MDX over JDBC driver.

Cameron has a great post on migrating an Essbase database to the cloud using PBCS.

Keith has an update to the FDMEE framework that he has been working on.  He has updated the logging functionality to be in line with PEP 8.

Tim tells us Happy Thanksgiving along with some kind words from a Dodeca Excel Add-In user.

Glenn gives us a few highlights from the Essbase 11.1.2.4.014 patch that was just released.  Sounds like we should all get patched up…

Rodrigo has an ODI post as well this week.  He continues his series on Dimensions and Cubes in ODI 12c with part 3 on Settings for Surrogate Keys.


Hyperion EPM Month In Review? November 18, 2016

Welcome to the Hyperion EPM Week Month in Review!  I can’t believe it has been almost a month since my last post.  With the holidays upon us, I can’t say for sure that I’ll keep up with the weekly posts going forward, but I’m certainly going to give it a shot.  Here we go!
Hyperion EPM Week In Review

Hyperion EPM Patches and Updates:

Hyperion Financial Clost Management 11.1.2.4.200 has been released.  They removed reduced the reliance on SOA in this release.  I guess its a step in the right direction, but a long way from where we all hoped it would be.

Hyperion Disclosure Management 11.1.2.4.253 has been released.  That’s about all I know about that…

The November 2016 Update for ARCS has been released.  More here.

The November 2016 Update for FCCS has been released.  More here.

The November 2016 Update for EPRCS has been release.  More here.

The November 2016 Update for PBCS has been released.  More here.  The dropping of support for the desktop FR studio is of particular interest.  Really?  Ugh…

The November 2016 Update has been released for PCMCS.  More here.

Hyperion EPM Blog Posts:

Cameron shows us how to work around a bug that’s been around for a long time.  FIX statements and shared members.

Tim shows us that query logging can really cause performance problems.  Beware!

Keith has a few posts.  He covers JConsole with ODI and some OutOfMemoryError’s.  He also announced JunkieFramework.  A framework for FDMEE development…interesting stuff.  He then asked for everyone to help collaborate with the framework.  All of these tools are only better with the community being more involved…so get involved!

Pete has a post on subvars and using them to hack data forms.  I hadn’t noticed some of the improvements to the PBCS side of things as it relates to subvars.  Good read.

Sibin kept busy while I was backlogged in my posting.  Here’s a quick re-cap:

Dmitry continues his datamining series.

Jason has a few posts.  He covers custom landing pages in Dodeca.  He keeps with  the Dodeca theme and covers multiple applications.  Did I mention Dodeca?  Jason did…this time covering Tenants.

John Goodwin shows us a way to run FDMEE data load rules from inside of a task list.  Groovy!

Another Tim laments the fact that Essbase feature adds are few and far between right now.

Francisco has been busy too.  He has a post about extracting YTD balances.  Next up…a pair of code snippets: logging fdmContext values and script code based on EPM environment.

Dayalan starts off a series about the EPM Automate Utility.

Sarah has completed another Ironman.

Ludovic has a pair of EPBCS posts:  Part 1 and Part 2.

Vijay shows us how to filter exports to remove duplicates in DRM.

Doug shows off the new functionality in FDMEE in FCCS for Multi-Column data files.

Opal has a few posts from the cloud.  Or is it about the cloud?  First she has a quick tip on EPBCS/EPC and how you should always log out.  She also covers PBCS administrator settings.  Last, but certainly not least, she covers the notable updates in the Oracle EPM cloud for November.

Other Stuff

In other news, thanks largly in part to my amazing blog post his qualifications, Jake Turrell has been elected to the ODTUG board of directors!  Congrats Jake!


Hyperion EPM Week In Review: October 7, 2016

This week we review our EPM week of only seven days, unlike the ten days of last week.  We had some great content, but no patches or updates.  Let’s get to it!
Hyperion EPM Week In Review

ODTUG Board of Directors

It’s that time of year.  Election season.  No, not THAT election.  The ODTUG Board of Directors election!  You can see the very long list of 16 nominees along with their campaign statements and bios here.  I urge you to pay special attention to Jake Turrell.  Jake has been contributing to the ODTUG community for as long as I can remember.  He has multiple best speaker awards and a great deal of passion for what we do.  He also has a fantastic blog that I reference multiple times a month.  I can’t imagine a better candidate for the ODTUG Board of Directors.  If Jake were more self-promoting, he would have let me put up an amazing campaign site.  But that’s not really his style, so I’ll leave it at this for now…VOTE FOR JAKE!!!

Hyperion EPM Patches and Updates:

 

No updates this week!

Hyperion EPM Blog Posts:

 

Sibin had yet another busy week with four new posts.  He first brings us a blog about the back-end tables that store source system information in FDMEE.  I’m a sucker for looking under the covers of EPM products…  He then shows us how to export data to a relational table from Essbase directly with a calculation script.  This is a great tutorial, but I will note that I have seen very slow performance going direct to a relational destination versus just straight to a flat file.  Now that’s I’ve said that, I feel the need to benchmark it.  In the meantime, he has a follow-up on adding a timestamp to the export.  He finishes his week off with another post on calculation scripts in Essbase, specifically allocations.

Ricardo reminds us that the deadline for Kscope 17 abstracts is rapidly approaching.

I have a the fifth part of my Essbase performance series.  We’re getting dangerously close to real Essbase benchmarks.  Excited?  I am…

Jason has a pair of posts on Dodeca this week.  First he covers dynamic rolling quarters.  He then has an extremely detailed post on adding a username to a row during relational input.

Keith has a pair of posts this week as well.  Both of his involve Jython.  First he shows us how to install it and then he shows us how to debug it in ODI.

Eric has a pair of posts this week as well.  First he advertises tells us about Managed Oracle EPM Hosted Solutions.  Next he tells us that he is running for ODTUG Board of Directors.  I will say that his campaign site made me laugh.

Christian has released Tools-EPM.  This sounds like a cool command-line utility to make our lives easier.  I haven’t had a chance to check it out yet, but I hope to eventually.

Opal went to the fair.  Not exactly EPM, but hey, it is an EPM blog normally.

Eric (Erikson, not Helmer) has a great post showing off the new charts in HFM data grids functionality.  Pretty pictures. 🙂

Kscope 17 Abstracts

Friendly reminder to those of you interested in presenting at Kscope17 next year…the deadline is rapidly approaching with just two weeks left.  That’s right, the deadline is October 14!  That is just one week from today!  Go submit some abstracts!


Hyperion EPM Week In Review: September 30, 2016

You know you are running late on your Hyperion EPM Week in Review when someone asks you about in on a phone call…  It’s been about 10 days since my last week in review, so welcome to this weeks “Hyperion EPM 10 Days in Review.”
Hyperion EPM Week In Review

Hyperion EPM Patches and Updates:

Hyperion Financial Reports 11.1.2.4.703 has been released.  Looks like mostly bug fixes.

The October updates for the cloud will start flowing out next Friday!  We have PBCS updates-a-plenty.  You can read more about those here.  We also have some ARCS updates that you can read about here.  Finally, we have FCCS updates that you can read about here.

Hyperion EPM Blog Posts:

We’ll start off with a post from Robert on the death of on-prem!  Well, it may be more of a question, but he has a great headline.

Summer has a post about the cloud and how to support your applications.  Managed services are becoming far more popular as it becomes more difficult and expensive to find an admin.

Dayalan has his third part of his Essbase Web Services series.  He covers the admin services portion of the web service.  He then follows that up with part four covering the Datasource Service.

Christian has a post regarding some settings in the BIOS to improve performance in Essbase.  Definitely an interesting post.  Obviously hyper-threading is bad and he also found that working with memory interleaving can help.

Glenn has a quick post on some Excel Add-In’s that cause odd behavior with Smart View.  I’m excited to hear more.  He also has a post on migrating from EIS to Studio.  I would just convert things back to a normal build and use DrillBridge personally.

I covered the next part in my series on FreeNAS.  I also spent some time with network storage getting ready for my Essbase benchmarks.

Sibin has several posts again this week.  First he covers Category Mappings in FDMEE.  Next he moves on to the Open Interface in FDMEE.  After that he covers the DATAEXPORT command in Essbase.  Finally he covers more information on the Open Interface Adapter.

Tim has some more information about Essbase Cloud Services.  This should be an interesting read if you haven’t heard much yet.

John Goodwin has a part one of a series covering Oracle’s REST Data Services and how to integrate that with the EPM stack.  Good read…very in-depth.  Not to be outdone by himself, he gives us part two as well.

Jason has a funny post about TBC going bankrupt.  Give it a minute and it will make sense.

Will has a post about some new features in DRG: Workflow Task Calculate Name and Calculate Parent.

Henri has a great post on the HFM Java API.  More parts are coming and I can’t wait to read them.

Opal talks a lot about FCCS and where she thinks development is heading.  This is a good read and FCCS is definitely going to open up a lot of new opportunities in our EPM market.

Gary has a collection of highlights from the Oracle docs to help everyone out with Smart View.  As more of us are forced to give up the Excel add-in, this will become more and more important.

Cameron really wants to you join ODTUG.   I’m a member…are you?  ODTUG brings us Kscope and a whole host of other important activities, so go become a paying member!

Oracle OpenWorld Coverage

OpenWorld was last week  I’ve recapped all of the blogging here by person including prior posts to have a complete list of coverage.

Opal

Cameron

Jason

Kscope 17 Abstracts

Friendly reminder to those of you interested in presenting at Kscope17 next year…the deadline is rapidly approaching with just two weeks left.  That’s right, the deadline is October 14!  Go submit some abstracts!