We are currently loading all sales for all fiscal years to one cube. I'm wanting to change this so each fiscal year goes to a unique cube. I have created a multiprovider to union them together for queries. However I'm confused on where I would direct the request coming in to the proper cube based on fiscal year.
Any help and points will be rewarded.
Thanks
Richard