Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Bring D365 F&O Product Image to AXDW

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

    Posted 18 days ago
    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
    ------------------------------
    AXUG Summit - Post


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

    TOP CONTRIBUTOR
    Posted 15 days ago
    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

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

    AXUG Summit - Post


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

    Posted 15 days ago
    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
    ------------------------------

    AXUG Summit - Post


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