Skip to Content
avatar image
Former Member

HANA CV data preview show correct value but Analysis show wrong

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 03, 2017 at 07:32 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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 :)

  • avatar image
    Former Member
    Jan 05, 2017 at 10:52 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded