TM1 Forum

Hi Christian, I think I understand where you are coming from though I've not used pick lists, from reading what you have said though it seems like they are just a string value that is an element from a dimension. It sounds like what you want to do is to say something like "We spent 200k of cape...

Appleglaze28, You can do it using rules too but it will be 'slow' (slow for TM1 anyway). The best approach (IMO) is to write a rule in the attibute cube to calculate the parent and then use a TI to copy it into a string attribute, this means that your test is fast (since we are not doing the hierarc...

Hi Sushanti,

You can certainly reference TM1 and ODBC type DBs from TI, what database do you need to view to drive your process?

Cheers

Just to qualify lotsaram's statement slightly, IMO Feedstrings is needed to get the display in the cubeviewer / zero suppression working but shouldn't be required at all to get the security working and shouldn't impact the perfomance of the security. ( In fact having Feedstrings when you don't need ...

Thanks for posting an update sushanti, it's not an area that many people get involved in. It would be interesting to know what your planning on using it for?
Cheers

The normal thing that drives start up time is the amount of feeding that takes place.

Not sure if you have security rules with feeding (probably not given the other thread that seems to suggest that feeding security rules breaks the object).

Hey Herman, I don't think the problems a missing lagnuage file it's more the error description is missing from the "language file". I get this error sometime when I work on French systems. 99% of the time I get an error message in French, the rest of the time I get a message like that. Tha...

Dan, It's fairly common practice with multi-dimensional time systems to have a lookup cube that does all the period mapping for you. Your PeriodLoopkup cube would be dimensioned something like this Periods, Years, Time Unit (with numeric elements year and period), Time Measure (with string elements ...

I was also wondering if the problem was that the feeder was not written hence the wrong result at the prodcut level? When you say the All Customer total is wrong, howis it wrong?

Hi ExApplix,

So your should remove the Ellev test on Customer.

Also try and bear in mind that we are giving up our free time to help you, what you want to do is not that tricky. We understand the problem and are doing our best to help you.

Cheers,

What about cube level security? It's possible you might have an empty cell level security cube that is interfering with things.

How are you testing? Does it still fail on a brand new cube?
Cheers

You may get what you want by removing the N: qualifier from the rule? I'm guessing that you don't want the count to sum along the region dimension but you do along the other dims? ['Count']= If ( Ellev('Product', !Product)=0 & Ellev('Customer', !Customer)=0 & & REPEAT THIS TEST FOR ALL D...

Hmmmm.... lotsaram wrote ['Contract Increase', 'Depts':'OCCUPANCY DEPTS', {'70200928U','70201028U','70205029U','70205530U','70453026U','70469026U','70469527U','70470030U'}, {'0380','0400','0420','0440','0460','0500','0560','0600','0660','0680','0700','0730','2750'}] Is this syntax new? I've never se...

Hi Gregory, What you need to find is a measure in the freight cube which has some form of relationship with BAF and use that to feed BAF from within the freight cube. For example say you have the measure 'ABC' that is populated in the cube (probably by direct entry rather than a rule), if you can ma...

I've split this off this thread . kielmc said This is where having the ability to use dynamic subsets on the left side would be extremely beneficial. Look for it in a future release : ) It sounds horrible to me and potentially very "expensive" as I would think that it would require some fo...

Or with a single If ['Contract Increase' ] =N:if(DB('Dept Lookup', !Depts, 'OccupancyChild')=1 & DB('Job Code', !Jobs, 'OccupancyJobCode')=1 & DB('Earning Code', !Earnings, 'OccupancyEarning')=1, 5, 0); No idea if there is any difference in the three different flavours of this rule once this...

Your might be nearly there Christiannot sure.... ['Approved Cost' ] = N: IF (ATTRS('Capex Measures_Picklist', 'Status', 'Picklist')@= 'Approved',['Total Cost' ],0); You're passing a string value to all the arguements of the attribute cube which is kind of a strange thing to do normally the middle on...

Hi Tom, That's not possible I'm afraid. But.. You may be able to put whatever conditions that drive your MDX subset into an IF statment on the right hand side of the rule. Typically you would set up an attribute / lookup value and test against this. From the you have written probably the best approa...

Steve Rowe wrote: In 9.0 I was surprised that when I went into to turn the logging off the cube logging cells for the }stats cube was blank. Clearly the system interprets this as On. Noooo, that ain't right. I'm looking at a 9.0 session right now. As with all other cubes, if the logging cells have ...

In 9.0 I was surprised that when I went into to turn the logging off the cube logging cells for the }stats cube was blank. Clearly the system interprets this as On. I don't know now if this was the starting condition of the cube. I'm less concerned about the logging, just moving it to somewhere else...