Post reply

Change in column names

  • September 28, 2008 at 9:11 pm

    #213327

    Hi,

    We have created a cube based on Database.

    Now they have changed the table columns and itz conflicting with cube columns.

    and while processing giving the error:

    OLE DB error: OLE DB or ODBC error: Invalid column name 'SalesValueIncludingTaxinStandardlCurrency'.; 42S22.

    how to reflect the database changed into cubes?

    Thanks

    Regards

    Viji

  • September 29, 2008 at 7:28 am

    #878386

    I might try looking at replacing the table in your Data Source View with a "With New Named Query". To find this right click on the table and select "Replace With". The using column aliases to get back to the old column names if they have only changed the column name and not he data, schema or meaning of the column.

  • September 29, 2008 at 9:29 pm

    #878666

    Hi,

    nice idea!!

    i'll try it out.

    regards

    viji

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply