none
Create calculated column programmatically RRS feed

  • Question

  • Hi,

    I wish all the best for the new year.

    I encounter a serious problem with creating a named calculated colunm programmatically to the table of a DSV of an analysis database. I would like to create this named calculated column by means of VB but any help in C# is acceptable.

    I can created this column in Microsoft Visual studio design but I need to be created programmatically now.

    Thanks in advance

    Best regards,
    Manolis

    Tuesday, January 2, 2007 12:25 PM

Answers

  • There's a topic in Boosk Online (I'm looking at the July 2006 update version) that goes through an example of creating a DSV programmatically.  Part of the example adds a computed column to a table in the DSV.  I think you can probably study this example and adapt it to your needs.  Here's the link in BOL:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/amo9/html/3f1ab656-f3bc-432d-8b6d-cdf204e5be10.htm#DSV

    HTH,

    Dave Fackler

    Wednesday, January 3, 2007 6:20 PM