TM1 Forum

Based on what you are showing here, it looks like 'Revenue', the actual stored amount, is in the same dimension as 'Project Revenue'. This is good because it will help simplify the rule. If we step back and look at the facts in simple terms, it looks like Revenue is the determing factor as to whethe...

-- hence it would have been more efficient to keep them in seperate cubes for TI load performance and for save data all performance Only if you are clearing and reloading the cube from scratch every time you load. -- and we would have benefitted more on TM1's cached calculated values for the numeri...

But how would you write the correct feeder which also flags the 0-value? Based on the picture you have shown it's not possible. Feeders have to feed off an actual value. In your case the only element that has values is Mes1, and it doesn't have values in all the cells. The only way you are going to...

I'll help you if you'll provide an english description of what the rule does. This one looks pretty complicated, or at least pretty involved. I don't have time to figure out what this one does AND help you figure out what the feeder should be.

Or, if you have an SMTP server in your company, use a command-line tool to send e-mails (same method as Christopher suggested - ExecuteCommand from a TI). There are a few free ones to download from the Internet. The problem here, of course, is that this is still a "pull" mechanism, not a ...

I have a period dimension (all dates and all the usual hierarchies). I want to create a dynamic subset based on the user inputting a date range. I have used the 'LastPeriods' function to take the end date entered by the user and count back the relevant number of days. The problem you are having her...

Yes I already used it and I dont see why you are saying thats a ridiculous suggestion. It's a ridiculous suggestion because ConsolidateChldren has nothing whatsoever to do with string values and feeding cells with string values. Using the ConsolidateChildren function will not feed anything. You sti...

but when I write the same SQL language in the TurboIntegrator using the ODBCOutput, it gives me an output of "1" (which i'm not sure what it means). Did you preface your ODBCOutput function with an ODBCOpen so that the conncection to the database is actually open before you attempt to run...

You can't do what you are asking. The problem is how is the Relation dimension supposed to know what you have "selected" in the Product dimension? To write an MDX statement to filter the Relation dimension in the way you want you would have to store your Product dimension selection in a cu...

cjedwards2005 wrote:I'm starting to think that there are more jobs than available TM1 specialists.

That would be a correct assumption and if you are talking about people who actually know what they are doing the population gets waaayyy smaller.

You can't process multiple data sources in a single TI process. Only one source per TI because there is no TI function for "opening" a file. That function is built into TI. A WHILE loop wouldn't do you any good because there is no way to open the next source. You CAN link TI's together by ...

Also, in theory, you shouldn't need to run a security refresh if there are no rule calculations for your security cubes. But maybe someone else has a different experience with that. it depends on which TI function you use to update the security. If you use ElementSecurityPut then that includes the ...

ExApplix wrote:How do I use/generate the MDX within the TM1RPTROW function.

You can't. You have to create the MDX code yourself and paste it into the formula or into a cell the formula references. You can use the subset editor to help you create the MDX if you want, that's what I usually do.

You realize, of course, that the server version of TM1 is not supported on Windows 7? It will run, because I'm running it right now on my laptop, but that's no guarantee it will on your machine. You may want to try the 32-bit version, it is less picky.

Look on the web server and make sure the TM1 Excel Service (this is the service that renders Excel sheets on the Web) is running. If not, start it.

I must admit I've never seen FTE defined as you are doing it. FTE, at least as far as I have always seen it, is for coming up with a way to combine full time employees with part-time employees to come up with a total. In other words, people that work the normal work week (40 hours or whatever) with ...

AFAIK, your scheme is a violation of IBM's licensing rules. The concurrent user portion of the server licensing is based on how many users can be logged in to the server at any one time, not how many user ID's are being used. There is also a client license issue to consider as well. Users can not sh...

I can tell you from experience you're never, ever going to come close to the speed of a flat file dump and then bulk load into SQL if you choose to do an INSERT row by row. There's too much overhead involved in the INSERT. The SQL engine has to check your INSERT statement for syntax, compile, and th...

The Server Explorer viewer, as launched through Excel, AKA, Perspectives, is nothing more than Architect. It is not an Excel interface. The options the OP was talking about were Excel sheets, in conjunction with menu options added to Excel used to maintain dimensions. There is no equivalent for main...

Alan Kirk wrote:Creating Cubes via Excel/Server Explorer:
Step by step instructions, here.

With all due respect. Server Exporer, aka, Perspectives. is not Excel. The XDI and XRU Excel-based sheets are Excel. There is no equivalent for cubes. Of course you already knew that.