Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

Data Module - Is it Possible to Remove Table from Custom View

  • 1.  Data Module - Is it Possible to Remove Table from Custom View

    Posted Wed November 11, 2020 05:27 PM
    Hello,

    I created a view based on two tables and now I decided I don't want to include one of the tables - essentially now it would be a view pointing to one table. If I remove that unwanted table from my data module entirely I see warning messages such as: 

    Warning: MSR-VRF-1206 The table "Receipt Attributes" refers to "Query1_0_3", which does not exist or its permissions do not allow it to be read.

    The view still returns data and the SQL looks correct (the unwanted table omitted) but the warning persists and there doesn't seem to be a way to remove it in the custom table diagram.

    In this case it's not a big deal for me but want to know for the future if I can remove a table reference from a custom view?

    Thank you.
    Warning: MSR-VRF-1206


    ------------------------------
    Jeremy Aude
    ------------------------------

    #CognosAnalyticswithWatson