Home Forums The XBRL API Multiple Dimension Levels

Viewing 1 reply thread
  • Author
    Posts
    • #198917
      John Summersgill
      Participant

      Hi, I’m trying to qenerate a query to access 3 known concepts across 8 known entities. The issue I’m having is those concepts sometimes having multiple dimensions levels (not of proper nomenclature).

      As an example I’m query entity CIK ‘0000896159’ for concept ‘PremiumsEarnedNet’. I have parameter to local only for member.local-name ‘SegmentGlobalReinsuranceMember’. The issue is that there is another dimension nested underneath that gets pulled into the query as well. What’s the best way to filter out the second dimension level? Below are the two dimensions returned. I only want the first one.

      [{‘dimension_namespace’: ‘http://fasb.org/us-gaap/2021-01-31’, ‘dimension_local_name’: ‘StatementBusinessSegmentsAxis’, ‘member_namespace’: ‘http://investors.chubb.com/20211231’, ‘member_local_name’: ‘SegmentGlobalReinsuranceMember’}]

      [{‘dimension_namespace’: ‘http://fasb.org/us-gaap/2021-01-31’, ‘dimension_local_name’: ‘StatementBusinessSegmentsAxis’, ‘member_namespace’: ‘http://investors.chubb.com/20211231’, ‘member_local_name’: ‘SegmentGlobalReinsuranceMember’},

    • #198967
      David Tauriello
      Keymaster

      Hi John – thanks for the email follow-up (our system moderates any posts with URLs, and the queue is checked a couple times a week).

      I think you’re on the right track filtering with dimensions.count combined with the specific member.local-name (note that dimensions.count is plural – https://xbrlus.github.io/xbrl-api).

      This seems to be headed in the right direction:

      /fact/search?entity.cik=0000896159&concept.local-name=PremiumsEarnedNet&period.fiscal-period=Y&fact.ultimus=true&fields=entity.name,period.fiscal-year.sort(DESC),fact.numerical-value,member.local-name,dimensions&member.local-name=SegmentGlobalReinsuranceMember&dimensions.count=1

      Reply on the thread if you have additional questions about this or if it’s not quite right.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Wednesday, June 29, 2022

Domain Steering Committee Meeting
Tuesday, July 19, 2022

Communications & Services Steering Committee Meeting
Tuesday, July 19, 2022

Dive into Debt Securities – Illustrations of the FASB Implementation Guide
Wednesday, July 20, 2022

Public Review: Annual Comprehensive Financial Report Taxonomy
Monday, August 15, 2022