Now you are fully prepared! After login the template is connected with the showcase application via the Excel Web Add-In. That means the Cloud Service recognizes which template - more precisely which sheet - has to be connected to which application (and of course the service checks userrights as well).
Login
Press the Login button in the data1.io Add-In Pane ...
... and enter your Credentials from your registration (or use the Forgot Password Link if you don`t remember):
Reading Mode
After login press the Button OK in the taskpane overlay in order to read the existing data from the application datamodel into the template.
Now double-click any element in the dimension tree to see the reading mode in action. Please note that for bottom-elements also the comments (= text) are shown whereas for top-elements real-time aggregation is applied.
Writing Mode
Writeback is available on bottom-elements in the dimension tree. Double-click a bottom-element, edit the forecast data in the Excel template and press the Write Button or just switch to the next element in the tree in order to save your data.
Switching to a top-element of the dimension tree shows that the newly entered data are of course part of the real-time aggregations.
Dynamic dimension tree
As you can see, with data1.io Excel gets a third dimension! Additionally to rows and columns data the sheet can be "switched" through the elements of the dimension tree in order to write and read (aggregated) data from that elements.