Slicing and dicing

The spreadsheet-for-component and spreadsheet-for-report endpoints support dynamic slicing and dicing.

Promoting aspects to dicers

Let us start again with our example balance sheet for Canon. By default, XBRL periods are used as dicers and appear as column headers.

[Public datalake] Spreadsheet viewing 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

Let us add the fiscal year as a dicer. We use the parameter ::category and set it to "dicer".

[Public datalake] Spreadsheet slice and dice 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&xbrl28:FiscalYear::category=dicer&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

Let us add the fiscal period as a dicer as well.

[Public datalake] Spreadsheet slice and dice 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&xbrl28:FiscalYear::category=dicer&xbrl28:FiscalPeriod::category=dicer&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

Now, we can make the XBRL period a slicer to get a nice view over fiscal years and periods. We also use the parameter ::category and set it to "slicer".

[Public datalake] Spreadsheet slice and dice 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&xbrl28:FiscalYear::category=dicer&xbrl28:FiscalPeriod::category=dicer&xbrl:Period::category=slicer&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

By default, slicers are invisible. We can make XBRL period appear in the slicer section with the ::visible parameter and set it to true.

[Public datalake] Spreadsheet slice and dice 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&xbrl28:FiscalYear::category=dicer&xbrl28:FiscalPeriod::category=dicer&xbrl:Period::category=slicer&xbrl:Period::visible=true&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"

Finally, we notice that only FY fiscal periods are available. We can make xbrl28:FiscalPeriod a slicer again.

[Public datalake] Spreadsheet slice and dice 

curl -X GET "http://secxbrl.28.io/v1/_queries/public/api/spreadsheet-for-component?aid=S1004KWM-2&format=html§ion=http%3A%2F%2Fdisclosure.edinet-fsa.go.jp%2Frole%2Fjppfs%2Frol_BalanceSheet&hypercube=jppfs-cor%3ABalanceSheetTable&xbrl28:FiscalYear::category=dicer&xbrl28:FiscalPeriod::category=slicer&xbrl:Period::category=slicer&xbrl:Period::visible=true&token=c3049752-4d35-43da-82a2-f89f1b06f7a4"