Cube not showing up in Metadata Browser

I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:

Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube. Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down. Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.

The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.

Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.

Regards,

Clayton

This has to fall into the "bonehead" category.

The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".

|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.
|||

hello,

yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).

hope this helps,

|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.

Cube not showing up in Metadata Browser

I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:

Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube.

Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down.

Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.

The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.

Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.

Regards,

Clayton

This has to fall into the "bonehead" category.

The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".

|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.|||

hello,

yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).

hope this helps,

|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.

Cube not showing up in Metadata Browser

I have a cube that is processed, available, browsable, etc., but that does not appear in the list of available cubes in the following scenarios:

Open a new MDX Query window in the Managment Studio: the Metadata browser displays the error message "Error loading Metadata: No cubes were found.", Yet I can still write a query and execute it against the cube.

Use excel and try connecting to the cube using the "Data", "Import External Data", "New Database Query", "Olap Cubes","<New Data Source>", create a new "MS OLE DB Provider for Analysis Services 9.0" data source pointing to the server/database, and no cube names show up in the cube drop down.

Proclarity 6.1: same problem: cube shows as not processed or unavailable and I can't connect to it.

The cube works great with the Excel Cube Analysis Add-in, so I'm suspecting it is one of the new features of AS 2005 that is causing the problem. I am using Many-to-Many dimension relationships in the cube, and mutiple measure groups. Other than that, the cube is pretty straight-forward.

Any ideas on what would make this happen? I've tried deleting the cube from the server and completely redeploying the project, changing the cube name to not have a space in the name and a few other simple things.

Regards,

Clayton

This has to fall into the "bonehead" category.

The cube's "Visible" property was set to "False". Not sure how this happened, but for the record, the solution is to set the "Visible" property to "True".

|||I don't know about "bonehead." I spent 4 hours with this exact same problem. Not until I found this post did I think to view the cubes XML and change <visible>false</visble> to <visible>true</visible>. I mean, is there even a way to change this property though the designer? I just about went crazy. Thanks.|||

hello,

yes, if you open your project in BIDS, and open cube designer, look in the properties panel - it should show the cube and one of the properties listed in there is Visible (in the Advanced category).

hope this helps,

|||I did the same thing. I think what we all have accidentally done was select a dimension that we wanted to hide then went to the properties window to set the Visible property. What I just noticed is that if you click on on one of the dimensions while on the Cube Structure tab the properties window does not change to the dimension and the Visible property on the cube gets set to false accidentally. At least that how I ended up doing it. I hope this helps someone else realize how it happened to them.

Cube Browser not filtering the data for the user having only read definition permission

Hi,

I am started working with SAS2005 recently. Using Adventure works sample database.

When I login to the Management Studio as administrator and browse the cube, the browser filters all the null value columns and rows.

Steps:

1. Add Product.Product Categories to filter area and select only Bikes

2. Add Date.Calendar.Date Calendar year to filter area and select year 2005

3. Add Product.Product to Row area

4. Add Measures.Internet Sales.Internet Sales Amount in the Total or detail area

5. Add [Date].[Month of Year] in the column area.

When I logged in as administrator or the user with the role Full control (administrator) and all the nessasary permission set on all the objects. The cube browser displays the data where only it has values. If the entire row or column are null then the row and columns are not displayed.

When I do the exactly same with the user has a role instead of full control using just read definition option (I do not want the user to get full permission, like to make a role as read only) , the browse cube shows all the rows and columns, even the row and columns where all the values are null.

The empty cells are displayed as #N/A.

Is it possible to make the browser behave for the read only user as exactly like administrator user.

Any suggestions and recommendations are great.

Thanks

I am stuck with this problem. Please somebody help...

Cube Browser FAILS to open. It HANGS

Hi, I am working on the Analysis Services Tutorial.

When I am in Business Intelligence Studio and I right-click on the cube and I choose browse to open the cube-browser, the Cube-Browser HANGS FOREVER. it never finishes opening. I always end up using the taskmgr to kill off Business Intelligent Studio. How is this HANGING problem fixed?

AIMDBA

The Event Viewer Applicaiton log is showing the following:

Hanging application devenv.exe, version 8.0.50727.42, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Fault bucket 230214627.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

AIMDBA

|||

Try to see if re-installing Analysis Services will solve the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Cube Browser

Hi all,
I created a cube in analysis services project in a computer where sql server 2005 is not installed there, when I try to click on Browser tab in the cube, the following error occurs:
TITLE: Microsoft Visual Studio
A connection cannot be made. Ensure that the server is running.
ADDITIONAL INFORMATION:
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)

Anyone have any idea on how to solve it? Thanks in advance.
Daren

Did you deploy your cube? Did you process it?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||Hi Edward,
I tried to deploy it to my server using the ip address, the same connection error came up.
Daren
|||

This could be permission issue.

Check if you have Admin rights to Analysis Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||Hi Edward,
Thanks for helping out. But where do I check the rights to Analysis Server? I tried browsing through the properties of the user, could not find anything about Analysis Server.
Daren
|||

Daren.

First, please make sure you install Analysis Services on your machine.

After you installed it, you should be able to deploy your project to Analysis Server.

I strongly recommend you try and work you way through tutorial for Analysis Services. Looks like you are missing very basic knowledge.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||Hi Edward,
To make the picture clear, I already have analysis services installed and go through the tutorial provided in BOL, and I managed to get it to work fine in another computer (which I installed sql server with analysis services in it as well for testing purpose). Then I redo the same steps on the another computer (installed with the same settings), the only difference on both computer are testing pc is windows 2000 with latest sp installed, the other one (that I have problem browsing the data) is using windows server 2003. I have no idea how to go about from there, that's why I posted my question here.
Daren
|||

Are you an Admin on Win2003 machine?

Can you connect to Analysis Services using SQL Management Studio? Can you see your database ?

The project you develop in BI Dev Studio needs to be deployed. Only after you deploy the project to Analysis Server, you will be able to browse your cube.

After you deployed your cube, you can navigate to it in SQL Management studio and browse it from there.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.