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
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