Multiple Dimension Levels

[John Summersgill]

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’},

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

[David Tauriello]

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.

[Author]

Posts