Cannot deploy AdventureWorks Analysis Services Project

Question

I've installed the AdventureWorks database and have been able to look at the reports in Visual Studio, I can open the AdventureWorks Analysis Services Project but when I attempt to deploy the Enterprise version I get:

Error 62 - Errors related to feature availability and configuration: The 'Perspectives' feature is not included in the '64 Bit Standard Edition' SKU.

I've tried following different help resources online and cannot find anything that works.

Answer 1

Hi,

perspectives are only in Enterprise edition. Standard edition doesn't support all features. You need tu deploy project in standard folder.

 

Jiri

---

Jiri Neoral BIExperts s.r.o. www.biexperts.cz

Answer 2

HI,
I am a total newbie to SQL, i downloaded sql express with advanced services and followed instructions on

http://msftdbprodsamples.codeplex.com/wikipage?title=Database%20Prerequisites%20for%20SQL%20Server%202008R2      and

http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database

page everything goes smoothly till i click on "deploy" on the "properties" Adventure Works DW 2008 then a "save" dialogue box appears and when i click "save" it prompts if i want to replace the file and when i give "yes" it says access denied......... i dont understand why, i am the administrator.............the connection test was successful and the deployment in the properties of the solution is the correct server name............Pls help i've been at it for the past 3 hrs.........

Thnx in advance

Answer 3

For the newbies,

In order to do what Jiri suggest you need to open the visual studio (bids) solution file (.sln) from C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks 2008R2 Analysis Services Project\standard

and reconfigure your data source (if you need so, even though the default should work) and deployment setting (right-click your solution project --> properties) [even though the deployment settings should be fine aswell]

Then right click your solution project and click on "Deploy" this should now go smoothly.

Seve