Finance | Project Operations, Human Resources, ...

Required table relationship

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi Team,

I am a Power BI developer and need to fetch the data from AX 2009 (V5) to create a Power BI report.

Could you please help to find the relationship between the below tables to create a query in AOT level.

1. CustInvoiceJour

2.CustInvoiceTrans

3.InventDim

4. InventTable

5. SalesTable

6. Address

7. CustGroup

8. CustTable

Please consider "CustinvoiceJour" as the main/primary table.

and Address table needs to map with respect to Invoice account and CustGroup needs to map with respect to Customer account.

Thank you in advance.

All responses (7)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Required table relationship

Thank you, I will check with the AX team to increate the Buffer size.
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Required table relationship

Try to increase the max buffer size, as instructed by the error message.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Required table relationship

Hello @Nikolaos Mäenpää

I have created Query and View as mentioned above format, but while synchronize getting an error message.
[quote]
Looks pretty much ok. Of course you need to test your query and verify it yourself.
[/quote]
Suggested answer

nmaenpaa 101,156 on at

Like (0)

Report

RE: Required table relationship

Looks pretty much ok. Of course you need to test your query and verify it yourself.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Required table relationship

Hello Ludwig,

Thank you for the response.

Yes, I have AOT level access, please see the attached table relationship. Is this the correct relationship?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Required table relationship

Hello Lokamba,

If you open those tables in the AOT then you should be able to see the relationships to other tables. Do you have access to the AOT?

There is also a cube reference guide for AX2009, which might help you getting some additional information on how to design your reports.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

Tables Relationship

Hi Team,

I am a Power BI developer and need to fetch the data from AX 2009 (V5) to create a Power BI report.

Could you please help to find the relationship between the below tables to create a query in AOT level.

1. CustInvoiceJour

2.CustInvoiceTrans

3.InventDim

4. InventTable

5. SalesTable

6. Address

7. CustGroup

8. CustTable

Please consider "CustinvoiceJour" as the main/primary table.

and Address table needs to map with respect to Invoice account and CustGroup needs to map with respect to Customer account.

Thank you in advance.