Change in column names

  • 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

  • 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.

  • 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