Forum Discussion
Financial Reporting - Parent summation
Hi - new to BI. Have a table construction via a function in SQL as such: account_id parent_account_id parent_account_id account_type_code depth adj_amount 1000 NULL CATEGORY Asse...
Hi thanks for the reply.
Output would be based on account_type_code and the roll-up of the amount - here's an example in excel that i was looking to replicate.
Hi -
i made modifications to use the Hierarchical data type in SQL now, so i have an inherent path for my nodes. https://docs.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-2017
How can that be utilized in BI?