Reflecting Reporting Problems and Data Warehousing

2011 ◽  
pp. 1682-1688
Author(s):  
Juha Kontio
Keyword(s):  
Applied Sciences ◽  
Information Systems ◽  
Data Warehouse ◽  
Case Study Research ◽  
Resource Planning ◽  
The Other ◽  
Structured Interviews ◽  
Other Hand ◽  
University Of Applied Sciences ◽  
Operational Information

Reporting is one of the basic processes in all organizations. Reports should offer relevant information for guiding the decision-making. Reporting provides information for planning and on the other hand it provides information for analyzing the correctness of the decisions made at the beginning of the processes. Reporting is based on the data the operational information systems contain. Reports can be produced directly from these operational databases, but an operational database is not organized in a way that naturally supports analysis. An alternative way is to organize the data in such a way that supports analysis easily. Typically this leads to the introduction of a data warehouse. In summer 2002 a multiple case study research was launched in six Finnish organizations. The research studied the databases of these organizations and identified the trends in database exploitation. One of the main ideas was to study the diffusion of database innovations. In practice this meant that the present database architecture was described and the future plans and present problems were identified. The data was mainly collected with semi-structured interviews and altogether 54 interviews were arranged. The research processed data of 44 different information systems. Most (40 %) of the analyzed information systems were online transaction processing systems like order-entry systems. Second biggest category (30 %) was information systems relating to decision support and reporting. Only one pilot data warehouse was among these, but on the other hand customized reporting systems was used for example in SOK, SSP and OPTI. Reporting was anyway commonly recognized as an area where interviewees were not satisfied and improvements were hoped. Turku University of Applied Sciences is one of the largest of its kind in Finland with almost 9000 students and 33 Degree Programs. Our University is organized in six units of education that promote multidisciplinary learning. In autumn 2005 an enterprise resource planning system was introduced at Turku University of Applied Sciences. At the heart of this information system is a data warehouse collecting necessary information from the operational databases. This paper concentrates on briefly describing the identified problems in reporting in the earlier research and how a data warehouse might help overcoming these problems (a more thorough description is provided at (Kontio 2005)). These ideas are benchmarked with usage experiences of the data warehouse based ERP at Turku University of Applied Sciences resulting to some generalizations and confirmation.

Data Warehousing Solutions for Reporting Problems

2008 ◽  
pp. 429-436
Author(s):  
Juha Kontio
Keyword(s):  
Decision Making ◽  
Information Systems ◽  
Data Warehouse ◽  
Data Warehousing ◽  
The Other ◽  
Other Hand ◽  
Operational Information

Reporting is one of the basic processes in all organizations. It provides information for planning and decision making and, on the other hand, information for analyzing the correctness of the decisions made at the beginning of the process. Reporting is based on the data that the operational information systems contain. Reports can be produced directly from these operational databases, but an operational database is not organized in a way that naturally supports analysis. An alternative way is to organize the data in such a way that supports analysis easily. Typically, this method leads to the introduction of a data warehouse.

Data Warehousing Solutions for Reporting Problems

2011 ◽  
pp. 334-338 ◽  
Author(s):  
Juha Kontio
Keyword(s):  
Decision Making ◽  
Information Systems ◽  
Data Warehouse ◽  
Data Warehousing ◽  
The Other ◽  
Other Hand ◽  
Operational Information

Reporting is one of the basic processes in all organizations. It provides information for planning and decision making and, on the other hand, information for analyzing the correctness of the decisions made at the beginning of the process. Reporting is based on the data that the operational information systems contain. Reports can be produced directly from these operational databases, but an operational database is not organized in a way that naturally supports analysis. An alternative way is to organize the data in such a way that supports analysis easily. Typically, this method leads to the introduction of a data warehouse.

Computer Viruses and Their Role in Accounting Information Systems

2016 ◽  
Vol 4 (1) ◽  
Author(s):  
Ali Shirzad ◽  
Shaban Mohammadi ◽  
Hamedesmaeili Oghaz
Keyword(s):  
Information Systems ◽  
Accounting Information ◽  
Financial Information ◽  
The Other ◽  
Accounting Information Systems ◽  
Computer Viruses ◽  
Other Hand ◽  
Main Factors

Dependence on information and rapidly changing technology can be seen in many organizations, with proper security and intelligence systems to protect themselves. But success in providing security depends on the awareness of managers and employees. The accounting information systems in organizations are the most important element. One of the factors threatening their system is virus. Malware are computer viruses that can cause a variety of disorders, including loss of data and accounting information systems are impaired in such case. On the other hand, one of the main objectives of the viruses is to steal financial information. In this paper, one of the main factors threatening the security of accounting information systems, the viruses are described.

scholarly journals Blockchain, Enterprise Resource Planning (ERP) and Accounting Information Systems (AIS): Research on e-Procurement and System Integration

