Skip to Content
0
Former Member
Aug 13, 2013 at 01:32 PM

Parent-Child Hierarchy in calculation view

304 Views

Hi

I have problems with parent-child hierarchies in a calculation view.

This calculation view is set up out of an account dimension and a balance fact. Both are calculation views as they have some logic I couldn't handle in attribute or analytic views.

The account dimension has two attributes: AccountCode and AccountFatherCode

The Balance Facht has AccountCode Attribute and Balance Measure.

I joined these two tables through AccountCode (I tried Script and Graphical) and then made a parent-child hierarchy with AccountCode as child and AccountFatherCode as Parent.

Validation and activation is fine. Also the datapreview works fine.

If I open the Cube with Excel I get an error.

I am using HANA STUDIO 1.0.60.

Any help would be appreciated

Thanks

Lukas

Attachments

Excel.JPG (23.3 kB)