Cognos Analytics

 View Only
Expand all | Collapse all

Data Modules Issue

  • 1.  Data Modules Issue

    Posted Wed November 14, 2018 07:26 AM
      |   view attached
    thumbnail image

    ​I am new to data modules. I have created a new data module using source as data server. there was some changes made to the columns in the data source but I am not able to update those objects in the data module.

    I tried to update it using the properties>expression and update it manually, but it throws "Identifier not found" error. please help.


    ------------------------------
    Karthik Rajendran
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Modules Issue

    Posted Fri November 16, 2018 02:27 PM
    Hey Karthik,

    Thank you for your post. What release of Cognos Analytics are you currently running in your environment?

    ------------------------------
    Sami El Cheikh
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 3.  RE: Data Modules Issue

    Posted Wed November 28, 2018 10:57 AM
    Hello,

    we are in Cognos Analytics 11.0.11.

    thanks,

    ------------------------------
    Karthik Rajendran
    ------------------------------



  • 4.  RE: Data Modules Issue

    Posted Thu November 29, 2018 10:43 AM
    Hi Karthik, 

    Thanks for the response! 

    it looks like your data type has changed. It shows Measure in the source panel, but is actually a text measure. 

    There could be various reasons for this, we'd like to troubleshoot it for you by recreating it in our environments via our support team. We ask that you log this ticket at the site below:
    IBM Support Community

    Thank you!

    ------------------------------
    Sami El Cheikh
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 5.  RE: Data Modules Issue

    Posted Fri December 14, 2018 04:29 PM

    Hi Karthik,

    Did you re-load the schema for the database?  If not, I think that will clear up your validation problem. In the data source connection schema list, select "Load metadata" to refresh the cached metadata for your database schema.


    I hope that helps.

    Cheers,

    Rob




  • 6.  RE: Data Modules Issue

    Posted Mon July 01, 2019 08:56 AM
    I have a similar problem running on version 11.1.
    A new column added to a view used in a data module. I have tried reloading the metadata through the data server connection/schemas but the new column is not added to the data module.  Do I need to somehow refresh the data module to get the new column or do I need to add the new column manually?
    I also seem to be unable to change the label/name of the data module, is this correct?

    ------------------------------
    Dagur Egonsson
    ------------------------------



  • 7.  RE: Data Modules Issue

    Posted Mon July 01, 2019 09:09 AM
    I have found that you need go to the Data Module and expand the dbo window on the far left then,  click and drag the updated View or Table again into the Data Module pane.

    A pop up will then ask you  'Do you want to import these items again?' 
    Select yes, you wont need to re-configure any column Settings or Relationships they will all be preserved as long as you haven't removed or changed any existing columns in the database.
    The new column will then be available.

     


    ------------------------------
    Jonathan berry
    ------------------------------



  • 8.  RE: Data Modules Issue

    Posted Mon July 01, 2019 10:22 AM
    This worked perfectly. Thanks @Jonathan.

    ------------------------------
    Dagur Egonsson
    ------------------------------



  • 9.  RE: Data Modules Issue

    Posted Mon July 01, 2019 12:41 PM

    The drag and drop action is necessary to add additional columns to a query subject in the module.   The new query items are added to the end of the list of query items in the query subject.  You can then move them to a position which you want.

    The module label, which shows at the module tree root node, is read only and reflects the name of the module.   You can set it by saving the module as another name. 



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 10.  RE: Data Modules Issue

    Posted Thu August 15, 2019 06:41 AM
    Now I have another issue.
    Tables earlier available in the source are not there any more. I have verified that they are selected in the data server connection and reloaded the metadata but they do not reappear.
    Is there a way to refresh the data source in a different way?

    ------------------------------
    Dagur Egonsson
    ------------------------------