07-11-2014 07:05 PM
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?
12-04-2014 10:00 AM
Have you tried creating a stored process that would export the detail data to an application like Excel? I provide my users the ability to "right-click" the OLAP cube measures and select a custom menu function that exports the underlying SAS dataset to excel, but you could export to an file type that you currently have support for.
If interested, I could send you a code sample. let me know