Skip to Content
avatar image
Former Member

question on universe refresh

Hello all,

I have a universe over BEX query. If my bex query changes , i have to refresh the universe to catch up the changes.. My question is if a new charectaristic comes into Bex query and replicated into universe. If i save the universe , will the web i reports still work?

If a new charectaristic comes into bex query and the universe is refreshed and saved to cms.. will all the webi reports lying on the universe work properly..i had faced this error long back..my new client is looking for a solution on this..could you please suggest me on this, how it works and what will be maintanence issues..

thnaks

Prashanth

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jun 09, 2010 at 06:12 PM

    With the latest release (XI 3.1) there are substantially better controls on how a universe over a cube works. The universe designer is prompted for changes and can react.

    But the bottom line is that adding objects to an existing universe should not impact any existing reports. That should be true whether it's a cube or relational source. It may be that under the old versions (where a cube was essentially dropped and rebuilt to handle changes to the cube structure) that there were issues with Web Intelligence reports. I don't think that should happen with the current release.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Normally when you refresh the universe, the WebI document keeps a reference to universe objects even if the names or definitions have changed.

      But if you are using objects in a WebI document that have been deleted from the Bex query, then the WebI query will remove obsollete objects and of course will impact WebI document.

      So one of the recommended path is to use the WebI change source feature to remap obsolete objects to other objects coming from the same universe.

      The other way is of course to modify WebI document in order to take into account BEx query and universe changes.

      This is a standard WebI behavior and it is not related to SAP BW.

      Didier

  • avatar image
    Former Member
    Jul 07, 2010 at 08:25 PM

    I added Restricked key figures and calculated key figures and I when I run my webi report I get this error message:

    Query 1 - Maintenance Orders Maintenance Plan and Actual - Regular Hours

    A database error occured. The database error text is: The MDX query SELECT { [Measures].[4IDV96Q35XYNK4WT6ECMO487E], [Measures].[4IDV96IEMZCY1IDD0KAAE29HM], [Measures].[4IDV96XROWKD2RG9C8EYY66X6] } ON COLUMNS , NON EMPTY CROSSJOIN( [0COORD_TYPE].[LEVEL01].MEMBERS, [0PMPLANGRP].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES [0COORD_TYPE].[20COORD_TYPE], [0PMPLANGRP].[20PMPLANGRP] ON ROWS FROM [ZPM_M04/ZPM_M04_REGULARHOURS] SAP VARIABLES [!V000002] INCLUDING [0BUS_AREA].[75] [!V000001] INCLUDING [0MAINTPLANT].[7500] [!V000010] INCLUDING 1/1/2007 12:00:00 AM : 7/6/2010 12:00:00 AM failed to execute with the error Unknown error. (WIS 10901)

    I see the universe in the query pane and I am and I see LOV and run query button.

    What do I have to do in the universe to get this fixed

    Thanks for your help

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2010 at 04:12 PM

    Thank you for the response.

    I need to know what I may have done in the universe that is not allowing me to run the reports.

    Nothing was deleted in BEX

    What have I done wrong?

    How can I fix it or troubleshoot it?

    Has anybody else encountered this problem?

    If so how did you fix it?

    Thanks for your help

    Mike

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2010 at 08:17 PM

    got the required Info

    Add comment
    10|10000 characters needed characters exceeded