Forum Discussion
Hello,
Going back to a simple example of seeding from an extended dimension:
Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo(String.Empty)
Dim sourceDataBuffer As DataBuffer = api.Data.GetDataBuffer(DataApiScriptMethodType.Calculate,"S#DetailedSourceScenario",destinationInfo)
Dim convertedDataBuffer As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("AnotherCube", "AnotherScenario", sourceDataBuffer)
api.Data.SetDataBuffer(convertedDataBuffer, destinationInfo)
Onto your specific questions
Q1) How do I filter the source members (like the member filters in api.data.calculate)
A1) You do it in the GetDataBuffer expression. Remember that if you need to filter like U1#[XXX].Base then use the GetDataBufferUsingFormula along with a FilterMembers() . There are some examples in the Design & Reference Guide.
Q2) What's the equivalent of the onEvalDataBuffer that you get in api.data.calculate ?
A2) You can simply do a for each loop in the DataBuffer that you opened up in the first line, and loop over the data buffer cells in exactly the same way as you would be doing in the onEvalDataBuffer argument.
Regards
Chris
Related Content
- 4 years ago
- 2 years ago
- 4 years ago
- 4 years ago