jason
All 303 posts.
- Cleaning Out the Closet: Aggregate View Formula
- Thriller 1.1: MDX Over JDBC, Now Open Source
- Bring Your Own Context: Building a Hyperion Planning Docker Image
- Opting Into Simplicity
- Essterm 1.0: Essbase Ad Hoc in Your Terminal, Now Open Source
- The Fusion of Essbase and AI
- The Complete Guide to Essbase 21 on Docker
- Simple Docker Compose file for Essbase
- Dodeca HFM Connector: Getting Started
- Drillbridge 3.4.6 Token Enhancements: Join Character and Line Removal
- So I’m running for the ODTUG Board (Please Vote)
- Oracle Essbase Docker June Update
- Simple Way to Check if Essbase XMLA Provider Is Working
- Oracle Essbase on Docker: What, How, Why
- Drillbridge Feature: Advanced Date Formats
- A REST API Primer for EPM Users & Developers
- Drillbridge Plus 3.3.0 Release & Features
- Dodeca Dynamic Build Example & Walkthrough
- PBCS Scripting with Groovy using the PBJ REST API Library
- Happy New Year & Best Posts of 2017
- Evolution of Essbase: new URL-based drill-through showed up in 11.1.1.3
- Drillbridge as drill-through solution with CSV data and replacing Access
- Speed up ASO SQL data loads by using multiple rules files
- New webpage for Essbase Java API evolution
- Configuring Drillbridge with Financial Reporting Web Studio
- Milestone for PBJ (PBCS REST API Java Client) Project: first outside contribution
- PBCS has a REST API, now what?
- New Drillbridge Plus feature: fetch attributes!
- People really hate VBA
- Dodeca 7.3 Workbook Scripts Enhancements Overview
- Dodeca: Turn on Auto Build button by default or hide it entirely
- Dodeca: Create and use a new Essbase MDX Selector List
- Small update to essbasepy
- New MDX Examples Page
- My Favorite New Dodeca 7.3 Feature: Outline Viewer
- More on Dodeca Dynamic Connections: Allowing Users to Select Multiple Connections
- Dynamic Essbase Connections in Dodeca: Faster Cubes and an Enhanced User Experience
- User Selectable Cube Connections in Dodeca
- Improving MySQL JNDI Connection Reliability
- Dodeca Zebra Striping with WBS Example
- Interesting Time Period Conversion with Drillbridge/PBCS
- Small update of Hyperion Parent Inferrer to 1.0.2
- Webinar Tomorrow: One Stop Data Shop with Dodeca
- New Substitution Variable Methods/CLI in PBJ
- Understanding the Outline Extractor Relational Extraction Tables
- Essterm: Terminal-based ad hoc client for Essbase
- Next Generation Outline Extractor version 2.1.3: Relational extraction enhancements
- You Should Rethink Your Essbase/VBA Spreadsheets
- PBJ 1.0.4 – New password options and start of CLI
- My Top 10 Favorite Drillbridge Features
- PBJ (PBCS REST API Library for Java) Updates
- Dodeca Workbook Script documentation available online
- I’ll be at Collaborate 2017 in Las Vegas, say hello!
- Handy Essbase Data Audit Log Query for Dodeca Repository
- Jazz Up Those Static Dodeca Views With Advanced Essbase Features
- JDBC and JNDI connections compared (with a Dodeca example)
- Hacking the Essbase Java API to run Application Calcs
- Showing off the power of Drillbridge query translation
- Deleting multiple files from PBCS using PBJ client
- Hyperion Parent Inferrer Updated (after four years!)
- Essbase Renegade Members Revisited
- Dodeca Technique: Multiple Essbase Data Sources in View
- Top Posts of the Year 2016
- Guest Posts Welcome
- Drillbridge Update: Officially Announcing Drillbridge Plus
- Vess + ODI to extract Essbase metadata
- Dynamic Calendar with Comments in Dodeca
- Dodeca Technique: Essbase View with Cascaded Transaction Details Tabs
- Creating Windows symlinks for Java installation
- Using Excel AutoCorrect to help type special characters
- Update to Thriller MDX over JDBC driver
- Want to see a Dodeca Excel Add-In demo? Webinar on Tuesday!
- Understanding Dodeca Tenants
- Multiple Applications in Dodeca
- Greet your Dodeca users with a custom landing page
- Playing with the Thriller MDX/JDBC Driver in Drillbridge
- Running MDX queries through a JDBC driver (for fun?)
- New Indenting Options in Next Generation Outline Extractor writer
- Dodeca Techniques – Auto Load Windows User Name During Relational Input
- Dodeca Techniques: Dynamic Rolling Quarters
- Oracle Open World 2016 Recap
- TBC Files for Bankruptcy
- Camshaft (Essbase MDX query tool) 1.0.2 released
- Oracle OpenWorld 2016 Presentation: Essbase Community Toys and Tools
- Simple Drill-through in Dodeca
- Camshaft MDX tool updated and available
- Vess + Dodeca for Substitution Variable Management
- Dodeca Dynamic Grouping with Relational Data
- Data Input with Dodeca, part 6 – SQL and Essbase Hybrid Input in one View
- Data Input with Dodeca, part 5 – Relational Database input
- Data Input with Dodeca, part 4 – Focused Calcs
- A primer on relational data views in Dodeca
- Data Input with Dodeca, part 3 – Data Audit Log
- Data Input with Dodeca, part 2 – Comments
- Data Input with Dodeca, part 1
- Multiple Retrieves in Dodeca
- Cascading Report Summary Sheets in Dodeca
- PBJ PBCS Client GitHub repository
- Advanced integration with PBJ Java PBCS REST API library
- Cascading Reports with Dodeca
- Kscope16 is almost here!
- Towards Spreadsheet Management
- Drillable Columns in Drillbridge
- Dependent Selectors in Dodeca
- Kscope16 sessions I’m looking forward to
- Essbasepy updated for Python 3
- Drillbridge Community Edition 1.5.5 available
- Drillbridge acquired by Applied OLAP
- Introducing PBJ: The PBCS Java Client Project
- Book Review: Developing Essbase Applications – Hybrid Techniques and Practices
- Drillbridge vs. Essbase Studio
- Database stats and outline viewing with Vess
- Vess Updates Substitution Variables
- Custom Drillbridge Reports feature
- Introducing Drillbridge Enterprise
- ODTUG interview with yours truly on Drillbridge
- Manually injecting rows to an ODI journal table
- More fun with Vess, the Essbase JDBC driver
- Essbase data loads with Windows integrated authentication
- Quadruple Backslashes
- ODI Automation: Don’t Call Us, We’ll Call You
- Kscope15 Presentation Preview: ODI Workhorses
- Kscope15 Presentation Preview: Drillbridge
- Essbase Version Archaeology
- Drillbridge 1.5.4 Available
- Your daily Vess (Virtual Essbase JDBC driver) update
- I’m an Oracle ACE Associate now
- Vess: a Virtual Essbase JDBC driver
- Where is the Essbase Java API method to build dimensions from a SQL source?
- Essbase Java API Load from FTP quick followup
- Essbase Java API digging: data load from FTP?
- Issue starting Drillbridge on Windows 2008
- Custom Functions in Drillbridge
- Running ODI Studio on OS X
- Fun with Unix join (on Windows too!)
- Drillbridge drill-to-bottom token parentheses note
- Cool tool for generating data
- GNU CoreUtils for Windows
- Code This, Not That: Python date string formatting
- Code This, Not That: Python string interpolation/concatentation
- Code This, Not That: From VBScript to Jython
- Advanced Drillbridge tokens: Protecting against unexpected members
- Drillbridge White Paper now available
- ODI journal table performance tweak with an index
- ODI journalization crash course
- ODI Oracle Merge Incremental Update burns sequence values
- Glitch with a non-printing Unicode character in member name
- Drillbridge White Paper now available
- cubus outperform EV Analytics Review: Position in the Enterprise
- Drillbridge Token Parameter Overview
- Thoughts on deprecated Essbase 11.1.2.4 features and the future of EAS
- cubus outperform EV Analytics Review: Using EV continued
- Drillbridge handling dimensions with spaces
- Deleted journalized rows in ODI populating target with NULLs
- cubus outperform EV Analytics Review: Using EV
- Blocks & Beers: SeaHUG meetup on Feb 19
- cubus outperform EV Analytics Review: Background
- Drillbridge on Linux
- Kscope15 – Two Presentations
- Drillbridge 1.5.0 available!
- Essbase Outline Export Parser released
- Camshaft 1.0.1 released
- Drillbridge 1.4.0 Feature Preview: Custom Mappings
- Drillbridge Webinar Slides Available
- Drillbridge with Teradata & Netezza?
- How to scan a cube for members with no data – the HUMA way
- Daily Drillbridge Update
- Drillbridge 1.3.4 BETA available
- Thoughts on using an ODI SKM to expose tables as a web service
- HUMA 0.5.0 available to download
- HUMA Lives: A tool for determining if members in a cube have no data
- Drillbridge 1.3.3 Update 2
- Drillbridge 1.3.3 re-updated
- Drillbridge 1.3.3 hot off the press
- Performance nuances with MaxL data imports with local and server
- Drillbridge Wiki now up
- Essbase Java API Consulting & Custom Development Available
- Drillbridge 1.3.2 available
- End of the road for EIS, start of the road for Drillbridge
- Drillbridge 1.3.1 available for download
- Drillbridge 1.3.0 available!
- You’re going to love this.
- Upcoming Drillbridge features, part 2: Custom Formatting
- Upcoming Drillbridge features, part 1: relational paging
- Good things coming in Drillbridge 1.3.0
- Drillbridge 1.0.2 package updated
- Might want to hold off on Drillbridge 1.0.2 for the moment
- Do this, not that: Current vs. Prior Year dynamic calc in Scenario
- Drillbridge 1.0.2 now available
- New functions and fixes in Drillbridge 1.0.2 and first enterprise deployment!
- Essbasepy update for 64-bit issues
- The MaxL “Repeated calls to startMaxl.bat stops working” on Windows issue
- Easy Hyperion Drill Through and the road to Drillbridge 1.0.2
- Drillbridge 1.0.1 out the door
- Drillbridge weekend update
- Drillbridge, the simple way to implement drill through
- SeaHUG officially off and running
- Calling all Seattle-based Hyperion enthusiasts!
- Gadget Review: The Jiggler
- OAUG Collaborate 2014 is a wrap
- A quick trick to avoid hard-coding folder names in batch files
- Winter Update
- Two of my favorite things together at last: Essbase and reddit
- Friday fun day, fish names, and 100th post!
- cubeSavvy Review
- essbasepy Python MaxL module for Hyperion moved!
- Inputting to level 1 and a crazy app idea
- Possible idea for a tool: cube delta
- Thank you to Hyperion Unused Member Analyzer testers, and thoughts on future tools
- Beta testers wanted for Hyperion Unused Member Analyzer tool
- Stupid Essbase names for a fish
- Eclipse tips for you Java folks out there
- Using the Unix paste command to join files together by column
- Processing a file line by line in Java
- Pre-seeding Hyperion Planning User Preferences with values for a smoother user experience
- Flipping an ODI model to a different technology and kicking the interfaces
- WSDL XML tweak for Essbase Web Services for C#/Service Util
- Upcoming Webinar: Practical Essbase Web Services
- Hyperion code drop: Parent Inferrer tool
- Hyperion Health Check Hit List
- ADS File Reader 1.0.0 released
- Hyperion Essbase Papercut: EAS unable to save custom views
- Do you have any ADS files you can share with me?
- Essbase Java API jars in Maven
- Evolving the Essbase Java API with JALE
- How are you using the Essbase Outline Extractor?
- Cool Hyperion Infographic
- Hyperion Essbase rejected record automation one-liner
- Announcing Jolo, a Java library for printing text-based tables
- EIS, IES, and things that make you go hmm…
- Hyperion Essbase wish list: Import a compressed file
- Hyperion Papercut: LCM security migration woes
- Calling all Seattle Hyperion/Essbase/EPM enthusiasts!
- Albert Einstein, on going through Hyperion automation systems
- Viva La Database Notes
- Small site updates (HTTPS!) and other tidbits
- Kscope13 Session Thoughts: Joe Aultman sprinkles magic Groovy dust on the Essbase Java API
- Hyperion Papercut: Cross-server cube copy in EAS doesn’t carry over data
- Contribute to Open Source Hyperion Utilities and Ideas
- SSD Upgrade (MOAR SPACE!) – for laptops and Essbase servers
- Thoughts on my Kscope Session ‘Practical Essbase Web Services’
- Kscope 13 Day 1 – Deep Thoughts, part 2 of 2
- Kscope 13 Day 1 – Deep Thoughts, part 1 of 2
- Kscope13 Day 1 – General Thoughts
- Essbase/EAS feature request: Metadata and description fields on Essbase objects
- Papercut: Calc script verification with FDM tokenization
- Essbase & Hyperion Papercuts
- Do you have an Essbase or Hyperion blog? Let me know!
- Pointing an ODI Procedure to different schemas on the same server to facilitate testing
- Fixing an esoteric Oracle Incremental Merge Update Knowledge module bug with journalizing and an aggregate function
- One extra thing to validate in that load rule, even if all looks well
- In case you missed it: Oracle Data Integrator success story webinar
- Using ODI error tables (and tables with dollar signs in their names) as models for transformations
- Linux troubleshooting guide for system admins!
- My ODTUG Kscope13 presentation: Practical Essbase Web Services
- Portable Firefox to the rescue!
- ODTUG down under? Oh my!
- More fun from the mad scientist in the labs: release of Hyperion Rejected Record Summary 1.0.0
- Hyperpipe updated (1.0.1) plus another tidbit
- New theme!
- Pump data into an Essbase cube directly from a relational database with just Java and no load rule using Hyperpipe
- Install Essbase Java API (jar) files as a local Maven artifact
- Survey Results: What is the one true MaxL script file extension to rule them all?
- The Essbase Book Review to End All Reviews: Developing Essbase Applications
- Release of cubedata 1.0.0
- Book review: Oracle Essbase 11 Development Cookbook
- Saxbi is now beta testing
- Release of Jessub 1.0.0
- Book review: Oracle Essbase 9 Implementation Guide
- A quick and dirty recipe for automating the yearly cube archive process
- A comprehensive Essbase automation optimization story, or: Shaving off every last second
- The %COMPUTERNAME%/MaxL trick for syncing test to production
- ODTUG 2009 Recap
- An Essbase Optimization Story
- Lots of little things: blogging, ODTUG, and Essbase 11.1.1.2.0
- Remote server automation with MaxL
- Essbase and SQL Server Express: just don’t
- Launch ClickOnce apps [such as Dodeca] through Firefox
- Essbase Performance Optimization: it’s not just the calc script
- Some performance observations changing an ASO hierarchy from Dynamic to Stored
- Delete that stubborn Essbase application in EAS!
- How to copy an Essbase application from one server to another
- An Introduction Essbase Integration Services (EIS)
- Essbase, the economy and thoughts from the last ODTUG
- MaxL Essbase automation patterns: moving data from one cube to another
- The new year, looking back and looking forward with a little Hyperion thrown in
- A quick and dirty substitution variable updater
- Getting everything done with just Essbase and Dodeca
- MaxL tricks and strategies on upgrading a legacy automation system from ESSCMD
- A @JExport odyssey: installing, updating, and troubleshooting the JExport custom defined function
- Speaking at ODTUG!
- Automate that old cube archive process!
- Optimizing Essbase Automation Jobs (for fun and profit!) – Part 1
- A MaxL quickie to unload those databases that are eating your precious memory
- Jason’s Top 10 Essbase Data Load Optimization Tips
- I submitted two abstracts for ODTUG!
- The Essbase Spreadsheet Automation Trick
- Automated EIS outline builds
- More fun with Ubuntu Brainstorm
- Normalize a fact table for a better EIS model
- Making order out of chaos with Essbase Integration Server – part 2
- Making order out of chaos with Essbase Integration Server – part 1
- A day spent on tuning