How to get last week data when the data posted with a week+1 number in hana calculation view.

[former_member233898]

Hi Experts,

We have a requirement.

1.In HANA, a Data file will be posted every week Friday with the next week number. When we run a report in the next week, we get the data posted on last Friday.

2. If we give last week number in the selection, we have to get the same data posted on last week Friday.

Ex:

Data posted on Friday(week 44)....saved in HANA with week number 45.

when we run report in week 45, the data posted on week 44 will show.

If we select week 44 , we will get the data posted on week 43

but we want data posted on week 44.

If we select week 43, we will get the data posted on week 42.

but we want data posted on week 43.

A calculation view was already created to get data as mentioned in point 1.Input parameter was created and based on the input,output data will be filtered .

we are trying to achieve point 2.

Please reply with a solution. Please let me know if you need more information.

Thanks,

Jyothirmayi