Facing some issue in MDX Query on using 'With Section'(Essbase error: 1260050)
Summary
Facing some issue in MDX Query on using 'With Section'(Essbase error: 1260050)Content
Hi,
I have written a simple MDX query using 'With Section' to calculate the absolute Variance on using 'Abs' Function. The MDX Query details are given below
WITH MEMBER
[Scenario].[Variance]
AS
'Abs([Scenario].[Actual] - [Scenario].[Budget])'
SELECT {[YearTotal].Children} ON ROWS,
{[Scenario].[Actual], [Scenario].[Budget], [Scenario].[Variance] } ON COLUMNS
FROM [DBUKATHI.Plan1]
where ([Version].[Working], [Account].[PL5110001], [Currency].[Local], [Entity].[3000S.3002 - German Gulf Qatar WLL],
([Version].[Working], [Account].[PL5110001], [Currency].[Local], [Entity].[3000S.3002 - German Gulf Qatar WLL],
[Cost_Center-Department].[GGE_Common], [Geo-Region].[Ethiopia], [Headcount].[ICP None], [Project-Customer].[Q/3082],
0