D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Bring D365 F&O Product Image to AXDW

  • 1.  Bring D365 F&O Product Image to AXDW

    SILVER CONTRIBUTOR
    Posted May 31, 2019 04:11 AM
    Hi,

    I guess we all know D365 has its own DW database (for Analysis Service) called AXDW. It is populated by Refresh Entity Store (System Administration / Setup / Entity Store)

    There will be a list of what they called now is Aggregate Measurement (the old days called Cube for SSAS Multidimensional).

    Well, the question is can we include image data, such as Product image which store in EcoResProductImage in that Aggregate Measurement.

    Thanks,



    ------------------------------
    An Ton
    Hunter Douglas
    ------------------------------


  • 2.  RE: Bring D365 F&O Product Image to AXDW

    TOP CONTRIBUTOR
    Posted Jun 03, 2019 02:23 PM
    Hi An,

    Interesting question. I have not tried adding any entities that have an image field. It is possible to add new/additional aggregate entities to Entity Store; and might allow an image field to be added. More info on adding aggregate measurements here:

    https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/model-aggregate-data

    I think your best option is going to be setting up BYOD and exporting your F&O data entities to your own Azure SQL Server db.

    Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | #MSDyn365FO
    Microsoft remove preview
    Bring your own database (BYOD) - Finance & Operations | Dynamics 365 | #MSDyn365FO
    This topic explains how administrators can export data entities from Microsoft Dynamics 365 for Finance and Operations into their own Microsoft Azure SQL database. This feature is also known as bring your own database (BYOD). The BYOD feature was released in Microsoft Dynamics AX with platform update 2 (August 2016).
    View this on Microsoft >
    https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/export-entities-to-your-own-database

    Mike


    ------------------------------
    Mike Hammons
    Director, Business Intelligence
    AKA Enterprise Solutions

    ------------------------------



  • 3.  RE: Bring D365 F&O Product Image to AXDW

    SILVER CONTRIBUTOR
    Posted Jun 03, 2019 09:52 PM
    Hi Mike,

    Thanks for your advise, and those links. Well to switch to another method needs a lot of discussion, survey and big decision as it will change the "course" of our entire applications.

    Anyhow I do trust your experience on this, Much thanks,

    An

    ------------------------------
    An Ton
    Hunter Douglas
    ------------------------------



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