This content has been marked as final. Show 2 replies
Actually you don't have "just" dimensions, they are hierarchies (meaning a year consists of months etc.).
I guess technically you could do a mapping to your one excel. I wouldn't do it though (it requires calling functions on your data to know whether January is part of 2012 or 2011 e.g.), I would transform the one Excel into different tables for performance reasons (unless you cache or don't have a tremendous lot of data).