In my last blog I did a demonstration of using an SQL query to build a PowerBI report for the general ledger transactions.
I hard coded the RecId for the financial dimensions. It might be cumbersome to build the query manual. So here I wrote a job you could run to get the query. It will spit out an infolog which you should be able to copy and paste.
static void navax_generateGLQuery(Args _args)
Its a bit crude but at least you get all the dimensions.