Topic
6 replies Latest Post - ‏2012-05-29T22:38:26Z by Venkat_GulfSoft
devil786
devil786
4 Posts
ACCEPTED ANSWER

Pinned topic Creating a single report for network Devices and Servers

‏2012-05-21T05:47:05Z |
Hi,
I am looking for a solution through which we can create a single report for Network Devices and Servers (all Platforms).
currently we are using ITM, netcool Omnibus, TBSM 4.2.1, Proviso and ITNM-IP in our environment.Any help/guidance will be appreciated.

thanks in advance
Updated on 2012-05-29T22:38:26Z at 2012-05-29T22:38:26Z by Venkat_GulfSoft
  • SystemAdmin
    SystemAdmin
    373 Posts
    ACCEPTED ANSWER

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-21T17:22:36Z  in response to devil786
    Hi,
    A report must get all its data from a single data model. This means all those product's data must be combined into a single data model using TCR's Framework Manager tool. One option is to combine all the product's existing models. This will make one giant data model. However there is a limit to the size a DM can get and still run (somewhere around when the model.xml is 100 MB). Combining all the product's data models would result in a model that would not run, it will put you way over the limit, I believe.

    Instead, since you have a specific need with this report, you may want to instead look at using creating new data model, bring in just the tables needed from each product. In FM, you can run through the meta data model wizard to pull in data from a database. Then just run it again, to point to the next product's database, etc. Once all the data is pulled in, you'll have to know the cardinality of the relationships across the different tables to make the relationships in FM. This will let the reporting tool know how to properly join the data later in the report. Note, since the data is joined the reporting tool (since it's cross-database), hopefully you won't be joining hundreds of thousands of rows.

    Another quick and dirty option is the look at Report Studio queries. They will allow you to put SQL directly into the query, so you can go direct to the database without the reporting tool creating the SQL for you. Then you can join the data from the various queries.

    Dan
    • devil786
      devil786
      4 Posts
      ACCEPTED ANSWER

      Re: Creating a single report for network Devices and Servers

      ‏2012-05-22T05:50:09Z  in response to SystemAdmin
      Hi Dk,
      thanks for the valuable information, is there any doc, guide etc available?
      • SystemAdmin
        SystemAdmin
        373 Posts
        ACCEPTED ANSWER

        Re: Creating a single report for network Devices and Servers

        ‏2012-05-22T13:30:19Z  in response to devil786
        Hi,
        For creating the data model, there is a video here, tip#2, on creating a basic data model:
        https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=9caf63c9-15a1-4a03-96b3-8fc700f3a364

        That's for TCR v1.3. The only difference in FM setup for TCR 2.x would be the URL ports and perhaps the security patch, depending on the bitness of your platform. The TCR 2.x install/config doc has a pointer to this.

        That video shows just a simple walk through the data model wizard. You can just run through it several times. Once for each database.
        Next you can click on one ID attribute, hold control, and click on another, and right click to create a relationship between the tables. You can test the join right there in FM.

        There is also a property in the data model to allow local processing. Be sure to enable this since you'll be joining data in the reporting engine.
        Search the web for Cognos data model videos. That will get you a good number of hits.

        Dan
        • devil786
          devil786
          4 Posts
          ACCEPTED ANSWER

          Re: Creating a single report for network Devices and Servers

          ‏2012-05-28T06:36:03Z  in response to SystemAdmin
          Ok thanks DK, will update time to time.
          • devil786
            devil786
            4 Posts
            ACCEPTED ANSWER

            Re: Creating a single report for network Devices and Servers

            ‏2012-05-28T06:58:15Z  in response to devil786
            I am using TCR installed with IBM TBSM 4.2.1 IF3, i think i will not be able to use the data modelling feature with this version?
            • Venkat_GulfSoft
              Venkat_GulfSoft
              24 Posts
              ACCEPTED ANSWER

              Re: Creating a single report for network Devices and Servers

              ‏2012-05-29T22:38:26Z  in response to devil786
              Nope, TBSM 4.2.1 uses older version of TCR (1.2, I think) and it is not compatible with Cognos data modeling.

              Thanks,
              with warm regards,
              Venkat Saranathan.
              Gulf Breeze Software.
              www.gulfsoft.com