Adding Multiple Hierarchy Levels with Excel data import

Questions & Answers
,
1

Hi everyone,

I’m doing some data mapping by importing data from an MS Excel file into a new Cube.

At present I have 1 hierarchy level.

I was wondering if it’s possible to have additional levels as shown in the image below when data mapping from an Excel file:

Multiple Levels
Multiple Levels1152×648 24.7 KB

Thanks for your help.

2

Hi,

You can have just two-level hierarchies in dimensions when they are created in “new” cubes.

The image on the right side in your screenshot is from the “Issue” dimension when eazyBI for Jira is used. There you can have more hierarchies as described here:
Additional Issue hierarchies.
But the same won’t work for custom cube dimensions imported from MS Excel data.

Why would you import issues in a new cube if you can use eazyBI for the Jira app and import them directly in “Issues” cube?

Martins / eazyBI support

Best,

3

hi @martins.vanags , is there a possibility to create a third dimension level when importing into a custom cube through SQL Server Connection ?

Thanks in advance.

4

@AntonBDR
Technically you can not create more than 2 levels from the import, but you could perhaps use MDX to create calculated members in the dimension to group 2nde level members, to artificially create the third level.
See a similar idea explained on the new release video (from 14th minute)

Martins / eazyBI