Skip to Content
0

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

Dec 02, 2016 at 12:19 PM

62

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers