Archives

---

2018

Feb 21 New Journey!! 18 comments Execute a Calculation script based on Planning unit status - Groovy on-premises Snippets Part III 20 Notepad++ Plugins 1 comments 14 Essbase outline from XML!! - Part II 13 Essbase outline from XML!! - Part I 07 Hybrid + MDXDataCopy, It's black magic

Jan 23 Email from calculation script - Groovy on-premises Snippets Part II 3 comments 16 Run shell script in Workspace 7 comments 09 2017 - A Groovy year 1 comments

2017

Dec 14 Essbase Member Operation Utility – Rename Aliases and Exception handling 2 comments

Nov 15 I'm back!!!! 2 comments

Oct 03 Smart View duplicate aliases Fun!!!!

Sep 28 Smart View formula replace mystery 19 EPBCS Groovy and use of Templates 5 comments

Aug 15 PBCS Quick Tips - Domain auto fill and accessing multiple PODs 10 Centralite 4256050-ZHAC Outlet and SmartThings 1 comments 09 Update modified cells to relational database using Groovy scripts - Groovy on-premises Snippets Part I 2 comments

Jul 14 ePBCS Quick Tips - Auditing is here 12 comments 12 Mondrian - an OLAP which is not Essbase 😵 6 comments 11 Kscope17 - a week full of fun and learning 03 To SUI, or not to SUI

May 24 Planning expressions in Calc Mgr - Part I 2 comments 10 The world of CLEARBLOCK NONINPUT, MaxL Set Statements and CalcMgrMDXExport 1 comments 02 Surprising FIX statement - Surprises in Essbase Part XIII 5 comments

Apr 06 Hierarchy-driven Smart Lists and using them in Calc scripts 9 comments

Mar 29 Nia - our second angel is here 3 comments 22 Shortcodes in Essbase - Surprises in Essbase Part XII 3 comments 17 DrumRoll and BlogRoll “This is probably one post which I'm writing for a selfish reason. (Ever another post ...” 2 comments 16 PBCS Quick Tips - Bulk upload security permissions in PBCS 2 comments 01 PBCS Quick Tips - Moving PBCS (Essbase) Cube to On-Premises 7 comments

Feb 23 Groovy in PBCS and On-Premises Hyperion Planning - Part IV, It's Groovy time 9 comments 21 Groovy in PBCS and On-Premises Hyperion Planning - Part III 2 comments 01 PBCS Quick Tip - Hierarchy driven Smartlists and Import Metadata time 2 comments

Jan 23 Groovy in PBCS and On-Premises Hyperion Planning - Part II, It's time for SmartLists 6 comments 17 Groovy in PBCS and On-Premises Hyperion Planning - Part I 8 comments

2016

Dec 20 Refresh Time in Webforms and a Calc Manager Surprise 11 comments 13 PBCS Quick Tip - How to delete members/shared members in an automated way 6 comments 08 PBCS Quick Tip - ADFS Federation and Signing Certificate issue

Nov 21 Essbase Member Operation Utility - Change Data Storage based on levels

Oct 25 How to check whether a form is read only/hidden and more (Decoding Webform options - FORM_OPT) 5 comments 18 Leap of faith 19 comments 11 OTN Appreciation Day : Groovy in EPM

Sep 23 Changes 15 Generating JSON for PBCS REST API 1 comments NUMSysCMDLauncher 2.0 - Export Essbase Filters as MaxL script 4 comments 09 PBCS Quick Tip - 16.09 Essbase data Artifact and Smart View surprises 2 comments 07 Finding the formulas used in HFR reports 3 comments 01 The King (or The Queen) of CDFs has arrived 2 comments

Aug 24 Smart View Quick Tip - Smart View 32 bit or 64 bit? Which one was installed? 5 comments 22 NUMSysCMDLauncher - Bulk User/Group Import/Modify/Delete from command line 08 PBCS Quick Tip - Make Smart View prompt for Domain and User Name 04 Style LCM Artifact Listing - Or Make It Readable 2 comments 02 PBCS Quick Tip - Migration 6 comments

Jul 19 Calc Manager Date Difference issue - Surprises in Calc Manager Part II 07 Update Smart View options for all Users 2 comments 05 Using Attributes along with Suppress Missing options in PBCS

