TM1 Forum

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 ...

PAW doesn't have any special way of defining picklists, it works the same way across all interfaces. However, in all interfaces, a picklist that is defined via a picklist CUBE (this will show in control objects as }Picklist_<Your Cube Name> ) will always take priority over anything you define with a...

In PAW you can highlight the cells you want to be part of the spread and then use the right-click spread option, this will let you do all spreading options except "relative xxx" I believe. You don't have to select right, up, down, or left as you have already defined the area to be included...

If it’s just a small training server I would hazard a potential guess that the physical server it’s sat on doesn’t have much RAM - and if you hit that limit it will start paging to disk instead which could cause it to be very slow. So to add to things to check - RDP to the physical server and check ...

Hi, As Elessar has pointed out it could be locking that causes this, but I assume this wait happens every time? If so it is unlikely that you are in a wait state every time... unless it's a high user concurrency system and/or there are TIs scheduled to constantly run against the view in question. th...

['Priority Types']=S:IF(!Demand Type @='Structural', subset:Priority Types:pcklist,""); rule is not saved and throwing an error that rule is having the logical error. please suggest. You mentioned that "Demand Type" will also be selected by users as a picklist. So instead of pul...

If you add additional columns outside of an active form you need to update the named range TM1RPTFMTRNG to include your new columns. This tells TM1 to dynamically update the relevant rows it adds in under that column when the form is refreshed/rebuilt.

1/ When the users are facing the issue - can they not do ANY data spreading or can they only not do it in certain cubes / cube intersections? 2/ When the users are facing the issue - have you tested performing the exact same spread with another account that has the "same" access - and was ...

Hi, There will be many different ways to do this and it is partially dependent on the DB you are using (e.g. Oracle, SQL Server etc.) That being said, generally, in cases like this, I would do a straight Insert/Bulk Update to a temp table in the DB and then use a MERGE to transfer data from the temp...

{StrToMember ( "[Dim_Measure].[" + IIF ( [Scenario].CurrentMember.Name = "Elem1", "MeasureA", "MeasureB" ) + "]")} Generally speaking, IIF should be inside of other functions that will return either a SET or MEMBER. Think of it as the results of the...

The agent needs to be installed on all of the TM1 servers for PAW to be able to monitor them. You can download the agent from PAW, and then go to a TM1 Server and install it. The fact that you can already see an agent for your TM1 server means that you already have one installed, so you probably don...

And is there perhaps an old paw.ps1 file that still has the old configuration? As I mentioned it's just a guess but the containers could still be associated with an old directory. And try running ./scripts/paw.ps1 in powershell with admin rights - this should force any configuration changes to be ap...

What does the paw.ps1 file in the config folder show? It should be exactly the same as what you see in the admin tool GUI since that will be where it retrieves the details it shows you is from. My guess with the info you have provided would be that you actually have kept multiple PAW folders/directo...