- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Accepted Solutions
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Mantautas,
I use Flexera Analytics (Cognos) daily and find it to be incredibly valuable, but I do acknowledge that it is not trivial and can be confronting to use - but I definitely think it's worth the effort. The System Reference guide (downloadable from the online help) has some content on Analytics, but it is very theoretical. You could look at the Learning center which has some introductory videos and lessons (https://learn.flexera.com/?q=analytics).
There are several data models published with FNMS - if using FNMS cloud there are 2 data models and if using FNMS on prem there is an additional 'operational' data model not available in the cloud (as of 2019 R1 anyway). Each data model has its purpose (dashboard development, versus low level reporting etc), so it would be important for you to become familiar with the different models and when to use each. My advice would be to use the "Flexera Data Models" for dashboard development and then if desirable develop drill through to detailed reports using the other data models.
If you're interested, I've attached a set of examples of dashboards/reports I’ve built using Cognos over the past few years. These might give you an idea of what kind of things are possible. I should clarify that whilst some of these use the OOTB data models in some cases it was necessary to use direct SQL queries to generate data for views I was aiming for (which can only be done for on-prem implementations of FNMS).
- Murray
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Reporting on COGNOS
Hi,
My experience is limited to local testing VMs and sample data. From playing around to see what I can customize beyond the standard Cognos dashboards, I found Cognos not just to be very slow (or resource hungry) but also my impression is that I am kind of limited by the existing data cube. Sure, I can add my own data, but it stays independent and is not integrated with the existing data structure.
I think the Cognos Cube Designer would be the solution to that, but it is not included. Please correct me someone, if I am wrong here.
I am not aware of any Cognos user guide from Flexera. You should definitely know your data and data structures - because you don't want to make the wrong business decission based on a sloppily created report.
If there are existing reporting solutions in place, possibly with experienced people as well and already integrated in company processes, you might consider using them instead.
Best regards,
Markward
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hi Mantautas,
I use Flexera Analytics (Cognos) daily and find it to be incredibly valuable, but I do acknowledge that it is not trivial and can be confronting to use - but I definitely think it's worth the effort. The System Reference guide (downloadable from the online help) has some content on Analytics, but it is very theoretical. You could look at the Learning center which has some introductory videos and lessons (https://learn.flexera.com/?q=analytics).
There are several data models published with FNMS - if using FNMS cloud there are 2 data models and if using FNMS on prem there is an additional 'operational' data model not available in the cloud (as of 2019 R1 anyway). Each data model has its purpose (dashboard development, versus low level reporting etc), so it would be important for you to become familiar with the different models and when to use each. My advice would be to use the "Flexera Data Models" for dashboard development and then if desirable develop drill through to detailed reports using the other data models.
If you're interested, I've attached a set of examples of dashboards/reports I’ve built using Cognos over the past few years. These might give you an idea of what kind of things are possible. I should clarify that whilst some of these use the OOTB data models in some cases it was necessary to use direct SQL queries to generate data for views I was aiming for (which can only be done for on-prem implementations of FNMS).
- Murray
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Reporting on COGNOS
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Re: Reporting on COGNOS
We are on 2018 R2 - how did you generate the views from SQL? very keen on learning how to do that as you cannot connect the core SQL backend to cognos.