TM1 Forum

Hello everyone! Thanks so much for all the great input and comments. Special thanks of course to Ty and Wim. @Ty: Big thank you, this was exactly what I needed. And I agree with the others - great code. @Wim: I went with your version (without being dependant on the }HierarchyProperties cube), thanks...

Hello all, I wonder if someone can help me out with a MDX. I tried with the help of the MDX primer and Wim's MDX site but I failed. I have a cube with months as columns. Month 04 and 08 have values, all other months are 0. Is there a way with MDX to show the last month with values (08) and all month...

Hi Wim and lotsaram, Thanks a lot you for your answers. @Wim: I knew I could solve it with an extra measure and rules. However I was sure it is somehow possible with MDX but I could not figure out how. @lotsaram: Thank you for the code example, it works great! I had the wrong approach - I tried to s...

Hi, I am looking for a solution to create a websheet which dynamically increases the rows when entering data. For example if you have an active form with a numbered list (elements 1, 2, 3 etc) as the row dimension. The active form should only show one empty row when opening it. As soon as the user e...

Hi, Version: PA local 2.0.2 Component: TM1Web We have multiple tm1 servers (e.g ServerA and ServerB) on the same host and are trying to create direct login links to TM1Web for each server. E.g. http://<hostname>:9510/tm1web http://<hostname>:9510/tm1web_ServerB This solution was working in 10.2 but ...

Thanks, Steve. Sounds like a very good guess to me.

Hi experts, I recently found a control cube called }ElementAttributes_}Processes in the solution with an attribute called IS_VALID and values true or empty (see screenshot). Does someone know when/why this cube is created and what the purpose of the attribute IS_VALID is? TM1 version 10.2.2 FP6 Than...

Hi Thank you very much for your help guys! It works now. I finally found the last step in the section called "Using TM1 Subsets, TM1Member, TM1SubsetToSet and Item" in the MDX primer. with the following example: {FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Account] )}, 1)}, [Reconciliation]...

Hi Guys I wonder if it is possible to use parameters (e.g. a value from a parameter cube) in a MDX statement in the subset editor's expression window (not in an active form in excel - I know how to do it there). Example: Children of element "123" in dimension "CostCenter". MDX: {...

Hi All I managed to avoid the warning in perspecives (server explorer) by changeing the tm1p.ini as you described. However, it still appears in TM1 Web. So I have the same question as Steven had earlier. Is it possible to avoid the warning in TM1 Web as well? Or should TM1 Web apply the settings fro...

Hi George Thank you for your answer. We discoverd in the web.config that there was a absolute path entered, specifying where the TM1WebEx folder should be located. But the path was wrong and the folder didn't even exist. So all the files where cached in the folder TM1WEB\ExcelSheets instead of TM1We...

Hi We experience problems with session time out in TM1Web. We have gone through some manuals which we found on the web how to change the session time out parameters but couldn't find an answer for the behaviour described below. Here some facts about the current versions and settings: Server: - IBM C...