TM1 Forum

I would question why you feel the need to "map" the annual salary data to a cube that has a time dimension including all the months in the first place. If the annual salary does not change then why include the months in the time dimension? You only need months if the salary may change dur...

Do you have months on your data or you want it to be distributed to all months? If so just add 12 lines for Jan to Dec... or use loop Hi Chesteronrada, i want it to be distributed to all months Thansk for the advice,i will try it..hope it works Abyway,what do you mean by loop? I have no idea on doi...

chesteronrada wrote:Do you have months on your data or you want it to be distributed to all months?
If so just add 12 lines for Jan to Dec...
or use loop

Hi Chesteronrada,

i want it to be distributed to all months

Thansk for the advice,i will try it..hope it works

Hi, Year Branch EmployeeName Grade Base Salary 2012 Branch KL A Chris Grade 1 2000 2012 Branch KL B Richard Grade 2 3000 2012 Branch Pahang A Katie Grade 3 4000 I have above data in excel, I would like to upload the data to cube using TI My cube have dimension Time Branch Grade Base Salary Measure T...

Or you can also create a brand new hierarchy tree for all the "last 6 months" consolidations as in:

Hi csjean,

Can we create multiple hierarchy in a single Date Dimension?

hello, I think Alan might be getting toward a TI to construct the DATE dimension overnight to take the following if current month = "JUN" -then last 6 month figure would be summation: --JUN --MAY --APR --MAR --FEB --JAN Hi ellissj3 But the Date Hierarchy in my cube should be +FY 2011 +Q1 ...

As you've found you could do it through rules, but to be honest I wouldn't. Consolidations are going to be much better performance-wise, and considerably more transparent to users. I'd be more inclined to schedule a TI which ran overnight at month end and created/recreated a consolidation using the...

Hi, I have one problem where i want to sum up last six month figure. Example: Let say current month is July, and the closing balance for july is to add figure for july+jun+may+apr+mar+feb. I can use attribute (attrs) to do this , that is will add 6 attrs in the Date Dimension. Attr 1: Prev Month Att...