The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company

The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company | Research Square window.SnipcartSettings = { analytics: { enabled: false } }; (function() { var accessVector = localStorage.getItem('access_vector') || ''; window.dataLayer = window.dataLayer || []; if (accessVector) { window.dataLayer.push({ user: { profile: { profileInfo: { snid: accessVector } } } }); } })(); (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src='https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);})(window,document,'script','dataLayer','GTM-K279D39R'); Browse Preprints In Review Journals COVID-19 Preprints AJE Video Bytes Research Tools Research Promotion AJE Professional Editing AJE Rubriq About Preprint Platform In Review Editorial Policies Our Team Advisory Board Help Center Sign In Submit a Preprint Cite Share Download PDF Case study The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company Ford Lumban Gaol, Lufty Abdillah, Tokuro Matsuo This is a preprint; it has not been peer reviewed by a journal. https://doi.org/ 10.21203/rs.3.rs-30203/v1 This work is licensed under a CC BY 4.0 License Status: Posted Version 1 posted You are reading this latest preprint version Abstract Introduction: XYZ is a company engaged in the port sector. XYZ is engaged in the business of loading and unloading terminal services and container buildup. To support the company's business processes. Case Description: XYZ uses two applications in carrying out operational activities, namely the CARTOS application to manage bills and the Finance application to record company costs and revenues. To produce a cost accounting report, PT XYZ is still processing and visualizing it manually using Microsoft Excel applications with data sources from the two applications previously mentioned. There are problems related to the process, where the processing time to process data into information is quite long. So that reporting to management cannot be done in real time. Discussion and Evaluation: The development of business competition is very rapid, the management of XYZ must be able to make decisions quickly and accurately, so company needs tools that can help the management to analyze and manage data into information in real time. The Business Intelligence (BI) method is one of the solutions to the company's needs, especially in analyzing and providing access to data to help make better decisions. Conclusion: This study discusses the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard in accordance with the needs of PT XYZ. The method used in developing the business intelligence dashboard refers to the executive information system lifecycle method which consists of justification, planning, business analysis, design, construction and deployment. The results of this research are dashboard visualization using Power BI tools that display information and knowledge needed in the monitoring process and become material for generating management decisions related to cost accounting reports. Business Law Business Intelligence Data Warehouse Dashboard Cost Accounting Financial Report Figures Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Introduction A dynamic business development requires companies to be faster and more careful in every decision making. The wrong action can cause a lack of effectiveness which results in losses received by the company. Because of its importance, many companies are competing to extract information and knowledge from their data. The main objective is to support decisions made based on the results of information and knowledge analysis representing company decisions. One method used is Business Intelligence (BI). BI is defined as one of the data utilization methodologies to produce information to become knowledge in supporting strategic decision making. XYZ is a company engaged in the port sector, where PT XYZ serves terminal loading and unloading services and container buildup. To support the company's business processes, XYZ uses two applications, the CARTOS application to manage invoices and the Finance Application to record company costs and revenues. Business Intelligence is a way to collect, store, organize, reshape, summarize data and provide information, both in the form of company internal business activity data, as well as company external business activity data including business activities of competitors that are easily accessed and analyzed for various management activities [ 1 ]. Business Intelligence is a series of applications and technologies for collecting, storing, analyzing, and presenting data access to assist company officials in decision making [ 2 ]. In addition, according to DJ Powers, said that Business Intelligence explained about a concept and method of how to improve the quality of business decision making based on data-based systems [ 3 ] From the three sources above, it can be concluded that Business Intelligence is the concept of collecting data, storing data and selecting data to provide information to help and improve the quality of business decision making for companies. So it can be said that the information system is a place for data entry, while the business intelligence application is a place for data analysis. Where the concept of business intelligence turns information into new knowledge and understanding for an organization. Previous studies that are relevant to this study include research conducted by Muhd ​​Zaimi Abd. Majid, Wan Zahran Zakaria, and Ali Keyvanfar with the research title Executive Information Site Management System for Project Performance Monitoring: System Requirements Study. In this research, it is discussed how to monitor and control the development of a construction project work by utilizing the Executive Information System technology[ 4 ]. The study uses the Classic Waterfall Model method in developing the system. Next is a study conducted by Meyliana, Henry A. E Widjaja, and Stephen W. Santoso with the title of University dashboard research: An implementation of executive dashboard to university[ 5 ]. In this research the data warehouse development method uses the Key Performance Indicator approach which is owned by the university. Based on research conducted by Mohammad Taleghani with the title Executive Information Systems development lifecycle explained the concepts and architecture in the development of EIS [ 6 ]. Also explained what criteria support in evaluating an EIS so as to produce an EIS that suits user needs. Based on research conducted by Joko Christian by using a data warehouse development method using a business life cycle approach and using the functionality testing of the prototype in the form of white box testing as feedback from the user [ 7 ]. This research uses a web service system as an intermediary between the data warehouse and the applications used and the research produces a model that cannot be implemented yet. Lutfi Izhariman, Eko Darwiyanto and Shinta Yulia Puspitasari conducted research under the title Design of Hospital Executive Information System for Evaluating Service Performance at Mohammad Hoesin Hospital Palembang [ 8 ]. In this study, it was discussed how to design an Executive Information System (EIS) that can support the processing of patient medical record data to display information on medical service indicators. The EIS design requires a data warehouse through the ETL (extract, transform, load) process in hospital operational data and displays the results of data analysis using OLAP (Online Analytical Processing) technique. Edy Martha, et al, also conducted research using the EIS system life cycle engineering methods and built a system model with the help of UML [ 9 ]. His research resulted in a web-based executive information system application to process data at the Cabinet Secretariat. Research conducted by Arif N, et al, using the EIS life cycle development method with primary data contained in the data warehouse is processed so that it becomes a form that can be analyzed by OLAP Server and uses a dashboard application to perform and view the results of the analysis [ 10 ]. The results of his research are in the form of a model design in building an executive information system at UGM that can show conditions in an organization in the form of a graphical display on the dashboard, so that it can be used as a material for university executive level consideration for decision making. This research will produce the design and results of the implementation of executive information systems in accordance with the needs of PT XYZ. This research will use the EIS Lifecycle development method in which there are 6 stages of development namely justification, planning, business analysis, design, construction and deployment. The data to be used in this application is sample data from XYZ that is pulled from the XYZ operational system. Case Description In the case of XYZ, currently to process data and visualize the data to be a cost accounting report is still done manually using the Microsoft Excel application. Based on the results of interviews with management, there are several issues related to the process, including : Data obtained from the supporting application outputs mentioned earlier are still in the form of raw data and take time to process data into information. Data that can be stored and processed in Microsoft Excel is limited so that the monitoring and view of historical data is still not optimal. The process of reporting cost accounting reports to management cannot be done in real time. PT XYZ requires a BI application that provides monitoring information related to profit and loss per project to improve management effectiveness and efficiency in strategic decision making. Therefore, the development of BI applications can be a solution to assist managers in monitoring business processes, specifically related to profit and loss per project. Development includes the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard. Method And Simulation In the development of executive information systems there are methods that can be used, namely the method of executive information system lifecycle. According to Taleghani, EIS life cycle is divided into 6 stages from justification to deployment [ 7 ]. In these six stages there are other stages. A description of the stages of the EIS Lifecycle can be seen in the following explanation. Justification In this stage, consideration is given to developing an EIS, at this stage consideration is given of business opportunities and business needs, as well as consideration of the development of an EIS with costs incurred with the benefits obtained, both business benefits or strategic benefits as decision aides. Planning In this stage there are two activities carried out, namely: Enterprise Infrastructure Evaluation At this stage an organizational infrastructure is identified. We can carry out technical evaluation of infrastructure such as; hardware, networks, middleware, database management systems and tools. Project Planning In this stage project management activities are carried out, project management is carried out so that the EIS development is carried out in accordance with the specified targets. Some basic activities in project management, namely determining the time of completion of the project, the costs required and determining who is working on the EIS development project. Business Analysis In this stage there are four activities carried out, namely: Project Requirement Definition In this stage we define what needs are needed. There are several ways to identify needs, namely by conducting internal meetings with executives, interviewing EIS developers with executives and conducting literature studies. Data analysis Data analysis focuses on identifying data sources, logic designs (ER-diagrams) and identifying attributes. Application Prototyping Prototype is built to be validated in accordance with specified business requirements. The results of the validation of the prototype were evaluated and their shortcomings were corrected Metadata Analysis Metadata is processed in the design and data sources are mapped to the metadata structure. Design In this stage there are two activities carried out, namely: Database Design Activities carried out at this stage are designing logical models. Data model for processing and as data storage. Database development for EIS is different from building a database for operational systems, here are some considerations in building an EIS database, namely: The purpose of the EIS database is designed to be simplified, high-performance data retrieval rather than for effectiveness and maintenance as in database operations. Reducing or minimizing data redundancy or data duplication is not the target of designing the EIS database. Multidimensional database design supports fast data retrieval over large data ranges. Two well-known multidimensional database design techniques are the star schema and the snowflake schema. Extract Transform Load (ETL) Design ETL design is important in the development of EIS, ETL functions as extracting data from other databases or operational systems, Performing data cleaning and loading data into the EIS database. ETL is designed to solve problems that exist in data sources, namely primary key inconsistencies, data inconsistencies, format differences, inaccurate data and data synonyms / homonyms. Construction This stage is the stage of design realization in accordance with the previous design stages. Deployment At this stage, the implementation of all the series of stages that have been carried out previously will be carried out by testing the application system to the end user whether it meets the needs, so that it can fulfill all the information needed. Discussion And Evaluation In accordance with the formulation of the problems discussed in case description, XYZ has a need for a system that can help provide financial accounting based on cost accounting. With the cost accounting based financial statements, it can help XYZ managers in determining the cost of production, controlling costs and supporting decision making. One solution that can be done for the above needs is the adoption of the BI system. BI can be one of the tools to produce cost accounting reports in the form of a dashboard. Through this research it is expected to provide the best solution for XYZ according to their needs. Project Requirement Definition and Data Analysis Information needs analysis is done with observe things that are needed at XYZ Company. Then conduct interviews and field observations. Based on the results of these methods, the information needs to be used to develop the BI model in XYZ companies include: Business segmentation information based on location Business segmentation information based on services Business segmentation information based on customer Business segmentation information based on equipment Business segmentation information based on commodity Data sources that will be used are operational data from the Oracle EBS application and CARTOS application used by XYZ companies in carrying out company operational activities. Database Design Based on the development of the method already described, the data warehouse modeling made is as follows such as Fig. 3 . Extract, Transform, Loading (ETL) Process ETL process is a process to move data from a database source (OLTP) into a data warehouse (OLAP). This ETL process uses the Pentaho Data Integration spoon application. Data warehouse stores data that is used to produce the information needed. The ETL process in this study uses the Pentaho Data Integration (PDI) tool. In PDI there are several icons used in the ETL process. The ETL process is carried out on 6 dimension tables and 1 fact table. One example of these ETLs can be seen in Fig. 4 below. Application Of Microsoft Power BI Microsoft Power BI desktop is an analytic application for analyzing data. Microsoft Power BI can also be called a visualization tool used to represent data in a data warehouse. Before visualizing the data, the first step taken is to retrieve data from the data source by selecting get data on the initial display when opening the application. After that, a dialog box will appear to select the data source to be used. There are 5 types of data that can be used, namely files, databases, Azure, online services, and others. In this study the data source used is an Oracle database. The visualizations used for developing the Business Intelligence model in this study are graphics and text. Visualization results are described in the form of a dashboard. Figure 5 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's location. Figure 6 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's services. Figure 7 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's customers. Figure 8 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's equipments. Figure 9 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's commodities. Conclusion And Future Work The visualization presented in the graph on the dashboard makes it easy for executives to see information about expenses used based on location used, services used, customers served, tools used and commodities used. With the existence of a cost accounting report in the dashboard, XYZ company can control costs for divisions that are considered unprofitable. So then the company's operational activities can be more effective and efficient. Declarations Availability of data and materials Not applicable Competing interests The authors declare that they have no competing interests Funding The funding of this research was supported by the universities Authors' contributions "FLG provided with the problem analyzing and data collecting as well as processing that initiate the drafting the manuscript. LA performed with testing and some calculations of the experiment result and continuing in writing the manuscript. The TM provide some survey literatures and some administration matters as well as process the payment of the research. All authors read and approved the final manuscript." Acknowledgements Not applicable References Chen, H., Chiang, R. H., & Storey, V. C. 2012. Business Intelligence and Analytics: From Big Data to BigImpact. MIS quarterly, 36(4), 1165-1188. Foshay, Neil & Kuziemsky, Craig. (2013). Towards an implementation framework for business intelligence in healthcare. International Journal of Information Management. 34. 10.1016/j.ijinfomgt.2013.09.003 Power, D.J. 2002, “Decision support systems: Concepts and resources for managers”. United State of America: Green Wood Publishing Group. Majid, M., Zakaria, W., & Lamit, H., 2012, Executive Information Site Management System For Monitoring Project Performance: System Requirement Study, OIDA International Journal of Sustainable Development Meyliana, Widjaja, H., & Santoso, S. W., 2014, University dashboard: An implementation of executive dashboard to university, 2014 2nd International Conference on Information and Communication Technology (ICoICT) Christian, Joko, 2010, Data Warehouse Model with Service Oriented Architecture for Supporting Executive Information Systems, Jurnal Telematika MKom, Jakarta. Taleghani, M., 2011, Executive Information Systems development lifecycle, MSIE Marta, Edy, dkk, 2012, Analysis and Design of Executive Information Systems Case Study at the Cabinet Secretariat. Yogyakarta: SENTIKA. Izhariman, L., 2017, Hospital Executive Information System Design for Service Performance Evaluation at RSUP Mohammad Hoesin Palembang, Semantec Scholar Nurwidyantoro, Arif, dkk, 2013, Executive Information System Design (Case Study at UGM), Yogyakarta: SNATI Cite Share Download PDF Status: Posted Version 1 posted You are reading this latest preprint version Research Square lets you share your work early, gain feedback from the community, and start making changes to your manuscript prior to peer review in a journal. As a division of Research Square Company, we’re committed to making research communication faster, fairer, and more useful. We do this by developing innovative software and high quality services for the global research community. Our growing team is made up of researchers and industry professionals working together to solve the most critical problems facing scientific publishing. Also discoverable on Platform About Our Team In Review Editorial Policies Advisory Board Help Center Resources Author Services Accessibility API Access RSS feed Manage Cookie Preferences © Research Square 2026 | ISSN 2693-5015 (online) Privacy Policy Terms of Service Do Not Sell My Personal Information {"props":{"pageProps":{"initialData":{"identity":"rs-30203","acceptedTermsAndConditions":true,"allowDirectSubmit":true,"archivedVersions":[],"articleType":"Case study","associatedPublications":[],"authors":[{"id":609609,"identity":"329a2436-2fb2-49ae-8397-a79db6510491","order_by":0,"name":"Ford Lumban Gaol","email":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZAAAAAyAQMAAABI0h/eAAAABlBMVEX///8AAABVwtN+AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAvElEQVRIiWNgGAWjYBAC9gYGBokHDDZAJmPjAaK08ACVSSQwpIG0NJCk5TCYQ6QW9t6HNxJ+nbdb234YaEuNTTRhLTzHjS0S+24nbzuTCNRyLC23gZAWe4k0NonEntvJZgeAWhgbDhPWwgPRci7Z7PxDUrQk/DhgZ3aDaFt4jjFbJDYkJ5jdANqSQIxfeNjbGG98+GNnb3Y+/eGDDzU2hLWAAWMbQyJYZQJRysHgD4M98YpHwSgYBaNgxAEAncBHO7jnK7gAAAAASUVORK5CYII=","orcid":"","institution":"Columbia University","correspondingAuthor":true,"prefix":"","firstName":"Ford","middleName":"Lumban","lastName":"Gaol","suffix":""},{"id":609610,"identity":"084dd9ca-37f4-4503-8d60-974ed5c0134b","order_by":1,"name":"Lufty Abdillah","email":"","orcid":"","institution":"Binus Universuty","correspondingAuthor":false,"prefix":"","firstName":"Lufty","middleName":"","lastName":"Abdillah","suffix":""},{"id":609611,"identity":"903dcb20-a72c-4d64-bec7-2d0653f28578","order_by":2,"name":"Tokuro Matsuo","email":"","orcid":"","institution":"Addis Ababa Institute of Technology","correspondingAuthor":false,"prefix":"","firstName":"Tokuro","middleName":"","lastName":"Matsuo","suffix":""}],"badges":[],"createdAt":"2020-05-19 05:46:28","currentVersionCode":1,"declarations":"","doi":"10.21203/rs.3.rs-30203/v1","doiUrl":"https://doi.org/10.21203/rs.3.rs-30203/v1","draftVersion":[],"editorialEvents":[],"editorialNote":"","failedWorkflow":false,"files":[{"id":1198768,"identity":"a9a3e4d2-73e5-4a01-818b-8f089e632481","added_by":"auto","created_at":"2020-05-28 17:46:01","extension":"jpg","order_by":1,"title":"Figure 1","display":"","copyAsset":false,"role":"figure","size":17546,"visible":true,"origin":"","legend":"Executive Information System Lifecycle [7].","description":"","filename":"Fig1.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig1.jpg"},{"id":1198769,"identity":"0cdb5c5f-ed33-4673-a97c-266684e19077","added_by":"auto","created_at":"2020-05-28 17:46:01","extension":"jpg","order_by":2,"title":"Figure 2","display":"","copyAsset":false,"role":"figure","size":13888,"visible":true,"origin":"","legend":"Business Intelligence Data Sources.","description":"","filename":"Fig2.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig2.jpg"},{"id":1198770,"identity":"adbb93f8-876a-48d0-99dc-5817640e59a7","added_by":"auto","created_at":"2020-05-28 17:46:01","extension":"jpg","order_by":3,"title":"Figure 3","display":"","copyAsset":false,"role":"figure","size":46375,"visible":true,"origin":"","legend":"Data Warehouse Schemes.","description":"","filename":"Fig3.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig3.jpg"},{"id":1198771,"identity":"713d5d33-0c30-4e8e-abfd-51a7eb700dad","added_by":"auto","created_at":"2020-05-28 17:46:02","extension":"jpg","order_by":4,"title":"Figure 4","display":"","copyAsset":false,"role":"figure","size":42470,"visible":true,"origin":"","legend":"ETL Process.","description":"","filename":"Fig4.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig4.jpg"},{"id":1198772,"identity":"590da6a6-719c-4491-8e0d-e4ff7750c49b","added_by":"auto","created_at":"2020-05-28 17:46:02","extension":"jpg","order_by":5,"title":"Figure 5","display":"","copyAsset":false,"role":"figure","size":48596,"visible":true,"origin":"","legend":"Cost Accounting Dashboard based on Location.","description":"","filename":"Fig5.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig5.jpg"},{"id":1198773,"identity":"55fb298b-ea85-4322-bd02-8e033e9ac830","added_by":"auto","created_at":"2020-05-28 17:46:02","extension":"jpg","order_by":6,"title":"Figure 6","display":"","copyAsset":false,"role":"figure","size":44884,"visible":true,"origin":"","legend":"Cost Accounting Dashboard based on Services.","description":"","filename":"Fig6.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig6.jpg"},{"id":1198774,"identity":"aeafac8b-4384-4ed7-818e-f11120fb3a49","added_by":"auto","created_at":"2020-05-28 17:46:02","extension":"jpg","order_by":7,"title":"Figure 7","display":"","copyAsset":false,"role":"figure","size":51771,"visible":true,"origin":"","legend":"Cost Accounting Dashboard based on Customers.","description":"","filename":"Fig7.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig7.jpg"},{"id":1198775,"identity":"44a7d8c9-49cc-4120-be80-f12ac30842b4","added_by":"auto","created_at":"2020-05-28 17:46:03","extension":"jpg","order_by":8,"title":"Figure 8","display":"","copyAsset":false,"role":"figure","size":48966,"visible":true,"origin":"","legend":"Cost Accounting Dashboard based on Equipments.","description":"","filename":"Fig8.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig8.jpg"},{"id":1198776,"identity":"d4893a72-03b9-4566-9c83-67eb3ba23526","added_by":"auto","created_at":"2020-05-28 17:46:03","extension":"jpg","order_by":9,"title":"Figure 9","display":"","copyAsset":false,"role":"figure","size":59970,"visible":true,"origin":"","legend":"Cost Accounting Dashboard based on Commodities.","description":"","filename":"Fig9.jpg","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/Fig9.jpg"},{"id":13533213,"identity":"17aa6a6c-19ed-491b-a017-f52635b4cdab","added_by":"auto","created_at":"2021-09-17 01:20:05","extension":"pdf","order_by":0,"title":"","display":"","copyAsset":false,"role":"manuscript-pdf","size":523943,"visible":true,"origin":"","legend":"","description":"","filename":"manuscript.pdf","url":"https://assets-eu.researchsquare.com/files/rs-30203/v1/f295a051-4ac2-451e-abc0-8459291d78e5.pdf"}],"financialInterests":"","formattedTitle":"The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company","fulltext":[{"header":"Introduction","content":" \u003cp\u003eA dynamic business development requires companies to be faster and more careful in every decision making. The wrong action can cause a lack of effectiveness which results in losses received by the company. Because of its importance, many companies are competing to extract information and knowledge from their data. The main objective is to support decisions made based on the results of information and knowledge analysis representing company decisions. One method used is Business Intelligence (BI). BI is defined as one of the data utilization methodologies to produce information to become knowledge in supporting strategic decision making. XYZ is a company engaged in the port sector, where PT XYZ serves terminal loading and unloading services and container buildup. To support the company's business processes, XYZ uses two applications, the CARTOS application to manage invoices and the Finance Application to record company costs and revenues.\u003c/p\u003e \u003cp\u003eBusiness Intelligence is a way to collect, store, organize, reshape, summarize data and provide information, both in the form of company internal business activity data, as well as company external business activity data including business activities of competitors that are easily accessed and analyzed for various management activities [\u003cspan citationid=\"CR1\" class=\"CitationRef\"\u003e1\u003c/span\u003e].\u003c/p\u003e \u003cp\u003eBusiness Intelligence is a series of applications and technologies for collecting, storing, analyzing, and presenting data access to assist company officials in decision making [\u003cspan citationid=\"CR2\" class=\"CitationRef\"\u003e2\u003c/span\u003e].\u003c/p\u003e \u003cp\u003eIn addition, according to DJ Powers, said that Business Intelligence explained about a concept and method of how to improve the quality of business decision making based on data-based systems [\u003cspan citationid=\"CR3\" class=\"CitationRef\"\u003e3\u003c/span\u003e]\u003c/p\u003e \u003cp\u003eFrom the three sources above, it can be concluded that Business Intelligence is the concept of collecting data, storing data and selecting data to provide information to help and improve the quality of business decision making for companies. So it can be said that the information system is a place for data entry, while the business intelligence application is a place for data analysis. Where the concept of business intelligence turns information into new knowledge and understanding for an organization.\u003c/p\u003e \u003cp\u003ePrevious studies that are relevant to this study include research conducted by Muhd ​​Zaimi Abd. Majid, Wan Zahran Zakaria, and Ali Keyvanfar with the research title Executive Information Site Management System for Project Performance Monitoring: System Requirements Study. In this research, it is discussed how to monitor and control the development of a construction project work by utilizing the Executive Information System technology[\u003cspan citationid=\"CR4\" class=\"CitationRef\"\u003e4\u003c/span\u003e]. The study uses the Classic Waterfall Model method in developing the system.\u003c/p\u003e \u003cp\u003eNext is a study conducted by Meyliana, Henry A. E Widjaja, and Stephen W. Santoso with the title of University dashboard research: An implementation of executive dashboard to university[\u003cspan citationid=\"CR5\" class=\"CitationRef\"\u003e5\u003c/span\u003e]. In this research the data warehouse development method uses the Key Performance Indicator approach which is owned by the university.\u003c/p\u003e \u003cp\u003eBased on research conducted by Mohammad Taleghani with the title Executive Information Systems development lifecycle explained the concepts and architecture in the development of EIS [\u003cspan citationid=\"CR6\" class=\"CitationRef\"\u003e6\u003c/span\u003e]. Also explained what criteria support in evaluating an EIS so as to produce an EIS that suits user needs.\u003c/p\u003e \u003cp\u003eBased on research conducted by Joko Christian by using a data warehouse development method using a business life cycle approach and using the functionality testing of the prototype in the form of white box testing as feedback from the user [\u003cspan citationid=\"CR7\" class=\"CitationRef\"\u003e7\u003c/span\u003e]. This research uses a web service system as an intermediary between the data warehouse and the applications used and the research produces a model that cannot be implemented yet.\u003c/p\u003e \u003cp\u003eLutfi Izhariman, Eko Darwiyanto and Shinta Yulia Puspitasari conducted research under the title Design of Hospital Executive Information System for Evaluating Service Performance at Mohammad Hoesin Hospital Palembang [\u003cspan citationid=\"CR8\" class=\"CitationRef\"\u003e8\u003c/span\u003e]. In this study, it was discussed how to design an Executive Information System (EIS) that can support the processing of patient medical record data to display information on medical service indicators. The EIS design requires a data warehouse through the ETL (extract, transform, load) process in hospital operational data and displays the results of data analysis using OLAP (Online Analytical Processing) technique.\u003c/p\u003e \u003cp\u003eEdy Martha, et al, also conducted research using the EIS system life cycle engineering methods and built a system model with the help of UML [\u003cspan citationid=\"CR9\" class=\"CitationRef\"\u003e9\u003c/span\u003e]. His research resulted in a web-based executive information system application to process data at the Cabinet Secretariat.\u003c/p\u003e \u003cp\u003eResearch conducted by Arif N, et al, using the EIS life cycle development method with primary data contained in the data warehouse is processed so that it becomes a form that can be analyzed by OLAP Server and uses a dashboard application to perform and view the results of the analysis [\u003cspan citationid=\"CR10\" class=\"CitationRef\"\u003e10\u003c/span\u003e]. The results of his research are in the form of a model design in building an executive information system at UGM that can show conditions in an organization in the form of a graphical display on the dashboard, so that it can be used as a material for university executive level consideration for decision making.\u003c/p\u003e \u003cp\u003eThis research will produce the design and results of the implementation of executive information systems in accordance with the needs of PT XYZ. This research will use the EIS Lifecycle development method in which there are 6 stages of development namely justification, planning, business analysis, design, construction and deployment. The data to be used in this application is sample data from XYZ that is pulled from the XYZ operational system.\u003c/p\u003e \u003cdiv id=\"Sec2\" class=\"Section2\"\u003e \u003ch2\u003eCase Description\u003c/h2\u003e \u003cp\u003eIn the case of XYZ, currently to process data and visualize the data to be a cost accounting report is still done manually using the Microsoft Excel application. Based on the results of interviews with management, there are several issues related to the process, including :\u003c/p\u003e \u003cp\u003e \u003col\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eData obtained from the supporting application outputs mentioned earlier are still in the form of raw data and take time to process data into information.\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eData that can be stored and processed in Microsoft Excel is limited so that the monitoring and view of historical data is still not optimal.\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eThe process of reporting cost accounting reports to management cannot be done in real time.\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003c/ol\u003e \u003c/p\u003e \u003cp\u003ePT XYZ requires a BI application that provides monitoring information related to profit and loss per project to improve management effectiveness and efficiency in strategic decision making. Therefore, the development of BI applications can be a solution to assist managers in monitoring business processes, specifically related to profit and loss per project. Development includes the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard.\u003c/p\u003e \u003c/div\u003e"},{"header":"Method And Simulation","content":" \u003cp\u003eIn the development of executive information systems there are methods that can be used, namely the method of executive information system lifecycle. According to Taleghani, EIS life cycle is divided into 6 stages from justification to deployment [\u003cspan citationid=\"CR7\" class=\"CitationRef\"\u003e7\u003c/span\u003e]. In these six stages there are other stages. A description of the stages of the EIS Lifecycle can be seen in the following explanation.\u003c/p\u003e \u003cp\u003e \u003c/p\u003e \u003cdiv id=\"Sec4\" class=\"Section3\"\u003e \u003ch2\u003eJustification\u003c/h2\u003e \u003cp\u003eIn this stage, consideration is given to developing an EIS, at this stage consideration is given of business opportunities and business needs, as well as consideration of the development of an EIS with costs incurred with the benefits obtained, both business benefits or strategic benefits as decision aides.\u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec5\" class=\"Section3\"\u003e \u003ch2\u003ePlanning\u003c/h2\u003e \u003cp\u003eIn this stage there are two activities carried out, namely:\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eEnterprise Infrastructure Evaluation\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eAt this stage an organizational infrastructure is identified. We can carry out technical evaluation of infrastructure such as; hardware, networks, middleware, database management systems and tools.\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eProject Planning\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eIn this stage project management activities are carried out, project management is carried out so that the EIS development is carried out in accordance with the specified targets. Some basic activities in project management, namely determining the time of completion of the project, the costs required and determining who is working on the EIS development project.\u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec6\" class=\"Section3\"\u003e \u003ch2\u003e Business Analysis\u003c/h2\u003e \u003cp\u003eIn this stage there are four activities carried out, namely:\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eProject Requirement Definition\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eIn this stage we define what needs are needed. There are several ways to identify needs, namely by conducting internal meetings with executives, interviewing EIS developers with executives and conducting literature studies.\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eData analysis\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003c/div\u003e \u003cp\u003eData analysis focuses on identifying data sources, logic designs (ER-diagrams) and identifying attributes.\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eApplication Prototyping\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003ePrototype is built to be validated in accordance with specified business requirements. The results of the validation of the prototype were evaluated and their shortcomings were corrected\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eMetadata Analysis\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eMetadata is processed in the design and data sources are mapped to the metadata structure.\u003c/p\u003e \u003cdiv id=\"Sec8\" class=\"Section3\"\u003e \u003ch2\u003e Design\u003c/h2\u003e \u003cp\u003eIn this stage there are two activities carried out, namely:\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eDatabase Design\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eActivities carried out at this stage are designing logical models. Data model for processing and as data storage. Database development for EIS is different from building a database for operational systems, here are some considerations in building an EIS database, namely:\u003c/p\u003e \u003cp\u003e \u003col\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eThe purpose of the EIS database is designed to be simplified, high-performance data retrieval rather than for effectiveness and maintenance as in database operations.\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eReducing or minimizing data redundancy or data duplication is not the target of designing the EIS database.\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003c/ol\u003e \u003c/p\u003e \u003cp\u003eMultidimensional database design supports fast data retrieval over large data ranges. Two well-known multidimensional database design techniques are the star schema and the snowflake schema.\u003c/p\u003e \u003cp\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eExtract Transform Load (ETL)\u003c/p\u003e \u003c/li\u003e \u003c/ul\u003e \u003c/p\u003e \u003cp\u003eDesign ETL design is important in the development of EIS, ETL functions as extracting data from other databases or operational systems, Performing data cleaning and loading data into the EIS database. ETL is designed to solve problems that exist in data sources, namely primary key inconsistencies, data inconsistencies, format differences, inaccurate data and data synonyms / homonyms.\u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec9\" class=\"Section3\"\u003e \u003ch2\u003e Construction\u003c/h2\u003e \u003cp\u003eThis stage is the stage of design realization in accordance with the previous design stages.\u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec10\" class=\"Section3\"\u003e \u003ch2\u003e Deployment\u003c/h2\u003e \u003cp\u003eAt this stage, the implementation of all the series of stages that have been carried out previously will be carried out by testing the application system to the end user whether it meets the needs, so that it can fulfill all the information needed.\u003c/p\u003e \u003c/div\u003e "},{"header":"Discussion And Evaluation","content":" \u003cp\u003eIn accordance with the formulation of the problems discussed in case description, XYZ has a need for a system that can help provide financial accounting based on cost accounting. With the cost accounting based financial statements, it can help XYZ managers in determining the cost of production, controlling costs and supporting decision making.\u003c/p\u003e \u003cp\u003eOne solution that can be done for the above needs is the adoption of the BI system. BI can be one of the tools to produce cost accounting reports in the form of a dashboard. Through this research it is expected to provide the best solution for XYZ according to their needs.\u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec12\" class=\"Section3\"\u003e \u003ch2\u003eProject Requirement Definition and Data Analysis\u003c/h2\u003e \u003cp\u003eInformation needs analysis is done with observe things that are needed at XYZ Company. Then conduct interviews and field observations. Based on the results of these methods, the information needs to be used to develop the BI model in XYZ companies include:\u003c/p\u003e \u003cp\u003e \u003col\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eBusiness segmentation information based on location\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eBusiness segmentation information based on services\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eBusiness segmentation information based on customer\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eBusiness segmentation information based on equipment\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003cspan\u003e \u003cli\u003e \u003cp\u003eBusiness segmentation information based on commodity\u003c/p\u003e \u003c/li\u003e \u003c/span\u003e \u003c/ol\u003e \u003c/p\u003e \u003cp\u003eData sources that will be used are operational data from the Oracle EBS application and CARTOS application used by XYZ companies in carrying out company operational activities.\u003c/p\u003e \u003cp\u003e \u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec13\" class=\"Section3\"\u003e \u003ch2\u003eDatabase Design\u003c/h2\u003e \u003cp\u003eBased on the development of the method already described, the data warehouse modeling made is as follows such as Fig.\u0026nbsp;\u003cspan refid=\"Fig3\" class=\"InternalRef\"\u003e3\u003c/span\u003e.\u003c/p\u003e \u003cp\u003e \u003c/p\u003e \u003c/div\u003e \u003cdiv id=\"Sec14\" class=\"Section3\"\u003e \u003ch2\u003eExtract, Transform, Loading (ETL) Process\u003c/h2\u003e \u003cp\u003eETL process is a process to move data from a database source (OLTP) into a data warehouse (OLAP). This ETL process uses the Pentaho Data Integration spoon application. Data warehouse stores data that is used to produce the information needed. The ETL process in this study uses the Pentaho Data Integration (PDI) tool. In PDI there are several icons used in the ETL process. The ETL process is carried out on 6 dimension tables and 1 fact table. One example of these ETLs can be seen in Fig.\u0026nbsp;\u003cspan refid=\"Fig4\" class=\"InternalRef\"\u003e4\u003c/span\u003e below.\u003c/p\u003e \u003cp\u003e \u003c/p\u003e \u003c/div\u003e \u003c/div\u003e \u003cdiv id=\"Sec15\" class=\"Section2\"\u003e \u003ch2\u003eApplication Of Microsoft Power BI\u003c/h2\u003e \u003cp\u003eMicrosoft Power BI desktop is an analytic application for analyzing data. Microsoft Power BI can also be called a visualization tool used to represent data in a data warehouse. Before visualizing the data, the first step taken is to retrieve data from the data source by selecting get data on the initial display when opening the application. After that, a dialog box will appear to select the data source to be used. There are 5 types of data that can be used, namely files, databases, Azure, online services, and others. In this study the data source used is an Oracle database. The visualizations used for developing the Business Intelligence model in this study are graphics and text. Visualization results are described in the form of a dashboard. Figure\u0026nbsp;\u003cspan refid=\"Fig5\" class=\"InternalRef\"\u003e5\u003c/span\u003e contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's location.\u003c/p\u003e \n\u003cp\u003eFigure 6 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's services.\u003c/p\u003e\n\u003cp\u003eFigure 7 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's customers.\u003c/p\u003e\u003cp\u003eFigure 8 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's equipments. \u003c/p\u003e\n\u003cp\u003eFigure 9 contains information on the composition of the company's revenue, costs, and profit and loss seen from the perspective of the company's commodities.\u003c/p\u003e"},{"header":"Conclusion And Future Work","content":"\u003cp\u003eThe visualization presented in the graph on the dashboard makes it easy for executives to see information about expenses used based on location used, services used, customers served, tools used and commodities used. With the existence of a cost accounting report in the dashboard, XYZ company can control costs for divisions that are considered unprofitable. So then the company's operational activities can be more effective and efficient.\u003c/p\u003e "},{"header":"Declarations","content":" \u003cp\u003e \u003ch2\u003eAvailability of data and materials\u003c/h2\u003e \u003cp\u003eNot applicable\u003c/p\u003e \u003c/p\u003e \u003ch2\u003eCompeting interests\u003c/h2\u003e \u003cp\u003eThe authors declare that they have no competing interests\u003c/p\u003e \u003c/p\u003e \u003ch2\u003eFunding\u003c/h2\u003e \u003cp\u003eThe funding of this research was supported by the universities\u003c/p\u003e \u003ch2\u003eAuthors' contributions\u003c/h2\u003e\n\u003cp\u003e\"FLG\u0026nbsp; provided with the problem analyzing and data collecting as well as processing that initiate the drafting the manuscript. LA \u0026nbsp;performed with \u0026nbsp;testing and some calculations of the experiment result and continuing in writing the manuscript. The TM \u0026nbsp;provide some survey literatures and some administration matters as well as process the payment of the\u0026nbsp; research. \u0026nbsp;All authors read and approved the final manuscript.\"\u003c/p\u003e\u003ch2\u003eAcknowledgements\u003c/h2\u003e \u003cp\u003eNot applicable\u003c/p\u003e "},{"header":"References","content":"\u003col\u003e\n\u003cli\u003eChen, H., Chiang, R. H., \u0026amp; Storey, V. C. 2012. Business Intelligence and Analytics: From Big Data to BigImpact. MIS quarterly, 36(4), 1165-1188.\u003c/li\u003e\n\u003cli\u003eFoshay, Neil \u0026amp; Kuziemsky, Craig. (2013). Towards an implementation framework for business intelligence in healthcare. International Journal of Information Management. 34. 10.1016/j.ijinfomgt.2013.09.003\u003c/li\u003e\n\u003cli\u003ePower, D.J. 2002, \u0026ldquo;Decision support systems: Concepts and resources for managers\u0026rdquo;. United State of America: Green Wood Publishing Group.\u003c/li\u003e\n\u003cli\u003eMajid, M., Zakaria, W., \u0026amp; Lamit, H., 2012, Executive Information Site Management System For Monitoring Project Performance: System Requirement Study, OIDA International Journal of Sustainable Development\u003c/li\u003e\n\u003cli\u003eMeyliana, Widjaja, H., \u0026amp; Santoso, S. W., 2014, University dashboard: An implementation of executive dashboard to university, 2014 2nd International Conference on Information and Communication Technology (ICoICT)\u003c/li\u003e\n\u003cli\u003eChristian, Joko, 2010, Data Warehouse Model with Service Oriented Architecture for Supporting Executive Information Systems, Jurnal Telematika MKom, Jakarta.\u003c/li\u003e\n\u003cli\u003eTaleghani, M., 2011, Executive Information Systems development lifecycle, MSIE\u003c/li\u003e\n\u003cli\u003eMarta, Edy, dkk, 2012, Analysis and Design of Executive Information Systems Case Study at the Cabinet Secretariat. Yogyakarta: SENTIKA.\u003c/li\u003e\n\u003cli\u003eIzhariman, L., 2017, Hospital Executive Information System Design for Service Performance Evaluation at RSUP Mohammad Hoesin Palembang, Semantec Scholar\u003c/li\u003e\n\u003cli\u003eNurwidyantoro, Arif, dkk, 2013, Executive Information System Design (Case Study at UGM), Yogyakarta: SNATI\u003c/li\u003e\n\u003c/ol\u003e"}],"fulltextSource":"","fullText":"","funders":[],"hasAdminPriorityOnWorkflow":false,"hasManuscriptDocX":true,"hasOptedInToPreprint":true,"hasPassedJournalQc":"","hasAnyPriority":false,"hideJournal":true,"highlight":"","institution":"","isAcceptedByJournal":false,"isAuthorSuppliedPdf":false,"isDeskRejected":"","isHiddenFromSearch":false,"isInQc":false,"isInWorkflow":false,"isPdf":false,"isPdfUpToDate":true,"isWithdrawnOrRetracted":false,"journal":{"display":true,"email":"[email protected]","identity":"researchsquare","isNatureJournal":false,"hasQc":true,"allowDirectSubmit":true,"externalIdentity":"","sideBox":"","snPcode":"","submissionUrl":"/submission","title":"Research Square","twitterHandle":"researchsquare","acdcEnabled":true,"dfaEnabled":false,"editorialSystem":"","reportingPortfolio":"","inReviewEnabled":false,"inReviewRevisionsEnabled":true},"keywords":"Business Intelligence, Data Warehouse, Dashboard, Cost Accounting, Financial Report","lastPublishedDoi":"10.21203/rs.3.rs-30203/v1","lastPublishedDoiUrl":"https://doi.org/10.21203/rs.3.rs-30203/v1","license":{"name":"CC BY 4.0","url":"https://creativecommons.org/licenses/by/4.0/"},"manuscriptAbstract":"\u003cp\u003eIntroduction: XYZ is a company engaged in the port sector. XYZ is engaged in the business of loading and unloading terminal services and container buildup. To support the company's business processes. \u003c/p\u003e\u003cp\u003eCase Description: XYZ uses two applications in carrying out operational activities, namely the CARTOS application to manage bills and the Finance application to record company costs and revenues. To produce a cost accounting report, PT XYZ is still processing and visualizing it manually using Microsoft Excel applications with data sources from the two applications previously mentioned. There are problems related to the process, where the processing time to process data into information is quite long. So that reporting to management cannot be done in real time. \u003c/p\u003e\u003cp\u003eDiscussion and Evaluation: The development of business competition is very rapid, the management of XYZ must be able to make decisions quickly and accurately, so company needs tools that can help the management to analyze and manage data into information in real time. The Business Intelligence (BI) method is one of the solutions to the company's needs, especially in analyzing and providing access to data to help make better decisions. \u003c/p\u003e\u003cp\u003eConclusion: This study discusses the design and implementation of business intelligence solutions ranging from architecture, data warehouse, ETL processes and visualization in the form of a dashboard in accordance with the needs of PT XYZ. The method used in developing the business intelligence dashboard refers to the executive information system lifecycle method which consists of justification, planning, business analysis, design, construction and deployment. The results of this research are dashboard visualization using Power BI tools that display information and knowledge needed in the monitoring process and become material for generating management decisions related to cost accounting reports. \u003c/p\u003e","manuscriptTitle":"The Implementation of Business Intelligence on Cost Accounting – Case Study of XYZ Company","msid":"","msnumber":"","nonDraftVersions":[{"code":1,"date":"2020-05-28 17:37:08","doi":"10.21203/rs.3.rs-30203/v1","editorialEvents":[{"type":"communityComments","content":0}],"status":"published","journal":{"display":true,"email":"[email protected]","identity":"researchsquare","isNatureJournal":false,"hasQc":true,"allowDirectSubmit":true,"externalIdentity":"","sideBox":"","snPcode":"","submissionUrl":"/submission","title":"Research Square","twitterHandle":"researchsquare","acdcEnabled":true,"dfaEnabled":false,"editorialSystem":"","reportingPortfolio":"","inReviewEnabled":false,"inReviewRevisionsEnabled":true}}],"origin":"","ownerIdentity":"2ef18566-f903-467e-84b3-67d6e640c1ca","owner":[],"postedDate":"May 28th, 2020","published":true,"recentEditorialEvents":[],"rejectedJournal":[],"revision":"","amendment":"","status":"posted","subjectAreas":[{"id":108332,"name":"Business Law"}],"tags":[],"updatedAt":"2020-06-28T14:22:58+00:00","versionOfRecord":[],"versionCreatedAt":"2020-05-28 17:37:08","video":"","vorDoi":"","vorDoiUrl":"","workflowStages":[]},"version":"v1","identity":"rs-30203","journalConfig":"researchsquare"},"__N_SSP":true},"page":"/article/[identity]/[[...version]]","query":{"redirect":"/article/rs-30203","identity":"rs-30203","version":["v1"]},"buildId":"2u56kwukJI3zHK-uzyFNs","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[84888],"gssp":true,"scriptLoader":[]}