Jun 19 Get Text IDs from PBCS

May 25 Configuring PBCS to Federate with Microsoft Azure Active Directory Base version 4 comments

Mar 28 Oracle ACE Director 4 comments 24 Essbase Member Operation Utility - Encryption and find which members to tag as Never Share 5 comments 22 Planning Client Utilities 1 comments

Feb 24 NUMSys Web Edition + Essbase Security Viewer + Workspace Access Viewer 1 comments 19 Bulk upload valid intersections in PBCS

Jan 29 Execute a truncate statement from Scribe 27 NUMSys Web Edition + Essbase Security Viewer 28 comments

2015

Dec 14 NUMSys Web Edition 2 comments

Oct 27 CloudMap - your integration mapping system 2 comments 08 How to log off Inactive Sessions from Essbase 07 Essbase Import Text List - Encryption 05 Conditionally trigger a Data transfer and Aggregation on a different cube - Calc Manager CDFs Part II 2 comments

Sep 25 Conditionally trigger a Data transfer and Aggregation on a different cube - Calc Manager CDFs Part I 6 comments 09 Planning new features - Different formula and Storage options for same member 1 comments

Aug 05 Show Validation Rules usage on Webforms

Jul 30 Show Smart List Usage - Forms & Accounts 4 comments 28 Essbase Member Operation Utility - Change Data Storage 7 comments

Jun 01 Essbase Member Operation Utility - Rename Members 16 comments

May 06 Essbase Member Operation Utility - Count Members 2 comments Essbase Member Operation Utility - Delete Members 10 comments

Apr 30 Move Planning Text Data to ASO with String concatenation 22 jMnDLoader a graphical approach for loading data and metadata into Hyperion Planning 5 comments

Mar 24 DATAEXPORT - FIX on DynamicCalc Sparse Member 3 comments 20 .5 Million and counting 03 Real Time data push from Planning to ASO 11 comments

Feb 18 Block Creation in ASO!!! 5 comments

Jan 28 11.1.2.4 released and first impressions 7 comments 14 NUMSys 3.0 - Native User Management System for Shared Services 11 comments 05 NUMSys 2.1 - Native User Management System for Shared Services

2014

Dec 25 How to sort Planning Webform folders 09 Endeca Journey begins 1 comments

Nov 19 Essbase MDX Optimization NONEMPTYTUPLE - Surprises in Essbase Part XI 13 Set Next Month, Previous Month using Current Month Substitution Variable 03 Calculation Manager 11.1.2.3.502 New Custom Functions Part II - Date functions

Oct 27 Using Lead MDX function for dimensions other than Time - Surprises in Essbase Part X 22 Selecting multiple data file and rules file in EAS 2 comments 08 Calculation Manager 11.1.2.3.502 New Custom Functions Part I 14 comments 02 FIXPARALLEL and EMPTYMEMBERSET - Surprises in Essbase Part IX

Sep 30 Shared Member Drill down - Surprises in Essbase Part VIII 12 comments 15 Data Load Rules - Use of data load field names 11 EPMA queries for member properties and more - Understanding EPMA tables Part III 2 comments

Aug 12 Essbase String to Number CDF 8 comments

Jul 29 Oracle EPM Workspace - HTTP 404.13 Request exceeds content length 10 Calculation Manager Execute MaxL and MDX Data Copy 8 comments

Jun 18 Export/Query Batch Scheduler details 2 comments

May 01 Change History Years in Planning on an EPMA application - Understanding EPMA tables Part II

Apr 15 Clear only unique members from data file – FDM 02 Path too long - Hyperion Reporting and Analysis error 7 comments

Mar 12 XREF on a text member in Planning 2 comments

Feb 17 Customize Planning Webforms 7 comments

Jan 16 Deleting a rule in Calculation Manager - Surprises in Calc Manager Part I 4 comments

2013

Dec 20 Run VB script in Workspace 1 comments 06 Substitution Variable Update - Surprises in Essbase Part VII 5 comments

Nov 19 NUMSys 2.0 - Native User Management System for Shared Services 4 comments 04 Smart View Shared Connection in an XML 21 comments

Oct 14 Focused aggregation in Planning Webform 4 comments Automating Essbase member deletion using API 13 comments 01 NUMSys 1.1 - Native User Management System for Shared Services 2 comments

