Skip to Content
Introduction

This BLOG discusses alternative options to use BI Hierarchies within Visual Composer! Moya Watson wrote a great blog here: Model BI Hierachies with Visual composer. I’m going to discuss how to use hierarchies from the WAD within Visual Composer

Technical Details

All the technical details are included in my how to guide to implement this scenario. It works based on portal eventing technology. This how to guide is geared towards a no code approach.

Advantages

The advantages to using this approach are that you can integrate via a button to call WAD dialogs to choose multiple hierarchy nodes or you could use a UI element to embed hierarchy selection directly within your Visual Composer models. Examples of both options are displayed in the how to guide.

Here’s an example of hierarchy dialogs:

image

Here’s an example hierarchy UI elements from the WAD

image

Summary

This guide shows how to integrate any UI Elements between Visual Composer and the Web Application Designer without having to write custom code. You can build a nested template and use this code in reusable applications! In addition, this is supplemental to Moya’s hierarchy solution so now you have multiple options for hierarchies!

To report this post you need to login first.

11 Comments

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

  1. Thomas Verstraeten
    Hi,

    I’ve used your WAD hierarchy integration in some of my visual composer applications and it works great.

    Currently I’m working on a much bigger application and I have therefore split-up the application in several nested iviews to overcome the 32K limit. I found however that I can’t use your solution anymore in this case, as I get an error saying that you cannot use HTML views within a nested iview. Do you know if there is a workaround for this ?

    Thanks
    Thomas

    (0) 
    1. Prakash Darji Post author
      Hey. This solution wouldn’t work with nested iViews as HTML iViews aren’t supported there. Unfortunately, there isn’t a workaround for this. The 32K limit is removed with a later version of Flex which will be added to the next release of Visual Composer.
      (0) 
  2. nichel jangiti
    Hellow Mr. Darji

    I have tried to use One of the Hierarchy Quire y in visual composer. But it gives no application data available. But i see the heirarchy data when i execute it in the business analyzer

    (0) 
    1. Prakash Darji Post author
      Hey,

      I haven’t had any other people complain of this issue. I would make sure you’re using the latest how-to guide. Additionally, this guide is setup for hierarchies that aren’t using postable nodes as parents (0HIER_NODE text nodes are parents). If you are using it for hierarchies where postable nodes are parents, then you will need to change the web api commands to handle that scenario.

      Cheers,
      Prakash

      (0) 
  3. GILSON TEIXEIRA
    Dear Mario,

    Dear Friend,

    I would like to ask you a question. In my report in Query Designer I set ‘Display as Hierarchy’ ‘active’ and I choose a characteristic in ‘Expand to’. I am not talking about hierarchy of an InfoObject but hierarchy in a Query Designer level (in Rows or Columns). Question: how could bring such hierarchy to Visual Composer and if negative how could I ‘simulate’ such hierarchy in Visual Composer?

    Best Regards,

    Gilson Teixeira

    SAP BI Consultant – Brazil

    (0) 
    1. Prakash Darji Post author
      This isn’t natively supported. The workaround is that you could use the Web App Designer table to show the display hierarchy and use eventing between the table element and VC.
      (0) 
  4. Ravi Kalidindi
    Hi Prakash,

    I have tried a example mentioned in the how to and worked successfully when i use Flash Compiler but does not run on Flex 2 complier. Is there a limitation on using flash compiler.

    Thank you,
    Ravi.

    (0) 
  5. Ravi Kalidindi
    Hi Prakash,

    I am using a dropdown from WAD and passing the values as filter to a query.

    When i am using infoobject 0PROFIT_CTR, it works fine. When i am using 0SALESEMPLY i am getting the following message in the flash debugger:
    “Number of rows in OUTPUT is: undefined” and the query result in the table is blank.

    I increased the number rows in the output port of the query, but still facing the same issue. Can you please tell me where i am going wroung.

    Thank you,
    Ravi.

    (0) 

Leave a Reply