Culculated member as slicer

[Fredrik]

Hi,

I have a crosstable with a couple of calculated members in the rows and I trying to do a drill through on this calculated members but ca´t get it to work.


An exampel of a calculated member i try to pass in my drill through looks like this:

member(total(currentMeasure within set set([Läkemedel];[Lokalhyror]));'Läkemedel Namn';'Läkemedel caption';[130 EK Resultatkub].[Konto].[Via rapportrader])


My target report have got this slicer where the passed value from the calculated member should be used:

[130 EK Resultatkub].[Konto].[Via rapportrader].[KRRAD_ID]->?konto?

There is no error validating the reporte but when I run the report and click on the drillthrough link i get this error message:


CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2015-03-12-15:37:24.665-#149

/Fredrik

[Fredrik]

Hi,

Solved it like this:

put the calculated member "Konto" (member(total(currentMeasure within set set([Läkemedel];[Lokalhyror]));'Lön';'Lön caption';[130 EK Resultatkub].[Konto].[Via rapportrader])) in both source and target report.

And the slicer in the target report looks like this:

#'['+prompt('Konto';'token') + ']'#

/Fredrik