Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Could please let me know I have only one group how to split into multiple sheets in oracle EBSR12
Answers
-
Do you have two iterations of G_ORG?
Do you get an error?
FYI: Please do not upload the XML data.
Thx,
Kevin
0 -
On the XDO_METADATA tab I did
Version
ARU-dbdrv
Extractor Version
Template Code
Template Type
TYPE_EXCEL_TEMPLATE
Preprocess XSLT File
Last Modified Date
Last Modified By
ABCD
Data Constraints:
XDO_MARKUP_?
false
XDO_SHEET_?
<?.//G_SUPPLIER_INDEX?>
XDO_SHEET_NAME_?
<?.//SUPPLIER_INDEX?>
Since I was using the supplier name as the Main Index I did this in the DM
end as Supplier_Name,
CASE
WHEN hp.party_name = 'ZZZZZ' THEN 'ZZZZ'
WHEN SUBSTR(hp.party_name,1,1) BETWEEN '0' AND 'E' THEN 'Suppliers 0-E'WHEN SUBSTR(hp.party_name,1,1) BETWEEN 'F' AND 'L' THEN 'Suppliers F-L'WHEN SUBSTR(hp.party_name,1,1) BETWEEN 'M' AND 'S' THEN 'Suppliers M-S'ELSE 'Suppliers T-Z'
END
SUPPLIER_INDEX0 -
What was the result?
Kevin
0
