SAP BI 4 WebI - Connecting to a Bex Query with hierarchical data

WebI - Connecting to a Bex Query with hierarchical data


In WebI as you already know is possible to connect to SAP Bex as data source and taking advantage of hierarchy set up  with related dimensions in order to explore hierarchical data, this is also possible form WebI Rich Client (version 14.0.0; build 760).


On the left side of the following  page you will select the Bex query with hierarchy
while on the right you will select the quert with multiple hiearchies
Then select the hierarchy  (1st pic) and a measure (2nd pic)




In the following picture you can see the query result,



by clicking on the plus sign you can expand the customer type hierarchy


By editing the query and clicking on the member selector list


You can explode and then  select all the hierarchy levels by clicking on the specific button



As you will see with this operation you will make visible all the hierarchy levels in the report tab:


Comments

  1. AnonymousJuly 27, 2017 at 7:26 PM

    thank for good post and sharing......
    หนังออนไลน์

    ReplyDelete
  2. dhanueshAugust 10, 2021 at 12:43 AM

    Looking for the best SAP BO Training in Bangalore, then don't delay join IntelliMindz SAP BO Training in Bangalore. Join our SAP BO training to get hands-on training and practice in SAP BO Software. Any Queries call @ 9655877677. IntelliMindz is the best IT Training Institute in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
    SAP BO Course in Bangalore
    SAP BO Course in Chennai
    SAP BO Online Course

    ReplyDelete
  3. UnknownDecember 17, 2021 at 7:22 PM

    getting your website the growing and interesting to read. I have much to learn from you. thank you
    online poker

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more