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

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

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-21T17:22:36Z  
    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

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-22T05:50:09Z  
    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
    Hi Dk,
    thanks for the valuable information, is there any doc, guide etc available?
  • SystemAdmin
    SystemAdmin
    373 Posts

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-22T13:30:19Z  
    • devil786
    • ‏2012-05-22T05:50:09Z
    Hi Dk,
    thanks for the valuable information, is there any doc, guide etc available?
    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

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-28T06:36:03Z  
    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
    Ok thanks DK, will update time to time.
  • devil786
    devil786
    4 Posts

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-28T06:58:15Z  
    • devil786
    • ‏2012-05-28T06:36:03Z
    Ok thanks DK, will update time to time.
    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

    Re: Creating a single report for network Devices and Servers

    ‏2012-05-29T22:38:26Z  
    • devil786
    • ‏2012-05-28T06:58:15Z
    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?
    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