Hi all,
I’m trying to create an information space based on a universe which uses a BEx query with a mandatory prompt input based on a list of values (free text entry is not allowed).
- The universe works fine in WebI and lets me create reports.
- I can see the universe, all objects and the list of values with the correct entries when I create an information space. I can also select a value from the lov, but in the next step I get the following error message:
Server error occurred while submitting the prompt inputs. (PS 50202)
Details (sorry, in German):
Datenbankfehler. Der Datenbankfehlertext lautet: Fehler beim Ausführen der MDX-Abfrage. Ursache: Für Merkmal 0FISCYEAR bitte Wert in zulässigem Format eingeben. (WIS 10901)
From what I understand, the format of the selected prompt value seems to be wrong, but as mentioned above, I can use tis correctly in WebI reports.
I tried to create information spaces with prompt inputs based on efashion and island resort, and this worked perfectly fine, so the actual indexing works.
The problem only occurs with BW universes.
System configuration is:
BOE Edge XI 3.1 SP2 FP 3.5 (Version 12.3.5.925) on Windows 2000 6.0
Does anyone have a clue how to solve this?
Thanks and cheers
Felix
felixkrul (BOB member since 2011-07-13)