Skip to Content
avatar image
Former Member

Getting zero as display in Design Studio

I have created a calculated column(attribute) in calculation view in SAP hana (a/b)*100 where a and b are counters from some other calculation view .I want to display this value in my cross tab in Design studio. I am getting values in filter selection but in cross tab the values are zero. I have checked the output in Hana data preview also it's fine but in Design studio cross tab it is showing as zero.Can anyone please suggest me reason for this. Also I am getting an error in log that column storage error attribute engine :divide by zero.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 02, 2016 at 08:51 PM

    Please share version of Design Studio you are using. If you are not on 1.6 SP01, consider updating to that version as there are some related notes to this:

    https://launchpad.support.sap.com/#/notes/2268514/E

    https://launchpad.support.sap.com/#/notes/2256550/E

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 03, 2016 at 11:09 AM

    I want to add a point that when I am using the same formula a/b*100 where I changed 'a' to a calculated column instead of a counter then I am getting the correct output in the cross tab.

    Add comment
    10|10000 characters needed characters exceeded