80 likes | 179 Views
21st XBRL International Conference “One Language, Common Vision: Role of XBRL Technology in the Post Crisis Era 19-21 October 2010 Beijing, China. Technology Track TECH 8. Implementation of Formula in CAS taxonomy Bing Leng , Chao Li 20 Oct 2010. Background.
E N D
21st XBRL International Conference“One Language, Common Vision: Role of XBRL Technology in the Post Crisis Era19-21 October 2010Beijing, China Technology Track TECH 8. Implementation of Formula in CAS taxonomy Bing Leng, Chao Li 20 Oct 2010
Background • One of the important goal of CAS taxonomy is to enhance the quality of financial information • Calculation linkbase is far from sufficient in terms of representing the inherent logic and dependency of financial reporting data, i.e. • lack of ability to calculate cross context • lack of ability to multiply between elements
Use Case Analysis • Some most commonly used calculation on financial reporting data includes: • Total of sub category accounts • Movement analysis, i.e. beginning balance + increase – decrease = ending balance • Converting between currency exchanges • All these can’t be achieved via calculation linkbase.
Formula Design Illustration • Total of sub category accounts • Dimension table – Changes of inventories
Formula Design Illustration • Total of sub category accounts • Consistency assertion is used • Setup at Axis level, calculation of all line items can be iterated automatically • Overview of formula design as following:
Formula Design Illustration • Total of sub category accounts • Consistency assertion • setting
Formula Design Illustration • Total of sub category accounts • Formula setting
Formula Design Illustration • Total of sub category accounts • Sum variables setting