how to bring back data from analyst cube to my database

[anilkumar]

hi guys

thanks for advanced help.

i  uploaded data from database(eg:xyz) to analyst d-cube, then i have to bring back this data to my data base.  is there any steps r else wat we have to do please send  solution asap

regards
anil kumar

[blackadder]

First ideas that come to mind are to do an Analyst publish (this creates a star schema of the cube in a new database, see the docs for more detail), or export the cube to a flat file and use the bulk load facility for your database to load it up.

[mrobby]

I have used the export to flat file method that Blackadder is talking about and then used DTS in SQL server to pick up the file.  Pretty easy and straightforward.  The publish idea is also a good idea as you can write a view of the published data to translate it back to what your database looks like and then set trigger to fire the SQL Update of your table.