导航

获取Finacial dimension value的description 值

Posted on 2015-06-11 16:59  Tokywu  阅读(211)  评论(0编辑  收藏  举报
public static Description findDimensionValueDescription(DimensionValue _dimensionValue, Name _dimensionAttributeName)
 { 
     DimensionFinancialTag dimensionFinancialTag; 
     DimensionAttributeDirCategory dimensionAttributeDirCategory; 
     DimensionAttribute dimensionAttribute; 

     select firstOnly Description from dimensionFinancialTag 
     where dimensionFinancialTag.Value == _dimensionValue 
     join DirCategory from dimensionAttributeDirCategory 
     where dimensionAttributeDirCategory.DirCategory == dimensionFinancialTag.FinancialTagCategory 
     join RecId from dimensionAttribute 
     where dimensionAttribute.RecId == dimensionAttributeDirCategory.DimensionAttribute 
     && DimensionAttribute.Name == _dimensionAttributeName;

     return dimensionFinancialTag.Description; 
}