SYMPTOM:
For certain In-Memory Intelligent Cube Query, extra attributes are included in output level that may lead to extra memory consumption on the Intelligence Server and the report execution may fail due to memory limit reached. This enhancement is to remove unnecessary attributes from the output level to reduce the memory consumption, producing the same correct data without the unnecessary attributes.
Here is the sample Intelligence Server Query before the enhancement:
select [Chn Bcc Child]@[CHN_BCC_CHILD],
[Chn Bcc Child]@[CHN_BCC_CHILD_DESCR],
count(distinct [GEOGRAPHY ID]@[GEOGRAPHY_ID])@{[Chn Bcc Child]} as [Count (GEOGRAPHY ID)]
from CITI_map2projectAttribute_small
with Table Join Tree: [F_VW_IS_PRL_DAF_AGGFCT_TBL_CUCR_10.csvC24B2EA1450CBC368530D7B71C13E957]
Join [F_VW_IS_PRL_CHANNEL_DRLDWN_CPDN_COMBO.csvF04E77364D707993C5DE1E99DE2A9544] with output level Tuple([Account Leaf]@[ACCOUNT_LEAF], [Channel Leaf]@[CHANNEL_LEAF], [Chn Bcc Child]@[CHN_BCC_CHILD], [Frs Bu Leaf]@[FRS_BU_LEAF], [Month]@[MONTH_ID], [PF SCENARIO ID]@[PF_SCENARIO_ID], [PRL MGD SEG ID]@[PRL_MGD_SEG_ID], [GEOGRAPHY ID]@[GEOGRAPHY_ID], [PRODUCT ID]@[PRODUCT_ID], [TRUE THIRD PARTY GC AFFILIATE]@[TRUE_THIRD_PARTY_GC_AFFILIATE], [PRL CUST SEGMENT]@[PRL_CUST_SEGMENT], [GC SOURCE]@[GC_SOURCE], [GC LEDGER BAL TYPE]@[GC_LEDGER_BAL_TYPE], [PRL FUNCTION CD]@[PRL_FUNCTION_CD], [PRL FX CUR]@[PRL_FX_CUR], [OPERATING UNIT]@[OPERATING_UNIT], [ACCOUNT TYPE]@[ACCOUNT_TYPE], [LAST UPDATE TIME]@[LAST_UPDATE_TIME], [ROWNUMBER]@[ROWNUMBER])
ACTION/RESOLUTION:
This is the enhancement in Strategy 11.0 and higher. Here is the same sample Intelligence Server Query after the enhancement:
select [Chn Bcc Child]@[CHN_BCC_CHILD],
[Chn Bcc Child]@[CHN_BCC_CHILD_DESCR],
count(distinct [GEOGRAPHY ID]@[GEOGRAPHY_ID])@{[Chn Bcc Child]} as [Count (GEOGRAPHY ID)]
from CITI_map2projectAttribute_small
with Table Join Tree: [F_VW_IS_PRL_DAF_AGGFCT_TBL_CUCR_10.csvC24B2EA1450CBC368530D7B71C13E957]
Join [F_VW_IS_PRL_CHANNEL_DRLDWN_CPDN_COMBO.csvF04E77364D707993C5DE1E99DE2A9544] with output level Tuple([Chn Bcc Child]@[CHN_BCC_CHILD], [GEOGRAPHY ID]@[GEOGRAPHY_ID])
Strategy reference numbers for this technical note are KB442280 and DE84949.
