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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 28.10.2009, 00:06   #1  
Blog bot is offline
Blog bot
Участник
 
25,631 / 848 (80) +++++++
Регистрация: 28.10.2006
emeadaxsupport: Query execution failed for data set 'Company'
Источник: http://blogs.msdn.com/emeadaxsupport...t-company.aspx
==============

Recently we were having problems to get the Role Center up and running. Report Server is setup and working in a correct way. Most reports can be generated, but a few does not answer correct. For those report the following error is generated: “Query execution failed for data set 'Company'” Reports in Role Center can not be accessed. Even those that default company was set in Business Connector Configuration Utility and on the connection tab correct AOS was set up we were still not able to make report working.
The root cause of this problem was that cubes in OLAP database DynamicsAX were not processed.
To solve the problem we were following WhitePapers which let us configure cubes and Role Center:

  1. The “Configure the Default OLAP Cubes” white paper and the cross-reference document are now available here: http://www.microsoft.com/downloads/d...displaylang=en
  2. Microsoft Dynamics AX 2009 White Paper: Configuring Kerberos Authentication with Role Centers: http://www.microsoft.com/downloads/d...DisplayLang=en
  3. Microsoft Dynamics AX 2009 White Paper: Configuring Enterprise Portal and Role Centers with SQL Reporting http://www.microsoft.com/downloads/d...displaylang=en
  4. Fixing Microsoft Dynamics AX Cube Processing Errors Caused by EDT Field Changes: https://mbs.microsoft.com/partnersou...ocessingErrors
The way how we troubleshoot the problem was following. We had problem with report ProjUtilizationEffeciencyEmpl.

Report ProjUtilizationEffeciencyEmpl is based on Project Accounting Cube.

If Company data set cannot be processed it seems there is something wrong with this cube. Company data set is called with following query:



WITH
MEMBER [Measures].[ParameterCaption] AS '[Company].[Company accounts].CURRENTMEMBER.MEMBER_CAPTION'
MEMBER [Measures].[ParameterValue] AS '[Company].[Company accounts].CURRENTMEMBER.UNIQUENAME'
MEMBER [Measures].[Key] AS '[Company].[Company accounts].CURRENTMEMBER.Properties("Key")'
SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[Key] } ON COLUMNS , Except([Company].[Company accounts].MEMBERS, {[Company].[Company accounts].[All], [Company].[Company accounts].[Unknown]})
ON ROWS FROM [Project Accounting Cube]



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

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Классы коллекций (инициализация, сериализация): List, Set, Map. petergunn DAX: База знаний и проекты 12 06.11.2024 18:38
emeadaxsupport: Unable to install Dynamics AX 2009 Analysis extensions when the default SQL Server Analysis Server collation is set to Turkish_CI_AS or Turkish_CS_AS Blog bot DAX Blogs 0 22.09.2009 04:06
emeadaxsupport: How to set the number sequence for Global Address Book when virtual companies are used Blog bot DAX Blogs 0 24.08.2009 14:05
Dynamics AX: QueryRun and Query Objects - Binding operation failed to allocate buffer space Blog bot DAX Blogs 0 03.04.2009 08:05
Говорят вышел SP2 для Axapta 3. Кто нибуть что знает на эту тему? soin DAX: Прочие вопросы 10 13.10.2003 10:43
Опции темы Поиск в этой теме
Поиск в этой теме:

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

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

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

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 02:55.