Deleting Columns

Deleted columns are replaced by a computed item with a constant value. For example, string columns may return n/a, and numeric columns may return 0. These replacements enable reports to continue working and display the constant value (for example, n/a) for the deleted columns.

Note:

If an entire table is deleted, it is treated as if the table has all columns deleted.

These procedures describe creating a computed item to mask the deletion of columns. Before creating the computed item, a series of processes; such as copying tables, changing names, and synchronizing data models, must be performed.

  To copy a table and make initial changes to the column names:

  1. In a database, for example MSAccess, open the Sample Database.

  2. Right-click a table, and select Copy.

    For example, select PCW_Items.

  3. Right-click again, and select Paste.

  4. In Paste Table As, enter a Table Name.

    For example, type Goods. Ensure that Structure and Data is selected.

  5. Click OK.

    A copy of PCW_Items called Goods is created.

  6. Right-click Goods, and select Design View.

    The table is opened in design mode.

  7. Select a row, for example Dealer Price, and delete it.

  8. Save and close the database.

  To change the physical name of a table:

  1. Open Interactive Reporting Studio, select Sample.oce, and click OK.

  2. In the Sample.oce Host User and Host Password dialog box, click OK, without entering any text.

  3. From the catalog pane, expand Tables, and drag a topic onto the content area.

    For example, select and drag PCW_ITEMS.

  4. Right-click the topic header, and select Properties.

    Topic Properties is displayed.

  5. Enter a new Physical Name.

    For example, type Goods as the physical name.

  6. Click OK.

  To synchronize the data model with the database:

  1. In Interactive Reporting Studio, select a topic, for example Pcw Items, and select DataModel , then Sync with Database, to perform a synchronization.

    Data Model Synchronization is displayed. If Show Detail Information is selected, the dialog box provides information on synchronization changes. For example, Dealer Price was deleted from the Goods topic.

  2. Click OK.

  To use a computed item to mask deletion of columns:

  1. In Oracle's Hyperion® Interactive Reporting Studio, right-click a topic header, for example Pcw Items, and select Promote to Meta Topic.

    Another topic is added to the content area. For example, the new topic is called Meta Pcw Items.

  2. Right-click the original topic header, for example Pcw Items, and select Properties.

    Topic Properties is displayed.

  3. Change the topic name, and click OK.

    For example, change the name to Pcw Items topic. Two topics are now displayed. For example, the topics are Pcw Items topic and Meta Pcw Items.

  4. Right-click a topic header, for example Meta Pcw Items, and select Properties.

    Topic Properties is displayed.

  5. Remove Meta from Topic Name, and click OK.

  6. Select the topic from step 5, for example Pcw Items, and select DataModel , then Add Meta Topic Item , then Server.

    Modify Item is displayed.

  7. Enter the Name of the row that was deleted in the database, and enter a definition.

    For example, type Dealer Price in Name, and type 0 as the Definition.

  8. Click OK.

    The computed item is added to the topic. For example, Dealer Price is added to Pcw Items.

  9. Select the topic with the computed item added, for example Pcw Items, and select DataModel , then Data Model View , then Meta.

    The selected topic is displayed in Meta View, and other topics are removed.