LLS Light The Night Walk, Norwalk CT, 10/24/2014

-
This year I am participating in the LLS Light the Night Walk in Norwalk, CT to raise money and awareness for the Leukemia and Lymphoma Society.

I am the captain of my corporate team.  We have committed to raising $5,000, and I personally have committed to raising $2,000 of that amount.

LLS is an amazing organization working for an extremely worthy cause. 

Would you please consider supporting me by making a donation at
 http://pages.lightthenight.org/ctwhv/Norwalk14/gcrisci

Thank you for your support!
Gary Crisci

Comments

Post a Comment

Popular posts from this blog

Oracle PBCS text file export from ASO plan type utilizing Data Management

-
Image
While recently working on a project to migrate an on-premise Hyperion Planning application to Oracle Planning and Budgeting Cloud Service (PBCS) I ran into a requirement to export data from the application to a downstream data warehouse. On premise this is handled with a BSO export calculation script. One of the changes we implemented when moving the app to the cloud was to take advantage of the ASO reporting cube plan type to eliminate the need to run aggregations on the BSO plan type. This decision however caused a challenge for exporting the data. When evaluating options we recognized that while we could use a business rule to export the data from the BSO plan type, not all the data we needed was available since we were not aggregating the BSO cube. In light of this we decided we would extract the data from the ASO reporting cube. The challenge with this approach however was that we could no longer use the business rule export since it is not supported for ASO plan type, furthermo...
Read more

PBCS dynamic xref, ASO to BSO - roll your own hybrid!

-
Image
Overview PBCS has made life so easy when it comes to moving data between plan types.  Setting up a Planning to Essbase ASO reporting cube, on-premise, is a very involved process with automations to either export/import data or to move data via partitions.  With PBCS it's pretty much as easy as clicking a button in the UI or calling a data map definition in EPMAutomate. A number of questions come up when determining how you want to architect your PBCS app.  You need to think about how data is going to be stored in the different plan types and how the data flow is going to work so that you get the results you need as quick as possible while ensuring the app is easy for users to navigate.  Features like Smart Push, which allow you to create data forms pointing to a BSO plan type and also write to an ASO plan type (or another BSO type if you wish) give you a lot of options to isolate your users from seeing what's going on behind the curtain.  I make it a sell...
Read more

Time Functionality

-
Image
Something I've worked on a number of times and even spoke about at the ODTUG Kaleidoscope conference is MDX and specifically how to use it to do time related calcs like period-to-date functions and Time Balancing. I've seen quite a few posts on the subject and figured it was worth putting up some examples here. More recent releases of Essbase will do time balancing natively, but period-to-date is something you still have to work out. My preferred method of doing this is to add an analytic dimension to the database and set the formula in one of the calculated members. For those of you who aren't familiar with the term, an analytic dimension is one that you add to your database that has a single default load member, all other members are calculated. In the case of time functionality I usually call this dimension [View] and have a default member called [Periodic]. I will then have some other members as needed, like [Time Balance], [QTD], [YTD], etc. For Example: The perio...
Read more