Parent-Child Hierarchy in calculation view

[Former Member]

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

[Former Member · Accepted solution]

Thanks for all the replies.

I figured it out.

With the joins I had to make sure, that all Account entries are present, so the keys wouldn't show to nothing.

Lukas

[Former Member]

Lukas,

Based on error message, can you try following:

• Copy the model and rename it & then Validate & activate it. Then try connecting to excel.

Remember to keep Category Option as 'Cube' in properties tab of your calculation View

Regards,

Kulwinder

[Former Member]

Hi Kulwinder

Thanks for your reply.

Where can I set the Category Option? I didn't find it.

What I found out is, that if I leave the FatherNum as it is the hierarchy works fine.

But if I modify it like this: IFNULL("FatherNum", "AcctCode"), if fails with the mentioned error.

On the other hand if I do this: IFNULL("FatherNum", ' ') it is fine.

Any ideas?

[former_member182302]

Hi Lukas,

Can you cast FatherNum and AcctCode to same datatype like NVARCHAR before you write your formula and try it?

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna

I'm afraid that doesn't work either, but thanks for the input.

Also they are the same datatype already.

Lukas

[Former Member]

Still dealing with the same Problem.

Anyone?