{"id":610,"date":"2020-07-16T12:21:30","date_gmt":"2020-07-16T10:21:30","guid":{"rendered":"https:\/\/test-downloads.geniusbytes.com\/?post_type=docs&#038;p=610"},"modified":"2024-05-06T12:35:15","modified_gmt":"2024-05-06T10:35:15","password":"","slug":"how-can-i-create-an-automated-report","status":"publish","type":"docs","link":"https:\/\/tic.geniusbytes.com\/en\/docs\/how-can-i-create-an-automated-report\/","title":{"rendered":"Create an automated report?"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Video<\/h2>\n\n\n\n<p>This video shows how to create an automated report based on the gathered accounting data from default templates The commentary is in German, subtitles are also available in English.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<figure class=\"wp-block-embed wp-block-embed-youtube is-type-video is-provider-youtube epyt-figure\"><div class=\"wp-block-embed__wrapper\"><div class=\"epyt-video-wrapper\"> <div class=\"brlbs-cmpnt-container brlbs-cmpnt-content-blocker brlbs-cmpnt-with-individual-styles\" data-borlabs-cookie-content-blocker-id=\"youtube-content-blocker\" data-borlabs-cookie-content=\"PGlmcmFtZSAgc3R5bGU9ImRpc3BsYXk6IGJsb2NrOyBtYXJnaW46IDBweCBhdXRvOyIgIGlkPSJfeXRpZF83MjgxOCIgIHdpZHRoPSI4MDAiIGhlaWdodD0iNDUwIiAgZGF0YS1vcmlnd2lkdGg9IjgwMCIgZGF0YS1vcmlnaGVpZ2h0PSI0NTAiIHNyYz0iaHR0cHM6Ly93d3cueW91dHViZS1ub2Nvb2tpZS5jb20vZW1iZWQva09hZHg0WjRQWmM\/ZW5hYmxlanNhcGk9MSZhdXRvcGxheT0wJmNjX2xvYWRfcG9saWN5PTAmY2NfbGFuZ19wcmVmPSZpdl9sb2FkX3BvbGljeT0xJmxvb3A9MCZyZWw9MSZmcz0xJnBsYXlzaW5saW5lPTEmYXV0b2hpZGU9MiZobD1lbl9HQiZ0aGVtZT1kYXJrJmNvbG9yPXJlZCZjb250cm9scz0xJmRpc2FibGVrYj0wJiIgY2xhc3M9Il9feW91dHViZV9wcmVmc19fICBuby1sYXp5bG9hZCIgdGl0bGU9IllvdVR1YmUgcGxheWVyIiAgYWxsb3c9ImZ1bGxzY3JlZW47IGFjY2VsZXJvbWV0ZXI7IGF1dG9wbGF5OyBjbGlwYm9hcmQtd3JpdGU7IGVuY3J5cHRlZC1tZWRpYTsgZ3lyb3Njb3BlOyBwaWN0dXJlLWluLXBpY3R1cmU7IHdlYi1zaGFyZSIgcmVmZXJyZXJwb2xpY3k9InN0cmljdC1vcmlnaW4td2hlbi1jcm9zcy1vcmlnaW4iIGFsbG93ZnVsbHNjcmVlbiBkYXRhLW5vLWxhenk9IjEiIGRhdGEtc2tpcGdmb3JtX2FqYXhfZnJhbWViamxsPSIiPjwvaWZyYW1lPg==\"><div class=\"brlbs-cmpnt-cb-preset-c brlbs-cmpnt-cb-youtube\"> <div class=\"brlbs-cmpnt-cb-thumbnail\" style=\"background-image: url('https:\/\/tic.geniusbytes.com\/wp-content\/uploads\/borlabs-cookie\/1\/yt_kOadx4Z4PZc_hqdefault.jpg')\"><\/div> <div class=\"brlbs-cmpnt-cb-main\"> <div class=\"brlbs-cmpnt-cb-play-button\"><\/div> <div class=\"brlbs-cmpnt-cb-content\"> <p class=\"brlbs-cmpnt-cb-description\">You are currently viewing a placeholder content from <strong>YouTube<\/strong>. To access the actual content, click the button below. Please note that doing so will share data with third-party providers.<\/p> <a class=\"brlbs-cmpnt-cb-provider-toggle\" href=\"#\" data-borlabs-cookie-show-provider-information role=\"button\">More Information<\/a> <\/div> <div class=\"brlbs-cmpnt-cb-buttons\"> <a class=\"brlbs-cmpnt-cb-btn\" href=\"#\" data-borlabs-cookie-unblock role=\"button\">Unblock content<\/a> <a class=\"brlbs-cmpnt-cb-btn\" href=\"#\" data-borlabs-cookie-accept-service role=\"button\" style=\"display: inherit\">Accept required service and unblock content<\/a> <\/div> <\/div> <\/div><\/div><\/div><\/div><\/figure>\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Preqrequisites:\">Preqrequisites:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Running Genius MFP environment<\/li>\n\n\n\n<li>(custom report definition file)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Objective:\">Objective:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>create an automated report based on the gathered accounting data from default or custom templates<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Solution:\">Solution:<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>create new report definition<\/li>\n\n\n\n<li>load default definition or upload custom definition<\/li>\n\n\n\n<li>set parameters (e.g. MyPeriod) to define the time window for the report data (daily (default), weekly, monthly, quaterlly, yearly)<\/li>\n\n\n\n<li>allow user to receive the report regularly via email<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Example:\">Example:<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-createreportdefinition\">create report definition<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Access Admin webinterface, Admin, Reporting, Definition<\/li>\n\n\n\n<li>Click load for built in default reports<br>(for a custom report click new and upload the report tempalte zip file)<\/li>\n\n\n\n<li>Enter a Name for your report (e.g. clicks for user cost centers)<\/li>\n\n\n\n<li>Enter a report description (e.g. report for all clicks accounted on user cost centers)<\/li>\n\n\n\n<li>Check active checkbox<\/li>\n\n\n\n<li>Configure CRON expression<br>the cron expression defines when the report will be created, not which data will be contained (see parameters section below)<br>please choose the creation date so it will be after the last date you want to be part of the report<br>Every cron parameter has to be seperated by a space from the next parameter.<br>The Cron parameters are:<br>second, minute, hour, day of the month, month, day of the week<br>* * * * * ?<br>would mean: every second every minute, every hour, on any day, in any month, whatever day of the week it is<br><br>Examples:<br>For a quarterly report ( at 2 o&#8217;clock on the first day of the month, for january and every 3 months following : 0 0 2 1 1\/3 ?)<br>The accounting data will be gathered on january 1st (for Oct-Dec last year) ,  april 1st (for Jan-Mar), july 1st (for Apr-Jun), october 1st (for Jul-Sep), january 1st (next year) (for Oct-Dec) and so on<br><\/li>\n\n\n\n<li>Check format types to be created<\/li>\n\n\n\n<li>Add groups that can subscribe to the report (if a user of this group can suscribe to the report and receive it via email upon creation)<\/li>\n\n\n\n<li>Press save and close<\/li>\n\n\n\n<li>Example view:<br><img decoding=\"async\" class=\"wp-image-611\" style=\"width: 600px;\" src=\"https:\/\/test-downloads.geniusbytes.com\/wp-content\/uploads\/GeniusServer_AdminWeb_ReportDefinition.png\" alt=\"\"><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Setparameters\">Set parameters<\/h3>\n\n\n\n<p>The report can have custom parameters to filter the data, for default reports the &#8220;My_Period&#8221; parameter can be set. Before you can set the parameters, please save the definition and reopen it.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the report in the list<\/li>\n\n\n\n<li>Press Edit<\/li>\n\n\n\n<li>Click Set parameters<\/li>\n\n\n\n<li>Set the timewindow for the reporting data, if My Period is not set, the timewindow will be &#8220;LAST_DAY&#8221;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">View created reports<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>after a report has been created it can be view from admin webinterface, Admin, Reporting, Definition by selecting a definition<\/li>\n\n\n\n<li>The reports will be displayed in the Report instance window<br><img decoding=\"async\" class=\"wp-image-612\" style=\"width: 600px;\" src=\"https:\/\/test-downloads.geniusbytes.com\/wp-content\/uploads\/GeniusServer_AdminWeb_ReportInstances.png\" alt=\"\"><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Report subscription<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>login to GWEB (e.g. http:\/\/&lt;your Genius Server VM&gt;:8080\/gweb<\/li>\n\n\n\n<li>access the reports section<br>if this section is not available, please check the user permissions (Admin web, Authentication Management, Grant, MyDefaultGrant)<\/li>\n\n\n\n<li>search your report and click subscribe<br><img decoding=\"async\" class=\"wp-image-613\" style=\"width: 600px;\" src=\"https:\/\/test-downloads.geniusbytes.com\/wp-content\/uploads\/GeniusServer_GWeb_Reports.png\" alt=\"\"><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Howcancreateareportdefinitionwithatemplate?-Troubleshooting:\">Troubleshooting:<\/h3>\n\n\n\n<p>If your report does not show any data:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>check if your my period setting parameter was set correctly<\/li>\n\n\n\n<li>check if accounting data was already transferred to the reporting section of the database<br>To do this you have to:<\/li>\n\n\n\n<li>Open Admin, Accounting, Pivot Table<\/li>\n\n\n\n<li>Set start and end date matching your report &#8220;my Period&#8221; parameter<\/li>\n\n\n\n<li>Click search<br>If the pivot table does not show any data, please check the Last execition date of the etl process<br>Admin,Service, Scheduler called &#8220;MFP-ACCOUNTING-etl&#8221;The planned execution of this task is every 30 minutes<br>This is the service which will transfer the raw gathered accounting data into the reporting database section<\/li>\n<\/ul>\n\n\n\n<p>If this scheduler has run after your clicks have been generatedand you still do not see clicks in the pivot table, please contact us.<\/p>\n\n\n\n<p>If your report is not generated:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Check Admin, Service, Scheduler, called &#8220;REPORT&#8221;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">More information<\/h2>\n\n\n\n<p>Read also our documentation on<a href=\"https:\/\/tic.geniusbytes.com\/en\/ProductDoku\/Server\/GeniusServer\/pages\/admin\/reporting.html\/\" target=\"_blank\" rel=\"noreferrer noopener\"> this point<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Video This video shows how to create an automated report based on the gathered accounting data from default templates The commentary is in German, subtitles are also available in English. Preqrequisites: Objective: Solution: Example: create report definition Set parameters The report can have custom parameters to filter the data, for default reports the &#8220;My_Period&#8221; parameter [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"doc_category":[32],"doc_tag":[35,36],"class_list":["post-610","docs","type-docs","status-publish","hentry","doc_category-genius-server","doc_tag-accounting","doc_tag-reporting"],"year_month":"2026-05","word_count":639,"total_views":"5811","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Bernd C.","author_nicename":"bernd","author_url":"https:\/\/tic.geniusbytes.com\/en\/author\/bernd\/"},"doc_category_info":[{"term_name":"Genius Server","term_url":"https:\/\/tic.geniusbytes.com\/en\/docs-category\/genius-server\/"}],"doc_tag_info":[{"term_name":"Accounting","term_url":"https:\/\/tic.geniusbytes.com\/en\/docs-tag\/accounting\/"},{"term_name":"Reporting","term_url":"https:\/\/tic.geniusbytes.com\/en\/docs-tag\/reporting\/"}],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/docs\/610","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/comments?post=610"}],"version-history":[{"count":5,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/docs\/610\/revisions"}],"predecessor-version":[{"id":7505,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/docs\/610\/revisions\/7505"}],"wp:attachment":[{"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/media?parent=610"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/doc_category?post=610"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/tic.geniusbytes.com\/en\/wp-json\/wp\/v2\/doc_tag?post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}