SSRS Drill through report using SSAS cube as datasource
Hi All, I am new to MS bi tools. I have two reports based on ssas Cube. I want to create drill through from 1 report to other.I have one date range parameter in 1st report,when i select any date range in the report then the report will display the values per date.Here i have created a drill through on value field,when i click on this value the corresponding date value should pass to next report. Up to this level I am able to do. But the requirement has got changed asbelow: once i click on a value corresponding some date for e.g: 21st july,2011 then it should pass 18th july,2011 and 24th july,2011 to the next parameter. Please any one help me out from this issue.... Thanks in advance...
July 29th, 2011 1:55am

Hi Santy_124, Based on your information it seem that you need to add three days and substract three days based on the data you selected, right? if that is the case, I think you can make use of DateAdd function to return a Date value containing a date and time value to which a specified time interval has been added. Other steps are the same to Drillthrough Reports (Report Builder 3.0 and SSRS). For more information about this please see: http://technet.microsoft.com/en-us/library/ff713971.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2011 2:01am

hi Challen Fu, Thanks for your reply. I ll explain the requirement 1st report i have columns like Date Revenue 2011-06-15 10000 2011-06-16 20000 In this report one date range parameter is present,based on date range selection above report will produce.The values of date format is like in the cube is 2011-06-15 00:00:00.000 (I think this is string format).And this report having drill through on revenue column.when i click on value 10000 the next report will filtered from 2011-06-12 to 2011-06-18.The second report will also have date range parameter and the format is also same as 011-06-15 00:00:00.000.so the next report will display as: date loc1 revenue 2011-06-12 xxx 1000 2011-06-12 uuu 2000 2011-06-12 ggg 3000 2011-06-12 aaa 1000 2011-06-12 jjjj j 2000 2011-06-12 kkk 1000 Please help me out from this requirement. Thanks in advance. Regards, Santosh YSantosh Y
August 2nd, 2011 8:36pm

I got the solution for this requirement as follows: ="[Date].[Date by Reporting Period].[Date].&["&Format(Cdate(Right(mid(Fields!Date.UniqueName,44,8),2) &"-" & (Right(Left(mid(Fields!Date.UniqueName,44,8),6),2)) &"-"& Left(mid(Fields!Date.UniqueName,44,8),4)).AddDays(-3),"yyyyMMdd")&"]" Regards, Santosh YSantosh Y
Free Windows Admin Tool Kit Click here and download it now
August 9th, 2011 4:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics