ICubeOperationResult.Error

Syntax

The Error property determines an exception that occurred during data loading.

Executing the example requires a data loader with the CUBE_LOAD identifier configured to send data from source cube to consumer cube.

Sub Main;

Var

MB: IMetabase;

CubLoadInst: ICubeLoaderInstance;

DimSS: IDimSelectionSet;

i: Integer;

Result: ICubeOperationResult;

Begin

MB := MetabaseClass.Active;

CubLoadInst := MB.ItemById("CUBE_LOAD").Open(Null) As ICubeLoaderInstance;

DimSS := CubLoadInst.Destination.CreateDimSelectionSet;

For i := 0 To DimSS.Count - 1 Do

DimSS.Item(i).SelectAll;

End For;

Result := CubLoadInst.Execute(DimSS, Null, AutoCubeUpdateOption.NoCheckDuplicates Or AutoCubeUpdateOption.GetResult);

Debug.WriteLine("Loader name: " + Result.Name);

Debug.WriteLine("Loader identifier: " + Result.Id);

Debug.WriteLine("Start of loading: " + Result.TimeStart.ToString);

Debug.WriteLine("End of loading: " + Result.TimeFinish.ToString);

If Result.Succeeded

Then

Debug.WriteLine("Data loading has been completed successfully");

Debug.WriteLine("Processed records: " + Result.RecordsProcessed.ToString);

Else

Debug.WriteLine("Error occurred while loading data");

Debug.WriteLine("Error: " + Result.Error.Message);

End If;

WinApplication.InformationBox(Result.FormattedMessage);

End Sub Main;

After executing the example data is loaded in to a cube. The results of loading are displayed in the console window and in the information message.