Double Column Prompt
Summary
Can we do double column prompt in OTBI like we can in data model?Content
In data models, we can create double column LOV similar to...
select description, id from ...
And then we can use the id in SQL instead of description for better performance. Is such a thing possible with Analytics in the cloud? I tried the following, but it didn't work.
SELECT "Workforce Performance - Performance Document Eligibility Real Time"."Assignment Manager (Unsecured)"."Manager Name", "Workforce Performance - Performance Document Eligibility Real Time"."Assignment Manager (Unsecured)"."Manager Person Number" FROM "Workforce Performance - Performance Document Eligibility Real Time" FETCH FIRST 65001 ROWS ONLY
1