Dimension for Currency Rates

 Hi All

I have created Finance and PR & AR cubes but the customer has now asked for me to show a conversion rate / factor in use at a given date.  so far I have tried to create a shell dimension based on a Rates table that I have brought into the DW

The Dimension I have created has three levels:

1. Currency

2. Start Date

3. Factor


the problem is that I can't get it to resolve to show all the dates when I group it under currency


There should be about 10 dates under each currency


Any thoughts on what I am doing wrong




Please sign in to leave a comment.