The Pivot Table Report template aggregates data across various combinations of dimension keys. While standard summing rolls up perfectly across subtotal levels, standard averaging does not — defaulting to mathematically incorrect “averages of averages” across stacked dimensions. To ensure accurate reporting, this template uses a true weighted average. Setting this…
This techblog post will discuss two options in regards to the layout and presentation of subtotal levels in the m-Power Regular Report template. Subtotals Below (or Above) Details By default an m-Power Regular Report application will print the subtotal level(s) below the details, like so: However if desired, the report…
With the June 2024 update, m-Power has transitioned from log4j1 to log4j2. This change is aimed at enhancing security and performance. However, this update also brings some adjustments for applications previously compiled with log4j1, as they will now have limited logging capabilities. To fully restore logging functionality, please follow the…
Overview Perhaps you have read the documentation on Creating a Line Graph with a Static Goal Line, however your use case is different. Instead of a static line, you need a dynamic goal line. Fortunately, FusionCharts (the graphing library that m-Power uses) has the ability to display a trendline in…
A recent common request has been the ability to control multiple dictionary menus from a central/master dictionary. In the past, the answer for this request has been to drop the mrc security tables from the database and create views in each dictionary pointing to the master dictionary security tables. While…