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).
So you mean for my case I would have a table for region,consumer and time?is that what you imply?
and do i do that manually?if it's a lot of data and i do that manually dont you think it's going to take
a lot of time?