I am trying to write a TI process that creates an alternate hierarchy within a dimension using attributes as parents. (dimension name = 'FOR_Nominal')
I was taught that when you are transferring data between cubes, you should always create and refresh a "dummy view" of the source data cube to ensure that your values are up to date and to maximize process efficiency. In this case, the source data cube is the control cube }ElementAttributes_FOR_Nominal - this has been selected within the Source Data tab, specifying to use the dummy view zUpdate. I know this view exists because I originally created it manually and can see it in the structure map on the left hand side!
My Prolog code is then, (parameter pDir)
Code: Select all
IF(ViewExists( '}ElementAttributes_FOR_Nominal', 'zUpdate' )=0);
ViewCreate( '}ElementAttributes_FOR_Nominal', 'zUpdate' );
ENDIF;
IF(SubsetExists( '}ElementAttributes_FOR_Nominal', 'zUpdate')=1);
SubsetDeleteAllElements( '}ElementAttributes_FOR_Nominal', 'zUpdate');
ELSE;
SubsetCreate( '}ElementAttributes_FOR_Nominal', 'zUpdate');
ENDIF;
SubsetElementInsert( '}ElementAttributes_FOR_Nominal', 'zUpdate', pDir, 1 );
ViewExtractSkipCalcsSet( '}ElementAttributes_FOR_Nominal', 'zUpdate', 1);
ViewExtractSkipRuleValuesSet( '}ElementAttributes_FOR_Nominal', 'zUpdate',1 );
ViewExtractSkipZeroesSet( '}ElementAttributes_FOR_Nominal', 'zUpdate',1);
ViewSubsetAssign( '}ElementAttributes_FOR_Nominal', 'zUpdate','FOR_Nominal','@L0');
ViewSubsetAssign( '}ElementAttributes_FOR_Nominal', 'zUpdate','}ElementAttributes_FOR_Nominal','zUpdate');
Any ideas please? The online reference points out that you can't assign a temporary subset to a permanent view, but from the system's point of view these subsets should be permanent.