
Max_Schoenhuber asked a question.
Hi all,
I am building a management report in Flexera Analytics (Flexera One ITAM) that ranks publishers by purchase spend per calendar year. The purchase side works well: using only Publisher name and Purchase amount from the Flexera Asset Management Model (relational), filtered on Purchase date before auto aggregation, the figures match the All Purchases view exactly.
The next step is to spread multi-year purchases across the contract term (contract start date to expiry date). For that I need the link between a purchase and its contract. In the product this link exists (Contract properties > Purchases tab, and Contract no. on the purchase), but I cannot find it in either Analytics package:
• Flexera Asset Management Model (relational and dimensional): the Purchases folder has no contract field, and the Contracts folder has no purchase field. Combining both in one list yields a cross product (every purchase amount repeated per contract).
• Flexera Data Models: same picture.
• The FNMS Schema Reference for the Analytics models does not list a relationship either.
Questions:
1. Is there a supported way in Flexera Analytics to report purchase amounts by contract, or to get contract start and expiry dates onto a purchase row?
2. If not, is the relationship planned for a future release of the Analytics packages, or should this be raised as an Idea?
The calculation needs to stay inside the platform (scheduled Analytics report, no external spreadsheet), so I am looking for a way to get contract start and expiry dates onto the purchase rows within Flexera Analytics itself. Any pointers welcome.
Thanks!