Skip to Content

WebI Hierarchy not displaying in-order as per in BW hierarchy

Hi BO/BI gurus,

Currently we are creating a WebI report by using Hierarchy nodes to display the Hierarchy, however, the webI report is displaying not according to BW Hierarchy due to the Hierarchy Node ID is not ascending nor descending.

As you can see, the Node ID highlighted in Red is showing the Node ID no in orderly manner, In WebI, the Hierarchy is sorted according to the Node ID, which is differ from the original BW Hierarchy.

BW Hierarchy

We would like WebI report to display as the same as the BW Hierarchy arrangement without following the Node ID.

Is that do-able?

Any Advice at all would be greatly appreciated.

Many thanks,

Vince

pastedImage_3.png (25.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jun 06, 2012 at 09:07 PM
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Simone, thanks for the kind offer to help.

      I actually found this article about WebI error message:-

      Which seems to have solved the problem.

      In case someone face this problem in the future, just to share

      If a formula or variable appears as a dimension in the calculation context of

      a smart measure, and the formula determines the grouping set required by

      the measure, Web Intelligence cannot display values for the smart measure.

      Web Intelligence cannot deduce the grouping set from a formula in this

      1. situation.

      For example, a report contains a variable, Semester, with the formula

      If [Quarter] = "Q1" or [Quarter] = "Q2" Then "H1" Else "H2"

      Placed in a block, the Semester variable returns the following result:

      Semester

      Revenue

      H1

      #UNAVAILABLE

      H2

      #UNAVAILABLE

      Web Intelligence can return a value for a smart measure when the smart

      measure is included in a formula, even when the formula requires a different

      calculation context from the context implied by the position of the formula.

      For example, a report contains a block as follows:

      Country

      Region

      Revenue

      US

      North

      10000

      US

      South

      15000

      US

      East

      14000

      US

      West

      12000

      If you include an additional column in the table with the formula:-

      [Revenue] ForAll ([Region])

      Web Intelligence initially returns #TOREFRESH because the formula requires

      the grouping set (Country). (The formula excludes regions from the

      1. calculation.) When you refresh the data, Web Intelligence adds the (Country)

      grouping set to the query and displays the measure values.

      Kind regards,

      Vince

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2012 at 07:06 PM

    Hi Vince,

    Can you tell which version of BO you are using?

    Regards,

    Venkat

    Add a comment
    10|10000 characters needed characters exceeded

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.