TM1 Forum

For those that have an interest, I successfully resolved my issue. It turns out that my problem in using ViewZeroOut had to do with my failure to correctly define the views being zeroed out by the process, something that only took a couple of minutes to fix. Once I properly defined what was to be ze...

Very true. I don't think posting a dozen questions in about a year would constitute abuse, would you? No. The trouble we're having at the moment though is quite a few cut price consultants trying to use the forum as their own personal helpdesk. Unfortunately a few good apples are getting caught in ...

Unfortunately, I am the consultant on this TM1 job.... done as a favor for a long-standing customer at an exceptionally low rate who is quite understanding while I "learn" at their expense (the expense is quite minimal, as I'm not billing most of my unproductive time). Would this solution...

I believe the advice is sound and I stand by it but I think you misunderstand where I'm coming from, in fact I am almost certain, so let me explain. According to the world as I see it a "good consultant" one worth what you pay them is not there to come in and code away according to a set ...

I would repeat my advice to get in an experienced TM1 consultant for a few days to straighten some stuff out for you. If it happens that you are the external TM1 consultant then really I don't know what more to say. Thanks for the advice. It's comments like this that turn people off from ever posti...

Absolutely. It's like substitute mode (as opposed to add mode) in an accumulation (or "consolidation" - if you're very old) link. Uh oh... major screwup and I don't quite know what happened. Based upon my understanding, I went into my process that was transferring the data, and here is ho...

The light bulb just went off... I'm an old EP guy and assumed that an "update" worked in a similar fashion as that product, i.e. with a default behavior that replaces everything in the target with everything that matches or is allocated from the source. Instead TM1 by default is really onl...

You are probably skipping zeroes in the datasource view. You can either untick that or create a destination view and use viewzeroout (my preference). Actually, the view used for the source only has one option ticked, and that is "Automatic Recalculate" so it can be reviewed by the system ...

This is a very stupid question, but one I'll ask anyway as I seem to have a discrepancy in data! When you run a process to update a cube with data, with the Cube Action "Update Cube" selected and "Store Values" selected for Data Action , what does TM1 do with target cells that ar...

I have built a TM1 process that runs nightly to update a product dimension where in the query against the database is only pulling products marked as "saleable", which of course can change for any product at any time. In my process, I have chosen "Update" as my action when the pr...

I think you'd be better off applying a rule (or using a TI possibly scheduled by a chore) to update an }elementsecurity cube. Just keep in mind that if you go down the route of using rules you will need to look into using securityrefresh in a TI or something. Updating the }elementsecurity cube does...

To meet end user requirements I am trying to construct a number of rules and processes that eliminate a number of date related maintenance functions as to whether or not time periods in a cube are writable. For the most part the following rules for the data entry cube the end user sees accomplishes ...

Just add this to the front of your MDX: {[dimProducts].[Total Products]} + I added an attribute called TotalFlag, applied a 'Yes" to Total Products and added that to my MDX. While it worked, your solution is simpler and would allow me to add other subtotals if they were ever added to the produ...

I'm a relative newbie, so excuse the ignorance! To meet end user requirements, I have a list of products and have created the following query to build a dynamic subset based upon two product attributes: ({ FILTER( {TM1SUBSETALL( [dimProducts] )}, ( ([dimProducts].[ProductLine] = [dimProductLine].[Pr...

I have a weird problem that I thought I'd see if anyone has a solution. I have built a static subset for an income statement, and to make it look like most people expect have set parents to "expand above". In the actual dimension structure, when the dimension members are viewed in a hierar...

I lied... because I haven't done a good enough job explaining my requirements. While your methodology does work, my end users need to have data writable in FINAL as we've defined in real-time as they are entering data via TM1 web and are used to seeing real-time results. Your solution assumes that d...

What I was actually suggesting is that you have "Final" as an N-Level element and initially TI the spread numbers into it. "Adjustment" is a C-Level Element with children "Final" (weight 1) and "Preliminary" (weight -1) So initially: "Prelim" = X &q...

Yes, the spreading has been accomplished and works quite well. I tried your approach before, and while it does force the adjustment to be the difference between FINAL and PRELIMINARY, I don't think I explained the situation clearly enough. What the end user wants of course is to use the following fo...

While I know TM1 has a number of ways to spread data, I have a request to recreate some EP functionality that is used for planning expenses. Here's the scenario the end user would like to achieve: In Cube 1, the end user reviews data from the prior year, enters a planned amount for an entire year an...

Have you looked into cell level security on the cube(s) in question? Your scenario is one of the situations where they are appropriate. So I've implemented your suggestion using a cell level security cube for a cube where a test user is given access to two different cost centers that have access to...