TM1 Forum

I found that there are dimension: Version: DRAFT, WORKING, FINAL PLine (1 level only), e.g. L01, L02 PCategory (1 level only), e.g. C01, C02, C03, C04 PSubcat (1 level only), e.g. MEN, WOMEN, BABY Product (4 level with hierarchy showing below. PLine level, PCategory level, PCategory + PSubcat level,...

Hi,

I have right click relevant cubes -> drill -> edit drill-through rule, but I find nothing in the editor. However do I verify that the existing cube used drill-through feature?

HI Martin,

How to do drill-through in an Excel? How do I want the existing websheet (or Excel) using drill-through?

I found that there are dimension: date: Year/ quarter/ month / date product: Product line / Product Category / "Product subcat + product"/ product product subcat: product subcat For product subcat, the element are MEN, WOMEN, BABY For product dimension, product should be A0001, A0002, B000...

Product line / Product Category / "Product subcat + product"/ product e.g. product should be A0001, A0002, B0001, and there are three product subcats: MEN, WOMEN, BABY. therefore, the 3rd level ("Product subcat + product") should be: "MEN - A0001", "MEN - A0002&quo...

There is a dimension Product: Product line / Product Category / Product subcat/ product There are dropdown boxes for Product Category and Product Subcat. I know that it is dummy to have two dropdown boxes in the same dimensions in TM1 websheet (excel). But I would like to use Product Category and Pr...

Hi, I am new to TM1. I am confused with Rules Vs Process on some feature. 1) "process" can update data in cube, right? Can "rule" store data? or just evaluate data (e.g. query in rdbms, without storing data)? 2) If i run a process to update a cube: "A" (e.g. dimension: ...

Hi rmackenzie,

Do you mean that I should 1) export dimension (month), 2) use the program you given to export month hieriacrhy?

And then use TI to 3) load "cma" file generated in step 1, and 4) use TI to load month hierarchy generated in step 2?

Hi,

I want copy a dimension from another dimension. I use Turbo Integrator. I export a dimension months (with hierarchy: year -> quarter -> months), and then use TI to load the cma into a new dimension. However, i found the result is wrong.

How can I copy a dimension in TM1?

I would like to modify some rule, process for a cube, how to backup data in a cube and metadata for the cube?

Hi,

There are some "process" in my TM1 environment. I am new comer but need to modify it. I would like to trace the TM1 loading program, e.g. 1) which process is the first process to how to load dimension data, cube data? 2) how to run the process?

thanks

Hi,

I found that there are some special dimension "}ApplicationEntries", "}Chores", "}ClientProperties", ..., "}Cubes", ..., "}Dimension". What are they? are they data dictionary in TM1?

then, metadata and data is quite similar. do you mean that the process will run coding in metadata first, and coding in data?

Hi, I get the definition of prolog, metadata, data, epilog: ============================== Prolog A series of actions to be executed before the data source is processed Metadata A series of actions that update or create cube, dimensions, and other metadata structures during processing. Data A series...

Hi,

I found most of my company Active forms (excel) containing one cube only. Does TM1 allows multiple cubes updated in one worksheet?

Hi Alan Kirk,

Many thanks.

Hi qml,

Sorry, I don't know how to change design mode. Would you mind to give me step by step?

Hi lotsaram and qml,

Thanks for your replies, but I have a question that how prolong program related to tm1?

Hi qml,

I want to know the "coding" of the button. It is impossible for me to delete it because I will lose the coding (in the button).