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 ?