2021 ◽  
Vol 11 (15) ◽  
pp. 6792
Author(s):  
Alessio Faccia ◽  
Pythagoras Petratos
Keyword(s):  
Information Systems ◽  
Enterprise Resource Planning ◽  
System Integration ◽  
Case Study Research ◽  
Accounting Information ◽  
Resource Planning ◽  
Security And Privacy ◽  
Accounting Information Systems ◽  
Erp System

Accounting information systems (AISs), the core module of any enterprise resource planning (ERP) system, are usually designed as centralised systems. Nowadays, the continuous development and applications of blockchain, or more broadly—distributed ledger technology (DLT), can change the architecture, overcome and improve some limitations of centralised systems, most notably security and privacy. An increasing number of authors are suggesting the application of blockchain technologies in management, accounting and ERPs. This paper aims to examine the emerging literature on this field, and an immediate result is that blockchain applications can have significant benefits. The paper’s innovative contribution and considerable objective are to examine if blockchain can be successfully integrated with AIS and ERPs. We find that blockchain can facilitate integration at multiple levels and better serve various purposes as auditing compliance. To demonstrate that, we analyse e-procurement systems and operations using case study research methodology. The findings suggest that DLT, decentralised finance (DeFI), and financial technology (FinTech) applications can facilitate integrating AISs and ERP systems and yield significant benefits for efficiency, productivity and security.

Promoting Success in the Introduction of Health Information Systems

2012 ◽  
pp. 631-641
Author(s):  
Paulo Teixeira ◽  
Patrícia Leite Brandão ◽  
Álvaro Rocha
Keyword(s):  
Organizational Culture ◽  
Information Systems ◽  
Literature Review ◽  
Human Resources ◽  
Health Information ◽  
Health Information Systems ◽  
The Other ◽  
Other Hand ◽  
Number Of Publications

The significant number of publications describing unsuccessful cases in the introduction of health information systems makes it advisable to analyze the factors that may be contributing to such failures. However, the very notion of success is not equally assumed in all publications. Based in a literature review, the authors argue that the introduction of systems must be based in an eclectic combination of knowledge fields, adopting methodologies that strengthen the role of organizational culture and human resources in this project, as a whole. On the other hand, the authors argue that the introduction of systems should be oriented by a previously defined matrix of factors, against which the success can be measured.

Accumulation and Integration in Seamless Knowledge

2012 ◽  
Vol 3 (2) ◽  
pp. 1-9 ◽  
Author(s):  
Shigeki Sugiyama ◽  
Junji Suzuki
Keyword(s):  
Information Systems ◽  
The Other ◽  
Information Goods ◽  
Other Hand ◽  
The World ◽  
Communication Methods

Society is in the era of globalization. Communication methods include transfers among commodities, facilities, information, systems, thought, knowledge, etc., causing many interactions among society. As a result of these situations, an individual’s world can be altered, causing multi dipoles. Currently, an individual is able to get as much information as he or she desires. But on the other hand, individuals are also losing information, goods, foods, etc., without recognizing how much is lost. The authors believe under these situations almost everything in the world may be interfering with one another in a multitude of ways. This phenomenon will aggressively continue. This paper studies the problems caused by these situations and proposes a method to resolve some of the problems caused by these situations: Accumulation and Integration in Seamless Knowledge.

Analyses and Evaluation of Responses to Slowly Changing Dimensions in Data Warehouses

2011 ◽  
pp. 324-337
Author(s):  
Lars Frank ◽  
Christian Frank
Keyword(s):  
Data Warehouse ◽  
Concurrency Control ◽  
The Other ◽  
Data Warehouses ◽  
Other Hand ◽  
Star Schema ◽  
Dynamic Dimension ◽  
Special Case

A Star Schema Data Warehouse looks like a star with a central, so-called fact table, in the middle, surrounded by so-called dimension tables with one-to-many relationships to the central fact table. Dimensions are defined as dynamic or slowly changing if the attributes or relationships of a dimension can be updated. Aggregations of fact data to the level of the related dynamic dimensions might be misleading if the fact data are aggregated without considering the changes of the dimensions. In this chapter, we will first prove that the problems of SCD (Slowly Changing Dimensions) in a datawarehouse may be viewed as a special case of the read skew anomaly that may occur when different transactions access and update records without concurrency control. That is, we prove that aggregating fact data to the levels of a dynamic dimension should not make sense. On the other hand, we will also illustrate, by examples, that in some situations it does make sense that fact data is aggregated to the levels of a dynamic dimension. That is, it is the semantics of the data that determine whether historical dimension data should be preserved or destroyed. Even worse, we also illustrate that for some applications, we need a history preserving response, while for other applications at the same time need a history destroying response. Kimball et al., (2002), have described three classic solutions/responses to handling the aggregation problems caused by slowly changing dimensions. In this chapter, we will describe and evaluate four more responses of which one are new. This is important because all the responses have very different properties, and it is not possible to select a best solution without knowing the semantics of the data.

