Slicer and parameter - Error when drilling through

[qvixote]

Hello!

I have a report with a multiselect prompt to select years used in some crosstabs and some charts. Then, I have some elements with a query in wich I need to consider only the last year of the group selected in the prompt. I'm working with a Transformer cube, so I used a slicer in that query recomended for someone here in this forum (can't remember who) and it work perfectly. The slicer is defined as:

tail(set(#promptmany('Param_Periodo','mun')#))

So when I run the report, and as the year prompt has default selections, the report works fine inmediatly.

The problem comes when I reference this report from other, using drill through. The report fails with the error:

- Se ha producido un error de análisis antes o cerca de la posición 11 de "tail(set()"

It says something like "It've been an analysis error near position 11 of "tail(set()"". I'm sure I'm sending the parameter value back.

Anyone knows if there may be something I've missed?

Thanks!

[MFGF]

My guess is that you are not passing through the MUN (Member Unique Name) of a valid member in your cube. What does a Year MUN look like in your cube? What exact value are you passing through in the drill through definition?

Cheers!

MF.


Sent from my iPad using Tapatalk HD

[qvixote]

Hi, MFGF!

Thanks for your answer! That was the problem, I was not passing the MUN. In the definition of values of parameter to drill through, I've selected the right parameter, but left "(defalut value)" as property to pass. Changed that value to MUN and it worked.

Solved! In some ocations the problem is in front of your eyes but you need someone's tips to clear your sight.

Many thanks.