Notifications
Announcements
No record found.
Hello all,
Is there a way I can get a report of the account structures? i.e. the active account structure with Main Account and valid dimension values.
Thanks for your help!
Alex
*This post is locked for comments
Hi Alexander,
There is no standard report for this. The data model is normalized and not easy to understand. The form control for configuring the account structures is especially designed to give an easy to understand overview.
When you setup real complex account structures I wonder if a SSRS report would be easy to achieve. You really need to create a very extended data provider for the report for this requirement. Probably another community member has some more light on this?
I am not sure what you expect inresult output, but you may try the following link:
instructorbrandon.com/sql-for-general-ledger-data-by-dimension-for-building-non-ax-reports-with-ax-data-part-2
Yes it kind of looks like what I want to accomplish... I think I'll give this a try. Thanks Qureshi!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Priya_K 4
Martin Dráb 4 Most Valuable Professional
Ali Zaidi 2