Rename a Cube

Question

Rename a Cube

noelia-258381

SSC Rookie

Points: 27
More actions
January 12, 2006 at 8:58 am

#111714

Hi all,
I have a problem. I thought that i could rename a cube in a Datawarehouse, but it seems it is not possible.
Can somebody tell me how to duplicate a cube without copy and paste, and without process it??

Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 1

You could tyr the DSO-XML converter but I think it's still an unsupported tool. Basically it extracts all objects using DSO to XML, you then modify the XML and then use the same tool to apply the revised XML back to the server. Probably a lot more work than copy|paste

Steve.

Phil.Nicholas SSCrazy Points: 2147 More actions · Answer 2

copy & paste cube in same database giving cube new name, delete old cube and reprocess in 2000 is the only way I've found to do it..

Phil Nicholas

noelia-258381 SSC Rookie Points: 27 More actions · Answer 3

It is no way to import/export data from a cube to other, am I right?

Phil.Nicholas SSCrazy Points: 2147 More actions · Answer 4

As far as I know in 2k theres no way of doing this?? It can be backed up and restored I think but as far as I remember you typically get warnings about shared data with the original cube or something like that???

Phil Nicholas

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 5

The archive and restore is at the database (catalog) level, so if you wanted to restore just a single cube, you'd end up over-writing all cubes in the catalog.

Steve.

Janet Josephson Grasshopper Points: 19 More actions · Answer 6

How about open the cube for Edit and then Save As a different name?

Regards,

Always Learning

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 7

You still have to process the cube (same as with copy|paste).

Noelia, I think the short answer to your question was no, there isn't any other way in AS2000 .

Steve.

Phil.Nicholas SSCrazy Points: 2147 More actions · Answer 8

Possibly you could copy and paste the data across in the data directory? Havent tried this myself...

Phil Nicholas

noelia-258381 SSC Rookie Points: 27 More actions · Answer 9

Thanks all.

I think only i can do is re-process the cube, duplicating sql tables and deleting data for the date i don't want.

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 10

What you've said here changes things a little.

If you want a copy of the cube but want it to have a subset of the data available within the fact table, do a copy|paste of the original cube, name it so that it reflects the subset of data. Then *without changing the fact table it refers to* edit the new cube and ensuring you've selected the cube within the treeview, open the properties pane in the editing screen. Either in Proprties or Advanced properties (for the cube) there will be a property for adding a fact table filter. Add SQL to this as per any standard SQL statement *after* a WHERE clause - so if you wanted only data where the year field is between 2002 and 2003, then add text like 'myYearColumn BETWEEN 2002 AND 2003' (without the quotes).

When you reprocess this new cube you'll get only the fact data allowable/specified by the where clause.

Note that in cubes where you have multiple partitions you can also add partition filters (and select different fact tables for each partition).

HTH,

Steve.