Developing Essbase Applications

Slay Bad Data in Essbase  •  63

Years = 'Curr Year' AND

[Time] = 'Jul'

GROUP BY Years, [Time]

--Retrieve the values exported from Essbase

INSERT INTO @Validate

SELECT

Years,

TimePeriod AS 'Time',

2,

OriginalPrice AS 'Original Price',

PricePaid AS 'Price Paid',

Rtns AS 'Returns',

Units,

Transactions

FROM <%=odiRef.getObjectName("ValidateASOsamp")%>

--Do the variance

TRUNCATE TABLE <%=odiRef.getObjectName("ValidationVariance")%>

INSERT INTO <%=odiRef.getObjectName("ValidationVariance")%>

SELECT

F.Years,

F.[Time],

F. [Original Price] - E.[Original Price] AS 'Fact vs. Essbase

OP Var',

F.[Price Paid] - E.[Price Paid] AS 'Fact vs. Essbase PP Var',

F.[Returns] - E.[Returns] AS 'Fact vs. Essbase Rtns Var',

F.Units - E.Units AS 'Fact vs. Essbase ...