I built a cube by Microsoft SQL Server 2005 Analysis Services and deploy into the server. The deployment was successful. I extract the cube by Microsoft Excel 2007 to view data. That also successful. Then I built an offline cube from there. I can successfully create the offline cube. And store into a thumb drive and open the offline cube by another pc through microsoft excel 2007/2003 both. I cannot open the offline cube and got the error as 'This datasource contains no visible tables'... and in another pc, it is asking the log in credentials.
The offline cube is disconnected from the datasource and can open anywhere else right? Then how can I got all these issues? Please help me on this. Thanks.
> The offline cube is disconnected from the datasource and can open anywhere else right?
Yes, the offline cube is disconnected from the relational data source, unless you have ROLAP cubes or partitions.
Adrian
If the storage mode is ROLAP for your cube or a partition or dimension that you will query from Excel, then you will need to have access to the relational data. To solve this, use the MOLAP storage mode. To check what storage mode you have, use either SQL Management Studio or BI Development Studio. With SQL Management Studio, use the properties dialogs to check each dimension, cube and partition. With BI Development Studio, connect to the database in online mode (File -> Open -> Analysis Services Database).
Adrian
|||Thanks Adrian for your reply. I checked the partitions in my cube. It is already in MOLAP storage mode. I am not using the ROLAP so far. Any further ideas...?
|||
grmohan68 wrote:
Thanks Adrian for your reply. I checked the partitions in my cube. It is already in MOLAP storage mode. I am not using the ROLAP so far. Any further ideas...?
No comments:
Post a Comment