从演示文稿链接库生成事实表 [英] Generating a Fact Table from a presentation linkbase
问题描述
这是来自此SO问题的后续问题.
现在已经从表示链接库中创建模型结构,该链接库在此处,我现在想提取事实表信息.
Having now created the Model Structure from the presentation linkbase found here, I now would like to extract the Fact Table information.
模型结构为:
us-gaap_IncomeStatementAbstract
Statement [Table] us-gaap_StatementTable
Legal Entity [Axis] dei_LegalEntityAxis
Entity [Domain] dei_EntityDomain
Statement [Line Items] us-gaap_StatementLineItems
Net sales us-gaap_SalesRevenueNet
Cost of sales us-gaap_CostOfGoodsAndServicesSold
Gross margin us-gaap_GrossProfit
Operating expenses: us-gaap_OperatingExpensesAbstract
Research and development us-gaap_ResearchAndDevelopmentExpense
Selling, general and administrative us-gaap_SellingGeneralAndAdministrativeExpense
Total operating expenses us-gaap_OperatingExpenses
Operating income us-gaap_OperatingIncomeLoss
Other income/(expense), net us-gaap_NonoperatingIncomeExpense
Income before provision for income taxes us-gaap_IncomeLossFromContinuingOperationsBeforeIn...
Provision for income taxes us-gaap_IncomeTaxExpenseBenefit
Net income us-gaap_NetIncomeLoss
Earnings per share: us-gaap_EarningsPerShareAbstract
Basic us-gaap_EarningsPerShareBasic
Diluted us-gaap_EarningsPerShareDiluted
Shares used in computing earnings per share: us-gaap_WeightedAverageNumberOfSharesOutstandingAb...
Basic us-gaap_WeightedAverageNumberOfSharesOutstandingBa...
Diluted us-gaap_WeightedAverageNumberOfDilutedSharesOutsta...
Cash dividends declared per share us-gaap_CommonStockDividendsPerShareDeclared
我试图从xml文档重新创建的事实表包含以下信息:
The Fact Table that I am trying to recreate from the xml documents contains this information:
然后可以渲染此事实表以生成该表:
This fact table can then be rendered to produce this table:
问题是我不确定如何获取每个订单项的具体事实.例如,模型结构包含元素Net sales
,其概念为us-gaap_SalesRevenueNet
. 实例文档包含以下对以下内容的引用: us-gaap_SalesRevenueNet
:
The problem is that I am not sure how to get the specific facts for each line item. For example, the model structure contains the element Net sales
which has the concept us-gaap_SalesRevenueNet
. The instance document contains the following references to us-gaap_SalesRevenueNet
:
contextRef decimals fact_value id_x tag unitRef {http://www.w3.org/1999/xlink}arcrole {http://www.w3.org/1999/xlink}href {http://www.w3.org/1999/xlink}type {http://www.w3.org/2001/XMLSchema-instance}nil cik_x cik_y id_y startDate endDate instant
471 eol_PE2035----1510-Q0015_STD_91_20141227_0 -6 74599000000 id_5473321_00DC1C18-22C7-426B-AF70-F6B281547EC4_2_0 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0 2014-09-28 2014-12-27
527 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1138497 -6 30566000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_1002_0 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1138497 2014-09-28 2014-12-27
529 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1173722 -6 5448000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_2002_6 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1173722 2014-09-28 2014-12-27
531 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1181338 -6 16144000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_3002_4 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1181338 2014-09-28 2014-12-27
533 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1184739 -6 17214000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_4002_2 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1184739 2014-09-28 2014-12-27
535 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1257623 -6 5227000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_5002_8 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1257623 2014-09-28 2014-12-27
628 eol_PE2035----1510-Q0015_STD_91_20151226_0 -6 75872000000 id_5473321_00DC1C18-22C7-426B-AF70-F6B281547EC4_1_0 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0 2015-09-27 2015-12-26
701 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1138497 -6 29325000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_1001_0 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1138497 2015-09-27 2015-12-26
703 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1173722 -6 4794000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_2001_6 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1173722 2015-09-27 2015-12-26
705 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1181338 -6 18373000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_3001_4 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1181338 2015-09-27 2015-12-26
707 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1184739 -6 17932000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_4001_2 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1184739 2015-09-27 2015-12-26
709 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1257623 -6 5448000000 id_5473321_493F2921-7163-4A93-9BC8-89E0F5E62B3B_5001_8 {http://fasb.org/us-gaap/2015-01-31}SalesRevenueNet iso4217_USD 0000320193 0000320193 eol_PE2035----1510-Q0015_STD_91_20151226_0_1106947x1257623 2015-09-27 2015-12-26
在显示的12个事实中,事实表仅需要两个-它们是具有eol_PE2035----1510-Q0015_STD_91_20141227_0
和eol_PE2035----1510-Q0015_STD_91_20151226_0
的contextRef的事实.
Of the 12 facts shown, only two are required for the fact table - they are the facts with the contextRef of eol_PE2035----1510-Q0015_STD_91_20141227_0
and eol_PE2035----1510-Q0015_STD_91_20151226_0
.
这些contextRef id对应于实例文档中的以下事实:
These contextRef id's correspond to the following facts in the instance document:
<context id="eol_PE2035----1510-Q0015_STD_91_20141227_0">
<entity>
<identifier scheme="http://www.sec.gov/CIK">0000320193</identifier>
</entity>
<period>
<startDate>2014-09-28</startDate>
<endDate>2014-12-27</endDate>
</period>
</context>
<context id="eol_PE2035----1510-Q0015_STD_91_20151226_0">
<entity>
<identifier scheme="http://www.sec.gov/CIK">0000320193</identifier>
</entity>
<period>
<startDate>2015-09-27</startDate>
<endDate>2015-12-26</endDate>
</period>
</context>
这些contextRefs本质上是Period Axis
元素.我无法确定如何从xml 文档,因此无法重现事实表.谁能阐明如何做到这一点?
These contextRefs are essentially the Period Axis
elements. I can't tell how the period axis are being determined from the xml documents and, therefore, cannot reproduce the fact table. Can anyone shed any light on how to do this?
推荐答案
您要粘贴的是简化的渲染,而不是IncomeStatement的完整渲染.
What you are pasting is a simplified rendering, not a complete rendering of the IncomeStatement.
完整的渲染图是:
您可以从定义中获得该信息链接库上面写着:
例如,您列出的SalesRevenueNet之一链接到上下文"eol_PE2035 ---- 1510-Q0015_STD_91_20141227_0_1106947x1173722".此上下文包含对轴"us-gaap:StatementBusinessSegmentsAxis"的限制.因此,此上下文不在StatementOfIncome内,因为未在根据定义链接库的超立方体中定义此轴.
For example, one of the SalesRevenueNet that you are listing is linked to context "eol_PE2035----1510-Q0015_STD_91_20141227_0_1106947x1173722". This context contains a restriction on Axis "us-gaap:StatementBusinessSegmentsAxis". Therefore, this context is outside of the StatementOfIncome because this axis is not defined in the hypercube of the according definition linkbase.
我认为您这样做是出于学习目的?否则,建议您使用secxbrl.info这样的服务:
I assume you are doing this for learning purposes? Otherwise, I'd suggest you use a service like secxbrl.info:
- 可作为呈现表(JSON)(您也可以获取html)
- Factable as a list (JSON) (you can also get csv, html, or xml)
- Factable as a rendered table (JSON) (you can also get html)
这篇关于从演示文稿链接库生成事实表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!