Skip to Content
author's profile photo Former Member
Former Member

BW query with mandatory variable not useable in WebI

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 27, 2012 at 03:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.