Answered by:

SSRS AX2009 complex TSQL

Question

has anyone worked with AX2009 using just Tsql , there are a few books out there and they talk about reports using AOT queries, report data provider classes, etc, I worked on a project a year ago and was reporting against a datawarehouse and AX2009
, but they were just simple reports against CustTrans and CustInvoice etc , so I am wondering was I missing something

Answers

If we are using the predefined Dynamics AX data source, click the ellipsis button (...) to open the Select an AX Query dialog box where we can select a query that is defined in the AOT. In this dialog box, we can also select which fields are to be returned
by the query. If we are using a data source other than the predefined Dynamics AX data source, click the ellipsis button. If our data source is a SQL data source, the SQL query builder displays where we can build a TSQL query string. If it is an OLAP data
source, the OLAP query builder displays where we can build an MDX query string.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.