How to load data to uneven hierarchy

[binu.jose]

Hi

I am trying to create a dimension with below hierarchy. But I am getting circular reference issue. Could you please help me to resolve this issue.

For example

Code: Select all

All Product
   ProductA1
         ProductA1
         Product A2
   ProductB1
         ProductB1

Admin Note: Moved from the Bugs forum. This is NOT a bug.

[Alan Kirk]

Hi

I am trying to create a dimension with below heirarchy. But I am getting circular reference issue. Could you please help me to resolve this issue.

For example

Code: Select all

All Product
   ProductA1
         ProductA1
         Product A2
   ProductB1
         ProductB1

You can't have an element as a child of itself. In this case you have ProductA1 and ProductB1 as both children of a consolidation, and as the consolidation itself. You need to use different names for the consolidation elements.

[binu.jose]

Thanks for your reply.

I am able to create hierarchy .
I refered below URL to create hierachy. dimension is created with out any error. but i am facing some issue while loading data.


http://publib.boulder.ibm.com/infocente ... _Wksh.html

[David Usherwood]

And your issue is....?

[Alan Kirk]

Thanks for your reply.

I am able to create hierarchy .

Not the hierarchy that you had in your original post you aren't. That simply wouldn't work. Never has, never will.

I refered below URL to create hierachy. dimension is created with out any error. but i am facing some issue while loading data.

You're unlikely to be getting a circular reference issue when you're loading data. When you're creating metadata it's more likely and is usually caused by the sort of example you had in that first post. Either
(a) That you're trying to assign an element as a child of itself as you claimed you were; or
(b) That you're trying to assign A as a child of consolidated element B and also B as a child of consolidated element A.

But as the Request For Assistance Guidelines say:

Similarly if you're getting unexpected results, specifics of what you're running, how, and what results you're getting will yield a more valuable response than "I'm running a T.I. but my code doesn't work properly"

This would include the specific TI code which is generating the error.