In RPD joining issue for month end date

Question

In my rpd I am trying to join my time_dimension table with my required fact table.

In my fact table date wise data is there.Data is cumulative and the month_end_date data shows

the cumulative data for the month.

how can i join the 2 tables so that i can get the data in the output for month_end_date alone.

Thomas Dodds · Answer

Dimensional aggregate rule for time should be LAST (others set to SUM) ... then pick a month - would return last day row for that month.  But then you won't be able to SUM across time ... a logical fact star answers a specific set of questions - you may need more than one logical fact star to satisfy your business requirements.

Robert Angel · Answer

Hi,

if the last day is or can be flagged explicitly, or can be identified by logic in some way, then you could apply a filter to the dimension in question to only display the last day of each month.

You could also create a copy of your existing measure and put some case logic on that to make the value zero unless the month was the last day of the month, provided as I said you can identify the last day of the month (I am not sure if we are taking about true calendar months or financial months)

3018071 · Answer

I can apply like that,but it is needed to be joined in the RPD level.else as it is a sum, the value is getting summed up for all the 30 days
in the report.
 I need only the last day's record in my report.

apart from that i have one more 'band' column in the output that i am calculating on the basis of this column,so it is fetching wrong record set.

Is there any way to achive it in the RPD level itself..