Question

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


Sponsored



Replies

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


Hello,

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 ?