Category Archives: The Quick Fix

The Quick Fix – How to create a financial dashboard in IBM Planning Analytics Workspace

IBM Planning Analytics Workspace (PAW) is a web interface that can be used for multiple tasks. You can: Consume Excel reports Pivot and analyse data Develop models for budgeting and forecasting Set up business logic to match the company’s requirements Read and write back to the TM1 Server Develop dashboards by simply dragging and dropping […]

The Quick Fix – What is Bedrock v4

Bedrock has been trialled and implemented for over many years in an array of projects in different organisations and industries globally, results have shown: 30-50% reduction in TurboIntegrator coding Increased scalability Dramatically faster prototyping Increased auditing and testing Reduced development time The model would be clearer to understand, therefore making it easier to maintain With […]

The Quick Fix – What is TM1 and Planning Analytics

TM1 and IBM Planning Analytics is a functional database that works with seamlessly with Excel that takes reporting and modelling to the next level. Are you a heavy Excel user and have come across these headaches? Slowness or crashes due the amount of data stored in your report Unable to have multiple staff collaborate on […]

The Quick Fix – What is a DBRW formula

DBRW is one of the key TM1 and Planning Analytics formulas that provides read and write back capability to Excel for the functional database. We can thank the inventor of TM1, Manny Perez for this clever idea. It’s inescapable on how important these four characters mean to the product’s integration with Excel. Syntax DBRW(TM1ServerName:CubeName, Element1, […]