I am using a live connection to an olap cube. I have a week dimension which shows weeks in format 2013101, 201302 etc. The weeks are from 201101 and go till 201352
Now I have a couple of requirements. I first want the week dimension to only show the weeks till current week and not future weeks. The second requirement is to select only last 13 weeks by default
Can someone guide me here how to do it
Retrieving data ...