Detailed GL transaction report with one line per distribution including all segments and subledger data, with amounts in both transaction currency and ledger currency. The report includes VAT tax ...

With the above steps, you can connect almost any data source to Zoho Analytics; be it your Zoho ecosystem, third-party apps, business databases, or just spreadsheets on the cloud. Let us see how this ...

ExcelTable is a pipelined table interface to read Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods), and flat files (delimited or positional) as if they were external tables.

I recently had some interesting problems and learned some cool solutions while working in Power Query in Excel =] ! The first problem I had was that I was trying to create a dynamic SQL query based on ...

This post would explain how to Integrate BI Publisher with ADF Fusion Application to generate report programmatically. The overview of BI Publisher & BI Publisher Desktop is not discussed here. Sample ...