Havas Labs

Cases where MDX is a better alternative to cube rules

I wanted to share a few examples where I’ve used MDX in place of a cube rule.

Useful IBM Planning Analytics for Excel (PAFE) Batch Scripts

Here are some useful batch scripts for IBM Planning Analytics for Excel (PAFE) Operations. Can use this as baseline to automate install / setup / deployment / configuration of IBM PAFE to end users. If you don’t want to run in Windows Command Prompt or Batch file, you can review the below and navigate directly to the appropriate registry keys or directories and adjust manually.

Add child element to parent element while specifying its position using TM1 REST API

It’s possible to simultaneously create a child element and specify its position under a parent element using TM1 REST API.

Seamlessly connect Salesforce with Tableau Cloud

Before you embed a Tableau View (from Tableau Cloud) onto a Salesforce Lightning Page, consider these extra setup steps to ensure a seamless experience, without extra login screens for users.

Customize New Record Page

Salesforce gives you a lot of flexibility. At times you need pointers to customize your App the way you imagined. One such example is customizing the layout of a new record page. I’ll show you exactly how to accomplish that.

Useful Salesforce SOQL Queries

Here are some useful Salesforce SOQL queries for reporting that isn’t easily available otherwise.

TM1 Rule-based Approach for Internal Rate of Return (IRR)

TM1 does not offer a native IRR function. After three years of on-again/off-again thinking through and researching online how to construct a proper TM1 rule-based IRR calculation, I’ve built this methodology which has been used in a production environment for several years.