Categories
- All Categories
- 168 Oracle Analytics News
- 34 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.8K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 13 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Build bip template when xml have nested levels

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
Answers
-
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
0 -
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
0