SMAX User Discussions

Home

Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

State Suggested Answer
Replies reply
1
Answers answer
1
Subscribers subscribers
19
Views views
59
Users 0 members are here

Related

Options

Capability to export related records or associated records in M:M relations

Hemanth Sadaram 1 month ago

Hello Everyone,

Do we have any way to export related records in M:M relationship records.?

Tags:

Custom Action

SMAX

smax-suite

Service Management Automation

Top Replies

Dave Heckford 1 month ago +1 suggested

Hi Hemanth, The best way to extract the data that you'd like to see is by using Odata. Here are some helpful links about how to use Odata: https://docs.microfocus.com/doc/SMAX/24.3/UseODataForBIIntegration…

Suggested Answer

0 Dave Heckford 1 month ago

Hi Hemanth,

The best way to extract the data that you'd like to see is by using Odata. Here are some helpful links about how to use Odata:

https://docs.microfocus.com/doc/SMAX/24.3/UseODataForBIIntegration

https://docs.microfocus.com/doc/SMAX/24.3/PowerBIReportsViaOData

By using Power BI Desktop for example you can produce a simple view such as this:

Here you can see a list of Changes and by Adding the r_ChangeCausedBy<Change> or <Incident> or <Request> you can then see the Many 2 Many relationships. In the example above I just added the Incident and Request to help show what caused those Changes.

Thanks

Dave
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Resources

Learning Services

Partner Programs

Privacy

Compliance

Help

Company

Privacy Policy
Terms of Use
Cookies Preferences

Accessibility
Anti-Slavery Statement

Support
Contact Us

Careers
Code of Business Conduct and Ethics

The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.