Rank: Administration
Groups: Registered, Administrators
Joined: 8/17/2010(UTC)
Posts: 6
Location: Denver
|
Here is a sample of using the class objects to write back data to the Financials cube using the view Sales Entry to supply the data. Code:
ES.ESWebService ws = new ES.ESWebService();
ES.ESErrorInfo err = null;
// Get the sales entry data
ES.SalesEntryResults results = ws.SalesEntry(null, null, null, null, null, out err);
if (err.Success == false)
return;
foreach (ES.SalesEntryRow row in results.RowSet.Rows)
{
// Increment March by 20
row.Mar.Value = row.Mar.Value + 20;
// Reduce September by 50
row.Sep.Value = row.Sep.Value - 50;
}
// Write the data back to TM1
ws.TM1ViewWrite(results, out err);
|
