In correct aggregation in SAP HANA view

[VijayCR]

Hello Experts,

I am currently facing a strange issue with respect to the Aggregation of the HANA view . I am trying to aggregate amount sin different months to a single month.THe mounts are not added upc correctly can you please let me know if i am missing anything when i remove the fiscal year field from the Aggregation i get a strange result as shown below.

Thanks ,

Vijay.

[former_member200930 · Accepted solution]

Hi Vijay,

I think, you need to use KEEP FLAG = TRUE in calculation view. Please do the following steps in your calculation view

1. Select Fiscal Year from Aggregation Node
2. Go to Properties Panel
3. set KEEP FLAG = TRUE
4. Validate and Activate
5. Data Preview.

Please let me know your feedback.

Regards,

Vikram Divekar

[VijayCR · Accepted solution]

No it was a formula which i was using so i have first aggrgated and then used the formula the issue is resolved now