Skip to Content
0

HANA CV data preview show correct value but Analysis show wrong

Jan 03, 2017 at 06:12 PM

128

avatar image

Hi Experts

I have a calculated column MTD(Month to date) calculated from Period $ Column based on user selection.

When I do data preview in HANA studio on my Calculation view it shows me correct $ value in MTD column for all GL's but when I run report in analysis for office(2.3 SP3) it shows wrong value in few GL's.

When I run the same report in Webi it shows me correct $ amount.

Where I am going wrong here ?

Thank you for reading my post!

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

2 Answers

Tammy Powlas
Jan 03, 2017 at 07:32 PM
0

Which HANA SP are you using?

Did you see this nice blog by Justin Molenaur https://blogs.sap.com/2014/03/10/how-tocalculate-ytd-mtd-anytd-using-date-dimensions/ - it might be better to use an Analytic View

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy

I am on HANA 1.0 SP12 (version 2.2.17).

Sure I will look into the blog from Justin & see whether i have same issue with that approach.

Thank you for your help :)

0
Arjun Khatti Jan 05, 2017 at 10:52 PM
0

We found that calculated column data type was not matching with data type of source column & thats why getting above error..

Since this is fixed, closing the ticket.

Share
10 |10000 characters needed characters left characters exceeded