Hi, I have a web report .srx file that is created from a information map over a Olap cube. I use multiple measures in one table against a single dimension Year-Week-Date. The problem I have is my users require the detail data behind each cell value but when using the drill through to detail data facility in Olap cube the observations that are returned is from what I can see based only on the Year-week-date dimension. My measures are simple sum measures and the value stored in the underlying data is 1 or null I'm told I could create a SP that sits inside a infomap and link this to a separate web report studio list report and use a SP to capture the dimension and measure cell value the user clicked on. So if a user clicked 500 outstanding at year the list report would show me 500 records. Is this possible? Has anyone done anything similar or have ideas about where to start? Thanks
... View more