Highlighted
Intrepid explorer

Cognos Analytics - Inventory Module

Jump to solution

We have customer requirement to create custom Dashboard on Cognos from Inventory devices, but when select data source "FlexNet Manager Platform Reports and Dashboard", unable to find Inventory Module on that.

If we need to create some report based on Inventory data then how can we get that ?

How can we use Inventory Module in default model? Is there any way to import it ?

 

 

1 Solution

Accepted Solutions
Highlighted
Frequent contributor

Re: Cognos Analytics - Inventory Module

Jump to solution

Hi,

Yes – the data modelling of those fields (#cores etc) (at best) is inconsistent, but in reality is just wrong.   If you right click on one that has the hash/pound symbol and choose “Properties” you’ll see that “Usage=Attribute”, whereas the Properties of the one with the L shaped ruler shows “Usage=Measure”.  You’ll also note that the Aggregate function in the properties is Count/Total respectively.   What that means is when you are just displaying the values of the records at the lowest level (i.e. individual/unique machine) then the correct Core count will be shown, but if you are rendering a widget that is aggregating the records then you will get inconsistent behavior between the two.

I’d suggest you submit a support case to Flexera to register the issue, but in the short term you may still be able to achieve what you need by using a Calculated field.  For example, if you :

  1. right click the “No. of Cores” field under the VM Host object and select “Create calculation”
  2. select “Use calculation editor”
  3. change the expression to be (just remove the + 😞
    [FNMPS-DW-DS][VM Host].[No of Cores]
  4. Change the Name of the calculated field to something like “VMHostCoreCount”
  5. Click OK.

You should then have a new field at the bottom of all of the data objects which you can set the Properties to be:

  • Usage:   Measure
  • Aggregate:  Total

Hopefully if you then use the VMHostCoreCount it will aggregate as you want.

If I have misunderstood what you’re trying to achieve feel free to send me a private message with details and I’d be happy to see if I can produce the output you are looking for.

-Murray

View solution in original post

17 Replies
Highlighted
Moderator Moderator
Moderator

Re: Cognos Analytics - Inventory Module

Jump to solution

Hello,

Is this for FlexNet Manager Cloud Edition or on premise, please?

Flexera Analytics ships with a data model that currently does not support all objects, but if you post your requirements here we might be able to suggest a solution as many things are possible.

Best regards
Thorsten

Principal Solution Engineer
(Anything expressed here is my own view and not necessarily that of my employer, Flexera)
0 Kudos
Highlighted
Intrepid explorer

Re: Cognos Analytics - Inventory Module

Jump to solution
We have FlexeNet Manager on premise only.

We need Inventory tab in cognos "FlexNet Manager Platform Reports and Dashboard" module based on that we will create our own Dashboard\report as per requirement.
0 Kudos
Highlighted
Frequent contributor

Re: Cognos Analytics - Inventory Module

Jump to solution

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.  

1.PNG2.PNG

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.

3.PNG

 

Murray

Highlighted
Intrepid explorer

Re: Cognos Analytics - Inventory Module

Jump to solution
We need all Inventory source in COGNOS Modules, we don't want Application or Installation from Inventory.
As specific, we need below fields from All Inventory source .
e.g. OS Name, Host details, Core details, Processor, Device Type also required some more fields which is required in All Inventory.
Your prompt response will be appreciate.
0 Kudos