Analytical Accounting Historical Prior year (2019) GL Trx Dimensions are not showing up in AATransactions view

(1) Share

Report

Posted on by jgdynamicsBI

I trying to create report for Power Bi with using AA Trx Dimension Codes (we call them projects) from 2020 AA with historical 2019 AA GL TRX. I do believe

..AAG40000 has historical AA data that I join to the other tables below.

-- THis is how my joins look
JOIN Company..AAG30003 e 
		ON (e.aaGLHdrID = d.aaGLHdrID and e.aaGLDistID = d.aaGLDistID and e.aaGLAssignID = d.aaGLAssignID)
JOIN Company..AAG00400 f 
		ON f.aaTrxDimID = e.aaTrxDimID
JOIN Company..AAG00401 g  
		ON g.aaTrxDimCodeID = e.aaTrxCodeID

Categories:

Microsoft Dynamics GP

All responses (1)

Answers (0)

Suggested answer

Derek Albaugh on at

Like (0)

Report

RE: Analytical Accounting Historical Prior year (2019) GL Trx Dimensions are not showing up in AATransactions view

My first question is whether you're using Power BI Desktop or online Power BI?

Also, are you pulling the AA data through anything like OData, or just pulling the custom SQL view directly into Power BI?

If your custom SQL view pulls data when run directly in SQL Server Mgmt Studio, I'm not sure why it wouldn't pull in Power BI, depending on what you're actually seeing?

Do you get any type of error message when trying to create the report in Power BI to pull the AA data, or does it just simply not show any data?

Thanks