TM1 Forum

Alan, After much experimentation, here is what I am seeing: The other two dims are fine. I'm still having problems with the first (giant) one. I put the empy mydim.xdi file, generated in Excel 2003, in the proper directory. I edited the dimension using the right-click Edit Dim option in Perspectives...

Your TM1 Options specify the data directory as DEF's. (As an aside, upon initial installation your options were probably pointed to the Planning Sample server's directory even if you didn't ever plan to use it.) Bingo. That was the problem. I repointed it. Two of the three dimensions have been fixe...

Alan, Nope, sorry, it did not work. Further investigation proved that the xdi files (yes, there are three dims involved, not just one) got written to a disconnected server. When our TM1 was installed, it came with a sample database. I have pretty much ignored that database, and had never connected t...

It may sound obvious, but the first thing to do is to make sure that your Options in Perspectives are pointing to the correct data directory, and that the .xdi resides in that directory.

Been there done that, but thanks for the reminder.

I'll try your other suggestions, thanks again.

I am working in TM1 9.4. All of my TM1 work is done through an Excel 2007 interface. I have a large dimension with 10000+ elements. I was working in the xdi file, rearranging, removing a few, adding more, etc. Somehow the xdi file got "unattached" from the dim file. I tried to fix it and e...

I did what everyone suggested and changed the system to a bunch of consolidations, in place of recursive rules.

The system runs much faster, it's simpler, more elegant and works great.

Thanks!!!

I agree, consolidations are the way to go. I have to deal with the plethora of user spreadsheets set up for the current system.

No one said it would be easy...

You are preaching to the choir. I just need to keep the old model working for a while longer, and don't want to waste time on it unnecessarily.

Learning the new stack limit, if there is one, would be of great help for many reasons.

I am converting a TM1 Vers 6 database to TM1 Version 9. I am "almost" done. I found a new error on the Vers 6 side, which remains the production version until the conversion is complete. We have rules that calculate Inception To Date. They are recursive, that is , Month 1 is added to Month...

I found this message while searching for something else.

Why go through the step of creating a temporary file? Just use the query as your data source

That works perfectly, and thanks.

David Usherwood wrote:My recollection is that dayno uses TM1's 'Day zero' of 31/12/1959, but the formats use Excel's Day zero of 31/12/1899, so you need to offset by the difference of 21916. Not sensible I know, but perfectly manageable.

I'm doing exactly that and it works great.

I thought I'd flesh this out a bit in case someone comes in with the same question and the same "beginner" status that I have. The datasourcenameforserer and datasourcecubeview in the Prolog essentially take precedence over a datasource and view defined in the first tab of Turbo Integrator...

DatasourceNameForServer (name of the cube); and
DatasourceCubeview (name of the view).

Thank, Alan.

(Self-administered dope-slap to forehead.)

I'm willing to bet there is no good way to do what I want to do. I want to define the data source in the TI code. I have cubes named Sales2010 Sales2011 Sales2012 etc. Salesyyyy is the datasource. The cubes are identical in terms of dimensions and elements. I would like to define the year as a param...

It should work fine, provided that there are no (different) objects with the same name that would overwrite each other. And, of course, provided that you copy all the object files that other objects depend on. OK, good. There are no duplicate object names and I'll make sure I copy everything. This ...

Kyro: same version TM1 servers by using the ODBO Connection datasource option within TI That could work, except that I am already using a cube view as the data source. The data source has a project code. I want to look at another cube on another server to see what type of project that particular pr...

(But should be... that, however, is another gripe (which IBM will ignore) for another time.)

Yeah, it should be, but is not. Sigh.

Since I'm still in the sandbox, it looks like I'll have to move it all to one server. Snarl. Gripe.

Thank, again, Alan. I really appreciate your help.

I have three servers in my "sandbox". I am in the process of converting from Vers 6 to Vers 9 and am learning Turbo Integrator. I need to write a TI process where the data source is a cube view on A: and one-off data is collected from cubes on B: and C: Essentially, I want something that l...

If you have only a few elements, then parameters are the best way to go. Right now, it's about 50, which should be typical. It could be as many as 75 or so. What would you suggest as a "tipping point" beyond which the text file would be more efficient, just for future reference? Can I ind...

Gentlemen, Thanks. Yes, I mean Visual Basic for Applications. And, yes, I was trying it with Application.Run. I will have a list of elements provided to me, in Excel, by a user, then will want to create a subset with that list. The only person executing this procedure will be me, with admin privledg...