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

[Former Member]

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

[arijit_das]

do you have any measure object in webi report showing extra months ? if not, add one measure and refresh the report.

[Former Member]

Hi,

No, in the report it is showing correctly:

201001 (Jan)

201011 (Nov)

201012 (Dec)

201101 (Jan 2011)

It's just the value in the prompt for 0CALMONTH that has those extra months (value when the prompt is loaded and when clicking on 'refresh'.

[Former Member]

Check if the settings of the 0CALMONTH infoObject are set to "master data" instead of "values in InfoProvider":

-Query Def Filter Value Selection

-Query Execution Filter Val. Selection

Beware that this is a global change that will impact other reports using the infoObject.

[Former Member]

Hi Victor,

I tried this and all 0CALMONTH value is displayed, which is not what I need. Then I tried using 'Only values in Infoprovider' for both fields. But the problem persist.

I got this note from SAP: 1614245. Might be the cause.

-

---

1614245 - Prompts on date ranges return values outside the given range in Web Intelligence reports based on a SAP BW data source.

Symptom

If a condion or prompt has been defined in the Web Intelligence query panel containing a date range, some values are returned in the report which are outside the given date range.

Using the operators Between, Not Between, Greater than or equal, Greater than, Less than or equal, Less than with a query based on a BW data source.

Environment

Web Intelligence XI 3.1

SAP Netweaver BW 7.x

Reproducing the Issue

Create a Web Intelligence report based on a Bex query.

Use a date object, e.g. 0CALMONTH

Create a prompt in the Web Intelligence query panel, using the Between operator.

Run the report and fill the prompt values, e.g. between 06.2011 and 07.2011

The results in the report contain values outside this range, e.g. 07.2010

Cause

MDX interprets a DATS object coming from BW as a character string. Therefore the list of values is sorted in alphanumerical order in stead of chronological order.

As a result, it will return all values between the two selected values of the alphanumeric list.

e.g.

06.2011

07.2010

07.2011

Note: This is a limitation of MDX. In Web Intelligence 4.0 the correct values are returned for date ranges, because MDX is no longer used.

Resolution

Workaround:

Define the condition/prompt with the In List operator in stead of Between.

Keywords

Webi; wrong; incorrect; too many; retrieve;

Header Data

Released on 26.07.2011 18:04:33

Release status Released to Customer

Component BI-RA-WBI Web Intelligence

Priority Normal

Category Problem

Product

Product Product Version

SAP BusinessObjects Business Intelligence platform (formerly SBO BOBJ ENTERPRISE XI 3.1

-

---

Edited by: shafiq shamsuddin on Oct 19, 2011 4:14 AM

[Former Member]

Is there a way to control or validate the values to be displayed in the prompt, in the universe itself?