Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Metadata Editor - Updating the metadata model tables with newly added columns

  1. #1

    Default Metadata Editor - Updating the metadata model tables with newly added columns

    Hi,

    I created a metadata model sometime back with some tables. Now one of tables included in the metadata model has a new column. what would be the process to include that newly added column to my metadata model?

    I am not able to find any easy way to do this,except to delete the table, re-import it, and then repeat all the steps I did before like add to business model, relationship and then finally view.

    Can some one please suggest if there is a way to update the existing tables so that they take up the newly added columns?

    Thanks,
    Nick

  2. #2
    Join Date
    Mar 2008
    Posts
    364

    Default

    you have to add that column by hand.

  3. #3
    Join Date
    Jun 2012
    Posts
    3

    Default

    I thought you could always add a new table to an existing business at any time, just like when the model was initially created.

    As for adding new columns to a physical table already defined in the model. A co-worker showed my how.

    1. Double click the physical table to bring up the Physical Table Properties
    2. Click the green plus(+) button at the top of the Subject section
    3. Give the physical table column a name. It does not need to match the actual column name
    4. In the 'Settings' section, find the Formula Value: field and enter the actual column name. It must match the name of the actual column name.
    5. Click OK,

    and voila, you have a new column that you need to add to the business tables and views in the business model.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.