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";</b> // Load Schema File
<font color="green">//connect the datasource</font>
<font color="green">//Install the data source</font>
PivotView1.DataSource = rdDataSource;
You can get more information on using the Schema Editor here:http://www.datadynamics.com/Help/ActiveAnalysis/SchemaEditor.html