Overcome limitations around using BI Hierarchies in VC by using UI elements from WAD…
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:
Here’s an example hierarchy UI elements from the WAD
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!
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
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
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
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
Regards,
Gilson
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.
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.