Oracle Analytics Cloud and Server

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

Unique field name values problem

Question
11
Views
0
Comments

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?