TM1 Forum

It will be very interesting to see what happens in the TM1 space over the next few years. On the one hand we have the existing user/consulting community with ~20 odd years of developing & interfacing in Architect and Perspectives, and on the other we have IBM introducing the very Cognos/EP-ish P...

one option would be to create one or more "reporting" cubes in TM1 and grant users access to these cubes alone in BI. The reporting cubes could have their values imported via TI process on a scheduled basis (only have C level rules) and be built in such a way that they would contain only t...

If your picklist type is "dimension" or "subset" then yes, element level security will result in users only seeing the customers they have permissions to in the picklist.

There may be a more elegant way to handle your issue via MDX, but one possibility would be to have a TI process loop through the dimension and create an alternate hieararchy of "Active" prospects. Your Active Form would then use the top of this alternate hierarchy as the starting point and...

If someone knows how to create an asymmetric cube view I'd love to hear it...frustrating to have it available in EV but not TM1's own adhoc views. What we've usually done is create a new cube with a hybrid time/measure dimension with the appropriate combinations as leaf elements. In TM1 10.1 you can...

take this with a grain of salt, as I was just "playing around" with TM1 10, but this happened to me when my test user did not have permissions on any CUBES in the model. Once I granted the appropriate cube security the Application displayed when I logged in to the portal as the test user. ...

There is if you're on 9.5.2...add or modify this line in your Web.Config file:

<add key="CubeviewerStringWrap" value="Enabled=true;MinCharactersToWrap=20;MaxDisplayCharacters=200;WidthOfWrapCell=50" />

Seems a bit silly but you could create your own version of the control cube with the same dimensions, create a picklist on this cube, and use a rule on the real control cube to read the value from the picklisted cell in your 'fake' control cube. Does anyone happen to know why picklisting control cub...

No, but you can right click on them in Architect or Perspectives under the Application folder and rename them with a suffix e.g., A. Global Assumptions, B. CapEx, C. Operating Expenses, etc. You can also create Applications (aka folders) that are named alphabetically to mimic your process and place ...

There is a worksheet function called TM1User that you can place in your Active Form that will display the user name: From the reference: TM1User This is a TM1® worksheet function, valid only in worksheets. The TM1User worksheet function returns the user name of the current TM1 user. If the current T...

As far as I know if you want your users to see different views in the same contributor model you'd need to have the views on different cubes and use cube security. If the user can't see the cube the view won't show up in contributor.

I'm pretty sure the version of TM1 that ships with Cognos Express is 9.4 (9.4.1 FP 3 perhaps?). Picklists did not appear unti TM1 9.5.0.

I suspect the version of TM1 that comes with CX will always lag a year or so behind the main product offering...

Thank you Frenya for posting this...

Jed, I'm a TM1 "white belt" so to speak, so this might not be the best way to achieve this, but you can add a new element attribute (say, called "RuleWeight") and add a rule to the }elementattributes_dimname cube like: ['RuleWeight'] =s:str(ELWEIGHT('dimname', elpar('dimname',!di...

Has anyone else experienced this as well? I'm getting the same error trying to deploy a super simple model that "validates" without any errors. I'm able to create a contributor application using the "planning sample" model, but not on my own model. I've followed all the rules in ...

Substring doesn't work in subsets as far as I know, but here is one solution: On your Schedule dimension create a text attribute called "SubString" (or whatever). In your }ElementsAttributes_Schedule cube write a rule along the lines of: ['SubString'] = S: SUBST(!Schedule, 6, 1); Now in yo...

TM1 9.4 FP2 64-bit Windows Server 2003 64-bit Excel 2003 Separate Web and App Servers running the same versions of TM1, same version of Windows, etc... Users are occasionally getting this error message when using the "Snapshot to Excel" button in TM1Web: Internal error occurred while creat...

Looking at the fix list for 9.5 I saw this: TM1 Web: Enhanced security on the TM1 server drop down list. Has anyone installed and played around with 9.5 TM1Web? I'm very, very curious about this functionality as it may solve an issue for one of my clients. Specifically i'm wondering if we can have d...

Here's the fix list for those who don't feel like navigating the IBM Support site maze: Issues corrected since TM1 9.4.1 FP2 - Export to PDF did not work when using a private subset from a worksheet. - The User Interface for the Attachments button in TM1 Workflow for the All Tasks button did not ope...

My understanding is that even within a single TI process using ASCIIOutput or TextOutput on different tabs will overwrite a file, let alone using two separate processes. A couple suggestions (I'm sure there are others): 1. If you are handy with a scripting language (e.g., vbscript) you could have tw...