Report Model from Analysis Services Project

• Agson Chellakudam

  Ten Centuries

  Points: 1387

  More actions

  June 7, 2006 at 1:11 am

  #171074

  Hi All

  I am using SQL Server 2005 Standard Edition.

  I was trying to create a report model from an analysis project.

  I have created and deployed around 3 analysis projects on the same server(local host).

  But when I am selecting 'Create a data source based on an Analysis Services project' option for creating Data Source. I am not able to find any projects listed

  Can anyone answer,

  Why analysis projects are not listed?.

  Any other way to create report model from a Cube?.

  Is this feature 'Create a data source based on an Analysis Services project' only available for 'Enterprise Edition' ?

  Regards

  Agson Chellakudam

   

• June 12, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Myles Matheson

  SSC Rookie

  Points: 41

  More actions

  July 12, 2006 at 1:27 am

  #648637

  Hello Agson,

  The quickest way to create a report model based on a cube is from a shared data source in Report Manager (Reporting Services Web Portal). 

  I have a blog post that describes how to generate a report model from Analysis Services Cube as a data source. Check out: http://bi-on-sql-server.blogspot.com/2005/12/report-builder-and-udm.html

  Hope this Helps

   

  Myles

   

   

• Agson Chellakudam

  Ten Centuries

  Points: 1387

  More actions

  July 13, 2006 at 12:30 am

  #648872

  Hi Myles

  Thanks for your reply

  It is working fine.

  Regards

  Agson Chellakudam