cube not visible from ms query

#1

I try to create a pivot table in excel, based on an Analysis Services cube.
When I create an Olap cube datasource, the cubes on the AS Server are not
visible. The database is visible, but no cubes, not even with the 8.0
provider. Any idea ?

#2

Make sure you have the 'visible' property to 'true' for each of the cubes
using the cube editor.

"joia" wrote:

Quote:

I try to create a pivot table in excel, based on an Analysis Services cube.
When I create an Olap cube datasource, the cubes on the AS Server are not
visible. The database is visible, but no cubes, not even with the 8.0
provider. Any idea ?

#3

Hi, I checked the 'visible' property, and it is set to 'visible'. Any other
idea ?

"Prasad" wrote:

Quote:

Make sure you have the 'visible' property to 'true' for each of the cubes
using the cube editor.

"joia" wrote:

I try to create a pivot table in excel, based on an Analysis Services cube.
When I create an Olap cube datasource, the cubes on the AS Server are not
visible. The database is visible, but no cubes, not even with the 8.0
provider. Any idea ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

cube not visible from ms query

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

cube not visible from ms query - 05-12-2005 , 05:16 AM

RE: cube not visible from ms query - 05-12-2005 , 07:23 AM

RE: cube not visible from ms query - 05-31-2005 , 07:35 AM