Start and End Date

[RLReyes]

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.

[mastertito4]

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.

[RLReyes]

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

Thanks again.