TM1 Forum

Hi,

I'm new to TM1. But, I need some help to create a new rule to add m_dor_output. I recently has cube: Load_GL_Month that pulling month and year. I would like to add dimentsion; m_dor_output to include MTD, QTD and YTD.

This is for a general ledger cube which contains the following dimensions: h_company, h_departments, h_accounts, h_submission list and t_12_months. It's getting the data from other cube; GLTrueUp2. As GLTrueUp2 has dimensions: h_company, h_departments, h_accounts, m_gl_true_up.




FEEDERS;

['CY ACTUAL' ] => DB('GLTrueUp2', !h_company, !h_departments, !h_accounts, 'GL Amount');
['PY ACTUAL' ] => DB('GLTrueUp2', !h_company, !h_departments, !h_accounts, 'GL Amount');


How can I modify current rule to add new dimensions m_dor_output to include MTD, QTD and YTD?

I can't help but notice you have no Period Dimension in your GLTrueUp2 Cube?

Not sure how your going to be able to do your Period calculations without a period dimension unless your doing something in TI or GLTrueUp2 is not the actual Cube for which the Rule applies.

RJ,

We have TI process schedule to run every hour to update the accounts.

Hi vivianzh, welcome to the forum.

You need to provide much more detail about your model and what you are trying to do. No one will be able (or will want to) to provide help with just the information you gave.

Please take a look here for guidelines on how to write a good post that will attract helpers carrying buckets of help.

qml,

I added new information in my post. Thank you.

You can't add dimensions to a cube. You will have to re-create the cube, including m_dor_output as one of the dimensions.

tomok,

can you give me some guide on how to create a new cube to include dimentions: h_company, h_departments, h_accounts, h_submission list, t_12_months and m_dor_ouput?

Hi Vivian,

How to create a cube is quite a basic function, I'd suggest you go through some more of the IBM materials on TM1 to get a bit more familiar with it.
You can also use the Search in the top Right of this forum or Google search "TM1 create cube" - there are plenty or articles & even Youtube clips.

From there you can update your question on the forum with what you are trying to acheive, what you have tried etc.

Hi,

Instead of adding new dimension, I was thinking maybe I can add the QTD and YTD into the t_12_months for additional subsets. Do you think that will work?

Yes, should work