TM1 Forum

However, it is generally possible to have a feederless design with C-level rules and not use ConsolidateChildren. I have used this technique in some really large cubes and it scaled very well and provided good performance. qml, I'm curious to know more about this. Were you able to design the rules ...

To answer your first question, all the information about a cube, metadata and data, is indeed stored in the .cub file That's what I had suspected, which is consistent with the Dimension Re-Order wizard telling me that it was currently in the original order when we loaded the .cub file from backup. ...

bplaia, how are you measuring cube size? Size of .cub on disk? }StatsByCube? Since you mentioned .feeder files, TM1 does some file timestamp sanity checking on feeder files and there's a chance it might have thrown out your saved .feeder file and reprocessed feeders at startup which could change so...

Hey guys, I was wondering if anybody here had some insight into where TM1 stores a cube's dimension order. I would assume that this information is stored in the individual .cub files for each cube, however the reason I'm asking is because we have changed the dimension order in our UAT environment fo...

You'll need to create the attributes and populate them on instance B with the values from instance A. Create a TI process to ASCIIOUTPUT your attribute values on instance A to a flat file and a TI process to read in the file and populate the attributes on instance B. Or alternatively you could just ...

We're talking about a cube of 190 GB in memory of which 180 GB is feeder flags. I can't imagine how performance could be anything other than barfworthy. For a data model of this size you have very different optimization parameters and design constraints that a cube of 100 MB. And one of the most si...

Your stats do look like there is some massive overfeeding going on. Maybe in your case you could try a feederless solution? Lotsaram described it in this thread . It does require a bit of thought and preparation, but it can work very well if you're able to get rid of all N-level rules, replace them...

How big is this cube having a virtual copy of itself? Again sorry, but the design is simply ludicrous, and not in a good way. A cube with this degree of data has a source system. User driven forecast input, if any, will be a small fraction of the data volume, and any rule derived values in another ...

If these intersections are indeed empty AND not being fed, then removing them will likey not help much. TM1 does a very good job with sparcity so these intersections are not being evaluated to begin with. Sure, there is a little overhead here so not having them versus having them with sparcity is n...

Unless what is being fed is "Total SKU" in which case a whole lot of overfeeding is going on which points to some dubious design. Sometimes it might be necessary to overfeed, for example in an allocation model. But there are almost always ways to limit the amount of overfeeding for exampl...

Hi all, I'm currently working on a relatively massive TM1 system for a client (404 GB in memory, 355 GB on disk in the Data directory) using Persistent Feeders to enable the instance to come back up during our weekly restarts and in the event of any crashes in about an hour. The caveat with Persiste...

The Process run fine but it throws an error "Unable to Register a View'. My advice would be to check and see if there is a view already created with that name ( 'SinceStartDate' ), since that's the error that gets thrown when it tries to create a view that already exists. Maybe add some condit...

Assuming you're talking about private subsets, simply copying them into the user's data folder won't work.

Inside the user's data folder there needs to be a Dimension}subs directory, and that is where you may copy the .sub files

Brian

Also as suggested by Neil you would be able to get to the above code by doing the following: [1] Open Subset Editor on "Customer" Dimension [2] Select "Tools" => "Record Expression" [3] Press "All" [4] Select "Filter by wildcard" [5] Search on "...

Latest attempt: {FILTER ( {TM1SORT( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( { DRILLDOWNMEMBER( { TM1SubsetBasis() }, {[TL].[AB00]} ) }, ALL, RECURSIVE )}, 0)}, ASC)}, {UNION( [AMAT1].([VER].[2014_1],[MAT1].[Price - Company Currency] ) <>0 , [AMAT1].([VER].[2014_1],[MAT1].[Price - Group Currency]) <...

I've lifted tm1top.exe from a 952 install, dropped it into the bin64 folder in a 10.2 install, configured the shortcut and it comes up fine. Haven't tested the thread cancellation functionality as yet. As David said, dropping TM1Top from a different installation version into the bin64 folder worked...

Did you select it as a component when installing? I haven't installed 10.2 yet so I don't know if it is an option. Check by modifying the installation to see if it is there, Jim. Uninstalled, re-downloaded a fresh copy of the install files, and re-installed...still nothing. Also, not that it should...

Hey guys, I've gone ahead and installed the new 10.2 version off the IBM download site onto my 64-bit Windows 7 machine. I ran the 64-bit installer, it completed as expected, TM1 runs normally as i can create servers, cubes, dimensions, processes, etc. however I do not seem to have TM1 Top anywhere ...

Can you see Architect on the Windows taskbar?

DBRW won't write back to TM1, you have to use a DBS or DBSW formula in order to save data on TM1 Incorrect. You can write back to TM1 over a DBRW formula. This has been a key feature umpteen years. What you CANNOT do is write back to TM1 in a DBRW when the cell has more than just a plain vanilla DB...