WEBVTT

1
00:00:00.000 --> 00:00:01.791
ROLAP vs. OLAP.

2
00:00:03.417 --> 00:00:08.881
What is OLAP? OLAP is multi-dimensional technology with data aggregation, the ability 

3
00:00:08.882 --> 00:00:14.346
to drill down across and through being able to slice and dice the information with consistent retrieval times.

4
00:00:15.992 --> 00:00:24.399
Normal limitations that people perceive are: time to load, calc and rebuild the cube environment, the ability to have

5
00:00:25.672 --> 00:00:33.756
lots of detail within the environment, as well as possible risks regarding data synchronization issues across multiple cube environment.

6
00:00:35.657 --> 00:00:42.063
ROLAP is OLAP in on a relational back-end technology instead of cube or proprietary technology

7
00:00:42.064 --> 00:00:48.469
performing calculations on the fly and presenting those to the end user.

8
00:00:50.495 --> 00:00:55.723
While there's many advantages to ROLAP the significant ones are one version of the truth with one 

9
00:00:55.724 --> 00:01:00.952
central data repository leveraging existing technology for internal IT support.

10
00:01:03.002 --> 00:01:12.863
The disadvantages that are normally perceived with ROLAP are 3: data retrieval time, calculation complexity support and storage capability.

11
00:01:14.600 --> 00:01:24.272
Now CCH Tagetik leverages ROLAP technology for many various reasons. But CCH Tagetik has also overcome many of the disadvantages 

12
00:01:24.273 --> 00:01:33.946
through its flexible architecture, the circumventing data retrieval key issues with its built-in calculation tool to be able to handle

13
00:01:33.947 --> 00:01:43.620
complex calculation requirements, as well as its built-in archiving for storage concerns. So, here we will see an example of this, where we have a dashboard 

14
00:01:43.621 --> 00:01:53.294
and the user wants to interact with this and create an aggregation point on the fly that may not exist within the cube environment,.

15
00:01:53.295 --> 00:02:05.910
With CCH Tagetik the user simply has to select these areas, ask the tool to refresh the data and get on the fly near real-time performance.

16
00:02:07.990 --> 00:02:16.483
So what does this mean for CCH Tagetik users and customers? That they get an enterprise performance system that leverages

18
00:02:16.484 --> 00:02:24.977
ROLAP technology and does not require data movement synchronization and maintenance that traditional cube solutions need. 

19
00:02:26.442 --> 00:02:30.843
Truly a solution that is meant to be maintained and operated by Finance professionals.