Issue with Power Pivot Filters RRS feed

  • Question

  • I am currently working in power pivot to visualize data from a cube.In power pivot i use certain dimensions on filters for which default member is set. The data gets messed up when i select the default member in the filter

    For Example :

    Considering the dimension to be "Time" which has the following hierarchy (Year-> Quarter-> Month ->Week ->Date) and the default member is "Current Date".

    In this case when ever i select the month which includes current date along with few other months.The aggregation that was specified for the measure doesn't works it just shows data for day level(default member) instead of aggregating the data for the combined months that were selected ,but when i select other months excluding the month that contains the current date it works as expected.

    This is the case with all the dimensions that contains default member and which are used in filters.

    Is there any solution to solve this?

    Thursday, August 21, 2014 12:03 PM