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

Webinar: DQC Rules for BDCs and Public Companies – Rule Set 20
Wednesday, December 14, 2022

Communications & Services Steering Committee Meeting
Tuesday, December 20, 2022

Domain Steering Committee Meeting
Tuesday, December 20, 2022

Public Exposure for Comment – Data Quality Committee Rules and Guidance
Saturday, December 31, 2022