Category: sql server analysisservices


Sanjay_S on Fri, 22 Mar 2013 08:23:10

Hello Experts ,

I have requirement in my cube I have three dates let say

1. Sale date

2. Purchase date

3. Transaction Date

when i browse a cube with any date parameter the cube should filter the data purchase Date irrespective I have chosen any date as parameter;

how this is possible ? please let me know


Rakesh M J on Fri, 22 Mar 2013 09:04:04

Is your sale,Purchase,Transaction in the fact table ? If you have you connected thrice as a role playing dimension in your cube ?

Sanjay_S on Fri, 22 Mar 2013 10:13:18


Yes all the tree dates are there in fact table

Rakesh M J on Sat, 23 Mar 2013 07:33:16

Then, Create only 1 cube dimension and remove the other two. Name the purchase data as Date and give him the option to filter by that. I don't understand why you need to show him three dates if you want only purchase date to be filtered ?