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 Not Answered
  • Replies replies
    9
  • Subscribers subscribers
    8
  • Views views
    934
  • Users 0 members are here
  • Locked Locked
Related
Options
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Multi value attributes in reports and charts

MigrationDeletedUser

Hello, I feel maybe there is something wrong in reports when multi values attrivutes are used.The field "Affected components" is multi valued but only the first item is shown in reports and charts.As a result the charts can be misleading.Is this the intended behaviour?Thanks a lot,Sebastiano.
  • 0

    Hello,Yes, it's a limitation.

    --
    Alex Shevchenko
    Sr Development Manager
    Although I work for OpenText, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button.

  • 0

    Hello Alexander,great thanks for the quick support!Have a nice day,Sebastiano.
  • 0

    Hi Alexander,is there a way to download all values of the multi valued attributes to Excel?This way I can do the charts by postprocessing the data in Excel.Thanks a lot,Sebastiano.
  • 0

    There are published views in the database. These are documented in the Guide to Reports. You may then access the published views by using ODBC to connect to the database as the report user. The names of all published views start with PCMS_
  • 0

    Ah, I heard about those reports via ODBC but never tried, thank you!Sebastiano.
  • 0

    Hi,You may also try C or Java API to query the attributes, or Web Services. All of these require some programming.

    --
    Alex Shevchenko
    Sr Development Manager
    Although I work for OpenText, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button.

  • 0

    Hello, is this limitation still existing in dimensions?

    For our multi values we always need to know just the latest entry.

    And I would need a solution for standard users without any programming knowledge.

  • 0 in reply to 

    Hello, is this limitation still existing in dimensions?

    For our multi value attributes we always need to know just the latest entry in Reports or the list of requests.

    And I would need a solution for standard users without any programming knowledge.

  • 0 in reply to 

    Hello Andreas,

    Yes, the behavior still remains for multi-value attributes showing the 1st value.

    In the case of only latest attribute value requirement - I think that can be a reasonable enhancement request to introduce such report option.

    Do you want me to record it for a future release?

    --
    Kind Regards,
    Alex

    --
    Alex Shevchenko
    Sr Development Manager
    Although I work for OpenText, I am speaking for myself and not for OpenText.
    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button.

Resources

Support
Documentation
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.