TM1 Forum

If you already have an All N subset, assign that to your view to be zeroed out. Alternatively, create dynamic subset for All N using SubsetCreatebyMDX. You should be able to find quite a few examples with a quick search - don't forget to set the last parameter to avoid an error on an empty subset.

You can try using:
DBRA(<dimension name>,<element>,<alias>) e.g DBRA('Account','5010','Account Description') if in Perspectives (hoping PAX too)
or in rules, use ATTRS(<dimension name>,<element>,<alias>)
HTH

Not going to be too much help but think you already know that an HTTP code of 500 relates to permissions. Guessing you cannot create the upload file on the Cloud instance. Not sure if this is by design with the sample/test environment through Concierge. p.s. were you able to create users using the f...

Leading on from what Declan and Lotsaram have said. I normally create an attribute on my measures dimension to indicate that the measure will be used for input. This is generally referenced in the security model but leveraged in TI. In my load process I use MDX to create an All N subset with a filte...

trentban wrote: ↑Sat May 19, 2018 2:07 pm is there a workaround to assign an admin user after the first login?

Have a look in the guide I posted the link to in the previous post - Chapter 6 - Change a User's Role.
I am still playing on a single user (admin) instance but let us know how you get on.

Found this document today which seems to contain a lot more than I previously had on Workspace - It details the roles, permissions and administration. HTH

What I did pick up from the installing PAW on Windows 2016 Youtube video is that the *first* user to log into PAW is deemed the administrator from there on out. Not sure how you change this or where at this stage.

Could be permissions or version - I am logged in as Admin on PAW 2.0.4 running on Windows 2016 and see: Further down are the Control Processes.

Your "AAA" string is stored in a cube so filtering by pattern will not work. Have a look around on the forum for where INSTR is used in MDX as you would need to use that to do your wildcard match.

Column C seems to be needed before column D can resolve but the AF is relying on column D to drive it. The dependencies seem to be "circular" which is why it works when you use a static element in column C. When you say it works on TM1 Web - as you have it with formulas in column C and D o...

Hi Mark, If you are using an Active Form, the TM1RPTVIEW will replace the VIEW - not sure that even if you have other DBRWs referencing this, you will see gains. The first thing I always try and think about is what drives the Active Form - I then link the relevant DBRWs to the TM1RPTVIEW and create ...

Note sure if it is getting unhappy here: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, SUBSETGETSIZE(dimIndex, subRef) + 1); may be worthwhile trying: SUBSETELEMENTINSERT(dimIndex, subRef, strLoopEle, 0); If memory serves, I remember the 0 index adds to the end but you will need to test. Failing...

Are your saves in Epilog?-had issues previously with these in Prolog.

If the dimension is used in a cube, have you tried creating a picklist cube then writing the relevant rule against the dimension?

There are some parameters for START - type in START /? at the command prompt - there may be something like the /I parameter that may work. The other issue that comes to mind is with the multiple commands being run, you can have a return code from each of them. Even if you were to have separate batch...

Instead of START, try using I have not tested with multiple statements but worth a try.

HI ptownbro, just fired up my server-I was getting stuck at START C:\ibm... - exit code was 9059. Try removing the START to see what you get: I am using: "C:\program files\ibm\cognos\tm1_64\bin64\tm1runti.exe" -i "C:\temp\RunTM1Process.ini" I dropped the -p as this is already in ...

Have a look at ERRORLEVEL is not %ERRORLEVEL% which may give you a bit more insight. I may only have some time to test out your batch file on the weekend to give more pointed advice.
HTH

A good start is your Calendar cube. In its most simple form, you would have a time dimension and a measures dimension. The measures dimension usually has calendar days and business days. Ensure that you can derive Working days MTD and YTD. If you are going to span years, would suggest a single, cont...

Generally when you create a hierarchy with levels, you would set sort order to Hierarchy so that it represents as a tree structure. This however depends on your goal as you may choose manual and order elements as you want. No right answer here. Would refer you to the manuals/online help with element...