Hi guys!

I would like to know how can I program (in a DTS, for example) the process to transform all my AS2K cubes to offline cubes in only one step. I have tried with the CREATE GLOBAL CUBE mdx sentence in Query Analizer, but I received several errors when execute the code (using Excel client-server utility i receive an OLAP Provider error in cubes with hierarchies).

Apart from this, somebody could clarify me if the offline cubes are uptodate when the user use them thru Excel PT or Data Analyzer (in Excel UI the user can update the data manually, and I'm not sure if this action update the offline cube too), but in Data Analyzer the user can't do it

Thanks in advance mates
Caroline

Hierarchies, like Time.Fiscal / Time.Calendar(=dimension names with dots) is
not supported in local cubes. You will have to rename the dimensions in AS.

HTH
/Thomas Ivarsson BI Consultant Malmö Sweden.

"Caroline" <anonymous (AT) discussions (DOT) microsoft.com> wrote

tried with the CREATE GLOBAL CUBE mdx sentence in Query Analizer, but I
received several errors when execute the code (using Excel client-server
utility i receive an OLAP Provider error in cubes with hierarchies).
the user can update the data manually, and I'm not sure if this action
update the offline cube too), but in Data Analyzer the user can't do it.

Thanks all
I'll try both solutions

Cheers,

Our product, the OLAP Client Management System, contains a DTS task called
the Local Cube Task, which automates the creation of offline cubes (local
cubes). The code shared by Verbani was generated by our product. If you are
creating a few local cubes, it would be practical to just modify that code
for each Analysis Server cube. However, if you're creating a lot of them,
our product will do it a lot more conveniently.

For example, if you want to transform all myour AS2K cubes in one step, you
just have to select all the cubes, or all the Analysis Server databases that
contain the cubes, and they will all be created. You can create local cubes
with our product interactively inside the Analysis Manager or you can add
the Local Cube Task to a DTS package so that new local cubes are generated
every time the Analysis Server cubes are processed.

We also create client files in our product for three Microsoft OLAP
clients - the Data Analyzer, Excel, and the Office Web Components.

A free 30-day trial full-featured copy of our product is available on our
web site.

Tim Peterson
www.localcubetask.com