TM1 Forum

I have a cube that has dollars & hours by pay periods. I would like to have the ability to select a start date & end date which the result will sum the data within those pay periods dates which may cross years. How would I go about writing a rule?

Thank you in advance.

It seems to me that one possible solution may be to edit your time dimension structure so that you have an element that stretches more than one time period/year to sum up the values for you. You may also want to create a start and end date element in your measure dimensions that will read a "1" on the start date and will continue to read "1" until the end date. This way you can take your dollars & hours by pa period and multiply by this start/end date flag and use the multiple period consolidated element you created in the first place to sum up those total values. Does that help? I am not sure if that is very clear or not.

Mastertito4...it does help. You have given me an idea.

Thanks again.