Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
When I try to drag a View into the dataSource of another view (AOT), it failed.
I get a node with the name of the view followed by "INVALID TABLE".
It is the same thing when I try to add a DataSource manually:When I set the Table property of the DataSource to the view's name, it changes to UNKNOWN when I'm leaving the Table field.
Is it possible to use a view as a DataSource ?
If so, why do I have this message?
The key is to set up your data sources first on a query in the AOT, then use that query in the view.
A view can be used as a data source within another view. Have you tried defining a query for the second view in the AOT which uses the first view as one of its data sources, then dragging this query onto the metadata node of the second view?
The standard DirPartyPostalAddressView in your example is an example of this.
Thanks for the reply.
The problem is that I did not create the second view. it is an AX view.
Beside, the second view (LogisticsPostalAddressView) is a Query view.
I don't know if you can test that:
Create a new view in AOT.
Drag LogisticsPostalAddressView (or any view) onto the metadata/data source node of the view.
I must be doing something wrong somewhere.
That's a good workaround.
When I wrap the view inside a Query, I can put it in a datasource.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13