hello,

just want to ask if it is possible to copy a cube? and how?
so that i can work everywhere i go particularly during out-of-town trips
or when i'm not around in the office. thanks.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can copy a cube by archiving a copy of it to a .cab file. You can do
this by right clicking on the cube in Analysis manager.

Rob

"Mark Jason Carranza" <jcarranza (AT) ansi (DOT) ph> wrote

thanks for the reply. i've done it within the my analysis server.

how about the possibility of totally copying the cube into another
computer that is not pointing on to the original database.

i just observed that the data source is still pointing to the original
source eventhough i copied it to another database. i guess i cannot
work with my cube once i copied it to another computer.

thanks,

Mark Jason
Senior Project Officer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sure that will work.

If you have two servers registered in Analysis Manager then you can copy and
paste between the 2 servers. If you want to query the cube you will have to
modify the destination datasource to point at any datasource that has the
same schema as your original datasource once you've copied it...


"Mark Jason Carranza" <jcarranza (AT) ansi (DOT) ph> wrote

hello,

how can i share my analysis server? thanks.

Mark Jason


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can do an Archive and Restore which will copy both the
metadata and data (though you may have to reprocess in
some cases).

What about the possiblity of creating a local cube for this purpose.

You could process your cube to a local cube(.cub) and then take that
cube file on the road with you. It will not require access to the
original Analysis Server.

Local cubes can be accessed in a number of ways. If you do not
currently have a tool to access local cubes <a
href="http://www.thebitzinc.com">The Bitz Inc</a> company has created
a very powerful cube browsing tool <a
href="http://www.thebitzinc.com/products/iqubbrowser/">IQub
Browser</a> which allows for access to local cubes and analysis the
data contained within.

Cheers,

Ron Myers
The Bitz Inc
<a href="mailto:rmyers (AT) thebitzinc (DOT) com">rmyers (AT) thebitzinc (DOT) com</a>

Thanks Ron, I tried to find the cub file but unfortunate i failed to
find it.

I'll try another way and i'll update the thread for any results.

Thanks again =)

Mark Jason


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi,

We use a BI/OLAP software frontend with automatic producing a local
OLAP cube for use on laptops based on an enterprise MS AS 2000 OLAP
cube. Please visit our website and download your own trial copy.

Regards,
Marco

Mark Jason Carranza <jcarranza (AT) ansi (DOT) ph> wrote

Mark,

What I meant was for you to do was to create a local offline
cube(.cub). If you would like to contact me directly I could run you
through the process of doing this.

Cheers,

Ron Myers
rmyers (AT) thebitzinc (DOT) com
Software Analyst
The Bitz Inc.