Averaging Values in Pivot Tables The Pivot Table Report template aggregates data across various combinations of dimension keys. While standard summing rolls up perfectly across...
Date Calendar Table The article addresses the challenge of working with non-standard date formats (e.g., yyyymmdd, mmddyyyy, cyymmdd) in databases. To facilitate date arithmetic, filtering, and conversions, this will show you how to create and use a Date Calendar Table that maps various date representations to a standard ISO format (yyyy-mm-dd).
Period Analysis — Prior Year Adjusted The Period Analysis feature within m-Power reports provides an excellent way to compare data from different time frames. Such as,...
Master Dictionary Menu A recent common request has been the ability to control multiple dictionary menus from a central/master dictionary. In the past,...
Custom Parameters Overview m-Power allows developers to pass variables directly from and to any mrc application via Freemarker. There are two main...
Upload Spreadsheet Data on a Schedule The Data Upload template is very useful to allow end users to take spreadsheet data and insert it into the...
Subtotal Level Formatting Options This techblog post will discuss two options in regards to the layout and presentation of subtotal levels in the m-Power...
Storing Session Information Overview Occasionally, you may want to save a variable for use in other applications. The User Session Template allows you...
m-Painter Editor Theme Background Overview This post details how to change the default background color and theme of the mrc Editor Theme, which controls...
General m-Power Troubleshooting Overview When working with m-Power it can happen where an application does not behave as expecting or the data returned...