Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Unique field name values problem
Summary
Unique field name values problem
Content
We use PT 8.55, in dutch.
In our queries we use unique fieldname values.
example: A.EMPLID -> unique fieldname "Employee Number"
In the generated datasource we see the xml tag: "Employee Number"
In the RTF we also see "Employee Number" als one of the input fields to pick from.
But adding this field in the RTF gives us no output. (also changing it manually to A.EMPLID has no result)
We have to use EMPLID instead. (that's the xml-tage value that you see when you run the query, in query manager, and click on downloadable XML)
(when there are 2 fields in the quey with the same name (A.EMPLID, B.EMPLID) then we see for EACH field, the unique fieldname in the downloadable xml and also in the generated datasource, so in that case everything works as expected)
Is there a way to force PS to ALWAYS use the unique field names in their xml?