Cannot open offline cube

Hi,

I created an offline cube file (.cub) using SSAS 2005 sp1. I tried to open the cube file by following these steps:

1. Open excel 2003. On the toolbar, click on Data and select PivotTable and PivotChart report.

2. Select External data source as the data you want to analyze then click on next.

3. Click on the Get Data button on the next step.

4. Choose the OLAP Cubes tab on the pop-up window, select <New Data Source> and Click OK.

5. Type "Sales" as the name of the data source.

6.Choose Microsoft OLE DB Provider for Analysis Services 9.0 as the OLAP provider. Click on Connect button

7. Select the cube file option and browse for the location of the cube file. Click Finish.

8. On the fourth step (here comes the problem),on the Select the Cube that contains the data you want list, nothing is available in the dropdown list. And since I cannot finish this step, the OK button remains disabled and I was not able to open the cube file.

Can any one help me on this?

Thanks in advance,

Destry

I have exactly the same problem, as a matter of fact I was about to ask that question.

Should you find a workaround on your own, I would appreciate it if you could post it here as well too. Tia.

|||

There are several things can be going wrong. Here are several ideas for you to try.

1. Try and use Microsoft OLE DB Provider for Analysis Services 8.0 to connect to your local cube.

2. Try and use MDXSample application. In the connection dialog, as server name specify a path to your local cube file. Something like c:\my cubes\cube1.cub. If you can connect and but cant see cube name there, most likely something wrong with your local cube file.

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

Cannot link measure group from cube in different AS database

I am trying to link a measure group from a cube in a different AS database (but on the same server), and get the following error: Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of 'AD043', cannot be verified against the source object.

Note that I can successfully link a dimension from a cube in a different AS database, and can also link a measure group from a different cube in the same AS database.

I found the following information at MSDN, but am not sure if this is the proper solution (nor do I entirely understand it--I'm not the security guy in our organization): In order to define or use a linked measure group, the Windows service account for the Analysis Services instance must belong to an Analysis Services database role that has ReadDefinition and Read access rights on the source Analysis Services instance to the source cube and measure group, or must belong to the Analysis Services Administrators role for the source Analysis Services instance.

At: http://msdn2.microsoft.com/en-us/library/ms174899(SQL.90).aspx

Can someone help me, please ?

When you create a linked MeasureGroup on a AS2005 server A, you specify its Source as a MeasureGroupBinding with these important properties:

- the DataSourceID pointing to the DataSource whose connection string points to the AS2005 server B on which the source MeasureGroup is

- the Persistance: an enum value, NotPersisted or Metadata; NonPersisted is the default and it means that the linked MeasureGroup content from server A will be pulled from the source server B at the time of creation. So a connection from server A is opened to server B. That's why the account for the AS2005 service on machine A needs to have permissions to AS2005 on machine B to read the source MeasureGroup. If the Persistance however is specified as Metadata, it means that you are sending manually the content of the linked MeasureGroup (so you specified the linked Measures one by one). In this case, a connection from A to B is still opened to verify the consistency between the linked MeasureGroup and its source. This verification adds more rules (that would generate the same error you are getting): the linked Measures need to be defined in same order as in the source MeasureGroup and they need to have the same DataTypes and AggregationFunctions as their source Measures.

Adrian Dumitrascu.

|||

Thanks, Adrian. I read your response carefully, and also passed it on to our database admin. As you stated, "a connection from A to B is still opened to verify the consistency between the linked MeasureGroup and its source. This verification adds more rules (that would generate the same error you are getting): the linked Measures need to be defined in same order as in the source MeasureGroup and they need to have the same DataTypes and AggregationFunctions as their source Measures."

I found thru experimentation last night that these "rules" you mention prevent me from deleting any of the measures in a linked measure group--and this appears to cause of the problem. This seems like bizarre behavior, but I can live with it merely by setting the visible properties for those linked measures I do not want displayed to false.

Thanks again.

|||

Yes, the linked MeasureGroup needs to define the same list of Measures as the source (in the same order) and the Visible property is the way to hide them fro user.

Adrian Dumitrascu.

cannot find dsn

Hello everyone,

This must be too simple to be true but im trying to set up the tutorial cube that comes with analysis manager and ive set up the cube and its dimensions but i cant progress beyond the storage design wizard as it gives me the following error when i try to process it:

[Microsoft][ODBC Driver Manager]Data source name is not found and no default driver specified

why is it that i am able to use this dsn to create the cube but not to process it or create the aggregations in the cube?
Ive set up the dsn exactly as described in the setup dsn pages (Tutorial/setup_sys_datasource.htm) and it has been working fine till this, i can even add further dimensions to the cube, just not process it, whats going on?

with much thanks, in advance, for any input

Amit

further to the above,

after going over my data source information again in analysis manager and starting up the i am now getting the following error message

error (-2147221411)Process operation faile;Time....

again im not sure whats changed or why this is different from the above or even if its closer to normal than the above but again any help will be gratefully appreciated.

Amit

|||

I sorted this by rebuilding the dsn and the cube from scratch, evidently there was something wrong somewhere along the line and it was good practice.

Amit