Skip to Content
avatar image
Former Member

consideration when object removed

Hi all,

I would like to delete certain objects from the Existing Universe and also the columns from the Database Tables used by those objects as well. I am following below process.. Please let me know if i am missing anything.

1. Find the objects

2. Find out the columns Used by those Objects

3. Check the these columns used in  select/where clause of the other objects

4.Check the object to be deleted called in other objects by using @select

Also few more questions

1.what happens when you move a object from once class to other class ?

2.What happens when you remove a object from universe which is used by a report ?

3. What happens when you remove a column which is using by report object from the database table ?

Thanks in advance for your help

Thanks,
Srinivas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 08:05 AM

    One solution can be to temporarily alter the column name in the table and do an integrity check of the universe. Then all objects with errors to be checked for reference to the column. However, this exercise is to be done for each universe using the table. Keep in mind that if there is any view or stored procedure using the column or any kind of reference anywhere else in database, that will be impacted. So, make sure you can revert it be

    fore you make change.

    1.what happens when you move a object from once class to other class ?

    The object will now belong to the new class. No impact on reports as the object ID will remain same if you move the object.

    2.What happens when you remove a object from universe which is used by a report ?

    The reports using the object will show error during execution. Same will happen if you delete an object from universe and create again.

    3. What happens when you remove a column which is using by report object from the database table ?

    The related object in universe will show error while parsing. Also, reports using the object will show error during execution.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Srinivas,

      For deleting Unused objects from universe, deleting Column from table is not required. You just check if the object has impact on other objects in universe.

      However reports using that object will give you # error where ever object is used in report.

      Regards

      Sheetal

  • avatar image
    Former Member
    Jan 06, 2015 at 08:42 AM

    The major requirement is to delete the table columns which are not being used by reporting. so i think now it makes sense

    Add comment
    10|10000 characters needed characters exceeded