> For the complete documentation index, see [llms.txt](https://help.rbcgrp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.rbcgrp.com/getting-started-tutorial/hypercubes.md).

# Hypercubes

Suppose we want to have a possibility to drill into each particular KPI to be able to make some detailed analysis. In other words, clicking particular KPI should allow us to switch to another analysis context (another visualization template with a different set of dimensions and an expanded set of measures).

One of the interesting features of PowerKPI is the ability to define unlimited number of visualization templates bonded to different definitions of dimensions and measures (**Hypercube** in Qlik Sense technical term).

Let's expand **HyperCubes** section (the first section) on the properties panel. 

![](/files/-LbNDAXhnmKnabc6Iy09)

You already have one HyperCube here called “New hypercube”. It has been created when you added extensions to the sheet.

Rename it to something meaningful, for example – “KPIs”. Expand “New hypercube” item and change “Title” property accordingly. Thus, the current configuration of dimensions and measures which you can see on the "Data" section of properties panel will be called “KPIs”.

![](/files/-LbNDl3C5zniJ30ZCjzo)

Let's create another hypercube called “Details”. Click “Create” button of the “HyperCubes” section. A new hypercube will be added. If you open the Data section of the properties panel, it will be empty.

![](/files/-LbNE0eX6n6AGcmg2BEH)

To switch back to “KPIs” hypercube, expand it in “Hypercubes” section and click “Show” button. 

![](/files/-LbNFi1_OXXeBCZQGMKM)

The “Data” section should contain all previously created dimensions and measures, and the editor should show previously designed visualization template. 

Expand "KPIs" hypercube again and click "Copy" button. In such way, in one click, we can copy dimensions and measues configured for the hypercube.

![](/files/-LbNG0Q5YbIJa709ALY_)

Switch back to the “New hypercube” in the same way as you did it for “KPIs” (expand it and click "Show" button). 

Paste copied measures by clicking "Paste" button.

Change the title for the newly created hypercube to “Details”. 

![](/files/-LbNHY2OJ5fANRqhj-ON)

Expand the “Data” section of the properties panel. It should contain the copied measures. Let's add a dimension using field "Dim1".

![](/files/-LbNI7v9i74Iyfsb3FMJ)

After adding the required dimension and measures on the “Data” section, you are ready to start building a new visualization template to implement drill-down feature.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.rbcgrp.com/getting-started-tutorial/hypercubes.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.