bool UpdCubeCache(CubeId tCube, UpdCubeCacheArg tArg)
tMon. Cube moniker.
tArg. Operation execution parameters.
The UpdCubeCache operation updates In-Memory cache for the specified cube.
The operation enables updating cube In-Memory cache files on BI server that is used for processing. The cache is updated by specified cube selection (the tArg.sels field) and for the specified cube display variant (the tArg.dest field). The operation returns True, if update was successful and False, if any errors occurred on updating.
NOTE. To provide an operation correct processing, it is required that only current BI server uses cache files.
{
"UpdCubeCache" :
{
"tCube" :
{
"id" : "S1!M!S!C1"
},
"tArg" :
{
"sels" :
{
"it" :
[
{
"k" : "5858",
"id" : "FACTS",
"sel" :
{
"elSelectOp" : "Select",
"elRelative" : "All"
}
},
{
"k" : "112",
"id" : "CALENDAR",
"sel" :
{
"elSelectOp" : "Unknown",
"elRelative" : "Unknown",
"setCalendarPeriod" :
{
"active" : "true",
"start" : "2000-01-01",
"end" : "2000-12-01",
"levels" :
{
"it" : "Quarter"
},
"append" : "false",
"findOutActive" : "false"
}
}
},
{
"k" : "116",
"id" : "DIM_1",
"sel" :
{
"elSelectOp" : "Select",
"elRelative" : "All"
}
},
{
"k" : "991",
"id" : "DIM_2",
"sel" :
{
"elSelectOp" : "Select",
"elRelative" : "All"
}
}
]
},
"dest" :
{
"@type" : "q1:CubeDest",
"k" : "1",
"id" : "STD_CUBE",
"n" : "Cube",
"vis" : "true",
"isDefault" : "true"
}
}
}
}
{
"UpdCubeCacheResult" : "1"
}
public static bool UpdateCache(CubeId moniker, Listsels, ItKey destination)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tUpd = new UpdCubeCache()
{
tArg = new UpdCubeCacheArg()
{
sels = sels.ToArray(),
dest = destination
},
tCube = moniker
};
//Update cache
var result = somClient.UpdCubeCache(tUpd);
return result;
}
See also: