TM1 Forum

Ashleigh W wrote: ↑Tue Apr 10, 2018 11:24 am Set to sort manually by Name.

Currently set or was set? Did you change to automatic by hierarchy?
If you select element 903, can you roll it up to check what its parent is?

Right click your dimension, click Set Elements Order then Automatic and Hierarchy. You can use TI to set this too, to set to Hierarchy and name, but try the right-click method first.

Check your dimension sort order. Try set to Hierarchy, by Name if not set already.

Thanks moby91 - quite a bit of content available!

Please vote for an RFE for IBM to provide the function to copy rule based cells to values. https://www.ibm.com/developerworks/rfe/ ... _ID=116669 - TM1 Data Snapshot functionality - Copy rule to values in a TM1 cube Noted that the comments on this RFE say that on 1 March 2018, IBM declined this req...

I normally use something like: =IF($C$4,DBSW(...),"No Send") C4 would have an expression to return True or False or just have a data validation. When TRUE, the DBSW is executed otherwise cells show "No Send". Works for me...and seems like it works for others too after reading rig...

Not sure if you have come across the Using TM1RunTI guide but based on the fact that you are using an INI file, you may have. What you need to do in your batch file is to use ERRORLEVEL - this variable will give you the return codes after executing the TM1RunTI command. Have a look here for more on ...

May be that your ini file is located in your user folder, to which the server has no access-try move it to a folder that the user who started the TM1 service has access to.

Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.

Here's the interesting thing, we haven't loaded or modified any new dimension, cube, hierarchy whatsoever. Have you been loading data via SQL by any chance? Noticed a similar increase in memory at a client, luckily did not crash but seem to remember garbage collection also sitting with quite a lot ...

May also be worthwhile deleting your feeder files if you are using persistent feeders, especially if you have been making rule changes and other structure changes. From some dev environments I have noticed that you can accumulate a lot of rubbish which then seems to be loaded, even if not needed, pu...

Have a look here - Wim has done a lot of work around this, alternatively, look into the CHO file itself. There are some posts on interpreting the CHO file.

Try something like: {Filter( {TM1FILTERBYLEVEL({DESCENDANTS([Customers SoldTo Only].[Region - 001]) }, 0)}, [AR History].([AR Measures].[Recent Activity],[Months].[Feb 2018])=0 )} The cube name should be after the tuple/set then the area defined within the brackets. I split the code for readability.

Confirm that you are looking in the correct location by checking the config in your TM1S.CFG

Generally the brackets are used to enclose a set. I have had varied experiences when using or omitting them. I try use them when expecting multiple elements being returned. Maybe someone has a more technical answer to your question though. Have a look at this link: https://mobile.databasejournal.com...

sMDX = '{TM1FILTERBYLEVEL( TM1DRILLDOWNMEMBER (TM1DRILLDOWNMEMBER {[' | vDimName | '].[(PROPOSED BUDGET)]},{[' | vDimName | '].[(RESTATED BUDGET)]}, ALL, RECURSIVE), 0)}'; .. Think you were almost there, just duplicated the TM1DRILLDOWNMEMBER( and mixed some brackets- try: sMDX = '{TM1FILTERBYLEVEL...

This one has been worrying me as I know I have some reports with 3000+ rows and am running on 10.2.2 FP4 i.e. Java, where we currently get a sum at the top of the column due to the way we derive the Active Form via MDX. One day we will need to migrate to PA and I wanted to confirm the impact. I buil...

Hi Loki, Have a look here - I remember going through a similar process trying to get integrated login with TM1 Web working - points 1 through 6 are probably relevant. I now use a field in the }ClientProperties to enter the Domain and then use a rule for the unique id - there should also be a post co...

I use the the alternate logging method to create a log file with logins. I then run a TI as a chore to process this file and write to a cube so that I can track frequency and last date of login.

Have a look at this thread for some guidelines

... setting WebsheetRowThreshold to a large enough value to ensure the active form is always fully rendered (which will have definite negative performance impacts!) Apologies tm123-Lotsaram has highlighted the flaw-I was testing on a smallish sample. Thanks for your input Lotsaram makes perfect sen...