Page 1 of 1
Creating a cube from .cma file
Posted: Mon Sep 27, 2010 7:21 am
by Radhika
Hi All,
We are unable to create a new cube from .cma file.
We are having a Data Server: xyz under which Market is a cube, now I right click on this cube and click " Export as Text data" , Market.cma is exported on my desktop. Now I want to use this Market.cma to create a cube in a Data Server: ABC.
How Can I create a cube using .cma file.
Please help me.
Thanks & Regards,
Radhika
Re: Creating a cube from .cma file
Posted: Mon Sep 27, 2010 8:57 am
by Wim Gielis
Hello
Did you create a TurboIntegrator process, and if yes, follow the steps in the wizard?
That means, selecting the file as the Data source, identifying the variables and provide their "contents" (last column in the variables tab), and fill in the tabs under "Maps"? (not all will have to be filled in)
Wim
Re: Creating a cube from .cma file
Posted: Mon Sep 27, 2010 1:00 pm
by lotsaram
Radhika wrote:Hi All,
We are unable to create a new cube from .cma file.
We are having a Data Server: xyz under which Market is a cube, now I right click on this cube and click " Export as Text data" , Market.cma is exported on my desktop. Now I want to use this Market.cma to create a cube in a Data Server: ABC.
How Can I create a cube using .cma file.
Please help me.
Thanks & Regards,
Radhika
You should note that the cma file will contain the address of all N level cube intersections that contain data. However this alone is not enough to rebuild an equivalent cube on another server as the cma file contains no meta data, that is; the dimension names, dimension hierarchies, dimension attributes, dimension subsets and cube views.
Re: Creating a cube from .cma file
Posted: Wed Sep 29, 2010 11:03 am
by Radhika
Thank you all.
Re: Creating a cube from .cma file
Posted: Thu Sep 30, 2010 3:24 pm
by sivan307
Hello All:
So in such a scenario, is there a way to re-build the whole cube with the structure & also the data. How do we achieve this task of re-building a complete cube with the structure & data.I know we can either use a front-end replication or a back-end replication using a script( I just wrote one to replicate my cubes onto different servers). Just trying to understand different ways of re-building a cube. Also please correct me, We can also use the dims & cubes created in one server by copying the data file & pasting that in the desired location where we have the new server & re-start the server.
Thanks,
Sivan