TM1 Forum

Hi gays

BariAbdul wrote:

Hi gays

Firstly,It should be guys,right?

Please go through below link,It might help:

http://www.tm1forum.com/viewtopic.php?p=22755
http://www.tm1forum.com/viewtopic.php?p=8275
Thanks

BariAbdul wrote: The "guys" was changed to "gays" by your advice. But I don't slove my problem.

Your Link URLs are different to my problem.

My dimention have 3 Level (0, 1, 2) .
"0 level" is leaf.
"1 Level" is consolidation and It have Level "0".
And Last one is Top consolidation and It have Level "1"
But last of data of raw is Fixed Opex that is Level "0" and "Total" is Level "2"

I want to auto-make Dimention on TI per month.
But last row data was occoured error. because. have same charactar "Total"

"Fixed Opex" "Total" "Total"

I want to keep below Dimension structor
(C)Total
├(c)Finance
│ ├(n)CFO
│ ├(n)CFO Office
│ ├(n)Accounting
│ ├(n)Controlling
│ └(n)Treasury
└(n)Fixed Opex

so how do I make raw data or do for TI configuration.

thanks for reading my repost.
ps. I'm not very good at English. you might be understands me.

tm1ist wrote:Try deleting one of the 'Total's from the last row. If that does not work, you should probably modify your TI process code. You can post the TI code here so we may help further.

rmackenzie wrote:For a ragged hierarchy, the preference is to use a Parent, Child structure in the input source. E.g.:

Parent	Child
CFO	Finance
CFO Office	Finance
Accounting	Finance
Controlling	Finance
Treasury	Finance
Fixed Opex	Total
Finance	Total

kidyee wrote:Thanks for answer and read my post.
But My customer give me a raw data include 3 culumns

That raw data came form SAP System .

tm123 wrote:If you're not using the wizard, then it's easy to resolve this issue. Looking at your sample data, your source file contains 3 columns, which in most cases represent a child-parent-grandparent relationship.
So in your metadata tab, with the assumption that you have 3 variables named (vElement, vParent, vGrandParent) then your code should look like:

IF ( vElement @<> '' ) ;
DIMENSIONELEMENTINSERT ( sDimName,'', vElement ,'N' );
ENDIF ;

IF ( vParent @<> '' ) ;
DIMENSIONELEMENTINSERT ( sDimName,'', vParent ,'C' );
ENDIF ;

IF ( vGrandParent @<> '' ) ;
DIMENSIONELEMENTINSERT ( sDimName,'', vGrandParent ,'C' );
ENDIF ;


IF ( vElement @<> vParent ) ;
DIMENSIONELEMENTCOMPONENTADD ( sDimName , vParent , vElement , 1 ) ;
ENDIF ;

IF ( vParent @<> vGrandParent ) ;
DIMENSIONELEMENTCOMPONENTADD ( sDimName , vGrandParent , vParent , 1 ) ;
ENDIF ;

DIMENSIONELEMENTCOMPONENTADD(sDimName,cTotalEmployee , vEmployeeLevel , 1.000000);

rmackenzie wrote:

kidyee wrote:Thanks for answer and read my post.
But My customer give me a raw data include 3 culumns

That raw data came form SAP System .

TM1 requires that all elements ( c-level or n-level) are uniquely named. Your source file does not comply with that requirement. Your options are to redefine the source file (Parent, Child format) or code for the fact that the source file is not in the structure that will align to the system requirement.

I assume you are using the TI wizard/ 'Maps' tab because you have not posted any code that shows you are trying to solve the problem per TM1 requiring unique names?