August 29, 2011 at 10:52 pm
Hi,
I'm having a cube with multiple dimension and one of the dimension is for date and based on the cube i developed a report in reporting service.
Date dimension is designed by named query and it display upto yesterdays date (dateadd(d,-1,now())).
After deploy it is working fine and i report is also generate based on the particular date given.
On the next day, if i generate the report it show only the day before yesterday data not the yesterday's data.
Thanks in advance..
August 31, 2011 at 2:08 am
You don't say what version you are using, but I'm pretty sure I've seen that one of the improvements in 2008 is updateable named sets. So if you're using a version before, you are not going to have this capability.
You'll need to do some more checking yourself. I'm just trying to get you pointed in the right direction.
September 2, 2011 at 5:02 am
Have you refreshed the data by processing the cube?
Thanks,
Amit G
http://www.msbiconcepts.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply