- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Re: Reporting on COGNOS
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- 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
- Report Inappropriate Content
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.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@anne_watson - it is possible to connect Cognos directly to the FlexNet Manager SQL database with FNMS On-Premises, but not with FNMS Cloud.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have On-Prem and i was told with 2018 R2, that functionality was lost. If this is not so, could you be so kind as to give me instructions as to how to connect?
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Flexera Analytics (powered by Cognos) is still part of the FlexNet 2018 R2 release. If it is installed and configured on your system, you would normally access it by clicking the the Reports button at the top of the UI and then select an option from the Analytics menu:
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That is not what I am referring to Chris - that we have configured. What i want to do is connect the external Cognos server to the raw FNMSCompliance database so i can transfer existing SQL queries we have developed into Cognos reports to make them accessible to our partners. Many of the tables we have built SQL queries from are not available in the data sources available in Cognos.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Anne,
For on prem FNMS environments the ability to utilise SQL as the source of queries has always been available - though since Cognos has evolved featurewise and (access rights/license levels) there has been some caveats:
For Cognos 10.x environments:
- Using SQL queries in Report Studio required the user to be assigned at least a "Professional User" license.
For Cognos 11.x environments:
- Licensing was simplified to just the two "Analytics User" and "Analytics Administrator" levels - both of these can use SQL queries.
- This release introduced the whol new UI and Dashboard environment which is widget driven & essentially requires data models to be DQM (Dynamic Query Model)
- Note: For FNMS, only the "Flexera Data Models" model is DQM
- the others are CQM (Compatible) and will not work in the Dashboard environment, but will work fine in the Reporting Studio/environment.
So: to use SQL in the Reporting environment you can:
- Create a Report (I am using the "FlexNet Manager Platform Reports and Dashboard" data model)
- Drag a SQL Query from the toolbox into the Queries
- For the Properties of the "SQL" query choose:
- SQL Syntax : Pass-through
- Data Source : Choose the database you want to access
(FNMP-Dashboard is the compliance DB, FNMP-DW-DS is the Data warehouse). - SQL : Enter the SQL code here
When you close the SQL window Cognos will validate the query and save the columns returned by the query for you to use in the report.
You can then build your report using whichever visualisations you want.
Note: if you have numeric fields that you want Cognos to automatically aggregate then you should explicitly set the appropriate aggregation formula (usually Sum/Total, but could be Max/Min/Average etc).
If you want to build dashboards using SQL then the approach is different but can be done by starting with creating a Data Server, then build a Data Module (allowing you to specify joins between subjects/tables) and then possibly Data Sets. You can then choose the Data Module or Data Set as the source of data for your Dashboard.
I presume you are really just asking for SQL in Reports though so I'll leave it there.
Let us know how you get on.
Murray
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's lovely and i have full Admin, Cognos roles, but i still get this error. Any idea?
Permissions error
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the updates, @anne_watson - any chance you could share what the solution ended up being?
Accept as solution to help others find it faster.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have very impressive reports in the pdf, I must say.
I am new to using Cognos but have familiarised myself with the different data sources. The challenge I face is having data from all 3 sources in one window as i do not know how to create the relationships yet. Is this something you managed to do in your reports?
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
He delivered all of IBM Cognos Report Studio to create and use layout, formatting, and user interaction reports. This is usually created by professional report writers who have a good knowledge of the tools and information.
In this exercise, you will learn to:
Create a chart
Make sure the report requires interaction
But you, the thing that the champion analyst on the streets of society. Report Studio creates a graph to display the performance report and returns the last years. Report the addition of an interactive prompt.
You will create a report and Report Studio will return Order Now as an example - Warehouse GO Data push sheet (analysis) of the sample.
Complete this exercise, you must have the appropriate license and security permissions for this feature.
To note:
When using Report Studio, the data, which will not live. You run the report while viewing the data.
You can see the XML report of infinity.
You can add multilingual gives you something.
