Edit a user defined function

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

  • Posted 3 August 2017, 4:02 pm EST

    Hi,

    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

    Namrata,

    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.

     {

    GrapeCity.ActiveAnalysis.Windows.Forms.DataSources.RdDataSource
    rdDataSource = new
    GrapeCity.ActiveAnalysis.Windows.Forms.DataSources.RdDataSource();


    rdDataSource.ConnectionType = ConnectionType.OleDb;
    rdDataSource.ConnectionString
    = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "nwind.mdb;";
    rdDataSource.QueryString =
        @"SELECT * from Products";
    rdDataSource.CustomSchemaFile
    =
    @"C:\SampleSchema.schema";
    // Load Schema File


    //connect the datasource
    rdDataSource.Connect();


    //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


Need extra support?

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

Learn More

Forum Channels