TM1 Forum

Hi Guys,

I am trying to create a ragged hierarchy using performance modeler TI Process.My datasource is a file. i have multiple columns in the source file, there is a column named "Sub Parent Name" which has values and blank values in it. The succeding elements of "Sub Parent Name" in source file are "Customer Code" and "Customer Dimension". i am trying to create a ragged hierarchy in such a way that whenever there are blank values for "Sub Parent Name" it has to display only the "Customer Name". But the TIP is creating the dimension which is dispaying both "customer code" and "Customer Name" whenever it encounters blank for "Sub Parent Name" in source file.

Please suggest me is it possible to achieve this??

Please find the attachments for more info

Regards,
Aravind

You should post your TI code rather than the dimension. The TI code will be where the issue is.

If you are using the TI wizard code to generate the dimension then it will not cope with a ragged structure an you'll need to hand craft the script yourself.

Steve,

Thanks for the reply, Pls find the attached TI Code

The Guided Import wizard will generate TI to import ragged structures (just need to check the right box). In fact after reviewing your TI it appears you are using this.

It sounds like you are trying to get a view of your dimension that is not possible in TM1?

Each element in TM1 must be uniquely named in the dimension -- hence the strategy used by the generated TI to name the "filler" elements in the ragged structure.

Thanks for the reply nybble, I have created "Ragged Hierarchy" using Guided Import but could not meet my requirement. Could do u guide me like where to create these "Filler" elements.

Thanks in Advance,
Aravind

Apologies for the incorrect info, I've not really used the wizards in PM, I'd assumed the same as Perspectives.