BW query with mandatory variable not useable in WebI

[Former Member]

Hi,

we have a BW query which has a mandatory and an optional variable / parameter. The Query is working perfect in Bex, but when building a universe and a webi report on this universe, always the following error occurs:

A database error occured. The database error text is: Die MDX-Abfrage SELECT { .[DC59N8GR349ERCCV3ZHIFFWGC] } ON COLUMNS ; NON EMPTY .[LEVEL01].MEMBERS ON ROWS FROM SAP VARIABLES INCLUDING .[V62009001] konnte nicht ausgeführt werden. Fehler Specify a value for variable MMEP_FISCPER. (WIS 10901)

The query is enabled for external access (By OLE DB for OLAP). When using only optional variables, this problem does not occur but the restrictions are respected.

Thanks,

Florian

[Henry_Banks]

Hi,

is there a problem with the default value on the fiscal period variable? (outside of range?)

or did the user input provide a response for MMEP_FISCPER that contradicted 0FISCPER.V62009001 ?

Regards,

H

[Former Member]

no, there is no Problem with the variable. It is working fine e.g. in Crystal Reports with this value.

[Henry_Banks]

Hi,

As the warning suggests, I have my doubts about the validity of that value.

What happens when you test this BEx query in RSRT ?

What happens when you test this MDX statement in MDXTEST ?

Regards,

H

[Former Member]

Hi

I post the error once again. I made an easier query and i saw that last time the forum did some strange things.

A database error occured. The database error text is: Die MDX-Abfrage 
SELECT { [Measures].[DC59N8GR349ETCCV3ZHIFFWGC] } ON COLUMNS 
 FROM [ZTESTM01/Z_ZTESTM01_TEST5_VARIABLE]
 SAP VARIABLES [!V000002] INCLUDING [0FISCPER].[V62009001] 
 konnte nicht ausgeführt werden. Fehler Specify a value for variable
 MMEP_FISCPER. (WIS 10901)

The query runs perfect in RSRT.

When i put the statement

SELECT
{ [Measures].[DC59N8GR349ETCCV3ZHIFFWGC] } ON COLUMNS 
 FROM [ZTESTM01/Z_ZTESTM01_TEST5_VARIABLE]
 SAP VARIABLES [!V000002] INCLUDING [0FISCPER].[V62009001]

in MDXTEST, it gives a result.

Best regards,

Florian

[Former Member]

Another thing you maybe need to know is the code of the filter in universe designer which can be found under "Where" in Properties of filter:

<FILTER KEY="[!V000002]"><CONDITION OPERATORCONDITION="Equal">
<CONSTANT TECH_NAME="@Prompt('Geschäftsjahr/Periode(Einzelwert, 
Pflicht)','A','Geschäftsj./PeriodeLovGeschäftsjahr/Periode (Einzelwert, Pflicht)
Base',mono,primary_key)"></CONSTANT></CONDITION></FILTER>

(I just made some line brakes so that you can read it easier)

Edited by: Florian Schwaiger on Jan 31, 2012 9:05 AM

[Henry_Banks]

hi,

sorry for not getting back to you sooner.

1. to qualify this issue a little better, could you tell me you BO version , SP level, and any FixPack / Patch you might have implemented? i.e. XI 3.1 SP4 FP4.1

2 Also, how about your BW version, EHp level, and SP level? i.e. BW 7.01 SP10

Do you have any significant correction notes for component BW-BEX-OT-MDX implemented?

3 Have the 'up to date' SAP Integration Kit TRANSPORTS been imported into the BW? (released every FP/Patch interval)

4 Have you made any modificaitions to the Filter Variable syntax in the universe?

5 in the prompt, is there a difference in beahviour between a) entering value manually (typing) or b) selecting from list?

Regards,

H