Solved

missing dimension and cube nodes in solution explorer 2008

Posted on 2014-02-03
3
369 Views
Last Modified: 2016-02-18
Hi,

I am learning SSIS, SSAS and creating first cube using online articles. (http://sql-bi-dev.blogspot.ca/2010/08/creating-first-cube-in-ssas-2008.html  
and
http://technet.microsoft.com/en-us/magazine/ee677579.aspx
and
downloaded adventureworks from : http://msftdbprodsamples.codeplex.com/releases
the adventureworksDW for SQL Server 2008)

my visual studio solution explorer 2008 does not display dimension and cube nodes?

I have AdventureWorksDW installed. I can see data connection, data source view, packages  and miscellaneous nodes only.
I have created the data souce connection, the data source view correctly.
But I do not see the dimension and cube nodes?

how can they be added?

thanks
0
Comment
Question by:shmz
  • 2
3 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39830438
Did you built the cube(s) first by using knowledge from the first two links you posted above?

If you did that already try use SSMS then connect to your Analysis Server first and check permissions/process the cube(s)

http://technet.microsoft.com/en-us/library/ms174957(v=sql.105).aspx
0
 

Accepted Solution

by:
shmz earned 0 total points
ID: 39871096
I noticed cubes option is available in SSAS only and not SSIS. Right?
0
 

Author Closing Comment

by:shmz
ID: 39985497
please close this question.
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now