Help!

I am trying to implement the task of viewing a virtual cube (SQL Server
Analysis Services 2000 SP4) in Excel (or any other viewer) from a local
cube file...I have been through many postings to this problem but still
I haven't arrived at a solution...virtual cubes appear to be especially
difficult...

The virtual cube is a simple advertising cube with three
measures/calculated members...

Impressions000 (measure)
Base (calculated member)
Ratings (calculated member)

The dimensions will follow in the code I am posting...

1) Rubik has been suggested on postings but I cannot get it to create a
local cube from a virtual cube. Is this expected behavior from Rubik?
Does Rubik work on virtual cubes?

2) I have also tried to create a local cube this way

CREATE GLOBAL CUBE Ratings STORAGE 'C:\Ratings.cub' FROM Ratings
(
MEASURE [Ratings].[Impressions000],
DIMENSION [Ratings].[DimAge],
DIMENSION [Ratings].[DimCommercial],
DIMENSION [Ratings].[DimGender],
DIMENSION [Ratings].[DimMediaDate]
)

Is this supposed to automatically create the calculated members Base
and Ratings in the .cub file? When I tried it didn't work. Is this
because Excel doesn't like calculated members? Also, when I try listing
the calculated members (ie MEASURE [Ratings].[Base]) I get an error. Is
this expected?

3) Finally, does someone know how to create a local cube from an
Analysis Services 2005 (virtual studio, BI or whatever)? I can't
assume our clients have an OLAP server on their computer.

Willy

Follow Up:

I believe one of the issues I was having is that I had hidden some of
my calculated members and measures in my cube design, and when Excel
reads a .cub file it doesn't like it when there are hidden members
(don't quote me on this)...

Also...forget about .cub files from AS2000 virtual cubes (I am fairly
certain about this).

Willy




willy wrote:

Hi willy,

to use hidden calc. member in an offlice-cube you have to put it in the
create syntax:

Example:
measures:
A hidden
B hidden
C visible
D visible

CREATE GLOBAL CUBE Ratings STORAGE 'C:\example.cub' FROM Ratings
(
MEASURE [Ratings].[A] HIDDEN,
MEASURE [Ratings].[b] HIDDEN,
MEASURE [Ratings].[C],
MEASURE [Ratings].[D],
DIMENSION [Ratings].[DimAge],
DIMENSION [Ratings].[DimCommercial],
DIMENSION [Ratings].[DimGender],
DIMENSION [Ratings].[DimMediaDate]
)

That works for me (within Excel XP/2000) and Analysis 2000.

greets

Bernhard

--
CS Result GmbH
Bischof-von-Henle-Str. 2
93051 Regensburg


"willy" wrote:

Great Bernhard:

I will try this. I would like to be able to hide things.

Does this also work for dimensions? This may seem counter intuitive
but AS2005 insists on key dimensions which I would like to hide...

I still can't figure out why my bosses' Excel won't read my working
..cub file....however I will prevail...

Thanks, Willy

Hi willy,

if dimensions are set to visible=false then just don't put it in the create
cube statement. At least one dimension has to be visible.
This is for Analysis 2000! I have never created an offlince cube with
AS2005. Sorry for that.

greetings

Bernhard


--
CS Result GmbH
Bischof-von-Henle-Str. 2
93051 Regensburg


"willy" wrote:

Bernhard:

I had time today to explore both the hiding of dimension attributes
(which I incorrectly called dimensions) and the hiding of measures....

You key word "HIDDEN" to hide measures worked great in AS2005 create
..cub files...and

There is property "AttributeHierarchyVisible" in AS2005 that can be set
which nicely hides dimension attributes, namely the extra key
attributes AS2005 creates.

Willy

Bernhard:

I finally got the result I want with your help and a little
bootstrapping...

After I got my nice offline cube working with everything hidden and all
the calculations in order I ran into the problem that my cube was
unviewable in Excel 2003 if SQL Server 2005 isn't installed...nuts.

The workaround is to install "Analysis Services 9.0 OLE DB Provider" on
the destination computer...

I won't go into the details because I don't want to crash anybody's
computer but the answer lies on this page....

http://www.microsoft.com/downloads/d...displaylang=en

Hope this helps anybody trying to build local cubes.

Willy

Hi willy,

as far as i know You have to install the SQLServer2005_ASOLEDB9.msi AND the
Microsoft Core XML Services (MSXML) 6.0 (msxml6.msi) on the clients. This
works for me to use offline-cubes made with AS 2005 and Excel 2003 (both
installer-files for x86-systems)
thank to You for Your hints

Bernhard


--
CS Result GmbH
Bischof-von-Henle-Str. 2
93051 Regensburg


"willy" wrote:

Bernhard:

Exactly -- I just just wanted to error on the side of caution since I
only had a Win2K SP4 box to try it on...

It appears those two installations/updates are safe...

Willy




Bernhard Saemmer wrote: