I need to create a filter between two different time values.
Actually I need to substract the "claim service start date"(which will be user prompt) and then compare it with "Cap Pay Month" (which will be a user prompt of Month attribute - Actually here Month Id is linked to the Cap_fact table since the fact at this fact table is at Month level).
Now how do I compare these two time attributes. The report has to display all the claim data only if Claim service start date is greater than that particular Cap month
"Claim service start date" is a day attribute(attribute role) defined at the day dimension level and "cap pay month" is an attribute(attribute role) defined at the month level.
Any ideas on how to accomplish this.
Kindly give your suggestions.
Thanks
teccum.