You’re offline. This is a read only version of the page.
115
Hi all,
I am working on a view. On top, I have SalesTable as parent datasource in my view. Inside it, I have SalesLine as child datasource. Inside SalesLine datasource, I have InventDim as second child datasource.
According to my new requirement, I need to add MarkupTrans as new child datasource. I want to put it besides SalesLine datasource because I want to set its join with SalesTable, but AX won't allow me to do it. Can somebody tell why it is happeneing.
Or is it OK to have MarkupTrans inside InventDim and make its relation with SalesTable instead of InventDim, will it work ?
I have seen an example in standard AX where a view has multiple datasources at same level but then I realized that actually on top there is a query attached as datasources and these multiple tables are attached inside the query datasource.
Martin, my view is not based on a view. I just have SalesTable in the datsource and inside it, I have other tables like SalesLine and InventDim.
My view does not have any query attached to its datasource, rather my view is attached to a query as its datasource.
Unfortunately I don't use AX 2012 anymore, therefore I can't test it there, but I'm pretty sure that it can be done. I don't know what is cause of your problem. Isn't your view based on an existing query?
Anyway, let me try to convince you that it having multiple data sources at the same level is possible. You should be able to find standard views with such data source, which would prove that it's possible. For example, look at CustTableCube. Below is a screenshot from F&O, but I believe that this view exists in AX 2012 and I assume that it has a similar structure.
Using InventDim as the parent data source doesn't make a good sense to me. You can try it if you want to know whether it would wokm but I wouldn't do that even if it's technical feasible.
Or is it OK to have MarkupTrans inside InventDim and make its relation with SalesTable instead of InventDim, will it work ? Martin please answer this one as well. I have done it this way, but in my class where the view fields are assigning values to the table, fields from MarkupTrans table are showing black values in debugger?
When I right click on datasource, it does not show me option 'add new datasource'. When I try to drag and drop the table, there appears a black circle over the datasource button. what do I do ?
It should be possible, AFAIK. What does exactly happen when you try to add the data source?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (