CODEWITHSUNDEEP
iccube
John
John

Reputation: 313

icCube parent/child dimension sort error

I have a child/parent hierarchy with columns: AreaName,ParentArea When I build the cube, I get the error:

The data of the parent/child hierarchy (AreaName) must be sorted (child-id:X,parent-id:Y).

This error is referring to the 2nd row in my csv data source. The first row has a blank value for ParentArea so maybe this is having some impact?

I double checked my source data and the values are sorted by AreaName,ParentArea. I then changed the sort order to ParentArea,AreaName and that seems to work although I don't understand why.

thanks

Upvotes: 1

Views: 43

Answers (1)

ic3
ic3

Reputation: 7680

In icCube you've a view that allows for sorting a parent / child relation as expected by the dimension (doc).

If your data source is a relational database the algorithm for sorting a parent/child relation are described in this stackoverflow post.

Upvotes: 1

Related Questions