Skip to Content

This is part-2 of How to fix Web Intelligence errors using BEx based Universe? Soon, I will consolidate it as an article on the most common errors we are facing in Webi Intelligence reports based on BEx query.  

 

Supplied XML is not valid

The following error is common, when we tried refreshing the report in Web Intelligence based on BEx query universe. The reason for the error that the Universe created from BEx query is not up-to-date. It might happen due to the object (Characteristics / Key Figures) which was used in the BEx query is replaced / removed.

 image

 

Resolution 

  1. Open Universe Designer -> Universe Name
  2. View -> Refresh Structure
  3. Update OLAP Universe Wizard appear, Click Ok
  4. Save and Export the universe to the repository

image

 

#TOREFRESH Error

We will be receiving #TOREFRESH error when we use the OLAP Universe based on BW query or CUBE. It will be an issue when we schedule the report and we need to refresh again, if we get this error.

 image

Resolution 

  1. We can ensure number of objects in the query panel should be used in the block at the report level
  2. At Universe, apply the Sum, and the properties to set the correct projection instead of Database delegated
  3. Report level variable by applying Sum ()

image

Please refer Part 1 : How to fix Web Intelligence errors using BEx based Universe?

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. P M
    I’d love to know the case for database delegated, from my experience is only a source of troubles difficult to explain to users and always “turned off” as you described
    (0) 

Leave a Reply