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...
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,...
Multi-values Checkboxes m-Power maintainer type applications have long supported checkboxes as alternative options to a text input. A checkbox list in a...
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).
Master Dictionary Menu A recent common request has been the ability to control multiple dictionary menus from a central/master dictionary. In the past,...
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...
Custom Parameters Overview m-Power allows developers to pass variables directly from and to any mrc application via Freemarker. There are two main...
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...
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...
