TM1 Forum

Thank you for your answer. Yes, that would be a possible solution, because there are only 12 months, so I have 12 statements. But what if I want to see this on a daily basis? Is there no way to loop through each element? I thought that the CurrentMember function was the right one, but it seems that ...

Hallo everybody, I have developed an mdx statement, that should give me all products, that were sold more than 50 times per month within the year 2010. So the Year-Dim only contains 2010 and the Periode-Dim contains Total,Jan,Feb,Mar,...,Dec. The Subset "dyn_L0" selects only the N-ELements...

Thanks a lot again, that worked as well. But I really wonder why it worked in 9.1 and does not in 9.4 anymore. There is another thing: charts are not reliable created wihin TM1 Web. Sometimes they work sometimes not. Seems to depend on, where you place the chart: the help files say you should not pl...

Great, =SUMME(INDIREKT("D28:D29")) works for example. You can only use certain areas in the excel sheet for that function, because the active form seems to block a big part of the sheet, but it works. What I wonder now is, that the formular above does not work when I put it into a chart. T...

Hello, I have a problem using the new Active Forms in TM1 9.4. I am not able to pull Active Form data into separate Excel cells (outside the Active Form). When I modify the Cube Data and refresh the sheet, the cells outside the Active Form become invalid. With the dynamic slices in 9.1 it worked. Th...