Create dimension problem

Post Reply
kennyyeung
Posts: 19
Joined: Fri May 15, 2009 12:44 pm
Version: 9.4 MRC
Excel Version: 2000

Create dimension problem

Post by kennyyeung »

MY hierarchy like

A -B - B
| -C - D
(see attached)

When building the dimension using TI ,a circlar refernece expection occur .
what can i do if i need to create that kind of hierarchy ?
Attachments
My hierarchy
My hierarchy
hierarchy.JPG (4.2 KiB) Viewed 6966 times
belair22
Posts: 68
Joined: Wed Feb 25, 2009 2:26 am
OLAP Product: TM1, Cognos Express
Version: 9.5 9.4 9.1 9.0 8.4
Excel Version: 2007 2003

Re: Create dimension problem

Post by belair22 »

Unfortunately you can't create that kind of Exact hierarchy. You can't have a parent (B) with the same name as any of its child (B). TM1 allows for 'ragged hierarchies' - essentially you can do away with the "B" parent in Level 1 (the remaining "B" element is still Level 0, but remains a sibling of "C").
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Create dimension problem

Post by lotsaram »

As belair22 says in TM1 there is no need for such a hierarchy as TM1 supports "ragged" or "unbalanced" hierarchies. Thus for example one branch of a tree could have 8 levels and another only 2. This allows you to build TM1 dimensions with structures that accurately reflect organisational structures rather than have to artificially fill hierarchies to meet the requirements of a database.

The error you are getting is exactly as is says, a circular reference, as a child cannot be it's own parent. Every element in a TM1 dimension must have a unique name and therefore you can't have 2 different element definitions for the same element name.

If you absolutely have to have the exact structure you have illustrated the only way in TM1 would be to prefix/suffix a hierarchy level or similar construct to element names. However in a TM1 model it would usually be considered bad practice to have single child parents as such structures are unnecessary.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
kennyyeung
Posts: 19
Joined: Fri May 15, 2009 12:44 pm
Version: 9.4 MRC
Excel Version: 2000

Re: Create dimension problem

Post by kennyyeung »

"Every element in a TM1 dimension must have a unique name" . is that the attribute also have to be unique ?
Andy Key
MVP
Posts: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Create dimension problem

Post by Andy Key »

Attributes only have to be unique if they are defined as being of type Alias. Text type attributes can be the same for multiple elements
Andy Key
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Create dimension problem

Post by lotsaram »

Kenny,

To elaborate further on Andy's answer an alias can have the same string value as the underlying element name but cannot be the same string as another element.

Alias type attributes must be unique. (You can think of them as being "alternate primary keys to the dimension member master fact table" if that helps). For string and numeric attributes anything goes.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
iesak
Posts: 20
Joined: Mon Feb 23, 2009 4:49 pm
Version: 9.4
Excel Version: 2003

Re: Create dimension problem

Post by iesak »

is it possible to give a unique key for each element in the hierarchy, then create a lookup cube and use DBR funciton to map the name on the report level?
Andy Key
MVP
Posts: 351
Joined: Wed May 14, 2008 1:37 pm
OLAP Product: TM1
Version: 2.5 to PA
Excel Version: Lots
Location: Sydney
Contact:

Re: Create dimension problem

Post by Andy Key »

Yes it is possible. But is there any reason why you wouldn't just use an Alias?
Andy Key
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Create dimension problem

Post by lotsaram »

I think you want to cover the situation where multiple elements might have the same description but you still want that description to display in the report? Yes this can be easily done with a string attribute (no need for lookup cube) and use DBRA to return the value in your report (and hide the column with the actual element names).

This is easy to do if your report is in Excel/TM1 web but there is no way to do this in the cube viewer or EV (not sure about analysis studio haven't played with it enough yet).
kennyyeung
Posts: 19
Joined: Fri May 15, 2009 12:44 pm
Version: 9.4 MRC
Excel Version: 2000

Re: Create dimension problem

Post by kennyyeung »

Thanks you brother !
That exactly what i'm trying to do .
Post Reply