Skip to Content
0
Former Member
Oct 18, 2011 at 02:56 AM

Values in WEBI prompt not the same as available value in BEX

51 Views

Hi all,

I have a prompt for infoobject 0CALMONTH. In the cube (and BEX) I only have the following data:

201001 (Jan)

201011 (Nov)

201012 (Dec)

201101 (Jan 2011)

But when I run WEBI, the values displayed in the prompt is showing the following:

201001 (Jan)

201002 ??

201003 ??

201004 ??

201005 ??

...

...

...

201011 (Nov)

201012 (Dec)

201101 (Jan 2011)

Does anyone know why am I getting all these extra months between Jan 2010 and Nov 2010 in the prompt value?

Is there a way not to show these dates, because if the user select any of these phantom dates then obviously the report won't return any results.

Thanks,

Shafiq