0CALMONTH and 0CALWEEK infoobject issue in BW/4HANA

[former_member475159]

Hello Experts

I am facing a strange issue in BW4/HANA environment. I have created a simple query on top of ADSO and have check ADSO contains around 200 records

While executing the query, it return values as present in the backend provider. However the moment I am trying to bring 0CALMONTH and 0CALWEEK in drill down from free characteristics, all the data vanishes with a message 'No applicable data found'

Please let me know if you have face the similar situation and what should be the probable solution

Thanks

Deb Deep Ray

[Former Member]

This is due to inconsistency in SID table of 0calmonth. All three flag should be marked true in SID table

/BI0/SCALMONTH if value exist in ADSO.

Update:

check SAP Note 2492414 - SIDs for TimeCharacteristics are missing, when they are used as NavigationAttribute for other Time Characteristics