Admin. Spreadsheet Templates. March 19th , 2018.
OLAP is really a technology that may be given to many users using a number of platforms. As theres just one store of information held inside the OLAP Cube, information and data could be utilized by many people users concurrently no matter their whereabouts.
Contrast this using the situation if spreadsheets were utilised they are driving this model. It wouldnt be easy to consider each one of these dimensions concurrently. Probably, the information will come in like a hierarchy of linked spreadsheets with every greater level consolidating and summarizing the data within the lower level spreadsheets. The sheets lower lower within the hierarchy would store information of smaller sized geographic regions as the greater level spreadsheets would contain consolidated information of bigger and bigger regions before the top spreadsheet would consolidate and summarize the entire data for the entire region where the organization was operating.
How come Spreadsheets used? Basically, because they may be. Finance professionals with hardly any understanding laptop or computer software development, programming or application design can develop complex models you can use to handle the finance function. Also, spreadsheets are broadly used and available inside the enterprise many information users get access to and understanding of using spreadsheets.
Archiving - Poor archiving can result in weaknesses in spreadsheet control that lead to operational risk.
Any content, trademark/s, or other material that might be found on this site that is not this site property remains the copyright of its respective owner/s. In no way does Eklo Templates claim ownership or responsibility for such items, and you should seek legal consent for any use of such materials from its owner.