cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Analytics cloud - unbooked members in live connection query dimension

Viktor1616
Explorer
0 Kudos
176

Hello,

I have live connection to BW4HANA system. There is dimension on which i want to set a filter (by range). The problem I'm facing is that whenever I try to set up  a fixed date filter on this dimension, I get following error. 

Viktor1616_0-1760432935391.png

So I checked the data in SAC model and there are quite a lot of unbooked data contains date that have no values for key figures. I gues these unbooked members are reason why I'm having problem with a filter ?
I checked the query designer, try to add zero suppress for rows and cols, but still without a change. 
Is there some option in BW query to turn off sending of these unbooked data ? Is there some solution for this problem ?

Thank you for your answers, 

The characteristic I want to filter is a custom one, here are the settings:

Viktor1616_1-1760444394035.png

 





Accepted Solutions (0)

Answers (0)