Sep 23 Getting Member formulas from an EPMA Application - Understanding EPMA tables Part I 04 Oracle ACE 12 comments 03 NUMSys - Native User Management System for Shared Services 7 comments

Aug 20 How to generate a Security report for EPM Workspace 8 comments 05 Smart View issues with alternate Hierarchy - Surprises in Essbase Part VI 20 comments

Jul 30 Generate Smartcuts for all objects under a folder 10 comments 17 Naythan - Dad's secret 1 comments 11 IFERROR MaxL - Surprises in Essbase Part V 4 comments

Jun 24 Exploring 11.1.2.3 Planning Features Part II - OutlineLoad from web 3 comments 05 Extract Column/Row/POV properties of Webforms

May 20 Exploring 11.1.2.3 Planning features - Modify Metadata from Smart View 3 comments 09 Customizing EPM Workspace 11.1.2.x Part III 10 comments 02 @CREATEBLOCK - Surprises in Essbase Part IV 8 comments

Apr 30 EPM 11.1.2.3 installation 18 comments EPM 11.1.2.3 available for download 18 Extract Webform Layout in a text file 2 comments 04 Run Batch file in Workspace 62 comments 02 Generate Security report for Planning 9 comments

Mar 19 Extract Supporting detail information from Planning 2 comments 11 Run MaxL in Workspace 27 comments

Feb 25 Essbase Error 1020034 - Binary spreadsheet table token error - Solutions 8 comments 18 Import Text Lists in Essbase 11 comments

Jan 28 Essbase Studio Custom SQL error "No mapping found for class" 1 comments 14 Essbase Origins

2012

Nov 20 @SHARE - Surprises in Essbase Part II and Part III 2 comments 01 SET EMPTYMEMBERSETS - Surprises in Essbase Part I 3 comments

Oct 29 Variable limitations in Calc Manager 3 15 Encrypting Dynamic MaxL scripts (which uses environment variables)

Sep 28 1000th IT title of Packt Publishers 10 Essbase Excel Add-in and SmartView free form retrieval 2 comments

Aug 27 SQL queries for finding folder location of Planning Webforms and more... 10 comments 15 Rotate Planning logs in 11.1.2.1

Jul 23 Monitor last login time in Planning/Essbase 29 comments 05 Create Hyperion Financial Reports from EXCEL 27 comments

Jun 19 Customizing EPM Workspace 11.1.2 Part II 11 comments 05 Failed to navigate from registry-state.displayName error 3 comments

May 30 How many zeros are there in Essbase and How to replace them with #Missing 8 comments

Apr 12 11.1.2.2 Installer Packages Description 29 comments 06 Oracle EPM 11.1.2.2 is released 3 comments

Mar 19 Oracle Essbase 11 Development Cookbook 1 comments 12 Clear ASO database using the members in data file 2 comments

Feb 27 Copy Supporting Detail within same version 1 comments 13 Excel based Essbase outline extractor 14 comments

Jan 30 11.1.2.1 Analyzer (WebAnalysis) Client not getting loaded - Solution 5 comments 24 Customizing EPM Workspace 11.1.2 Part I 17 comments 03 How to check whether a "User" ran a "Rule" after data entry 15 comments

2011

Dec 16 Export Substitution Variables from Essbase and Re-Create 10 comments 15 Calculation Manager rules locked by "which" User 2 comments 05 Bulk file upload with permissions in Workspace 13 comments

Nov 25 Essbase Hot Backup possible!!!! 3 comments 03 Show Usage for a member in Calc Manager Bulk user addition in 11.1.2.1 Shared Services 18 comments

Oct 25 Change weekly distribution of an existing Planning Application 7 comments 12 New Planning Utilities in 11.1.2.1 2 comments 03 Change Start Month in Hyperion Planning

Sep 20 Weeks, Months and Days in Planning Period Dimension 6 comments 08 Variable limitations in Calc manager 2 7 comments 01 Export Essbase Filters from Server and Re-Create 14 comments

Aug 23 @RETURN - Planning Business Rule validation function 4 comments 08 Clear Planning security only for some objects (not Webforms, not Administrators)!!!!! 4 comments

