SSAS cubes in MOSS 2007

Question

Hi All- I am very new to BI ,I have default cube generated from Adventureworks ,I want to view this cube using MOSS,Please help me what are the steps need to connect SSAS cube to MOSS.

Thanks
Saritha

---

saritha k

Answer 1

What version of MOSS do you have and what are you trying to do with the SSAS data?  There are quite a few ways that you could look at using the data and connecting to the cube, so if you could provide some additional insight as to what version and what you are wanting to do that would be helpful.

You can use SSRS reports, Excel Services, KPI Lists, PerformancePoint server, etc.

You might find it helpful to take a look at the Business Intelligence Virtual Labs on TechNet - http://technet.microsoft.com/en-us/bb499788.aspx.  These labs will provide you with manuals you can download and exercises that you can walk through to show you would to leverage and integrate business intelligence into SharePoint 2007.

Answer 2

Hi Dan - Thanks for your reply,I am using Moss 2007 and Sql server 2008 ,I have sample Adventureworks cube ,I want to see this cube in MOSS ,so I don't have any idea how it works ,Please send me steps to open it in moss.

Regards,
Saritha

---

saritha k

Answer 3

Are you running the Enterprise Edition of MOSS 2007?

What exactly do you mean by you want to see the cube in MOSS?  Do you want to display information to users and if so, how do you want to do this?

I would take a look at the Virtual Lab link I provided and walk through the labs.  You can download the lab manuals and get the necessary steps to connect to SSAS sources depending on what you are trying to accomplish.

Answer 4

Hi Dan - No am running standard edition ,Basically no idea on cubes so ,here is all what we have ,we installed sql 2008 bids ,so we got one built in cube from adventure works now i need to see how i can see cube in MOSS ,what all are options like how to see it
can we browse or can we divide into small perts and view it  thru mdx query  or how exactly.
To be honest  dont know anything where to start up.
First of all how to connect this cube to MOSS.

---

saritha k

Answer 5

You could create SSRS reports if you are using SSRS and then display these reports to end-users through SharePoint. 

The majority of the items like Excel Services, KPI Lists, Dashboards, PerformancePoint, Business Data Catalog, etc. are all Enterprise features.

Refer to the Virtual Labs for guidance on how to incorporate BI into SharePoint.