I have a query mdx that where it doesn't filter

Question

I have a query mdx that where it doesn't filter

SSC Rookie

Points: 33

August 2, 2019 at 1:33 pm

I can't find the reason because a query that has in 'with member' an attribute of a dimensio that is key does not filter with where, if I put another attribute that is not key if it works ?.

Dimension FE6

FE6 is key (int)

FE6b (int)

Descripción (character)

WITH
       SET [FILAS] AS EXCEPT([FE6].[FE6].[FE6].members, {})
       MEMBER [FE6].[FE6].[FILASTOTAL] AS ([FE6].[FE6].[All]) , CAPTION = 'Total'

SELECT
{
    [Measures].[Documento]
}
ON 0,
{
   [FILAS],
   [FILASTOTAL]
}
ON 1
FROM [ModelosPredictivos2] 
WHERE 
(
    {[FE6].[Descripcion].&[2]}
)

2 162091

Total 1544775

WITH
       SET [FILAS] AS EXCEPT([FE6].[FE6B].[FE6B].members, {})
       MEMBER [FE6].[FE6B].[FILASTOTAL] AS ([FE6].[FE6B].[All]) , CAPTION = 'Total'

SELECT
{
    [Measures].[Documento]
}
ON 0,
{
   [FILAS],
   [FILASTOTAL]
}
ON 1
FROM [ModelosPredictivos2] 
WHERE 
(
    {[FE6].[Descripcion].&[2]}
)

2 162091

Total 162091

Thank you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.