Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to create a custom...
Finance forum
Suggested answer

How to create a custom CUBE in D365 FO

Posted on by
HI,  Dear Experts:
  

  we previously used the old version of AX to create various analytical data warehouses. Now in D365, we found that there is no place to create CUBEs. Is there a way to customize a data warehouse in D365 to create CUBEs for our own custom analytical reports? We found that the performance of Entity Store is not good enough. Are there any better recommendations?

   Thanks a lot!

  

 
  • Anthony Blake Profile Picture
    Anthony Blake 1,207 on at
    How to create a custom CUBE in D365 FO
    Entity Store is the logical replacement, the alternative would be to get your data into SQL via data lake or synapse link, and build your OLAP cubes in Azure: https://learn.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    How to create a custom CUBE in D365 FO
    Hi,

    Documentation for reporting Dynamics 365 data using Power BI can be found here: Reporting and analytics with Power BI home page - Finance & Operations | Dynamics 365 | Microsoft Learn
    I would suggest reading through the documentation first. Let us know in case you have specific questions.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    How to create a custom CUBE in D365 FO
    Moved to the Dynamics 365 Finance forum.
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans