SKIP If doesn't exist instead of ERROR

[AlphaWay]

Hi All,

Base Table - ABC
Source Table - XYZ
Cube - Product
Dimension - PROD

Table : ABC
PROD | Measure
______________
Car | 2000
Bike | 1000
Cycle | 500
-----------------

Table : XYZ
PROD | Measure
______________
Car | 2000
Bike | 1000
Car | 3000
Car | 2000
-----------------

I have a TI Process to load "Product cube" from XYZ table.

I have a dimension "PROD" so Products(Car,Bike,Cycle) from ABC table would be the elements of PROD Dimension .
But the TI process throw errors when cube was loaded - Since i don't have product(Cycle) in "PROD" dim, they ended up in error.
I have to load data only for products that exist in "PROD" Dimension.
I need to Just skip others if it doesn’t exist instead of throwing error.

[declanr]

Code: Select all

If ( Dimix ( <DimName>, <ProductName> ) = 0 );
	ItemSkip;
EndIf;

[lotsaram]

This question is so basic I think it's appropriate to guide you to the request for assistance guidelines.

This is really TurboIntegrator scripting 101.
Usually you would make sure that metadata (that is dimension updates) is loaded in a separate process from a separate source, and that this happens BEFORE loading data. This avoids double-processing of data extracts and any potential locking. You can also avoid the errors during the data load without having metadata up to date in advance by either skipping records of elements that don't exist or inserting the elements before the CellPut.

E.g.

Code: Select all

### skipping
If( DimIx( cDimProduct, vProduct ) = 0 );
    ItemSkip;
EndIf;

### making sure element exists
If( DimIx( cDimProduct, vProduct ) = 0 );
    DimensionElementInsertDirect( cDimProduct, '', vProduct, 'N' );
EndIf;

[AlphaWay]

Thanks @lotsaram and @declanr !

It worked