I get asked this question all the time in my work as I am the BI consultant in Dynamics 365 Operations implementations. Customer: “I would…
Why I cannot download .pbix files from powerbi.com
If like me you thought “Hey, it’s a new feature, I can finally create reports in powerbi.com service and then when I need to mashup…
Dynamics 365 AX – Creating Data Entities for BYOD Azure Database including those without a natural key
We, BI professionals, sometimes take for granted that we can access the database of an ERP system quite easily, especially one that is made by…
When not to use Management Reporter
Management Reporter is easy to use to create Management Reports and it does not require a developer to do it. But there are times when…
Using Organization Hierarchies as Reporting Unit filters with Management Reporter
Well, hello. It has been more than three years since my last blog, since then I have been really busy at work and have a…
Using PIVOT function without a CTE
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE. One such case is when…
Microsoft Dynamics AX 2012 – Multiple Rows In Demand Forecast Table [FORECASTSALES] for each item
Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012? This is helpful to know for BI…
Management Reporter Security
Are you confused by how user roles in AX 2012 are integrated with Management Reporter roles? Have problems adding or deleting users in Management Reporter?…
Zap Business Intelligence Installation
This walkthrough helps you to install Zap Business Intelligence. Some of you may need help knowing where to download the files. This is where I…
Conditional Coloured Bar Charts in Excel with Upper and Lower Targets
I was just trying to gauge my BI knowledge level the other day and decided to chart it for visibility. It should be able to…
What is Microsoft Management Reporter for Dynamics AX?
It is a collaborative and interactive reporting solution from Microsoft for finance data. View more here: Management Reporter 2012 Overview How is it different from…
Introducing Microsoft Dynamics AX 2012 with SSRS Reports
Hi all, I’ve started a new job with eBECS which is a Microsoft Gold Partner in the ERP Business. Since I have been there, I…