This is a migrated thread and some comments may be shown as answers.

CubeDataSource - database not appearing

2 Answers 64 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Jordan
Top achievements
Rank 1
Jordan asked on 15 Jul 2013, 07:39 PM
Hi Everyone,

I'm having an issue with my cube data source that I'm attempting to set up. In Microsoft SQL Server, I have the AdventureWorksDW2012 data cube which is set up fine and works.

When I attempt to add a new CubeDataSource to my Telerik Report, my databases do not appear. When I put in my server name, no databases appear in the "Database name" drop down. I have both Adomd files as listed here http://www.telerik.com/help/reporting/cubedatasource-configuring-project.html but it won't work.

If I instead set up a SqlDataSource and input the same server name as the CubeDataSource, all of my databases appear in the list. Is there any reason they don't appear in my CubeDataSource? The CubeDataSource works fine when I instead connect to "http://demos.telerik.com/olap/msmdpump.dll".

I'm not sure the issue. Thanks for the help. 

2 Answers, 1 is accepted

Sort by
0
Jordan
Top achievements
Rank 1
answered on 16 Jul 2013, 02:09 PM
Just to see what would happen, I actually typed the Database name into the field and I get the error as shown in the image (I'm running a virtual machine).

I also attached a snap shot of my databases. They only thing I've added is the AdventureWorksDW2012 database. Everything is else is from the fresh install I did on this VM instance. 

The only thing I can think of is that the AdventureWorksDW2012 isn't an appropriate cube for the CubeDataSource?
0
Jordan
Top achievements
Rank 1
answered on 16 Jul 2013, 02:29 PM
Well, my previous post answered my own question. I misunderstood the AdventureWorksDW database, but I have created a cube out of it and everything works fine.

Sorry for the spam posts! Didn't mean for this to be my train of thought thread...
Tags
General Discussions
Asked by
Jordan
Top achievements
Rank 1
Answers by
Jordan
Top achievements
Rank 1
Share this question
or