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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 01.03.2011, 22:11   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Measure 'Total purchases' in Accounts payable cubes for dimension 'Vendor Master' shows values Uknown
Источник: http://blogs.msdn.com/b/emeadaxsuppo...es-uknown.aspx
==============

Some time ago I run into problem that measure ‘Total purchases’ for dimensions ‘Vendor Master’ did not work. There was only values for attribute Uknown. So I was not able to see what was sum of vendor purchases for each vendor although I had bunch of Purchase Orders which were posted and invoiced.

First step to troubleshoot this issue was to find out what exactly query is hidden under measure ‘Total purchases’ To do it in Business Intelligence Development Studio when you look into Source Property of ‘Total Purchases’ measure:



You can that values are coming from VendTransTotalPurchase.AmountMST.

When you go to data source view Dynamics AX you will that VendTransTotalPurchase it is named query and you will be able to see query behind.

If you wan to change this query to get data for Vendor account number I got following:

SELECT     VENDTRANS.ACCOUNTNUM,  sum(AMOUNTMST), VENDTRANS.DATAAREAID, VENDTABLE.NAME
FROM         dbo.VENDTRANS, dbo.VENDTABLE
WHERE     (INVOICE '') and VENDTRANS.ACCOUNTNUM = VENDTABLE.ACCOUNTNUM and VENDTRANS.DATAAREAID = VENDTABLE.DATAAREAID
group by VENDTRANS.ACCOUNTNUM, VENDTRANS.DATAAREAID, VENDTABLE.NAME
order by VENDTRANS.DATAAREAID
If I run this query I could see correct values for each vendor, but still I could not see it in ‘Vendor master’. So my next step was to get closer look on Vendor Master dimension.

I found that when processing dimension Vendors master attribute Vendors (key) there is very long and very complex query which I will not copy here, but the most important was where expression which looked like:

WHERE
  (
   
  (
   [VENDTABLE].[DATAAREAID]   =  [EMPLTABLE].[DATAAREAID]
  )
     AND 
  (
   [VENDTABLE].[MAINCONTACTID]   =  [EMPLTABLE].[EMPLID]
  )

  )

The I looked into my VENDTABLE and I saw that indeed the field MAINCONTACTID was not set up.

In summary to solve problem I needed in Dynamics AX Client for each Vendor update field Main Contact on General tab (to assign employee to vendor – it can be dummy empl) after that processing Vendor master dimension and Accounts payable cube is needed. It worked !!!

--author: Czesława Lagowska --editor: Czesława Langowska --date: 1/March/2011




Источник: http://blogs.msdn.com/b/emeadaxsuppo...es-uknown.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
emeadaxsupport: Dynamics AX OLAP cubes shows data only till 2008 year Blog bot DAX Blogs 0 07.02.2011 16:11
emeadaxsupport: How to add financial dimension to Dynamics AX Default cubes Blog bot DAX Blogs 0 13.01.2011 16:11
emeadaxsupport: Solving various issues when using Export to Excel feature in Chart of Accounts Form (Microsoft Dynamics AX 2009) Blog bot DAX Blogs 0 15.07.2010 20:08
emeadaxsupport: Passing UtcDateTime values in extended query syntax Blog bot DAX Blogs 0 10.05.2010 21:05
Настройка проводок в Accounts Recevable/Payable Lauskas DAX: Функционал 6 20.07.2003 23:00
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

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