In the data model you refer to (FlexNet Manager Platform Reports and Dashboard), the “Computer” subject would be the one to use if the focus is on hardware inventory, but if you are wanting to report on software then the “Installation” subject might be appropriate. Note that these parts of the data model operate at the individual record level, i.e. an individual computer or an individual install of an application on a computer so if the report (or dashboard) you are trying to build is more of an aggregated count you can still use these objects but there will be more work done at runtime to aggregate the data.
The areas under OLAP are pre-aggregated counts of licenses (measured by consumption/entitlements) or software installations across enterprise groups over time – but note that since these are historical counts you must handle the different snapshots to focus either on a trend or maybe the most current snapshot which should reflect the counts as of the last data warehouse export.
Murray
Hi - I'm not seeing any discrepancies between that core counts shown in Cognos versus FNMS - see below as an example of what I am seeing:
Could you share examples of what you are seeing?
-Murray
OK thanks for uploading the screenshot. I can see that you are using the dashboard editor (I was using the report studio) so that makes more sense. The data model "FlexNet Manager Platform Reports and Dashboard" existed prior to IBM/Cognos releasing the new dashboard tools - without getting too technical it was CQM (Compatible Query Mode) based and was really intended more for Reports. Data models used for dashboarding are DQM (Dynamic Query Mode) based which enables Cognos to generate queries better for the dynamic nature of the dashboards. In your simple layout of 1 widget/2 fields it renders ok, but I would expect that you'd start running into issues when you have multiple widgets on the page and they start filtering each other.
So, my suggestion would be to use the "Flexera Data Models" for Dashboarding and use "FlexNet Manager Platform Reports and Dashboard" for creating Reports.
Having said that, if you want to make what you've done show the SUM of cores instead of the COUNT of VM's that have a core count you can "Edit" the widget and go to the "Summarize" options for No. Of Cores. Here you will see the options for aggregating the measure - the default will be what is released in the data model but you can override that if/as needed (eg change Count to Sum as highlighted below).
Note though, that if you are aiming to list the No of Cores in the host then using this combination will not be accurate as it assumes the #Cores in the host is just the sum of all the cores in the VM's hosted by it. This can be wrong for several reasons (eg not all VM's have returned inventory, or virtual pools are used to share cores across vm's etc).
If however you choose the following combination you should get the actual core count as a single figure for the computer/host:
Operational Objects/Computer/Computer-General/Computer Name
Operational Objects/Computer/Computer-Extended/No. Of Cores
- Murray
We have prepared report as per our requirement ad got correct core details for Virtual Machine.
But when preparing same report for Computers and VM Host core count is not matching with Inventory count. Then found that If we select No. of core details of Virtual Machine then it showing different symbol.
Due to this reason core counts showing as a number instead of SUM.
