Uncategorized
We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.
SUBST TM1 Function (like Excel MID or SQL Server SUBSTR): Use and Syntax
The SUBST function is essentially the same as the Excel MID function or the SQL Server SUBSTR function, in that it allows you to select a group of characters of a specified…
Recommendations for Infocube
We always value recommendations from our clients. Here is what a couple of our clients have recently said about us: Dick Smith Electronics Recommendation “Many thanks to the Infocube team for their…
Scan TM1 Function: Syntax and Use
Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is…
Scan TM1 Function: Syntax and Use
Scan is a TM1 function that find the numeric position of the first instance of a specified substring within a string. If the substring is not found, it returns zero. It is…
Using STET and CONTINUE in TM1 Rules
Often we want to tell TM1 to ignore this cell and move onto the next cell if a certain condition is met (or not met). To do this we would…
Using STET and CONTINUE in TM1 Rules
Often we want to tell TM1 to ignore this cell and move onto the next cell if a certain condition is met (or not met). To do this we would…
ELPAR TM1 Function: Syntax and Use
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use…
ELPAR TM1 Function: Syntax and Use
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use…
ELPAR TM1 Function: Syntax and Use
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use…
ELPAR TM1 Function: Syntax and Use
ELPAR stands for Element Parent, which describes what it does pretty well! In other words it returns the parent of an element in a defined dimension. You are better to use…
Need help with TM1?
We're here for you
Keen to chat? Book a discovery call!