Share
Report
3,252Hi All,
I am trying to achieve this query
{SELECT FIRSTFAST * FROM DimAttributeOMCostCenter(ds) ORDER BY DimAttributeOMCostCenter.Value ASC NOTEXISTS JOIN 'x' FROM DimensionAttributeValueLedgerView(DimensionAttributeValueLedgerView_1) WHERE DimAttributeOMCostCenter.Key = DimensionAttributeValueLedgerView.EntityInstance /
using Data entity. How can I achieve this? I tried it but when I see the design from sql it is return this:
/SELECT T1.RECID AS KEY_, T1.OMOPERATINGUNITNUMBER AS VALUE, T1.PARTITION, T1.RECID, T2.NAME, T2.PARTITION AS PARTITION#2
FROM dbo.DIRPARTYTABLE AS T1 INNER JOIN
dbo.DIRPARTYTABLE AS T2 ON T1.RECID = T2.RECID AND T1.PARTITION = T2.PARTITION
WHERE (T1.OMOPERATINGUNITTYPE = 2) AND (NOT EXISTS
(SELECT TOP (1) ' x ' AS Expr1
FROM dbo.DIMENSIONATTRIBUTEVALUELEDGERVIEW AS T3
WHERE (ISSUSPENDED = 1) AND (T1.RECID = ENTITYINSTANCE) AND (T1.PARTITION = PARTITION))) AND (T1.INSTANCERELATIONTYPE IN (10781))/
FROM dbo.DIRPARTYTABLE AS T1 INNER JOIN
dbo.DIRPARTYTABLE AS T2 ON T1.RECID = T2.RECID AND T1.PARTITION = T2.PARTITION
WHERE (T1.OMOPERATINGUNITTYPE = 2) AND (NOT EXISTS
(SELECT TOP (1) ' x ' AS Expr1
FROM dbo.DIMENSIONATTRIBUTEVALUELEDGERVIEW AS T3
WHERE (ISSUSPENDED = 1) AND (T1.RECID = ENTITYINSTANCE) AND (T1.PARTITION = PARTITION))) AND (T1.INSTANCERELATIONTYPE IN (10781))/
Any hint?
Categories:
All responses (
Answers (
