Skip to content
Microsoft Dynamics 365 Blog

AX Content: Using Power View with Dynamics AX 

Have you heard about Power View? Microsoft introduced the interactive data exploration, visualization, and presentation tool with SQL Server 2012. You can use it with Microsoft Dynamics AX to build some amazing-looking reports. It’s just another reporting tool, isn’t it? I’ve been a technical writer for 14 years. I’ve seen my fair share of reporting...

Read more

Dynamics AX Reporting Error “No such host is known” when running report which is based on cubes 

Some time ago we run into the issue when Dynamics report which were based on cubes sudenly stopped working. Ie. CFOProfabilityAnalysis.RoleCenter report was raising following error “An error has occurred during report processing. (rsProcessingAborted)       Query execution failed for dataset “Company” (rsErrorExecutingCommand)          A connection cannot be made.Ensure that the service is running.               No...

Read more

AX 2009: The “Goal” value in the Profitability Analysis report on RoleCenter page pages does not show the budgeted values 

I came across this sometime back now. The “Goal” value in the Profitability Analysis report on RoleCenterpage pages does not show the budgeted values. Going through the KPI underneath the Report I found: -The general ledger KPIs in the analysis database does not take into account any budget defined in AX Client as the goal...

Read more

Dynamics AX Business Intelligence blog 

I run into this blog some time ago. It is lead by Saveen Reddy who is Product Manager for Dynamics AX Business Intelligence. On his blog you will find the bunch of screen cast which will help you to develop reports: http://blogs.msdn.com/b/dynamicsaxbi/archive/2010/12/01/ax-ssrs-reporting-screencast-list.aspx as well some sneak previews regarding Dynamics AX 2012 and BI. Blog: http://blogs.msdn.com/b/dynamicsaxbi/...

Read more

Dynamics AX OLAP cubes shows data only till 2008 year 

Some time ago we run into following problem. When we browsed Accounts Receivable Cube for Total Sales dimension we could see data only till 2008 year, the data for years: 2009, 2010 and 2011 where just simple not displayed. The first idea was to try solution from following post: http://blogs.msdn.com/b/emeadaxsupport/archive/2011/01/07/olap-time-dimension-does-not-contain-dates-for-year-2011.aspx but it did not help....

Read more

Error when accessing form “BI generation options” 

You get error when opening form Administration > Setup > Business analysis > OLAP > BI generation options Cannot execute the required database operation. The SQL database has issued an error and in Application event viewer on AOS server you can find following entry The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Invalid column...

Read more

How to add financial dimension to Dynamics AX Default cubes 

Lately we got some request regarding this subject. Unfortunately in current version the is no way to get it done automatically. The process as the cleaning cubes process is quite complex and manual. Although with help of team we managed to create attached draft document with step by step documentation how to add financial dimension...

Read more

OLAP Time dimension does not contain dates for year 2011 

I ran into this problem when running TS_DeliveryPerformance report which was simply empty. After investigation I saw that all packing slip transactions made in January 2011 were shown in Sales Cube under Unknown year. Going forward when I browse Time dimension I could see that dates are only generated till the end of 2010 year. ...

Read more

Problem with CEO Role Center 

Sometimes I can see following problem. In the CEO role center the financial KPIs give following error: The error is Query (1, 9) The Total Revenue-Argument for the given KPIVALUE-Function must be a KPI-Name (Key Performance Indicator). Here problem is quite easy. For General Ledger KPIs please make sure that Ledger account categories are correctly...

Read more