TM1 Forum

Is it possible the elements are getting deleted and then added back? I would expect you to be losing data against these elements as well if this is what is happening too.

Hi, Just hit this issue that had me scratching my head, pretty sure I've had it before so just writing it down here so if I search for it I can find the answer... If the formating of a Dynamic Report is working correctly in Excel but not in TM1 Web / PAW check the the named range TM1RPTFMTRNG"N...

If you are going to use locking extensively and are combining that with TIs then you are probably also going to want to use CubeLockOverride(), a lightly documented TI function. To turn all locking off in the whole DB use CubeLockOverride(1); To turn it back on again use CubeLockOverride(0); Turning...

On the basis the Member ID / EPN and their respective aliases are always totally interchangable 100% of the time, this is a bug.

It is probably behaving as deisgned however....

Thanks for the good idea! I did not think about "lock" (or "reserve") - but I checked the security: Members of ADMIN-Group do automatically always have ADMIN-rights to all Dimensions and Elements and this cannot be changed. Setting to LOCK will also stop admins from changing the...

You've not mentioned the source for the TI processes. I'm guessing it is a SQL query. Have you checked that any ODBC connections in the production environment are not pointing at a Dev environment or a cube of reference information has not been promoted with the Dev information in it? It is far more...

I've been following this thread with interest. 20TS, my reading of the issues you are raising is that they were process and project management issues rather than a technology problem? Any project against any technology is going to look a mess if the initial scope is not correct and then there are si...

Just to follow up. Is the bucket size referring to the RAM or the disc consumption? If it disc consumption rather than RAM, then you need to look at and understand how the logging is configured on TM1. Areas to check. Make sure you understand how the disc is used, can it only be TM1 causing the issu...

You'll first need to identify which of the services on the box are causing the RAM spike. It might not even be a TM1 problem, can you get to the task managed or similar on the box? I'm going to assume it is the Tm1 DB. You'd have to make some significant changes to the config of T1Web to allow it to...

One thing that would be worth doing in your build is before (and maybe after) a job runs check for another occurence of the same job with the same parameters and clear it from the queue. Just to protect yourself from impatient users who sit there clicking the button becuase "nothings happening&...

Hi Nissy, I think that is going to be pretty hard to answer this in absence of any requirements at all. My advice would be A. Make sure the requirements have been clearly articulated and documented to you. then 1. Have a clear idea of what dimensions are going to be required hold the data to deliver...

Thanks Maren,

Because in editing the code to make it non company specific I managed to drop off the end of the statement, now updated. Thanks again

Thanks Mike.....you learn something new everyday! This is almost triggering me into rant but I've better things to do!

MDX views are quite hard, or at least require you to step up your MDX game significantly. I started by looking at the MDX that PA was generating for a view (there's a lot of noise in this) and then reading up on the MDX documentation, and a lot of trial and error until I got to a method that worked ...

You'll want to use ViewCreateByMDX, rather than the more usual subset logic.

https://www.ibm.com/docs/en/planning-an ... reatebymdx

See https://www.tm1forum.com/viewtopic.php?t=16024 for a hopefully helpful approach on creating one...

Sorry.. I meant these formula in the link you provided. Absolutely a DBRH would be the number one item on my wish list! https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/r_pax_tm1_ref_wrk_tm1resolvebook.html TM1RESOLVEBOOK( ) - removes nes...

Trying to think of a use case for what those new formula might be?

They don't seem particularly relevant to TM1 and more generally in Excel, what would you use them for...?

This is pretty hidden, had to raise a ticket to discover myself. Instructions here
https://www.ibm.com/docs/en/planning-an ... xploration

Hi tm1beginnerguy, Welcome to the forum, hopefully you are going to want to change your username at some point in the future! Just in case, don't forget that when you add an ODBC driver for TM1 to use it needs to be on the machine where the TM1 DB is running on not the machine where you are accessin...

Hi Barkes,
Any specific reason you choose to post the above on such an old post? It seems a bit of an odd activity to take.

Hopefully you've read all the FAQ and posting guidelines?

Cheers,