Solved

missing dimension and cube nodes in solution explorer 2008

Posted on 2014-02-03
3
358 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

SQL Server  2012 Release with lots of Enhancements in Database Engine functions, SSIS, SSRS and some of new services like Data Quality Server and Master Data Service. Of particular interest, and the focus of this Article is SSIS. So, time to elab…
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

708 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

18 Experts available now in Live!

Get 1:1 Help Now