Can't Access Cube Templates

Hello,

I appreciate this is probably a noddy question but I can't find the answer in any of the normal resources.

I'm working through Brian Larsons Business Intelligence with SQL Server 2005.

Chapter 6 requires me to set up a Cube from a Template.

I've chosen the Cube Wizard from the Project Explorer and then clicked next on the welcome page.

Problem is when I select the second radio button (the option that indicates that the source is not a data mart) the chose template checkbox that activates the template drop-down is disabled.

This obviously means I can't chose the template I need. I've continued with the book anyway but now I need to use the Cube that I've failed to build :(

I think this may be something to do with the default template folder as the path indicated int he book did not exist so I have to build it. Does anyone know the default path for OLAP Cube Templates?

I am using the Trial Version of SQL Server 2005 and assocaite Visual Studio components.

Thanks for any help,

James

I see templates installed on my machine into C:\Program Files\Microsoft SQL Server\90\Tools\Templates\olap\1033.

But I think for specific question regarding particular book you should direct your questions to the author.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi James,

Did you solve your problem of being template drop down being not accessible ? I have exactly the same probelm ?

-TIA
Panks

|||

I guess.... I have figured this out..My sql server installtion is in e: where as my windows dir is d: so MSSQL installed common components in d: , when I created the nested dir structure for cube templates in d: Cube wizard did enable the cube template drop down.

I am never able to understand why MS provides an option of specifying directory when windows drive is indeed a requirement anyway.

-Panks

|||

Hi. I am trying to build cube using cube template with help of brian larson book "delivering business intelligence using SQL server 2005". Books asks to copy sales and inventory folder from book web site to the cube template folder in the sql server(page 131).can you please advice me how to do it? which site to go to?

thanx

|||I am having the exact same annoying problem. Have you found anything?|||

The book's web site is at:

http://mhprofessional.com/product.php?cat=112&isbn=0072260904

Use the Code link on the left side of the page to download the zip file with all of the goodies. You will find the sales and inventory folder in there.

|||I had encountered the same problem, but when following a different book. I discovered that irrespective of where SQL Server 2005 is installed, there MUST be a templates folder on the drive where Windows is installed. In my case SQL Server 2005 was installed on E: and the Analysis Services templates folder the installation created was at E:\Microsoft SQL Server\90\Tools\Templates\olap\1033\. For some reason the Cube Wizard in BIDS cannot see this folder and so no templates are visible in the wizard. If you create a folder with a path of C:\Program Files\Microsoft SQL Server\90\Tools and then copy the Templates folder (and all its contents) from (in my case) E:\Microsoft SQL Server\90\Tools\ to C:\Program Files\Microsoft SQL Server\90\Tools you will be able to see the templates in the Cube Wizard.

HTH
Caryl