Replied 3 August 2017, 4:02 pm EST
It is not possible to edit a user defined measure in the Viewer control. However ,you can do this using the Schema Editor that ships with ActiveAnalysis.
To run the Schema Editor, go to the Start Menu and select All Programs > GrapeCity > ActiveAnalysis > Tools > Schema Editor.
Here you can add/delete measures and attributes and also add user defined functions for the measures. The User defines function can be easily modified using the Schema Editor.
After you are done with creating/modifying your schema, you can save the Schema to a schema file using the Schema Editor. This schema can now be loaded at run time using a similar code.
rdDataSource = new
rdDataSource.ConnectionType = ConnectionType.OleDb;
= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "nwind.mdb;";
@"SELECT * from Products";
@"C:\SampleSchema.schema"; // Load Schema File
//connect the datasource
//Install the data source
PivotView1.DataSource = rdDataSource;
You can get more information on using the Schema Editor here:http://www.datadynamics.com/Help/ActiveAnalysis/SchemaEditor.html