Hi all, I have to handle some offline cubes (.cub), they are all different silces of the same cube. I can access to them using excel2010 and using power pivot as well, but i'd like to load them to an analysis server and possibly to rebuild the cune from which all those slices have been taken.
Is it possible?? if so, how can i do?....my experience is related to sql2000, i must use sql2008
I am not sure i understand your problem correctly.
If you want clients to be able to modify the contents of the cube, you could consider write-back feature. See http://msdn.microsoft.com/en-us/library/ms174750.aspx to learn more details about applying writeback for cube partition/dimension.
If you want to rebuild offline cubes, use REFRESH CUBE statement to rebuild a local cube and update its data. For more information, see http://msdn.microsoft.com/en-us/library/ms146078.aspx .
Dear Jerry, thanks for your answer.
my problem is the following:
I have two files: a.cub and b.cub
They are two slice offline cube. They have the same multidimensional structure, same original cube, let's call it C.cub. They have been 'extracted' basing on a dimension selection, this dimension is Market.
So a.cub is derived from C.cub where Market='North' and b.cub is derived from C.cub where Market='South'.
What I was asking is if it is possible tu rebuild the original C.cub starting from a.cub and b.cub
Once i could obtain C.cub I'd like if possible to manage it from Analysis Server.
Do you not have access to the source cube in Analysis services? If you do, you could either backup and restore that analysis services database or script it out, and deploy that way.
I've not seen what you appear to be asking - to build a cube from an offline OLAP data set.
- Edited by Mike Lindberg Tuesday, February 07, 2012 12:13 PM