You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can we have an alias in OTBI Analysis Subject Area

edited Nov 5, 2019 9:49AM in Reporting and Analytics for ERP 3 comments

Summary

Can we have an alias in OTBI Analysis Subject Area

Content

Can we have an alias in OTBI Analysis Subject Area like below, or is there another way.

 

SELECT SubjectArea1.s_1 s_1
FROM
(
SELECT
   0 s_0,
   "Fixed Assets - Asset Depreciation Real Time"."Depreciation Details"."Cost" s_1,
   "Fixed Assets - Asset Depreciation Real Time"."General Information"."Asset Number" s_2
FROM "Fixed Assets - Asset Depreciation Real Time"
WHERE
(("Ledger"."Ledger Name" = 'SAGT_PRIMARY_Ledger') AND ("Fixed Assets - Asset Depreciation Real Time"."Depreciation Details"."Depreciation Source Code" = 'D') AND ("Fixed Assets - Asset Depreciation Real Time"."General Information"."Asset Number" IN ('3', '100152'))) 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!