TM1 Forum

I've seen this happen a number of times. The reason that a "zero out view" or "processing view" invariably stops working is that a public subset used by the view has been overwritten from the intended element set. Invariably also the root cause of this is having inept or inexperi...

I assume you are talking about element security in the company dimension? 1/ How is the region which populates the dropdown lists filled? You would need to fill it with SUBNMs otherwise the TM1 security isn't going to get picked up or have any effect. 2/ Assuming you have done this have you done a f...

you may get more response from the EV experts at www.evusers.org

belair22 wrote:Active Forms in TM1 9.4 covers most if not all the reasons you outline.

Inbuilt charting - no.
Drilldown on columns - no.
Drag and drop in Excel - no.
Connect to other plugins - no.

I'm not sure what exactly you were referring to.

I hate it when people ask this question but I just have to do it : "Why would ya want to do that?" The TM1 GUI (Excel & Perspectives) is essentially a super-charged Pivot Table. Kinda like choosing to hand-wash a basket of clothes when you have a brand-new washing-machine right next t...

Telula,

Reading your post a 2nd time maybe your "All Active Contracts" consolidation already exists? In which case all you need to do to your MDX is:

{ TM1DRILLDOWNMEMBER( { [Contract].[All Active Contracts]}, ALL, RECURSIVE ) }

Hi Telula, I think you might be confusing subsets and hierarchies. Although it is a "hidden feature" of TM1 that you can use a subset name in a DBRW formula which will act like a user defined consolidation this may or may not be what you are after. It's probably "dangerous" to us...

It is a bit difficult to say, I thought I knew what your problem was but the more I reread your post the more I am confused by what you are saying. So rather than posting a hypothetical solution based on guesswork maybe some further questions will help you out .. 1. Is the pseudo-navigation replacin...

TM1 never releases memory back to the OS but it does internally recycle it's own pool of "garbage memory"

Leaf holds simple yes. Distinguishing between blank and zero cell values definitely not, especially when also involving Undefvals. My understanding is that when Undefvals is used in a cube's rule file then if a zero value is entered into a cell or a value is zeroed out then TM1 will distinguish betw...

... disappointing as I thought they sorted this issue out in 9.1.4 This might be a kludgy workaround but no reason why it wouldn't work. Have a control cube that lists by time blocks and days of the week when your intra day chore should run, check on the prolog of the first process whether the intra...

But once the decision aboout the software is made, we have to get the best of it. ... and to get the best out of TM1 the approach may be very different from other systems! It might pay to get some good training and advice on TM1 cube and report design. One of the problems with this tool is that it ...

If the description attribute is an alias then you can use SubsetAliasSet( DimName, SubName, AliasName ) in TI to set an alias to use in the subset definition.