WEBVTT

1
00:00:01.256 --> 00:00:14.180
Quick Data Loader functionality in CCH Tagetik enables end users to easily and quickly load external information, like global assumptions and drivers right on the fly, to update plans in CCH Tagetik in real time. 

2
00:00:14.181 --> 00:00:20.000
Here's a quick example of a simple driver based data entry template where, based on those different assumptions and drivers 

3
00:00:20.001 --> 00:00:29.080
such as 'Units per Work Day', CCH Tagetik's going to recalculate the number of units I need to sell and the subsequent revenue we'll receive, at the individual product lines.

4
00:00:29.081 --> 00:00:38.500
I can always key in my information for drivers or other statistical information, just by leveraging my keyboard and CCH Tagetik's going to show the impact of my plan right away, 

5
00:00:38.501 --> 00:00:46.500
but potentially, as an end user, I don't want to manually enter this information for 'Units per Work Day', I actually want to load that on the fly.


00:00:46.501 --> 00:00:48.900
So I can go right through my CCH Tagetik work flow, 

7
00:00:48.901 --> 00:00:54.000
and actually use the QDL functionality to load that information, rather than type it in manually.

9
00:00:54.001 --> 00:01:04.140
And one click away I can enable that functionality, select my file type and then choose the file that I want to upload, which in this case will be my import file located on my desktop.

10
00:01:04.050 --> 00:01:09.070
CCH Tagetik is going to give me a quick preview of my import layout, in terms of rows and columns

11
00:01:09.110 --> 00:01:15.070
and then give me the ability to map those rows and columns into different business dimensions that make up CCH Tagetik's Data Model. 

12
00:01:15.071 --> 00:01:22.119
When it comes to my scenario, which is a bucket of data in CCH Tagetik, I can just grab that from a flat list like my 2017 budget, 

13
00:01:22.120 --> 00:01:31.239
before my periods, I can actually just start dragging and dropping my month column coming from my import file to the period dimension of CCH Tagetik's Data Model. 

14
00:01:31.240 --> 00:01:35.059
Right away in real time you'll see that the exclamation mark's turn into a blue check mark, 

15
00:01:35.060 --> 00:01:42.000
letting me know that everything has been synced up properly, and I can move onto my next set of mandatory information which will be my GL account.

16
00:01:42.001 --> 00:01:48.800
So I can repeat that exercise just by dragging and dropping, I can scroll trough in terms of all those mandatory sets of information, 

17
00:01:48.801 --> 00:01:58.800
again just selecting in this case my transaction currency for US$, and I can complete my data upload by selecting the amounts and dropping them over to my amount field.

18
00:01:58.801 --> 00:02:05.000
As soon as I hit on run CCH Tagetik's going to enable that data processing, and also let me know that it is complete. 

19
00:02:05.001 --> 00:02:13.090
So now I can go in and actually take a look at my updated sales numbers, as we can see my 'Unit per Work Day' driver has been updated across 

20
00:02:13.091 --> 00:02:18.040
all 12 months and subsequently CCH Tagetik recalculated my entire plan for the entire year.