{"id":3747,"date":"2016-07-14T03:00:11","date_gmt":"2016-07-13T19:00:11","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3747"},"modified":"2019-10-14T16:18:15","modified_gmt":"2019-10-14T08:18:15","slug":"data-dictionary","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/07\/14\/data-dictionary\/","title":{"rendered":"What is Data Dictionary?"},"content":{"rendered":"<p>Today we will introduce data dictionary of FineReport <a href=\"http:\/\/www.finereport.com\/en\/\" target=\"_blank\">reporting tool <\/a>in this article.Data presentation requires meaningful actual value.<\/p>\n<h3>1. Overview<\/h3>\n<p>In original data of <a title=\"FineReport BI and reporting tool report designer\" href=\"http:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\">report designer<\/a>, what\u2019s saved is the data of code nature. However, data presentation requires meaningful actual value.<\/p>\n<p><strong>1.1 Database table setting<\/strong><\/p>\n<p>In database table setting, we will select corresponding database and table and fill in actual value and desired display value, as shown below:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607114.png\" alt=\"\" width=\"634\" height=\"291\" \/><\/p>\n<p><strong>1.2 Data query setting<\/strong><\/p>\n<p>Data query setting in report designer is to query data set. We will select corresponding data set and set actual value and display value, as shown below:<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607115.png\" alt=\"\" width=\"625\" height=\"228\" \/><\/p>\n<p><strong>1.3 Custom setting<\/strong><\/p>\n<p>Custom display value in report designer, as shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607116.png\" alt=\"\" \/><\/p>\n<p><strong>1.4 Formula setting<\/strong><\/p>\n<p>Formula data dictionary is shown below:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201607117.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today we will introduce data dictionary of FineReport r&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3747"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3747"}],"version-history":[{"count":5,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3747\/revisions"}],"predecessor-version":[{"id":8285,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3747\/revisions\/8285"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3747"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3747"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3747"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}