Edit a user defined function

Posted by: nsingh on 3 August 2017, 4:02 pm EST

  • Posted 3 August 2017, 4:02 pm EST


    I am able to create a user defined function by following the following steps:

    1) Right click on a field of Measures section
    2) Select Add Measures
    3)And Define your function

    Now I want to edit the created function, so please tell me how do I edit a User defined function.

  • 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;";
    rdDataSource.QueryString =
        @"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:


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels