TI not writing string value to consolidated element

[kenship]

Hi all,

I have trouble writing to consolidated element of a cube. Here's some details of how I setup the TI process:

Data Source: Cube View - Target cube
Variables: Based on Target cube dimensions, Variable Type all "String", Contents all "Other"

Prolog:
1. Setup Target view and Target subset in Target cube
2. Setup Target subset using MDX that include leaf and consolidated elements for a few dimensions
3. Assign MDX of each dimension to Target subset
4. Assign Target subset to Target view
5. Activate ViewExtractSkipZeroesSet and ViewSuppressZeroesSet of Target View in Target Cube

Data:
CellPutS to Target Cube based on variables for each dimension. Content is referenced to another cube using CellGetS.

My problem is that it works fine for intersection on the leaf level but nothing is written to consolidated level elements as defined by the Target View and Target Subset.

Appreciate any help.

Kenneth

[ascheevel]

Make sure your TI source view isn't skipping consolidations: ViewExtractSkipCalcsSet?

[kenship]

Make sure your TI source view isn't skipping consolidations: ViewExtractSkipCalcsSet?

Thanks for the reply. I checked the view and it does include the consolidated elements.

I've been testing by changing the CellPutS to special consolidated elements instead of variables and it worked. But I need the CellPut command to put content according to how the View is setup. I don't know if using variables is the right thing to do at all.

Kenneth

[ascheevel]

Post some code?

[Wim Gielis]

Did you look at ViewExtractSkipConsolidatedStringsSet ?

[kenship]

Hi all,

For simplicity, I created a very small cube to show what I'm trying to accomplish.
The cube includes:
DimA - (A-TOTAL)->A1, A2
DimB- (B-TOTAL)->B1, B2
Dim_m- $, Description

What I'm trying to do is to put string into "Description" for consolidated elements (A-TOTAL), (B-TOTAL) when $ has value.
The image shows only leaf element has string value based on the CellPutS.

Screenshot 2020-10-08 134531.png (19.83 KiB) Viewed 3740 times

Here's my TI process

1. Data Source: Cube View, Demo->DimOrder
2. Variables: vDimA, vDimB, vDim_m, vValue, Variable Type: String, Contents: Other
3. Prolog:

Code: Select all

tCube = 'Demo';
tSubset = 'tsubset';
tView = 'tView';

IF(ViewExists(tCube, tView) = 1);
    ViewDestroy(tCube, tView);
ENDIF;
ViewCreate(tCube, tView);

vIndexDim = 1;
WHILE(TABDIM(tCube, vIndexDim) @<> '');
	vDimName = TABDIM(tCube, vIndexDim);

	IF(SubsetExists(vDimName, tSubset) = 1);
		SubsetDestroy(vDimName, tSubset);
	ENDIF;

	vMDX = '{TM1SUBSETALL( [' | vDimName | '])}';
	SubsetCreateByMDX(tSubset, vMDX);
	ViewSubsetAssign(tCube, tView, vDimName, tSubset);
	vIndexDim = vIndexDim +1;
END;

ViewExtractSkipZeroesSet(tCube, tView, 1);
ViewSuppressZeroesSet(tCube, tView, 1);

DatasourceCubeView = tView;

4. Data

Code: Select all

CellPutS('Check',tCube,vDimA,vDimB,'Description');

Again, this process put the text string "Check" into leaf element but not for consolidated level element.

Thanks!

Kenneth

[ascheevel]

Can you add the below items to your prolog below the other ViewExtract... declarations and re-test?

Code: Select all

ViewExtractSkipCalcsSet('tDemo', 'tView', 0);
ViewExtractSkipRuleValuesSet('tDemo', 'tView', 0);

[kenship]

Looks like it's the ViewExtractSkipCalcsSet that needs to be inserted.

Thanks very much!

Can you add the below items to your prolog below the other ViewExtract... declarations and re-test?

Code: Select all

ViewExtractSkipCalcsSet('tDemo', 'tView', 0);
ViewExtractSkipRuleValuesSet('tDemo', 'tView', 0);