Can we have an alias in OTBI Analysis Subject Area
Summary
Can we have an alias in OTBI Analysis Subject AreaContent
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')))
0