Error while performing drill through from HFM web form.
Hi ALL,
We are getting below error while we are performing drill through FDM on HFM web form.
Can you please help on this.
** Begin FDM Runtime Error Log Entry [2013-02-20 10:23:05] **
-------------------------------------------------------------
ERROR:
Code............................................. 7123
Description...................................... INSERSECTION SQL DEBUG
Procedure........................................ SELECT vDataFact.PartitionKey, PartName, CatName, CatTarget, PeriodKey, PeriodDesc, DataView, AccountX, EntityX, ICPX, UD1X, UD2X, UD3X, UD4X, UD5X, UD6X, UD7X, UD8X, UD9X, UD10X, UD11X, UD12X, UD13X, UD14X, UD15X, UD16X, UD17X, UD18X, UD19X, UD20X, SUM(DECODE(ChangeSign, 0, (Amount), 1, (Amount *-1), (Amount))) AS Amt From vDataFact Where (((CatTarget) = N'ACTUAL') And ((PeriodTargetM) = N'Dec') And ((YearTarget) = N'2012') And ((CalcAcctType) > 0) And ((AccountX) = N'030034') And ((EntityX) = N'51_SINGAPORE') And ((ICPX IS NULL) or (ICPX = N'') or (upper(ICPX) = N'[ICP NONE]')) And ((UD1X IS NULL) or (UD1X = N'') or (upper(UD1X) = N'[NONE]')) And ((UD2X IS NULL) or (UD2X = N'')