The Challenge of Transdisciplinarity in Information Systems Research

2009 ◽  
pp. 88-102 ◽  
Author(s):  
João Porto de Albuquerque ◽  
Edouard J. Simon ◽  
Jan-Hendrik Wahoff ◽  
Arno Rolf
Keyword(s):  
Information Systems ◽  
The Other ◽  
Mutual Understanding ◽  
Common Language ◽  
Academic Field ◽  
Is Research ◽  
Systems Research ◽  
Other Hand ◽  
Information Systems Research ◽  
Scientific Results

Research in the Information Systems (IS) field has been characterised by the use of a variety of methods and theoretical underpinnings. This fact recently raised concerns about the rigour of scientific results of IS research and about the legitimacy of the IS academic field. On the other hand, a number of IS researchers have argued for a view that values diversity as a strength of the IS field. This chapter supports this viewpoint and analyzes the relation between IS research and concepts originating from theoretical debates around transdisciplinarity. We present results from a group of researchers of various disciplinary backgrounds towards an integrative platform for the orientation of transdisciplinary IS research. The Mikropolis platform provides researchers with a common language, allowing the integration of different perspectives through exchange of experiences and mutual understanding. We also discuss some practical issues that arise from the transdisciplinary cooperation in IS research.

scholarly journals Favouritism: Exploring the ‘uncontrolled’ spaces of the leadership experience

Leadership ◽  
2018 ◽  
Vol 15 (3) ◽  
pp. 381-397 ◽  
Author(s):  
Ofelia A Palermo ◽  
Ana Catarina Carnaz ◽  
Henrique Duarte
Keyword(s):  
Ethical Issues ◽  
Social Process ◽  
The Other ◽  
Structured Interviews ◽  
Organisational Justice ◽  
Other Hand ◽  
The Social ◽  
Leadership Experience ◽  
The One ◽  
The Way

In this paper, we argue that a focus on favouritism magnifies a central ethical ambiguity in leadership, both conceptually and in practice. The social process of favouritism can even go unnoticed, or misrecognised if it does not manifest in a form in which it can be either included or excluded from what is (collectively interpreted as) leadership. The leadership literature presents a tension between what is an embodied and relational account of the ethical, on the one hand, and a more dispassionate organisational ‘justice’ emphasis, on the other hand. We conducted 23 semi-structured interviews in eight consultancy companies, four multinationals and four internationals. There were ethical issues at play in the way interviewees thought about favouritism in leadership episodes. This emerged in the fact that they were concerned with visibility and conduct before engaging in favouritism. Our findings illustrate a bricolage of ethical justifications for favouritism, namely utilitarian, justice, and relational. Such findings suggest the ethical ambiguity that lies at the heart of leadership as a concept and a practice.

scholarly journals Drivers and barriers of reverse logistics practices: A study of large grocery retailers in South Africa

2017 ◽  
Vol 11 ◽  
Author(s):  
Arno Meyer ◽  
Wesley Niemann ◽  
Justin Mackenzie ◽  
Jacques Lombaard
Keyword(s):  
Information Systems ◽  
Enterprise Resource Planning ◽  
Reverse Logistics ◽  
Reverse Flow ◽  
Resource Planning ◽  
Cost Driver ◽  
Structured Interviews ◽  
Lack Of Information ◽  
Generic Qualitative ◽  
Internal Barriers

Background: Reverse logistics (RL) practices have previously been viewed as a cost drain, but have received greater attention from practitioners because of increasing competition and dwindling margins.Purpose: The purpose of this generic qualitative study was to uncover the main internal and external drivers and barriers of RL within major South African grocery retailers.Method: Eleven face-to-face, semi-structured interviews and one telephonic interview were conducted with participants from four large grocery retailers.Findings: Optimising profitability and cost reduction goals are the identified internal drivers, whereas the main external driver was to reduce the organisations’ environmental impact. A lack of information systems – such as enterprise resource planning systems or warehouse management system software – and infrastructure were revealed as the main internal barriers for organisations’ RL practices, whereas supplier non-compliance and transportation inefficiencies were the main external barriers exposed.Managerial implications: In order to optimise the efficiency of the reverse flow, managers are recommended to devote more capital to RL infrastructure, develop policies to manage supplier behaviour, focus on RL as a revenue generating stream as well as implement information systems to manage the entire reverse flow.Conclusion: All participating grocery retailers follow similar RL processes. Growth in RL practices as well as infrastructure to perform those practices is a future priority for all the reviewed grocery retailers. RL is no longer only a key cost driver, but also provides organisations with many additional opportunities.

Sign in / Sign up

Export Citation Format

Share Document