Hi,
I need to pass a set of data as a parameter to my dataset, because all my filters are gathered outside the report.
I wish to pass a parameter like this:
{[CLIENTE].[SEGUIMENTOS].[SEGUIMENTO].&[DISTRIBUIDORES / ATACADOS]},{[VENDEDOR].[SUPERVISORES].[SUPERVISOR].&[GERENTE DE VENDAS]}
So I could use in the Where() function in my MDX query.
I tested the MDX with this parameter and it works.
So I added a @Filtros parameter to my dataset query, but It throws an error saying that it was expecting a tuple set and instead recieved a number or a string.
My Query:
SELECT
NON EMPTY { [Measures].[FAT] } ON COLUMNS,
NON EMPTY {
([PRODUTO].[CLASSES].[PRODUTO].ALLMEMBERS * [Time].[Time].[Quarter].ALLMEMBERS )
}
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM
[SCA]
WHERE(@Filtros)
CELL PROPERTIES
VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Thank you.