TM1 Forum

Hi this maybe a little silly but perhaps someone can help

I am currently working on extracting data from a Test dimension which has been extracted as a .CMA File. I have changed the element name slightly and want to import the changes via a TI Process to see if the new changes would be incorporated in the dimension. I have created the TI Process and choosen Text and browsed for the file under Data Source Name Type. Delimited, comma and quotes remain unchanged. Cube Action is no action and Prolog is

#****Begin: Generated Statements***
DIMENSIONSORTORDER('Test Dimension WC','','','ByInput','ASCENDING');
#****End: Generated Statements****
And Metadata is

#****Begin: Generated Statements***
DIMENSIONELEMENTINSERT('Test Dimension WC','',V2,'s');
#****End: Generated Statements****

When i execute it there are errors and it refers to the Data Source telling me it cant find it or the source choosen is invalid. Anyone have any ideas what i could be doing wrong.

Thanks

Hello,

How do you exported the dimension into CMA? Right click > Export Dimension...?
If yes, then you cannot import it via TI.
On the other hand you can save it from Excel as a dimension worksheet.

Regards,

Peter

The error you described..."Data Source telling me it cant find it or the source choosen is invalid" sounds like it could be the .cma file is local on your computer or on a network drive that the TM1 server can't see.

Check the "DataSourceName on Server" in the TI process to ensure the TM1 server has access to the defined network path. For example:

In this example the file is on your local PC and the TM1 server does not have access to it and you will get a datasource error:
Data Source Name: = c:\Tm1\CMA\dimfile.cma
Data Source Name on Server: = c:\Tm1\CMA\dimfile.cma


In this example the file is physically saved on the Tm1 server. Your PC is mapped to that location via drive letter M:
Data Source Name: = M:\Tm1\CMA\dimfile.cma
Data Source Name on Server: = ServerName:\\Tm1\CMA\dimfile.cma

This script that you've included will only result in adding elements the test dimension as string elements and will not result in rebuilding your hierarchy. To effectively build a dimension with Turbo Integrator you need a Parent Child table and a DimensionElementComponentAdd statement to define the hierarchical relationship children to parents

DIMENSIONELEMENTINSERT('Test Dimension WC','',V2,'s');

Using Excel TM1 Dimension Worksheet Save may be a better solution for what you are trying to accomplish.


Hope this helps

Many Thanks for your help on this i think i will probably go the worksheet route or try and save as a CSV File. I am worried about the data so will try and probabaly test even outside the development environment if possible as may loose the data attached to the old dimension so will test it carefully.