Blank records are showing as '0' in Analytical View

[Former Member]

Hi,

     How to avoid blank records not to be shown as '0' in Analytical View?  Can you please help me on this?

For your information: from the above image, there's no data for column 3 for Fiscal Period 005 - 012 but it's displaying as '0' rather than showing it as blank while I do a data preview of an analytical view.

Regards,

Antony Jerald.

[former_member182302]

Hi Antony,

Did you check at the table level that records are 0 or blank? Can you share that screenshot too?

And also is that column a measure column?

Regards,

Krishna Tangudu

[Former Member]

Hi,

     The analytical view generated in Hana is based on Bex query imported from BW.

     Actually I'm calculating Year till date (YTD) Last Year(LY) Sales, TY(This year) Sales based on posting period.

     In Bex query for YTD Sales last financial year data its posting period would be from 1-12(ie., for the entire last year what's my sale).

      While doing calculation for YTD current year, since we are in posting period 4 which is july month(i.e,calculation would be from 1-4), rest of the month's would not have any data for YTD Current year.  It's showing as blank in Bex query.  But hana analytical view is displaying as '0' which ideally should come as blank. 

     Kindly let me know how can we handle this.

Regards,

Antony Jerald.

[Former Member]

Hi Antony,

That is the natural behavior of a measure. It will show zero by default.

Thanks and Regards,

Jerry

[Former Member]

Hello Jerald,

To avoid the 0's in the output you might wanna use the below logic in the calculation column,

IF("FISCAL_PERIOD"=0,NULL,"FISCAL_PERIOD")

But even with this logic you get a "?" in the out put. But when the view is consumed for reporting the "?" will be replaced with null.

Regards,

Krishna.