I have a cube with several measures in it. I also have 2 time dimensions called Repoting Date (RD) and Business date (BD). The reporting date dimension is pretty small only containing the dates as the end of the month. The business date dimension is
a normal time dimension on day basis.
Now I want to create a set or filter where the reporting date is the same as the business date. And that should apply to all measures.
So I should get (BD.Date.2010-01-31, RD.Date.2010-01-31), (BD.Date.2010-02-28,RD.Date.2010-02-28)
Any thoughts on this one ?
View Complete Post