Hi everyone I have a calculated member in my cube where I perform my necessary calculations but I am unable to check these calculations (in the cube browser) based on my time dimension When I browse the cube and add the time dimension in the Filters fields area (after draging all other necessary measures, calc member & dims to each area), the calculations (data) only work for one particular dayid (when i select one dayid from filters area). Can anyone plz suggest/help me on adding the slicer expression (mdx) for time dimension. Help will be really appreciated. Thanks,
Not sure I have got grasp of your requirement, but see http://msdn2.microsoft.com/en-us/library/aa216772(sql.80).aspx any help here for information. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=817586&SiteID=1 too.