显示标签为“msdn”的博文。显示所有博文
显示标签为“msdn”的博文。显示所有博文

2012年3月9日星期五

FiscalWeekOfQuarter missing

When I build a time dimension, FiscalWeekOfQuarter does not show up. On the following MSDN page it is listed as an attribute.

http://msdn2.microsoft.com/en-US/library/ms175662.aspx#time_dimension_attribute_types

Anyone know how I can add it? Thanks.

Can you describe the steps you took to build the dimension? I just ran through the dimension wizard, building a server-based time dimension and an attribute of type "FiscalWeekOfQuarter" was created by the wizard. I also looked at an existing time dimension I had based on a dimension table and I can select "FiscalWeekOfQuarter" as the Type for an existing dimension attribute...

Dave Fackler

FiscalWeekOfQuarter missing

When I build a time dimension, FiscalWeekOfQuarter does not show up. On the following MSDN page it is listed as an attribute.

http://msdn2.microsoft.com/en-US/library/ms175662.aspx#time_dimension_attribute_types

Anyone know how I can add it? Thanks.

Can you describe the steps you took to build the dimension? I just ran through the dimension wizard, building a server-based time dimension and an attribute of type "FiscalWeekOfQuarter" was created by the wizard. I also looked at an existing time dimension I had based on a dimension table and I can select "FiscalWeekOfQuarter" as the Type for an existing dimension attribute...

Dave Fackler

2012年2月24日星期五

first analysis service project+deployment failure

I created small analysis service project as according to the MSDN.
and when i test the database connection it says its okay.
but when i try to deploy , it says

'The project could not be deployed to the '(localhost)\SQLEXPRESS' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.'.

what kind of security or other configurations i should do.
what went wrong?

i know someone might have answered this earlier also.
pl help on this.I had kinda the same problem a while ago, when I started the following thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1247494&SiteID=1

Hope this'll be helpfull :-)|||

The message "'The project could not be deployed to the '(localhost)\SQLEXPRESS'" means that you are trying to deploy an AS project to a SQLServer EXPRESS edition?

Because SQL Server EXPRESS edition doesn't support Analysis Service.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx