Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Build bip template when xml have nested levels

Received Response
41
Views
2
Comments
Rank 4 - Community Specialist

Summary

Build bip template when xml have nested levels

Content

Hi All

I am trying to build an age analysis template from the Aging from the Aging - 7 Buckets - By Account Report. The xml is attached and the template thus far built. The results of the template as it stands now is correct however I only want data extracted for two of the INV_TID. I am getting all the records for all INV_TID's (Accounts).

The problem is that the INV_TID values lies in an upper level in the xml layout and it is only presented once for each INV_TID (Account)

You will see there are multiple INV_TID's and for each one the listed customers and there balances. As example I only want all the customer data as in my template that relate to INV_TID 01 00 00 000 60150 000 000 and 01 00 00 000 60154 000 000.

All other records should not pull into the data results.

How can I achieve this?

Any help would be most appreciated.

 

Thanks

 

Cheryl

 

 

 

 

Version

BIP 12.2.1.4.0

Annotation 2019-03-13 140902.png

Tagged:

Answers

  • Rank 6 - Analytics Lead

    You can try Conditional Formatting and use IF Condition to display only values corresponding to INV_TID values you desire. Though INV_TID is at higher level you can fetch value for the same into your for each group.

    Something like this...

    <?for-each@section:TEST1?>
    <?if:INV_TID =’01 00 00 000 60150 000 000’?>

    Fields you want to display
    <?end if?>
    <?end-for-each ?>

    Refer below for this

    https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-04477E49-F671-4BF1-8353-06A7CDEAD2CC.htm#BIPRD2481

  • Rank 4 - Community Specialist

    Thank you for your post Suresh. I was however able to achieve what I wanted with the following command. <?if:number(../../SORT_FIELD2)<2000 and TOTAL_CUST_AMT != ''?>

    Regards

     

    Cheryl

Welcome!

It looks like you're new here. Sign in or register to get started.