{"id":926,"date":"2017-06-05T14:04:24","date_gmt":"2017-06-05T05:04:24","guid":{"rendered":"http:\/\/help.glu.jp\/en\/?p=926"},"modified":"2017-11-17T12:53:30","modified_gmt":"2017-11-17T03:53:30","slug":"tags-summary","status":"publish","type":"post","link":"https:\/\/help.glu.jp\/en\/tags\/tag_basics\/tags-summary\/","title":{"rendered":"Tags Summary"},"content":{"rendered":"<ol class=\"list2\">\n<li><a href=\"#content_1_1\">What is a tag? <\/a><\/li>\n<li><a href=\"#content_1_2\">How to Create a Tag <\/a><\/li>\n<li><a href=\"#content_1_3\">Changing Tag Names <\/a><\/li>\n<li><a href=\"#content_1_4\">Format Settings <\/a><\/li>\n<li><a href=\"#content_1_5\">Showing\/Hiding Tags <\/a><\/li>\n<\/ol>\n<h3 id=\"content_1_1\">1. What is a tag?<\/h3>\n<p>A tag is used to output data to the Excel report templates when compiling reports.<br \/>\nEach individual instruction on a tag is referred to as a directive, consisting of the format &#8220;name=value&#8221;.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/tag_intro.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-1490\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/tag_intro.png\" alt=\"Tag Summary\" \/><\/a><\/div>\n<p>When you compile a report using the compiler, the report data will embed in the excel file according to directives mentioned in the tag.<\/p>\n<p>The first tag directive and its sheetname must be written as follows.<br \/>\nSheet Name: ~T_IND<br \/>\nTag Name: @RTT<br \/>\nDirectives:<br \/>\n<span style=\"color: #008000\">TYPE=top<br \/>\nDATA=index<br \/>\nINDEX_TARGET=self<\/span><\/p>\n<p><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/tag_intro_part2.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-1462\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/tag_intro_part2.png\" alt=\"Excel Template\" \/><\/a><\/p>\n<p>\u203b The Tag is created as a shape on Excel.<br \/>\n\u203b It is necessary that the tag name begins with \u201c@RTT:\u201d to function properly.<br \/>\n\u203b Begin notes to self with a &#8220;#&#8221;. This will comment it out from the tag.<\/p>\n<p>If you have already installed the report compiler on Excel, click \u201cNew Book\u201d under \u201cReport\u201d in the Add-Ins tab to create the \u201c~#T_IND\u201d sheet complete with tag and blank sheets.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/new_book.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1718\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/new_book.png\" alt=\"New Book\" width=\"651\" height=\"223\" \/><\/a><\/div>\n<p>\u203b If you have not yet installed the report compiler on Excel, please refer to &#8220;Installing the Report Compiler&#8221;.<\/p>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_2\">2. How to Create a Tag<\/h3>\n<h4>Download the report tag from glu.<\/h4>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>Select the dice to be used for reporting.<\/li>\n<li>Select \u201cPeriod\u201d under the \u201cReport\u201d tab.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1715\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag.png\" alt=\"Report Period\" width=\"688\" height=\"92\" \/><\/a><\/div>\n<\/li>\n<li>Specify the report conditions under Data \u201cAspect\u201d.<br \/>\nNote: According to the data you wish to export, adjust the display format under &#8220;View&#8221;.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1716\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag2.png\" alt=\"Data Conditions\" width=\"640\" height=\"347\" \/><\/a><\/div>\n<\/li>\n<li>Click \u201cExport\u201d and then download \u201cTemplate Tag\u201d.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1717\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag3.png\" alt=\"Export_ReportTag\" width=\"671\" height=\"157\" \/><\/a><\/div>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<h4>Embed the tag in Excel<\/h4>\n<ol>\n<li>Click \u201cNew Tag\u201d under Report in the Add-ins tab.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1719\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag4.png\" alt=\"Create Tag\" width=\"650\" height=\"223\" \/><\/a><br \/>\n\u203bIf you have not yet installed the report compiler in Excel, please refer to &#8220;Installing the Report Compiler&#8221;.<\/div>\n<\/li>\n<li>Click Open Tag File and drag and drop the template tag from glu to the pop-up window.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1713\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag5.png\" alt=\"Create Tag_Open File\" width=\"478\" height=\"402\" \/><\/a><\/div>\n<\/li>\n<li>Click \u201cCreate\u201d.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1714\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag6.png\" alt=\"Create Tag_Insert\" width=\"478\" height=\"402\" \/><\/a><\/div>\n<\/li>\n<li>The tag content should fill in.\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1762\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/11\/create_tag7.png\" alt=\"Complete Tag\" width=\"351\" height=\"345\" \/><\/a><\/div>\n<\/li>\n<\/ol>\n<p>\u203b The basic tag content will download here, but you may need to edit specific directives such as &#8220;period&#8221;. If you are unclear about what to edit, please contact our Support Team.<\/p>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_3\">3. Changing Tag Names<\/h3>\n<p>It is necessary to assign a name beginning with \u201c@RTT:\u201d to each tag. The portion after \u201c@RTT:\u201d may be decided freely.<\/p>\n<p>Click the tag which you wish to edit on Excel. The tag name will appear in the upper left-hand corner. You can edit the tag name here.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2015\/09\/tagcreate3_tagnamechange.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1460\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/ja\/wp-content\/uploads\/sites\/2\/2015\/09\/tagcreate3_tagnamechange.jpg\" alt=\"\u30bf\u30b0\u306e\u540d\u79f0\u5909\u66f4\" width=\"259\" height=\"110\" \/><\/a><\/div>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_4\">4. Format Settings<\/h3>\n<p>You may customize the background color, transparency settings, and other format settings freely.<\/p>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_5\">5. Showing\/Hiding Tags<\/h3>\n<p>You can choose to show or hide the tag under the \u201cSelection Pane\u201d feature on Excel.<br \/>\n\u203bAfter the report compiles the tag will be hidden. Redisplay the tag under the \u201cSelection Pane\u201d.<\/p>\n<div class=\"jumpmenu\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/selection_pane.png\"><img decoding=\"async\" class=\"alignnone size-medium wp-image-1445\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/selection_pane.png\" alt=\"Selection Pane\" \/><\/a><\/div>\n<p>Tags will display in the order that they are placed (the bottom-most tag displaying first in the Selection Pane).<br \/>\nWhen you have both a tag retrieving the reference date &amp; a tag referring to the reference date cell with START_AT\/END_AT, change the order of the tags with the arrow buttons so that the tag retrieving the reference date is executed first.<\/p>\n<div class=\"img_margin\" style=\"text-align: left\"><a href=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/selection_pane2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1787\" style=\"border: 1px solid #a9a9a9\" src=\"http:\/\/help.glu.jp\/en\/wp-content\/uploads\/sites\/3\/2017\/06\/selection_pane2.png\" alt=\"Compile Order\" width=\"242\" height=\"267\" \/><\/a><\/div>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>What is a tag? How to Create a Tag Changing Tag Names Format Settings Showing\/Hiding Tags 1. What is a tag? A tag is used to output data to the Excel report templates when compiling reports. Each individual instruction on a tag is referred to as a directive, consisting of the format &#8220;name=value&#8221;. When you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[59],"tags":[],"class_list":["post-926","post","type-post","status-publish","format-standard","hentry","category-tag_basics"],"_links":{"self":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/comments?post=926"}],"version-history":[{"count":12,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/926\/revisions"}],"predecessor-version":[{"id":1148,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/posts\/926\/revisions\/1148"}],"wp:attachment":[{"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/media?parent=926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/categories?post=926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.glu.jp\/en\/wp-json\/wp\/v2\/tags?post=926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}