Solved

missing dimension and cube nodes in solution explorer 2008

Posted on 2014-02-03
3
400 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

724 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