Hi Experts,

I have been assigned to convert some of the report from microsoft excel to SSRS using SSAS. I have never used the BI Site of SQL Server before and therefore i am stuck.  

I am quite clear about the data sources and i think i have figured out the dimension tables and the fact table (i am sure i will have to make lots of changes later). I am not sure where to start with now?

In BIDS will i create a new SSAS project and start defining my dimension and fact  tables (would be helpful if i could find tutorial on it) and then use SSIS to import the data from SQL Server database?
or is there any other way of doing this?

Sorry if this seems a silly question but i need your help.

Ali ShahSQL DeveloperAsked:
Who is Participating?
ValentinoVBI ConsultantCommented:
If you don't have a cube yet, you would indeed need to create an SSAS project using the BIDS.  Here's a tutorial to get you going:

Once you've got the cube, follow the instructions given by TempDBA (thanks for mentioning my article btw :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.