Why Can't I Add Second Child Datasource in View ?

(0) Share

Report

Posted on by 00030000036294D5

117

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 the same question (0)

All responses (7)

Answers (0)

Sort by

Martin Dráb 239,364 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It should be possible, AFAIK. What does exactly happen when you try to add the data source?

Was this reply helpful? Yes No
00030000036294D5 117 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
00030000036294D5 117 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Martin Dráb 239,364 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
00030000036294D5 117 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
00030000036294D5 117 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jeson 120 on at

Like (0)

Report
Copy link

Link copied!

Hi, i think you cant add more than 1 datasource on view, maybe try to construct it on a query and drag the query to the view.

Was this reply helpful? Yes No