WAD in Nested iview, Visual Composer

[Former Member]

Can i use the hierarchy in an nested iview?

I have made a selection list in an Nested iview and the several tabs in an another nested iview. Now i would like to get the WAD hierarchy application in my model.

How can i get this? I know that it's not possible to add a HTML ia Nested iview.

Is any solution?

Thanks

[Former Member]

Wrong, you can use hierarchies in a WAD iView, that you integrate in the VC application via a HTML View control. Prakash wrote a couple of documents, e.g. this one:

How to Integrate Visual Composer Applications and BEx Web Templates

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ad182ac7-0a01-0010-4fb8-8a4...

and here is one from Shan:

How to Model SAP BI System Hierarchies in Visual Composer

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/4155b345-0a01-0010-ac9f-b3b...

if you want to use hierarchies directly in the VC. I elaborate the hierarchies even more in my book: https://wiki.sdn.sap.com/wiki/display/VC/SAPNetWeaverVisual+Composer

[Former Member]

Dear Mario,

Thank you for the links. I think i was not able to explain clearly my problem. I mean the hierarchy use in the Nested iview of VC. I have already read the guids of Prakash and made the hierarchy of location. I can do it wel in an iview(VC) with HTML view, but not in an Nested iview. Then i get an error like this:

"HTML views cannot be used inside nested iviews. Element wil be ingonerd".

I like to do the innested iview, because i have alredy made a model in nested iview

Can you help me please?

Thank you,

regards,

Esrat

[Former Member]

Hi Mario,

I am reading your book now, and I assume the page 364 of passing values on Hierarchy is talking about this solution. I tried the method in this page, but I could not get the Hierarchy node filtered dynamically. My VC module is finding data from a BI query (revenue by GL account), and sending out a result of Revenue by a bar Chart. Basically I need to do is allow the user to filter the result by GL hierarchy node. (I don’t need to display GL hierarchy itself in the result)

The WEBAPI formula I am using is ‘IOBJNM=0GL_ACCOUNT; VALUE&@AREAS&’, AREAS is my BI query GL Hierarchy node variable. Could you please let me know if it is the right page to read or anything more I need to setup?

Thanks,

Liang

[Former Member]

I think you concatenate the value incorrectly; first you have a space between the semicoln and the parameter Value, then you have the value to eb assigned inside the quotes. You do not assignt eh value, but the name of the value (which is AREAS). And then you are missing the equals-sign.

I guess you want this syntax:

‘IOBJNM=0GL_ACCOUNT;VALUE=&" & @AREAS & "&’

[Former Member]

Hi Mario,

Thanks for your reply. It is still not working for me. I am wondering if I am saying my request clearly, and if I am understanding the book you wrote clearly.

My VC module is getting data from a BI query in a nested iview. The query contains a hierarchy node variable, technical name AREAS. My VC users need to filter the result by GL hierarchy node, similar way like BEx GL hierarchy node variable.

In the VC module, this query input form has a drilldown list field of 0GL_Account like the book you wrote in page 366, and SUBMIT WEBAPI syntax is ‘IOBJNM=0GL_ACCOUNT;VALUE=&" & @AREAS & "&’ like you told me.

You didn’t mention how to setup the configuration of the property of drilldown list 0GL_ACCOUNT in the Input form in your book. I am assuming it is Dynamic entry list. What are the correct Assigned Value for Input Port Input field and Output portout field?

Thanks for your help,

Liang

[Former Member]

Hi Liang,

I had a look into the book and I find another example on page 366, but I think formula is correct. But if you have further questions about the Web API have a look into the <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b1089290-0201-0010-288c-98e4d26487ee">Web API Reference for BW 3.5</a>.

Best Regards,

Marcel

[Former Member]

Hi Marcel / Mario,

1. did you put Hierarchy node variable in the formula? Is the Hierarchy node variable technical name AREAS?

2. how did you setup the property of the Input form drip-down list field (like 0GL_ACCOUNT), is it Dynamic entry list? What are the Assigned Values for Input Port Input Output port

Those are not mentioned in the book.

Thanks,

Liang