TM1 Forum

Thank you Declan. I have got what I wanted. No more being puzzled...
Thanks all.

In Perspectives/Architect Server Explorer turn on the Properties Window; navigate to the view, highlight the view but don't open it and tell us what the number is for your period dimension under the "# Elements" column. Declan you're putting up a good fight but I fear our colleague may be...

Thank you all for the info above. I manually created two views, same structures <2015> R1 R2 R3 L1 L2 L3 ===================== <2016> R1 R2 R3 L1 L2 L3 ===================== Subset L.2015(contains L1,L2,L3) is used in view <2015>, subset L.2016(contains L1,L2,L3) is used in view <2016> Subset R.2015...

Hi there, I know there are many similar discussions, but I still feel this function is cryptic to me. I have a cube with 3 dimensions, Version(2015, 2016...), Production line(L1, L2...), and Region(R1, R2...), I created two views <2015>, <2016> as following, <2015> <2016> R1 R2 R3 R1 R2 R3 L1 10 10 ...

What I meant is that the subsets are used when defining the cube.
Thanks.

Hi there, I am stuck with one problem. I have a cube which has four dimension: Version, Organization, Class and Measure. In the web form, Version is a title dimension, Organization is displayed in rows, Class is displayed in columns. Both Organization and Class have a subset 'DailyUpdate' that are u...

Hi there, If I need to recreate a dimension with a brand new set of data, what I am doing is to use DimensionDeleteAllElements to truncate the dimension at first. When I put this command at the first line in one TI followed with codes to fill the dimension, the dimension is always empty. However, in...

Hello, IBM has an online document about customizing TM1 web via modiying the configuration file. I recalled from a workshop long time ago, the speaker mentioned all the configuration parameters can be stored in a control cube, so instead of modifying the config file, all need to do is to change the ...

Hover over the column's letter (e.g. where it says "L") you should see a down arrow appear instead of your cursor, press the left mouse button, this will highlight that column. With the column still highlighted: Hold "SHIFT" press the "End" key (while still holding &qu...

Thanks. Still clear as mud though :( 1/ Open Perspectives 2/ Select your websheet from the applications folders 3/ Select all empty columns to the right of your data 4/ Right-Click and select "hide" 5/ Select "Update" from the TM1 ribbon 6/ On the update popup box, select the sa...

tomok wrote:

nayitian wrote:Thanks. Still clear as mud though

You never answered Willi's question. It's highly relevant.

There are no more other columns defined in the format range.
Thank you.

Thanks.

To you who might look for the same thing, to be more specific,
1 right click the cube to create pick list cube
2 display control objects and locate the picklist cube
3 write a cube rule

It works for me.

Hello, I have been searching the site but have not been lucky to find the answer. Here is a cube structure, Dim1 : Fiscal Year (2011, 2012...2015) Dim2 : Region (Asia, Europe, North America...) Dim3 : Measure (Activ_Status, ...) After coding "subset:MyPicklist:Boolean" in Active_Status atr...

Thanks. Still clear as mud though

Hi there,

I have an Active Form which has only 4 columns, when it is published to TM1 web, everything is ok, except that there is a very very long horizontal scrollbar down at the bottom, is it possible to set a web form size and keep the scrollbar from displaying?

Thank you.

Thank you all so very much. Your tips are quite usefuly.

well i dont know if you can or cant really, this is just my personal experience, but so far, i dont know if there are parameter to modificate the size of the button, one time i added an image inside the button and i changed the size, but as far as i know, you can't change the location of the button...

well i dont know if you can or cant really, this is just my personal experience, but so far, i dont know if there are parameter to modificate the size of the button, one time i added an image inside the button and i changed the size, but as far as i know, you can't change the location of the button...

Hi, may you help with some issues regarding Action Button? 1) How to adjust the size of the button? 2) Once an Action Button is added in the sheet, I am not able to move it to tweak the position 3) The button caption displays fine in the sheet, but it gets truncated when viewing in TM1 web Thank you...

If I gather what you are trying to do correctly: You would like to automatically feed the Sequence # FROM an Number Type Attribute named: 'Sequence_Alias' on the Dimension:Sequence to the Cube Value: 'Seq_Code' in Measure. In Terms feeding it ['Sequence':'Sequence_Alias] => DB('Course', !Version, !...