Hi
We are working on Flexera Analytics to build some custom reports and dashboards for customer.
The challenge is, the data fields are not present in one Package. So we need to write SQL queries to pull data from Database to achieve this.
However, we are facing challenge with queries, particularly because we do not exactly know which table names and which columns in Database would the required data be present at.
Is there any reference diagram or document which can guide on following -
1. Tells us the mapping between fields in FNMS with Fields in Flexera Analytics GUI.
2. Guides us to understand which data fields is present in which particular tableName and columnName in Database.
Thank you!
Best regards
Syed
āJan 29, 2024 04:51 AM
Hi @SyedByhaqiEMT,
I see a similar question was raised previously here:
https://community.flexera.com/t5/FlexNet-Manager-Forum/Create-reports-charts-from-SQL-query-in-Cognos-Analytics/td-p/269201
As highlighted in the other post, the Database Schema is a good starting point for what you are wanting to achieve. The link below is the reference for FNMS 2023 R2:
https://docs.flexera.com/FlexNetManagerSuite2023R2/EN/Schema/index.html
Regards
Vas
āJan 29, 2024 04:53 PM