In RPD joining issue for month end date

3018071

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.

Joel

In your time dimension, if you have a column which indicates that the date is a month end, then you can quite simply apply a filter in your report to return facts for month end dates only.

3018071

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..

Robert Angel

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)

Thomas Dodds

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.