TM1 Forum

Alan Kirk wrote:If the TM1 server application was running on a real server box with Lotsaram and Loadzagrunt, then you'd be getting decent performance.

Alan, you always had a way with words Happy Christmas!

For the purposes of completeness only... ITYM "There is no way in VBA to get a list of the subsets that a dimension has unless you resort to calling the TM1 API with it"...

You could potentially look at the content of the DIMENSION_NAME}subs folder in the data folder...

YMMV

I am pretty sure Alan's explanation is correct. Apologies in advance for being the one who copies and pastes from the manual (with 9.4.1 FP3)... DimensionElementInsert This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes. This function adds an element to a dimension. You c...

If there is insufficient physical RAM and parts of the model need to be swapped to disk then performance will suffer, and not just incrementally but by orders of magnitude. Access to main memory is around 10^2 nanoseconds and for magnetic disk it is around 10^7 nanoseconds - some difference. An int...

Once you start to allow non-Admin users to look at the transactions you need to ask yourself if there are any security issues... Using the relational store as Lotsa suggests is great if there are no issues, otherwise you start to have problems having to rework TM1 security into some sort of ETL logi...

You could investigate the Hofmeister-Brezel framework which has been used to some effect in the past ?

As an example...

Original cubeview:


MDX query:


Result:

There's not really a direct method of talking to the In Spreadsheet Browser via VBA. It is possible indirectly but if I recall correctly you can't invoke the object methods.

Active Forms are the new In Spreadsheet Browsers...

Statistical functions aren't well catered for in TM1, and there isn't a rules or TI function to find median averages. There is a MEDIAN MDX function that I guess you could try and leverage in either a dynamic subset or view query (via a 3rd party tool). Which would lead me to ask: do you want to fil...

In Excel, if you want a new line, you drop down to the next cell. I'm genuinely unclear on how that's "a pain". Well, take for example a rule like this: ['Measure']=N:DB('SomeCube',!Dim1,'SpecificElement',!Dim2,!Dim3); Now, for arguments sake, let's say I want to break the rule up like th...

I assume you are talking about something equivalent to doing a "SELECT DISTINCT" type query in SQL Actually I think the OP's problem is more to do with the fact he is trying to resolve a headcount from adding up FTEs. I would advise him to explore the option of a separate cube, with a sep...

I believe I saw an article in the Forum (which I can’t seem to find) of a technique that disables cube rules as the restart begins to speed up load time and enable the rules as the load is complete Have you looked at the DEMANDLOAD measure in the }CubeProperties cube. From the manual (Ops guide):...

This definitely looks like a bug, not a feature...

You can do us all a favour and raise a ticket with IBM

Is your problem that the process is hanging, as in it never stops, or is your problem that you are struggling with a zero out because of cells that are conditionally calculated ?

I downloaded it myself this morning, so it's definitely there.

Thanks. Where are you getting the release note items from ?

I'm getting conflicting information about when hotfixes are coming out and what will be in them - so I'm just looking for definitive information...

Are you creating TargetVersion in the Prolog ? If so, you probably should create TargetVersion first in a separate process, before trying to include it in a subset in your version copy process.

Thanks Alan,

Do you know the release date for 9.5.1 HF2 ?

Then just change 100000000 to whatever works for you in terms of a delay.

Or perhaps if you can categorise the invoices so you get different points of aggregation (by customer, by payment terms, etc) in the invoice dimension then you can chop off the detailed level in the cube and allow access to the invoice detail using a relational drill-through.

my invoice dimension will be 6000 * 15 * 12 * 3 which is 3.2 million. Is this even possible, let alone running efficiently? Yes, and that wouldn't be the largest dimension out there either. However, very large dimensions such as these don't 'play well' with functionality like Subset Editor, Cube Vi...