Jedox For Excel 3.3

First Steps with

Jedox for Excel
Version 3.3

Business Intelligence for Performance Management

First Steps with Jedox for Excel Version 3.3

Jedox AG

Dated: February 13, 2012

Copyright © Jedox AG Copyright Reserved. Reproduction including electronic reproduction and substantive recovery - even of parts - only with the approval of Jedox AG. Legal steps may be taken incase of non-compliance. Jedox, Worksheet-Server™, Supervision Server and Palo are trademarks or registered trademarks of Jedox GmbH. Microsoft and Microsoft Excel are trademarks or registered trademarks of the Microsoft Corp. All other trademarks are property of the respective companies. For the purpose of readability, brand names and trademarks are not explicitly stressed. If a relevantdescription (e.g. TM or ®) is missing, it is not to be concluded that the name is freely available.

Starting with version 3.3 Jedox is the new name for Palo in the Premium Version. Because there are some screenshots not yet changed, in this manual both names are used synonymously. The names of files and services with Palo in the name and also of the PALO-functions were not changed.Table of Contents
1 2 Introduction ....................................................................................................................... 5 Jedox Basics ..................................................................................................................... 6 2.1 How Jedox works............................................................................................................ 6 2.2 Jedox is cell-related ........................................................................................................ 6 2.3 Jedox is an in-memory database .................................................................................... 6 2.4 Jedox is multi-dimensional.............................................................................................. 6 2.5 Working with hierarchies ............................................................................................... 12 3 First steps with Jedox for Excel .................................................................................... 13 3.1 Menu Jedox.................................................................................................................. 13 3.2 Connecting Jedox-Clients with Jedox-Server ............................................................... 15 3.2.1 3.2.2 3.2.3 3.2.4 Connecting Jedox-Client with local Jedox-Server ............................................... 15 Connecting Jedox-Client with a Jedox-Server via a Proxy-Server...................... 16 Connecting Jedox-Client with a Jedox-Server in thenetwork ............................. 17 Deleting a server-connection .............................................................................. 18

3.3 Creating a Jedox worksheet ......................................................................................... 19 3.4 Paste View.................................................................................................................... 19 3.4.1 3.4.2 3.4.3 Dialog window "Paste Elements" ........................................................................ 22 Selection buttons for element selection .............................................................. 24 Further options in the dialog-window "Paste View" ............................................. 28

3.5 Paste Elements............................................................................................................. 33 3.6 Paste Data Function ..................................................................................................... 38 3.7 Paste Subset ................................................................................................................ 39 3.7.1 3.7.2 Top Ten Products...