cancel
Showing results for 
Search instead for 
Did you mean: 

Strange issue regarding 0CALMONTH

Former Member
0 Kudos

Hi,

I am facing a strange issue regarding the use of 0CALMONTH in my query...

I want to display the months in columns and restrict it to certain values. If I select one or two values, everything is fine.

But if I choose three or four months, only the first is shown in result table and even in filter selection I cannot see the other three months?!

Five or more months is working correctly again, so I am quite confused... Of course, the data provider contains values for all selected periods.

Anyone ever seen anything like this? Any help would be highly appreciated!

Best regards,

Björn

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184494
Active Contributor
0 Kudos

Bjorn,

Is this filtering at the Query Designer level or Display level and is it on WAD or BeX ?

I had a similar issue in WAD display where the filter did not affect certain queries...

It was resolved when we did an SP.

Arun

Former Member
0 Kudos

Arun,

I restrict 0CALMONTH in Query Designer to e.g. Jan 2005, Feb 2005 and Mar 2005. Then in BEx Analyzer I only see Jan 2005, if I try to set a filter in Analyzer I also see only Jan 2005. I did not check in Web Application right now because my users are focussed on MS Excel...

BW is version 3.5 and the latest patch level is applied.

Best regards,

Björn