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.

Upcoming XBRL US Events

Webinar: SEC Rule – Tailored Shareholder Reports for Mutual Funds and ETFs
Wednesday, May 15, 2024

Domain Steering Committee Meeting
Tuesday, May 21, 2024

Communications & Services Steering Committee Meeting
Tuesday, May 21, 2024

GovFin 2024: Municipal Reporting Workshop
Tuesday, July 30, 2024