Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Data Module Metadata Processing Cognos 11.1 and 11.2

    Posted Thu November 18, 2021 03:47 PM
    Hi everyone,

    I'm a long-time Framework Manager user that's slowly easing into the world of Data Modules. And for the most part I can get things to work, but now I'm trying to figure out "how" things work. What I want to know is "how" does Cognos do the metadata processing for sources like uploaded CSV files going into a Data Module? For example, it does a good job of picking out "identifiers", "facts", and "attributes", but how does Cognos know what "usage" values to assign to those various data items that are coming out of a generic source like CSV? What metadata criteria does it use for the assignments and at what stage in the process is the criteria applied?

    I checked out the IBM Cognos Analytics v11.2 Metadata Modeling Guidelines, but it doesn't drill down into the stuff I'm looking for. So does anyone out there in Cognos Land have the info that will set my mind at ease… *^_^*

    Thanks in advance, for any helpful insight.

    Syd… <â¿â>



    ------------------------------
    Syd Shewchuk
    Trainer / Consultant
    Newberg, OR
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module Metadata Processing Cognos 11.1 and 11.2

    Posted Fri November 19, 2021 01:31 PM

    When metadata is being created (metadata import or file uploads), a step is applied where the names assigned to things (i.e. columns) is used to help suggest a usage.

    In FM, the heuristics were primarily driven by explicit metadata in returned by a database (constraints), and perhaps the data type.

    Looking at the actual data values themselves, can also provide additional metadata used by NLP etc.

    https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=metadata-data-sampling



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 3.  RE: Data Module Metadata Processing Cognos 11.1 and 11.2

    Posted Sat November 20, 2021 02:27 PM
    Thanks Nigel for the insight. Being from the "old school" I tend to forget about the wonders of AI. It was especially useful to learn that AI is attempting to gleen useful info from the column heading spellings (e.g. ID, code, key, etc.). That can be useful when constructing Excel and CSV files. However, after some experimenting I noticed that AI still has difficulty with alphanumeric keys and with bar codes (alpha + numeric + special characters) regardless of the column header - they tend to be treated as "attributes". Not a big deal since Data Modules makes it easy to change usage.
    Thanks again,
    Syd

    ------------------------------
    Syd Shewchuk
    Trainer / Consultant
    Newberg, OR
    ------------------------------



  • 4.  RE: Data Module Metadata Processing Cognos 11.1 and 11.2

    Posted Tue December 07, 2021 11:55 PM
    How do you find Data Modules? I still found them sub-par when compared to Framework Manager packages.  I think they are useful to support one or two ad-hoc reports or for data preparation tasks replacing excel.  On the other hand, a well-designed framework package can be used to source hundreds of reports. While framework manager packages take more time to build, this is offset by their resilience. A small change in the source structure will render the data model unusable, while this is in FWM can be easily accommodated.  Just looking for some feedback from users with practical experience using both tools.

    ------------------------------
    Mauro Santos Otero
    ------------------------------