Hi,
My Financial Dimension are made from different kind of backend resource, as follows:
1. Branch from RetailChannelTable
2. ActionGroup from Operating Unit with name="ActionGroup"
3. ProfitCenter from Custom Financial dimension
All this can be seen if I run this query :
1. select DISPLAYVALUE,BACKINGENTITYTABLENAME,* from DIMENSIONATTRIBUTEVALUE a
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='Branch'
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='Branch'
2. select DISPLAYVALUE,BACKINGENTITYTABLENAME,* from DIMENSIONATTRIBUTEVALUE a
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='ActionGroup'
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='ActionGroup'
3. select DISPLAYVALUE,BACKINGENTITYTABLENAME,* from DIMENSIONATTRIBUTEVALUE a
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='ProfitCenter'
join DIMENSIONATTRIBUTE b on a.DIMENSIONATTRIBUTE=b.RECID where b.NAME='ProfitCenter'
As we can see, the backingEntityTableName contains RetailChannelTable, OMOperatingUnit, and DimensionFinancialTag.
I managed to separate this list based on the each "dimensions" (Branch / ActionGroup / ProfitCenter), by using that join table above, but may I know how to get the description of it ? Because it looks that the DISPLAYVALUE" only specify the code of it, while I need also the description.
As it spread on those 3 resource tables, I wonder whether there is an easier way of getting it, other than I need to do another join query to each specific table
Or is there an even easier to get all my Financial Dimension but able to separate it into each of the dimensions.
Thanks.
Categories:
