TM1 Forum

TM1 Version 10.2.

In defining of the Rule calculation, I have factor which involved in the ratio calculation. I have the time dimension which is at both the month level and week level and the factor is derived as (X/Weeknumber for Weekdates, Y/Monthnumber for dates under month hierarchy). The factor is defined as the text attribute in time dimension. How can I derive the factor both at Week. month level. Week no, Month No are comming the database. Can we calculate the factor at SQL level/Rule Level and use it as an attribute. Any ideas??

Thanks in Advance.

I am not sure if I understand you entirely. I presume you meant all your time dimension attributes is stored in a database and you would like to import them into TM1 as attributes. You can create a TI and connect it to your database using SQL. The fields you select will appear as variable in the tab. In the metadata tab in your TI, you can update using AttrPutS or AttrPutN into the }ElementAttributes cube for your time dimension. You will also need AttrInsert statement in your prolog if the attributes have not been created in the dimension. Refer to the reference guide for the formula.

If you know what X and Y is you can also calculate it within the TI and then update it into an attribute.

If this is not what you after, perhaps illustrate your problem further.