Skip to Content

WebI Report on SAP BW Query Universe shows error Message

Hi,

I build a universe on a SAP Query und developed a WebI Report on top of that. With a SAP_ALL user everything is fine. But then I tried it with a user and its rolls decribed in the Best Practice Guide and I Recieved the following Error:

Datenbankfehler. Der Datenbankfehlertext lautet: Die MDX-Abfrage SELECT { .[4B5IPTSAQ8V8UTEVIADGC2NWX], .[4B5IPTKM7A9JC6VFCGB420P75], .[4B5IPUUPD1VSFY44BGP5QCHHT], .[4B5IPTZZ97GYDFYBO4FSM4MMP], .[4B5IPU7NS62NW2HRTYI4W6LCH], .[4B5IPUFCB4ODEP17ZSKH68K29], .[4B6HSC27R5177KZU77OUK5K7L], .[4B5IPW4SITI1JPCTAH37EO9SH], .[4B5IPTCXOBNTTKBZ6M8RRYQHD], .[4B5IPVHQXXOWZTQGSYW6KIDN5], .[4B6HTFBKNZZMESEG0VNLY6ZYP], .[4B69NESW3JU3TBXLMLYMUM0EP], .[4B6HSC9WA3MWQ7JAD1R6U7IXD], .[4B5IPV2DW0HHYKNKHARI0EG7L], .[4B5IPUN0U3A2XBKO5MMTGAIS1], .[4B5IPVX3ZUWC12TD4N0V4MB2P], .[4B5IPX775MIL4U223NEWSY3DD], .[4B5IPWRU3PB63KZ5RZA88U5XT], .[4B5IPWK5KQPGKYFPM57VYS781], .[4B5IPVPFGWAMIG9WYSYIUKCCX], .[4B5IPXMK7JQ0634YFBJLD20SX], .[4B5IPWCH1S3R2BW9GB5JOQ8I9], .[4B5IPWZIMNWVM7ILXTCKIW4NL], .[4B5IPVA2EZ37H770N4TUAGEXD] } ON COLUMNS , NON EMPTY CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( CROSSJOIN( .[LEVEL01].MEMBERS, .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), .[LEVEL01].MEMBERS ), { .[0000072801] } ), .[LEVEL01].MEMBERS ) DIMENSION PROPERTIES .[2ZRLISPFAC___F101], .[1ZRLISPFAC___F119], .[2ZRLISPFAC___F119], .[2ZRLISPFAC___F21], .[2ZRLISPFAC___F34], .[1ZRLISPFAC___F497], .[2ZRLISPFAC___F497], .[1ZRLISPFAC___F53], .[2ZRLISPFAC___F53], .[2ZRLISPFAC___F560], .[1ZRLISPFAC___F578], .[2ZRLISPFAC___F578], .[1ZRLISPFAC___F591], .[2ZRLISPFAC___F591], .[1ZRLISPFAC___F608], .[4ZRLISPFAC___F608], .[1ZRLISPFAC___F611], .[2ZRLISPFAC___F611], .[4ZRLISPFAC___F611], .[2ZRLISPFAC___F615], .[1ZRLISPFAC___F622], .[2ZRLISPFAC___F622], .[4ZRLISPFAC___F622], .[1ZRLISPFAC___F710], .[2ZRLISPFAC___F710], .[10COUNTRY], .[1PMOBJTYP], .[20COUNTRY], .[20POSTAL_CD], .[2PMOBJORT], .[2PMOBJTYP], .[2ZRLISPFAC___F720], .[5PMOBJTYP], .[2ZRLISPFAC___F734], .[1ZRLISPFAC___F735], .[2ZRLISPFAC___F735], .[2ZRLISPFAC___F737], .[5ZRLISPFAC___F737], .[2ZRLISPFAC___F738], .[5ZRLISPFAC___F738], .[1ZRLISPFAC___F752], .[2ZRLISPFAC___F752], .[1ZRLISPFAC___F804], .[2ZRLISPFAC___F804], .[2ZRLISPFAC___F806], .[2ZRLISPFAC___F807], .[2ZRLISPFAC___F808], .[1ZRLISPFAC___F82], .[2ZRLISPFAC___F82], .[1ZRLISPFAC___F846], .[1ZRLISPFAC___F851], .[5ZRLISPFAC___F851], .[1PMCAGTYP], .[2PMCAGTYP], .[2ZRLISPFAC___F852] ON ROWS FROM SAP VARIABLES INCLUDING .[20080825] konnte nicht ausgeführt werden. Fehler FUNCTION_NOT_FOUND. (WIS 10901)

Any Ideas?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2008 at 10:15 PM

    A couple of tests to run:

    1. Can you ask the Administrator user to run the report?

    2. Can the regular user run a query with only one or two objects from the same db/tables?

    These should help to give a clearer picture of where the credentials might be missing. Authorization can be configured on the BOE CMS, but it can also be erroring due to DB access rights.

    - If test 1 fails, then it's probably a DB access rights issue.

    - If only test 2 fails, then it's a CMS credentials issue.

    - If both succeed, but the original query fails, then it's probably a specific object that's causing the problems. In that case, you'll have to incrementally add or subtract objects to get to the culprit.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      We are also facing the same issue. I will also try the same steps to analyze the issue. Meanwhile please let me know if any solution found for this issue.

      -Raghu

      Edited by: Raghavendra Barekere on Nov 2, 2008 4:45 PM

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.