TM1 Forum

What is the query? Is it against a table or something else? It's certainly not unheard of for the error messages to be misleading but "object no longer exists" is not one I have come across before. I wonder if its something like a stored procedure to return a view but another user has exec...

monkey97 wrote: ↑Tue May 23, 2023 9:04 am2.0.72

Yes, you will need to upgrade workspace to a more recent version in order for that feature to be available.

What version of PAW are you on?
I think custom themes were introduced in 76.

Nope the problem would have to do with a circular referencation. If I'd write: ["Element 3"] = N: ["All Elements"] - [!Element] TM1 would be kinda displeased :-D What is the cube structure you are working with and what are you trying to get a sum of? As long as you have a measur...

Hi, You need to use the AddGroup function, not dimensionelementinsert. Maren DimensionElementInsert or AddGroup will work; the }Groups dimension is a dimension just like any other. Similar to how you can use CellPutS on the }ClientGroups cube instead of AssignClientToGroup - the difference is that ...

This is exactly how I set up version archiving processes in all of my models. You've described the master process perfectly. So for the slave process you need to: Check how many dimensions are in the Cube on the prolog Create your process using a dummy source (something with at least as many variabl...

Something like the below should work; it sounds like you were on the right track. The trick is to think of hierarchies as completely separate entities, so you can take the "Name/Description" of an element from one (but that could come from anywhere as its just a bit of text) and the Member...

As George has suggested the version being used could be useful. To the best of my knowledge the behavior of "changing dimension order" should be the same whether in manual or automatic calculation mode for Excel. There is an option called "Design Mode" under the "Data" ...

And in terms of the MDX view that Wim mentioned you would want to use code like below: SELECT {[Measure].[Measure].MEMBERS} ON 0, {Filter( {[Order#].[Order#].MEMBERS}*{[Line].[Line].MEMBERS}, [Test].([Measure].[Flag])<>"Inactive")} ON 1 FROM [CubeName] Within the Filter section; you are co...

In each TM1 instance, you can set a homepage per user in the }ClientSettings cube. After logging in the user will be redirected to whichever page you set here. Since the }ClientSettings cube is different per instance, but the same client can exist in both - this allows the same user to be directed t...

Sorry, I might not have explained the whole picture. The objective is to have a cascading filter from organization dim to program dim in a cube view in PAW. That's why I cannot understand your statement can't have a user pick an element from the "Organization" dimension --- because the se...

Yes, this was why I mentioned the currentmember being an issue. The "Organization" dimension is returning the MDX list of elements, you can't have a user pick an element from the "Organization" dimension --- because the second that they do... the MDX expression stops applying. Yo...

TM1SubsetToSet([program], IIF([organization].[parent].[Level] = "Level 0" , "Subset1", "Subset2")) It seems by this code [organization].[parent].[Level] you're trying to first grab the parent attribute of the element from the organization dimension and then the level o...

If your interface is PAW or PAX you could just right click on the time dimension in the view and select show attributes. That is the quick GUI friendly way to show what you want. If you want it to be part of the view that will work in other interfaces also then I would do it by using a MEMBER calcul...

I use it all the time to display values from 1 cube alongside an input view for another cube with some related dimensions. No point in duplicating data in various points across a model, if the purpose is just to present something to a user for info then I tend to try and do it in the presentation la...

Hi, Yes, at the moment there is no default redirect to a landing page from the PAW url for different users. Each book does however have its own URL, that you can take from the "Share" options. So you can have users save that as a shortcut to navigate to instead of using the main URL. Thank...

I presume you are talking about PAW? If so, I would be interested to know how you would avoid the calculation appearing twice in the view if there are 2 dimensions at play? MDX Views can be used in PAW and in PaFE explorations. For Explorations in PaFE you get the "Exploration" subsection...

Hi, Running a TI process against a sandbox shouldn't have significant differences to running against the base data - on the assumption that it's processing roughly the same data. What is possibly happening here is that the particular sandbox being executed against has user inputs which result in a s...

Where are you looking? You are correct that TM1 can use both types of groups at the same time, but "local" TM1 groups won't be visible in Cognos. Any group created in TM1 will be visible only in TM1, in the }Groups dimension and relevant cubes e.g. }CubeSecurity. The }Groups dimension will...

As I have understood your requirement: You want to produce a file with 25 columns: - Column 1 = Project Code - Column 2>13 = Revenue for Month 1 through to 12 - Column 14 > 25 = Expenditure for Month 1 through to 12 And you want to exclude any Project/Row where all of the 24 values are zero. Unless ...