Friday, June 17, 2016

BI 4.0 Web Intelligence - Hierarchies



Definition

A hierarchy is a set of data members arranged in levels or parent-child relationships
For example, a [Geography] hierarchy might contain the [Country], [State] and [City] levels
Hierarchies produce hierarchical columns in the result set produced by the query.
You can expand the items in the hierarchy to explore its data.
For example, you can expand the [California] level in a [Geography] hierarchy to explore data related to California.
You can select which members appear in the result set by using the Member Selector.
In hierarchical data sources, hierarchies are associated with a dimension and appear beneath the dimension with which they are associated in the list of available objects.

How they work

They normally come from hierarchical data defined at database level and accessed through OLAP Universes or BEx queries.
When accessing RDBMS sources they are commonly called hierarchies, but technically they are navigational paths.

Best practices - How to's

Accessing SAP Hierarchies in Webi with Opendocument and REBEAN
Impact of a BEx query change to universes and WebI documents
Web Intelligence 4.0 and time-dependent hierarchies
SAP Notes on "Consulting" Category. Application Area-BW-BEX-OT-F4
Differences in SAP-BI (BEx) and BO Reports

Known Issues

BI 4.0 SP05
ADAPT01643457
Hide hierarchy objects in Webi BOE SP2+14 it was working now after system was upgraded to 16 & 17 is not available
ADAPT01643989
BW Hierarchy Node value selected in a prompt shows full path in HTML viewer, only the value in all other viewers/editors
ADAPT01644836
"Incorrect results in Window of ""Ambiguous Hierarchy for Drill"" in Web View mode."
ADAPT01645440
hierarchy display in WebI
ADAPT01645890
Hierarchical node default selection for variables are not supported by DSL
ADAPT01658395
Not able to see Calculated Key Figure (CKF) under hierarchy structure
ADAPT01658831
Hierarchy issue with Patch 4.2
ADAPT01668149
Cannot run duplicated queries containing hierarchical objects

Useful KBs, Notes


Webi report filters based on hierarchies display all values when none are expected
Error: "An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270) (WIS 30270)" when refreshing WEBI report with a hierarchy object.
DHTML viewer: Hierarchy node variable LOV non-responsive in a Webi report
'List of values for current prompt requires value for following prompts' in prompt in WebI coming from a BEx hierarchy node variable.
BEx hierarchy variable is displayed in a flat list instead of in a tree hierarchy structure in Webi prompt
Linked nodes of an SAP BW Hierarchy are not supported in Webi (accessing BEx query via BICS) in BI4.0
Cannot select any node as prompt answer for prompt on hierarchy object in a Webi report
In WebI 4 how to change the display of hierarchy nodes and hierarchy node values in a prompt generated from a hierarchy node variable
WebI reports incorrect after BW 7.1.5 upgrade: Cannot drill below Level 5 of Hierarchy
Sort order of hierarchy node members is not the same in WebIntelligence as the source system (SAP R/3, SAP BW)
Unable to apply a Custom Sort on Hierarchical Dimensions 
1694760Hierarchy expansion behavior set at BEx query level does not replicate in BI Launchpad

Frequently Asked Questions:

Q.: Is it possible to display parent levels at the bottom of the results (by default they are at the top) i.e.:
instead of
USA $400
Florida $100
Texas $100
Wisconsin $100
Florida $100
Texas $100
Wisconsin $100
USA $400
A: No, at present the order is predefined and cannot be customized

Source;https://wiki.scn.sap.com/wiki/display/BOBJ/BI+4.0+Web+Intelligence+-+Hierarchies

No comments:

Post a Comment