Translate

Wednesday, May 3, 2017

List of table Ids in AX- SQL dictionary

Hi,


If you ever want to know where all table Id of AX tables are stored? here is the answer its SQLDICTIONARY


here is a query to know the table ID for VendTable

select tabId from sql where sql.sqlName=='VendTable'
&& sql.array==0;

Hope this Helps!
Prasan

Tuesday, March 14, 2017

Power BI documents

Hi,

Found some interesting topics that would help to explore much on data analysis and reporting.

Microsoft Power BI Documents

Introducing Microsoft Power BI, by Marco Russo and Alberto Ferrari:
http://www.sqlbi.com/books/introducing-microsoft-power-bi/

Power BI tutorial videos from Adam Saxton:
 
hope you get on to this.
 
Thanks,
Prasan

Monday, March 13, 2017

Dynamics AX 7 Wikipedia

Hi folks,

Below is the link where you can find documentation of AX 7.0 and dynamics 365 for operations. Happy Daxing!!

https://ax.help.dynamics.com/en/

Thanks,
Prasan