![]() HcmPositionDefaultDimension = HcmPositionDefaultDimension::findByPositionLegalEntity(HcmPosition::findByPosition("000001").RecId,CompanyInfo::find().RecId) ĭimStorage = DimensionAttributeValueSetStorage::find(HcmPositionDefaultDimension.DefaultDimension) įor (i=1 i<= dimStorage.elements() i++) HcmPositionDefaultDimension HcmPositionDefaultDimension static void GetDefaultDimensionAttributeName(Args _args)ĭimensionAttributeValueSetStorage dimStorage The purpose to share this again here that I have did some minor modifications in his job to get both attributes (Value and Name) for Default dimension. Yasir Co-blogger also explained this quite well in his blog. This topic is not new and we have lots of blogs available on it. ) AS 'Expense Class' from #MainAccountDimensionTmp Group by MainAccount SelectĬase Name When 'Department' then DISPLAYVALUE ELSE '' ENDĬase Name when 'ICP' then DisplayValue ELSE '' ENDĬase Name when 'MISC' then DisplayValue ELSE '' ENDĬase Name when 'Expense_Class' then DisplayValue ELSE '' END please add as many dimesions as you want, like i have added 4 dimensins below. Join DEFAULTDIMENSIONVIEW as ddv on MALE.DEFAULTDIMENSION = ddv.DEFAULTDIMENSION -where MAINACCOUNTid = 'test01' end - reading again from tmp table in way that values are showin in column. Join MAINACCOUNT on MAINACCOUNT.RECID = MALE.MAINACCOUNT ) End - selecting main accounts and all financial dimensions and storing into tmp table Begin Insert into #MainAccountDimensionTmp (Name, DisplayValue, MainAccount) ![]() Begin CREATE TABLE #MainAccountDimensionTmp This script is designed to show the values in columns for better read - Deleting if tmp table already exists Begin drop table #MainAccountDimensionTmpĮnd - creating new Tmp table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |