Problem with rolling data

[kishorj1982]

hi All,

we have rolling data.For every month we are getting the flat files related to respective month.But sometime for current month file is getting delayed by 5-10 days.

Apparently ,data will not be displayed if data for that month is not there.But client still needs to view the data.

Can you please suggest the possible solution to this.

Thanks

[Anil_Babu_Samineni]

May be look Master calendar  to get all missed months , Dates ...

[luismadriz]

Hi,

You're saying that old data is not being displayed when the current month data hasn't been uploaded?

In other words, data is only be displayed if the current month data is present?

Is that's the case, I think there must be calculations done against current month instead of max(month)...

But difficult to say without more information. Can you share more information about the data calculation?

Cheers,

Luis

[neha_shirsath]

Apparently ,data will not be displayed if data for that month is not there.But client still needs to view the data-

This means unless and until new data file get uploaded till then user want to see old data ?

[kishorj1982]

Yeah.

[neha_shirsath]

What expression/logic you are using to update new file?

Might be you are considering today's date or current month logic instead of that use max(date) in your expression.