ENUM values missing in SRSANALYSISENUMS Table



原文： http://tech.alirazazaidi.com/enum-values-missing-in-srsanalysisenums-table/

做数据库中BI开发的时候发现一些ENUM的值没有，查看一些文章发现表“SRSANALYSISENUMS”主要是为了AX自带的SSAS Cube服务的,所以并不是所有的ENUM值都可以在这张表找到。可以将使用这些ENUM值的表增加到Propectiv,然后执行类“BIGenerator”的"populateSRSAnalysisEnum"方法就可以将这些ENUM值更新到表中去了，愉快的使用吧。下面是网上找到的具体的操作步骤。

During one of assignment, I have to get some data directly from Dynamics Ax table in SQL Server.

All enum based column in table shown their numeric values in Sql Server. For Analysis services Or OLAP services Dynamics Ax holds a table with name “SRSANALYSISENUMS”. This table contains the all enum which are used inside the Cube ETL process.

Analysis services was not install on my machine, for this reason “SRSAnalysisENums” table was empty.

This table is populate with static method “populateSRSAnalysisEnums” of class “BIGenerator”. We can directly run this method to populate the require table so we can join it in SQL server to get enum display/Name in query result instead of their numeric values.

If you have custom table which has one or more tables are based on Enum data type. Or your required enum values are not present in “SRSANALYSISENUMS”.  You have to perform following steps.

• Create a new prospective.
• Drag required table in Table node of new prospect.

• Save the prospect.
• Open a new job inside the Dynamics Ax AOT node.

 

• Run a static method populateSRSAnalysisEnums() of class BIGenerator as follow

static void Job4(Args _args)
{
//BIGenerator _Bi= new BIGenerator();
BIGenerator::populateSRSAnalysisEnums();
}

• You will find that SRSAnalysisENums” will be populated and your required Enum will be present there.