How to create dimension with hierarchy from cube data?

[ioscat]

I've got a task I don't know how to solve it anyhow. Main idea is by using web interface fill cube cells (NxM) and by clicking smt create/recreate or edit dimension with hierarchy.

I don't even know is it possible in common?

I see it like this:

Code: Select all

N     N-1    N-2 .... 
A       a
A       b
A       c       d
B       e

And in the output get 2 parents 3 direct children in 1st 1 direct child in 2nd

[ioscat]

I don't know, is possible to create dim elements from cube data, should we use iteration on all of elements or use some nice IBM TM1 engine?

[Steve Rowe]

It is possible to use a feed from a cube to build a dimension is you want to, just code the TI up....
The real challenge will be in writing a sensible set of code to do this and establishing how the view that you will use as datasource for the TI.

So if you are looking for reassurance that what you want to do is possible, then be reassured.

With the structure you layout in your first post it doesn't look too bad...

Cheers,

[ioscat]

Please, could anyone provide the simpliest process code example for 2x1 cube? How to get data of the n-th cell to set n-th element name?

[ioscat]

Just completed task and can't help myself not to tell (#is it correct phrase construction?) our solution.

1) Create cube with cell to fill (parent, child, p+c)
# p+c is hidden from user
2) Create process that fills column 'p+c' and exports p+c (semicolon delimeted) column to .csv
# for this purpose I used special cube view with only one element in dimension
3) Create new dimension from .csv
?)
5) profit!