D365 Finance & Operations and Dynamics AX Forum

BI/FP&A Solution for AX 2012

  • 1.  BI/FP&A Solution for AX 2012

    Posted 21 days ago
    Greetings AX/D365 UG,

    I would like to get anyone's thoughts and input on what folks are doing to deliver structured BI/DW and FP&A, primarily for Finance users of AX 2012 but that can also migrate with us to D365 in the future. Here are the high level requirements that we are looking at for product recommendations.

    • Dimension management
      • The ability for power users to have a UI to maintain attributes and hierarchies for dimensions such as Account, Department/Organization, and others.
    • Security management
      • The ability for an admin to configure row-level security by any combination of legal entity, department, accounts, across calculated measures (facts).
    • Planning/Forecasting tool
      • A user interface to create and maintain financial model forecasts such as projected revenue or expense forecasts and the ability to run forecast to actual reports.
    • Solution must be OLAP/Cube based as to avoid contention between data processing and reporting.

    We currently have a custom developed financial data warehouse so looking for ideas of what products/tools other AX shops are using.

    Thanks
    Jeff
    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role