loading data for an alternate hierarchy

[captainkarisma]

Hi guys,

Wondering if anyone can help with an issue.

I have loaded 2 hierarchies under a dimension.

Now when i'm loading my data , im not sure how to do this using cellincrement ( which works with one dimension and one hierarchy) function as the variables for cellincrement function require dimensions. So im not sure where to reference the extra hierarchy


Does anyone have a technique that can assist with this?

Many thanks.

[EvgenyT]

Now when i'm loading my data , im not sure how to do this using cellincrement ( which works with one dimension and one hierarchy) function as the variables for cellincrement function require dimensions. So im not sure where to reference the extra hierarchy .

1. You can only reference n-level elements in CellIncrement function...

2. Can you please explain what are you trying to do here, because it doesnt make sense so far.

Thanks

ET

[captainkarisma]

I have 5 dimensions containing 1 hierarchy each.
I load the data into the cube via cellincrementN . It works fine


Now, for dimension number 3, I have added a second hierarchy

My issue is, how do i now reference that 2nd hierarchy for dimension 3?
Does that make the cellincrementN function redundant because
cellincrementN(vMEASURE, cub, dimension 1,dimension 2, dimension 3, dimension 4, dimension 5, 'My measure') works but not sure how to reference dimension 3->hierarchy2

hope that makes it clearer

[David Usherwood]

TM1 has no concept of named hierarchies. You load (or increment) against the base element and the data rolls up in all directions.