Jul 20 Essbase MDX and Maxl language highlighting in Notepad++ 5 comments 14 Automated Essbase Filter Creation 5 comments 06 Variable limitations in Calc Manager 1 5 comments

Jun 23 Dynamic Maxl scripts using environment variables 3 comments 10 Launch Maxl from Notepad++ 1 comments 02 Essbase language for Notepad++ 29 comments 01 Essbase in Notepad++ (just like EAS console) 27 comments

May 23 Workforce issue while enabling custom dimension 10 Calc Manager error "An error occurred while running the specified calc script.Check the log for details" 03 Change History Years in Planning 12 comments

Apr 25 Neilana, Our little Angel 4 comments 12 Dynamically changing FR Forecast report (Hyperion Financial Reporting) 1 comments 11 Hide prompts in 11.1.2 Planning while using Calc Manager 3 comments 08 11.1.2.1 ready to download 2 comments

Mar 24 Calc Manager Rules deployment issue with EPMA 5 comments 22 How to get Smart View 11.1.2 Shared connections back, if it got removed 15 comments 21 Workspace not showing PDF version of FR report HTTP 500 4 comments 14 How to change Plan Type name in LCM

Feb 15 EAS error while opening up Business Rules 3 comments 10 Place Planning under Maintenance Mode from Command Line 1 comments 02 Kerberos with Websphere and Hyperion Shared Services 11.1.1.3

Jan 27 Essbase DataExport and Formatting 12 comments 20 Financial Reporting Server property files (fr_repserver.properties) in 11.1.2 4 comments

2010

Dec 20 EAS not starting in EPM 11.1.2 with error Unable to open wallet 5 comments 07 Re-initialize Capex and Workforce 3 comments 02 Start Order for Hyperion - 11.1.2 4 comments

Nov 22 How to extract MDX queries fired by Reporting tools 2 comments 15 WebAnalysis - how to show the current user's report when he logs in 04 LEFT and RIGHT functions in Essbase 13 comments 02 Essbase Custom function for time calculation 18 comments 01 Hyperion Financial Reporting import fails for large file 2 comments

Oct 25 Show percentages (%s) in Financial Reporting Charts 2 comments 18 WebAnalysis Relational Database connection issue 13 Set Essbase Refresh timings in WebAnalysis Reports 07 Automation of Level0 Data Load in Essbase 06 11.1.2 Planning Data form changes continued...... 10 comments

Sep 24 How to run CMC as a service 21 11.1.2 Planning Data form changes continued..... 1 comments 14 11.1.2 Planning Data form changes 2 comments 08 11.1.2 Shared Services changes 12 comments

Aug 31 Automation of Hyperion Shared Services User (LDAP) addition process 5 comments 28 Customize Grid Spread in Hyperion Planning 2 comments 10 Customize Workflow in Hyperion Planning 15 comments

Jul 23 Restore Hyperion Shared Services 3 comments 14 Hide and Unhide WebAnalysis reports 11 Getting Member formulas from a Planning Application 2 comments 06 Exporting Users and User provisioning 13 comments 01 How to create next line character in Planning Webform Instructions 5 comments

Jun 18 Session time out while running Business Rules from Hyperion Workspace 12 comments 11 Check Disk space on Hyperion Essbase server 02 Process behind Hyperion Shared Services back-up and files involved in it.... 4 comments

May 20 Re-cover Hyperion Shared Services from error 21 (with screen shots) 11 Recover Hyperion Shared Services from error 21 3 comments 10 Create Essbase substitution Variables from ESSBASE.SEC file!!!! 9 comments 05 Delete Essbase Partitioning 3 comments 04 Oracle EPM 11.1.2 available in E-Delivery 03 How to Encrypt Essbase Maxl Scripts 46 comments

Apr 16 Oracle Hyperion 11.1.2 - Webcast Issue with Hyperion TEXT measure 1 comments 15 Oracle Hyperion 11.1.2 1 comments Manual configuration of Hyperion 11.1.1.3 with Weblogic 9.2 MP3 and Apache 1 comments Enable Kerberos With Workspace 11.1.1.3 & Weblogic 9.2 MP3 & Apache 4 comments Hyperion Excel Add-in Ribbon 2 comments What is Hyperion.....?

---