on 05-29-2006 10:19 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.