AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 27.04.2017, 12:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
stoneridgesoftware: Part II: Publishing a Dynamics AX 2012 R3 Default Entity
Источник: https://stoneridgesoftware.com/part-...efault-entity/
==============

This blog is a continuation from Configuring the Dynamics AX 2-12 R3 Entity Store.  This is part 2 of a 3-part series:

Part 1Setting up and Configuring the Dynamics AX 2012 R3 Entity Store

Part 2Publishing a Dynamics AX 2012 R3 default entity

Part 3 – Creating and publishing a custom Dynamics AX 2012 R3 entity

When we last left off we had configured the Entity Store but hadn’t published an Entity due to challenges with some of the default entities fields (namely the memo field). For this blog, I’ll be publishing the SalesTable entity since it does not contain the memo field. To do this, I selected the SalesTable entity and clicked Publish:



Then I selected my source and clicked publish . . . .DRATS! Foiled again!



Apparently, some of the tables that are referenced by the DMFSalesTableTargetEntity query (tables referenced in the data sources) do not have the ModifiedBy property set to Yes.  This means I’ll have to locate all the tables in all the data sources and verify that ModifiedBy is set to Yes.  To do this I did the following on the SalesTable and PriceDiscChangePolicy table.
  1. In the AOT go to Data Dictionary, Tables, [Table]
  2. Right click on table (if properties pane does not appear on the right) and select Properties
  3. Find the Modifiedby property and change it to Yes
  4. Click the Save button in the AOT
  5. Synchronize
  6. Restart the AOS (I found this was required for it to pick up the changes, your mileage may vary)




Once the SalesTable and PriceDiscChangePolicy reflected the change I went back and attempted to republish the SalesTable entity.



Success! Now to check I opened up SQL Server Management Studio and queried the table that was published (DMFSalesTableEntity).  As you can see there is no data because this only published the definition (schema) of the entity to the database but did not push the data over.



To populate the table with data, go back to AX, open the Data import export framework Area page and click on Manage refresh schedule.



Click New.



Create a group to hold the entities that you will sync.



Once a group is created, select it and then click Entities.



Select the SalesTable Entity we created before (ignore the other one, that will be in a later post on creating a custom entity)



Select the source



Click New schedule



Within the schedule form you have 2 ways to get data:
  1. On a schedule
  2. Ad-hoc


If you simply click OK, the dialog will close and the population process will kick off.  You can also schedule this to run on a batch server and on a set schedule (click Recurrence) for an automatic incremental refresh.  For now, I’m going to click OK. When the processing is complete you will see something like this:



Back in management studio I now see data!



And that completes publishing a default entity. For the final post, I will cover how to modify the existing entities that contain memo fields that are incompatible with SQL.  For now, you can hook up PowerBI to the table that was created and start reporting!



Источник: https://stoneridgesoftware.com/part-...efault-entity/
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
axsa: Extensibility in Dynamics AX 2012 R3 CU8 (CRT, RetailServer, MPOS) Part 2 – New data entity Blog bot DAX Blogs 0 21.05.2015 01:19
axperf: Multiple new Benchmarks released: Microsoft Dynamics AX 2012 R2 Multiple Retail Workloads, Microsoft Dynamics AX 2012 R3 Financial Benchmark, Microsoft Dynamics AX 2012 R3 Day in the Life Benchmark for Retail and Distribution Blog bot DAX Blogs 5 13.01.2015 14:26
ax-erp: Creating SSRS-Reports in Dynamics AX 2012 – What’s no longer possible in AX-reports Blog bot DAX Blogs 0 18.07.2012 12:11
axinthefield: Dynamics AX Event IDs Blog bot DAX Blogs 0 01.03.2011 22:11
german_nav_developer: Buildnummern-Übersicht Microsoft Dynamics NAV 2009 SP1 Blog bot Dynamics CRM: Blogs 0 11.06.2010 16:33
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 08:45.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.