SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Terry's Business Intelligence

Terry is a BI Developer in London, focusing on DataWarehouse design and Reporting using SQL Server SSIS/SSAS/SSRS.

Archives: May 2014

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 for cubes that aggregate the data in the [FORECASTSALES] table. Basically the overview line and each exploded line of the same item is stored in…

Read more

1 comments, 589 reads

Posted in Terry's Business Intelligence on 28 May 2014

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? Get your answers here. In the last couple of weeks I have been asked by AX developers about Management Reporter Security. Mainly, they were stumped…

Read more

9 comments, 720 reads

Posted in Terry's Business Intelligence on 23 May 2014