TeamOne Explorer

TeamOne Explorer is your Planning Analytics for Google Sheets. You can easily create explorations (cube views) by selecting dimensions and elements in the sidebar and the data will be refreshed directly in the Google Sheets grid. img

Create exploration

You can open TeamOne Explorer from the sidebar using the Explorer button on first tab. When you create a new exploration it becomes linked to the current open sheet and gets the same name as the sheet. When you open the Explorer screen, it will load the current sheet exploration if it exists, otherwise you will be able to create a new exploration or select an existing one to open. img

System cubes

You can select system cubes by selecting Show system objects from the menu

Open exploration

When you click the Explorer button, it will load the current sheet exploration if it exists, otherwise you will be able to create a new exploration for the current sheet. To open a different exploration, you can either switch to the sheet you want to open the exploration for and click the Explorer button or you can do it using the Other explorations menu option. TeamOne will automatically switch to the corresponding sheet for you. img

Exploration cube

You select the cube name when creating a new exploration or you can change the existing exploration cube in the exploration settings, which you can open from the exploration menu or simply by clicking the cube name.

In both cases TeamOne will build a sample exploration for you by selecting the last 2 dimensions for your rows and columns and using $ALL MDX mod to dynamically select all elements for each dimension.

Include empty rows

By default TeamOne will suppress empty rows. Select Include empty rows to include elements with no amounts or text data.

Include empty columns

By default TeamOne will suppress empty columns. Select Include empty columns to include elements with no amounts or text data.

Groups rows

By default TeamOne will group rows elements (print distinct row element names). Uncheck the Group rows option if you prefer to repeat all the row elements. img

Hierarchy indentation

By default TeamOne will indent rows elements by the hiearchy level. Uncheck the Hierarchy indentation option if you prefer to print the rows elements without indentation. img

Start row and column

By default TeamOne will print the exploration starting from the first (A1) cell. Use Start row and Start column to control the beginning of the exploration output. img

TIP

You can add your custom content such as a title or other calculations before the Start row or even after the exploration last row

Rows, columns and filters

Each exploration has 3 dimension areas: rows, columns and filters. You can manually select elements or use and existing subset or use a subset expression for row and column dimensions. You can select a single element for each filter dimension

Rearrange dimensions

You can move dimensions between areas (rows, columns and titles) or up and down within an area (to change the order of nesting) using the dimension context menu: img

Row and column dimensions

You should have at least 1 row and 1 column dimension.

Filter elements

Click a filter dimension to select an element. The subset screen will open and the element dropdown field will be activated automatically and you can start typing the element name or simply select it from the list. You can also select a different hierarchy, an existing subset and attribute or use an MDX to control the element list.

img

You can unselect the element by clicking the clear icon on the right

TIP

While typing the element name, hit ENTER to select the first highlighted element and close the subset screen.

Default elements

If you do not select a filter element, TeamOne will use a default element for that dimension, which is usually the first top level consolidated element user has access to. Default element can also be set by TM1 administrator in }HierarchyProperties control cube. Keep in mind, if there is element security defined for a given dimension, users may see a different default element depending on their permissions.

Row and column elements

For row and column dimensions you can choose to display elements from an existing subset, use an MDX expression or pick the elements manually

Subset

Simply select a subset from the Subset list and TeamOne will fetch the elements automatically.

TIP

If subset has an alias, it will be selected automatically as well

TIP

If subset is dynamic, the MDX button color will change to "indigo" and you will be able to see the expression by hovering the mouse of the MDX button

MDX

Use the MDX button to edit the existing MDX expression or create a new one. In the MDX editor you type the expression manually or use the MDX mods buttons at the top to build an expression with no code.

For instance, the next expression will filter all the leaf level Organization dimension elements by the currency attribute value equal to CDN and will select the first 2 elements. You can also use the Convert MDX button to get the real MDX:

img

More over you can simply type or copy-paste the elements. Or even use wildcard patterns: img

TIP

MDX expressions are dynamic, meaning the element list will be evaluated upon refreshing exploration data

Select elements

Finally you can select elements manually:

img

Refresh exploration

Click the Refresh data button to refresh the exploration data on its sheet. This will also save all your exploration changes. Depending on the exploration data volume it may take time to fetch and print all the data. For large explorations TeamOne will split data requests into multiple packages, up to 10000 cells each. Each result will be printed on the sheet as soon as it is received. Also keep in mind Google Sheets limit of 10 million cells per document.

img