TM1 Forum

Hello,

I came across this technique of setting up a TI process to read the input file path and name from an information cube.
the example codes are below:
datasourcePath = CellGetS(NameOfInformationCubeName, MeasureNameForCategoryMeasureNameForFilePathName );
dataFileName = CellGetS( InformationCubeName, MeasureNameForCategory, MeasureNameForFileName) ;
# --- set the datasource info for this process
DatasourceNameForServer = datasourcePath | dataFileName;
DataSourceType = 'CHARACTERDELIMITED';
DatasourceASCIIDelimiter = ',';

can someone please let me know where I should put these codes? I suppose in Prolog?

thanks!

Prolog, because otherwise you wouldn't be able to access the file contents in Metadata and/or Data tab.

Thank you so much again!

FYI, I tend to specify paths (input files, output files, custom scripts, ...) relative to the TM1 data directory.
You can do this with . and ..
Like that, whenever paths change, you will have less trouble adjusting all the paths.
TI functions like AsciiOutput, TextOutput, AsciiDelete, ExecuteCommand, FileExists, WildcardFileSearch, Datasourcenameforserver, ...
they all support the relative paths.

sorry dumb question again...

I created a new process and put this in Prolog (haven't created the information cube yet, just to see if these codes work):
DatasourceNameForServer = 'A:\Customer List.csv;
DataSourceType = 'CHARACTERDELIMITED';
DatasourceASCIIDelimiter = ',';


but the Metadata and data are both greyed out, what do I need to do activate them?

thanks!

Thanks for the information...that is too advanced for me for now...I'm trying to figure out how to get to Metadata and data at this moment...

Use a dummy file with the correct columns to get yourself a preview and variables. Hence a Metadata and Data tab.

Is it really impossible for you to follow a TM1 course ?

It is a one day course and they spent half a day going through how to set up dimensions using TI, all very basic material. all I learnt is that metadata is for dimension/subsets; data is for uploading cubes. little was explained about Prolog or Epilog (basically just use the manual input page to browse to the files and did a few SQL to pull raw data in from a SQL server). can you recommend a good online course that covers more details?

thanks!

lynnsong986 wrote: ↑Wed Oct 30, 2019 12:09 am It is a one day course and they spent half a day going through how to set up dimensions using TI, all very basic material. all I learnt is that metadata is for dimension/subsets; data is for uploading cubes. little was explained about Prolog or Epilog (basically just use the manual input page to browse to the files and did a few SQL to pull raw data in from a SQL server)

That’s pretty bad I would say.

lynnsong986 wrote: ↑Wed Oct 30, 2019 12:09 amcan you recommend a good online course that covers more details?

I set up my own Turbo Integrator course material with slides and exercises. It’s a 2-day course for those who are not too new with both TM1 and TI - although I can start from the beginning if needed (at the expense of skipping more advanced topics or a 3rd day). Obviously this material isn’t available online, yet my website covers many areas of TI. The material is kept up to date with every new release of the software, like new functions that are introduced or new us of working.

I’m sure others can offer custom training in TI too - of higher quality compared to what you know received. Likewise there are good sites out there as well. It will not be easy to find a site that gives you the same output and quality an experienced trainer can give you.

I definitely agree that I need a better course, I'd love to take yours but I'm in Canada so my best bet would be an online course with a different provider...good thing is my company pays for it...

Thank you!

I visited your site, I went though the MDX statements and have been practicing them. My problem is really with TI, not much with rules (I’m an advanced excel user, I use VBA a lot and have done quite a bit financial modeling in excel, so rules are fairly straightforward once I figure out the syntax). I think TI resembles VBE a lot, I need to find a good trainer for sure...

There are specialist online TM1 training courses availabe. Just do a search for "TM1 + training" and scroll down the list.
You get what you pay for, the better courses are considerably more expensive than the cheaper offerings.

I signed up for a course provided by INTELLIPAAT, just went through 2 sessions but I can already tell this is so much better! They also provide 24/7 support (at least they claimed), I'll see how it goes...

thanks!