Hello
I get the following error message in one of my ASP applications:
--------------------------
Microsoft OLE DB Provider for Analysis Services error '80004005'
Cannot connect to the server '172.16.103.14'. The server is either not started or too busy.
--------------------------
The IIS server is on a different machine to the MSOLAP server.
When I change the ASP code to point the 'localhost' it runs fine so Im fairly confident the necessary db conn libraries are installed on the IIS server.
There does not appear to be any traffic between the IIS/MSOLAP servers. Although all TCP ports are open. Interestingly, there are other pages on the same site that access a SQL Server resident on the MSOLAP servers & there are no issues.
Any assistance on this matter would be greatly appreciated. (I am a relative novice re: ASP/MSOLAP/IIS etc)Howdy
Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.
Can you ping the IP address from a dos window on the server?
Cheers
SG|||You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.|||Originally posted by sqlguy7777
Howdy
Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.
Can you ping the IP address from a dos window on the server?
Cheers
SG
Everything seems to be in order on this front. You will note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK.|||Originally posted by beyond cool
You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.
Everything seems to be in order on this front. Note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK...unless im missing something here....|||Howdy kalaa,
Can you confirm you can do these things :
(1) Ping the SQL box by name from the web server from a dos window on the web server e.g. ping <SQL_Server_name>. This will test if you have connectivity to the SQL box from the web server and more importantly confirm the SQL box is recognised in DNS.
(2) you have a valid SQL user ID set up on the SQL box, and that user ID has at least read access in the required database on the SQL box.
This is the user ID that the web application will use to talk to the SQL box.
Cheers,
SG
Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts
Friday, March 23, 2012
Microsoft Neural Network, how do I feed it ?
Hello there,
I'm working with Analysis sevices 2005 developer edition. Looking through the documentation i becomes apperent that the NN algorithm takes 255 input attributes by default. This can be changed to any integer value, OK....
My problem is that I want to feed the network with 40000 input variables. In order to do so, I will have to do a select:
SELECT fld1, fld2, ...... fld39999, fld40000
FROM tblSometable
However, this is not possible, as the books online describes it is only possible to return 4096 columns from a select statement.
Question : How do I populate a NN in AS2005, with nmore than 4096 inputs ?!
The limit may actually be smaller. SQL Server supports, I think, only 1024 columns
Analysis Services 2005 supports the concept of nested table which allows multiple related tables to be included in modeling.
With nested tables, Analysis Services can use much larger input sets (even hundreds of thousands) represented in multiple tables. Some details on the nested table concept are available here. http://msdn2.microsoft.com/en-us/library/ms175659.aspx
However, this is a data modeling issue and not related to the NN 255 default limit.
The NN algorithm (and many other algorithms included in SQL Server 2005) will always perform feature selection,using (by default) 255 input attributes. it means that, even when your data contains 40K inputs, NN will still use, by default, only the most significant 255. To increase this limit, change the value of the MAXIMUM_INPUT_ATTRIBUTES algorithm parameter. This parameter has the same name for all the algorithms that perform feature selection. If you cange this parameter value to, say, 40000, then all 40K inputs will be used.
|||
Thanks.
I suspected I could do this using nested tables. Thanks for confirming this. Time might be an issue, however. Mu current test-network consisting of 1000 inputs (MAX_INPUT_ATTRIB = 1000), that are zeros and ones, takes +3 hours on a 3.0Ghz PentiumD with 3 GB om memory. Is the time going to grow exponential or linear with the number of input nodes ?
regs,
Mads
Microsoft Neural Network, how do I feed it ?
Hello there,
I'm working with Analysis sevices 2005 developer edition. Looking through the documentation i becomes apperent that the NN algorithm takes 255 input attributes by default. This can be changed to any integer value, OK....
My problem is that I want to feed the network with 40000 input variables. In order to do so, I will have to do a select:
SELECT fld1, fld2, ...... fld39999, fld40000
FROM tblSometable
However, this is not possible, as the books online describes it is only possible to return 4096 columns from a select statement.
Question : How do I populate a NN in AS2005, with nmore than 4096 inputs ?!
The limit may actually be smaller. SQL Server supports, I think, only 1024 columns
Analysis Services 2005 supports the concept of nested table which allows multiple related tables to be included in modeling.
With nested tables, Analysis Services can use much larger input sets (even hundreds of thousands) represented in multiple tables. Some details on the nested table concept are available here. http://msdn2.microsoft.com/en-us/library/ms175659.aspx
However, this is a data modeling issue and not related to the NN 255 default limit.
The NN algorithm (and many other algorithms included in SQL Server 2005) will always perform feature selection,using (by default) 255 input attributes. it means that, even when your data contains 40K inputs, NN will still use, by default, only the most significant 255. To increase this limit, change the value of the MAXIMUM_INPUT_ATTRIBUTES algorithm parameter. This parameter has the same name for all the algorithms that perform feature selection. If you cange this parameter value to, say, 40000, then all 40K inputs will be used.
|||
Thanks.
I suspected I could do this using nested tables. Thanks for confirming this. Time might be an issue, however. Mu current test-network consisting of 1000 inputs (MAX_INPUT_ATTRIB = 1000), that are zeros and ones, takes +3 hours on a 3.0Ghz PentiumD with 3 GB om memory. Is the time going to grow exponential or linear with the number of input nodes ?
regs,
Mads
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
sql
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserv...5/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.
Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pro.../dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pro...y/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/err...rror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron
|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pro.../default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/errorpages/smarterror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbengine.mspx
And this only led me to the downloadable version. How I ended up getting to
the actual online version was by going to http://msdn.microsoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/errorpages/smarterror.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/prodtechnol/sql/2005/library/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
--
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft launches SQL Server 2005.
Today at 9AM Pacific Standard Time Steve Ballmer launches Microsoft SQL
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Server 2005, our next generation data management and analysis software. You
can follow the launch, including a Webcast of the launch from this Web site:
http://www.microsoft.com/windowsser...l
t.mspx
In addition, the SQL Server Web sites have now been updated to cover SQL
Server 2005:
SQL Server product site: http://microsoft.com/sql
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
Data Access and Storage Developer Center: http://msdn.microsoft.com/data
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights.Thanks Alan, I have a couple of issues.
(1) Books Online:
Is this the permanent URL for Books Online?
http://msdn2.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
The "msdn2" subdomain, as well as the use of parentheses in the URL, make it
seem like more of a temporary resting place to me. You might also make
links to this online version a bit more prominent; it took me several
minutes to find. It took me 4 or 5 clicks to get to this page, which
finally had Books Online listed under the toolbox:
http://www.microsoft.com/technet/pr...rosoft.com/sql/ and
clicking on Learn SQL Server 2005 > What's New in SQL Server 2005, then
navigating my way up the left-hand navigation tree.
(2) on the following URL:
http://www.microsoft.com/technet/pr...ry/default.mspx
All the links under "Browse by Task" are 404 and lead to:
http://www.microsoft.com/library/er...error.aspx?404;
Their equivalent links in the left nav (flyout menu) work fine.
(3) The SQL Server 2005 item in the left nav is very unintuitive. Why would
I look under "SQL Server 2005" for links to SQL Server 2000 and SQL Server
7.0? I suggest using a menu like "Previous Versions" or "Other Versions"...
the guy in the next cube had a pretty good laugh when I showed him what is
currently under that menu. I guess it made more sense to him than it did to
me, or he has a weird sense of humor.
Thanks,
Aaron|||The MSDN2 URL's are temporary. When the MSDN Library is migrated into the
new MSDN publishing system, the URLs will be changed to remove the 2, so the
URL you listed will change to:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx
I'll talk to the SQL Server site managers about doing other links to the
copy of the Books Online in the MSDN Library. For the launch we concentrated
on having the SQL Server Web site pages link directly to the sections of the
Books Online that were most relevant, so the pages actually have many links
to that copy of the Books Online. Where we talk about the Books Online as a
whole, especially where we talk about getting the download, we should also
let people know about the copy in the MSDN Library and link them there.
The site manager has fixed the links on
http://www.microsoft.com/technet/pr...y/default.mspx,
thanks for letting us know.
We are also discussing a change to the SQL Server 2005 link in the left nav
column.
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Wednesday, March 21, 2012
Microsoft Excel Add-In for Analysis Services
Our customer is using the latest version of the Microsoft Excel Add-In for Analysis Services in a Microsoft Excel ver 10.6823.6735. When using a filter on a report that queries a SSAS 2005 (SP1) cube Excel stops responding. Does anyone have an idea what to do or what to look for? Any help is welcome.
Thanks
Hi,
By 'Stop responding',
Do you mean that excel does not display any data?
or applying the filter does not filter the necessary data?
Regards
sqlMonday, March 19, 2012
Microsoft Analysis Services on the web problem
Hi All!
We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:
Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services
Client: Active X Cube Browser included with Office 2000 - Pivot Table Services
For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:
"The operation requested failed due to security problems - the user could not be authenticated"
If you have any idea or suggestion about this problem, let me know.
Thanks!
IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.
Try setting up the accounts to use SQL only authentication & see how you go.
Post back if probs
J.|||Thanks for your advice, but we already solve the problem.
We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.
Thanks again,
Ignacio|||HII
Can u tell me what was the permissions in the cube.
1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.
Regds
Ram
Originally posted by isbampato
Thanks for your advice, but we already solve the problem.
We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.
Thanks again,
Ignacio|||Ram,
we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.
Besides, we added basic web authentication to the web page with the online cubes.
We didn't analyze yet how to secure this because it's still at a test phase.
Best regards,
Ignacio
We are trying to implement a web solution which include some OLAP cubes. We are using the followings applications and components:
Server: Windows 2000 - Microsoft Internet Information Server - SQL Server 2000 - Microsoft Analysis Services
Client: Active X Cube Browser included with Office 2000 - Pivot Table Services
For access the cubes, we developed an ASP which includes the Active X, and connect to the Analysis Services server. If i access this web page from the server, i can view the cube, and use it without any problem, but if i try to access the cube accross internet, i am having the following problem:
"The operation requested failed due to security problems - the user could not be authenticated"
If you have any idea or suggestion about this problem, let me know.
Thanks!
IgnacioIt depends on the secuity mode you are using with SQL server most sane people wont let NT authentication through their firewall which leaves SQL logins only.
Try setting up the accounts to use SQL only authentication & see how you go.
Post back if probs
J.|||Thanks for your advice, but we already solve the problem.
We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.
Thanks again,
Ignacio|||HII
Can u tell me what was the permissions in the cube.
1) if the cube gave has access to everyone . How did u restrict people on the network to access the cube.
2) if it was specific domain users. How did u manage to propagate security of a user accessing from the page.
Regds
Ram
Originally posted by isbampato
Thanks for your advice, but we already solve the problem.
We need to install SQL Server 2000 Enterprise Edition, because it has http connection and it works.
Thanks again,
Ignacio|||Ram,
we didn't configure a secure environment yet, because the cubes were prepared only for a demo in our intranet. We have created a test database, and a test set of cubes, and added a new user only for use in this test environment, and with full control over it.
Besides, we added basic web authentication to the web page with the online cubes.
We didn't analyze yet how to secure this because it's still at a test phase.
Best regards,
Ignacio
Microsoft Analysis Server 2005 and .NET 1.1
Hi,
Firstly, I had to post this query here since I did not find any other place relating to Microsoft SQL Analysis Server 2005 and that it is related to SQL server 2005.
I am using Microsoft SQL analysis server 2005 and .NET 1.1 for Asp.NET (C#)
I need to programmatically create Measures, Dimensions and Cubes using .Net 1.1 (C#) in an Asp.NET page, and then I need to access the measures, dimensions and cubes again from another Asp.Net page.
My querys are:
1. To create and manipulate the SQL Analysis server objects like Dimensions, Cubes what should I use? The documentation for Analysis server 2005 says we can use (Analysis Management Objects)AMO. but I am not sure if we can use it with .NET 1.1?
2. If AMO is possible, then what to use? There is one more technology we can use called as (Deciscion Suport Objects) DSO. but they are COM based and were for Analysis services 2000.
3. To query the data, what technology can I use? Microsoft says we can use ADOMD.NET. Microsoft also gives many other technologies that I think do similar work, like XMLA, ASSL.
Can somebody help me in this.
Also please do give me some links that have code samples for the same.
Thanks and Regards
Vijay R
Analysis service in SQL Server 2005 is on the calculus end of the relational model and Microsoft is compliant with all the Calculus algorithms. When I tested SQL Server 2005 in beta 2 there is a management studio for Analysis service if you don't have it installed I suggest you do so because you can get sample ADOMD.NET code from the templates. I dont think you can use DSO(decision support object) with your web application because your database must be Denormalized and the tables read only which was required in SQL Server 2000 because Microsoft had only two Calculus algorithms and one was flawed.
But SQL Server 2005 comes with something that let you strip the algebra and move to Calculus in one step called UDM(unified dimension modeling).
Try the links below for more info and the last link is the site of the person who created the Calculus end of the relational model. Hope this helps.
http://www.microsoft.com/sql/solutions/bi/default.mspx
http://www.mosha.com/msolap/yukon.htm
http://www.rkimball.com/
Friday, March 9, 2012
metadata services for analysis services
Hi,
I was wondering if anyone can tell me what options do I have to browse metadata for a cube built on Analysis services 2005. We would not like to buy a new thrid aprty tool for this. Does sql server 2005/ analysis services 2005 have a inbuilt option to view the metadata?
Thanks in advance.
Try running an AMOBrowser sample applicaiton. You should be able to see all Analysis Services metadata.
Another point here is: In version 2005 Analysis Services metadata is in XML format and it is easily obtainable. Go to the SQL Management studio, right click on any object and you can create a script containing metadata definition of the object. You can parce the XML yourself and manipulate it the way you want.
Hope that helps.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
thank you so much for the information. But i dont see any place at microsoft where I download the amoBrowser. Can you point me where I can find the amoBrowser and its installation files?
thanks again.
|||AMOBrowser is part of the Samples you install with the product. You dont need to download it separately.
After installing the Samples you should be able to find it on your machine in C:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
nevermind, i found it here,
http://msdn2.microsoft.com/en-us/library/ms160930.aspx
thanks again.
Wednesday, March 7, 2012
Meta Integration Solutions
Hi,
Has anyone experience with Meta Integration Solutions and converting to SSIS ?
and converting to SQL ?
and converting to Analysis Server ?
and converting to Reporting Server ?
You can find their website http://www.metaintegration.net/Products/Overview/Solutions.html
Constantijn Enders
You can check out http://www.metaintegration.net/Partners/Microsoft.html for specific versions supported. Scroll down where it says SSIS (dtsx) packages will be supported from their 6/1/07 release. The contact info of folks from MSFT are available on the same page.Meta Integration Solutions
Hi,
Has anyone experience with Meta Integration Solutions and converting to SSIS ?
and converting to SQL ?
and converting to Analysis Server ?
and converting to Reporting Server ?
You can find their website http://www.metaintegration.net/Products/Overview/Solutions.html
Constantijn Enders
You can check out http://www.metaintegration.net/Partners/Microsoft.html for specific versions supported. Scroll down where it says SSIS (dtsx) packages will be supported from their 6/1/07 release. The contact info of folks from MSFT are available on the same page.Meta Data Management / Dependancy Analysis
BI perspective, meta data management is quite crucial. In SQL 2000, as far as I know we didn't have a great support for meta data. Has that changed in SQL2005?
What about dependancy analysis? For example if I drop a column from a SSIS data flow what would be affected? Is it possible?
Thanks
Hi Thiru,Re: Dependancy analysis: IDW 13 (I think) contained new functionality in the data-flow that detected when the metadata of the data-flow was not correct (e.g. If a column gets deleted from a component all downsteam componentrs will be affected) and prompts the designer with a number of options to fix. Of course, this same functionality is still there.
Re: Metadata management: What sort of metadata do you want to manage (e.g. metadata about the pipeline, execution metadata etc...?
How do you want to manage it?
-Jamie|||Jamie
We have used AbInitio EME (yes I know very very expensive product) at Reuters. Which does meta data management very well. This enables us to let the user community (via web site) to see where the data comes from and how we have transformed etc. So users can see it very clearly what calculations have been conducted etc.
At General Motors, SAS consultants used to show how SAS does dependancy analysis. I thought it was quite impressive.
I would like to see these two features inside SQL Server / even if we have to purchase it as separate product(s).
So my question, "is MS going to provide similar tools like their competitors?" I did speak to few MS speakers at TechEd, but didnt get any definite answer. Jamie, I was wondering whats your opinion on this?
Maybe Kirk or Ash can shed any light?
Thanks
Sutha|||Sutha,
Informatica too has a fantastic real-time monitoring tool called the Workflow Monitor. I asked a while back whether SSIS was going to get anything similar and was told "Not in this version".
Remember that this is still a version 1 product and even though there's a tremendous raft of features perhaps we shouldn't be expecting metadata tools such as these too early.
I'd be particularly interested to see if Donald has any thoughts on this but unfortunately he doesn't check this forum.
-Jamie|||Jamie
Infact I did speak to Donald about thing among other things. He didnt give me a definite answer and therefore I did assume it is not there. I did ask him about AbInitio data profiler and what is equivalent in SSIS. He did point that grpahs can act as a data profiler. I think MS need to make improvements on Data Profiler side too.
To compete with AbInitio, Informatica and other products, MS have to come up with a tool which can compete at same level. MS can compete very easily on price as the other products are extremly expensive.
Lets see what Kirk or Ash got to say!
Thanks
Sutha|||Hi guys, thanks for the questions. We're still just trying to get Yukon out the door. So, as you can imagine, we haven't quite transitioned to V.next discussions. We're aware that metadata management is something people are asking for. However, what that means to one person may be totally different than for another.
We're aware of what competitors provide, and will be looking at how to best fill the needs of our customers. As we get closer to planning v.next, we'll be eliciting more input like this from you our customers. We have some ideas about what's next, but we'd like to hear what you have to say.
Thanks,|||Thanks Kirk. I understand you are trying to get the product shipped in time. For next release it would be great if we could have something to cater for these 3 major areas.
Data Profiler (We can do now to a cretain extent)
Metadata Management Tool
Dependancy Analysis Tool
Sutha|||Can you describe those a little better to me? Please send me email directly and we can take this off line. Thanks,
K
Kirkha[at]Microsoftdotcom|||Ok ta. I will do that.
Thanks|||
In all of the responses I did not see where someone said if there is a way to at least generate some sort of meta data reports of the packages. Yes it is in xml, but I assume Microsoft at least has a way to retrieve meta data easilly. For examples Tasks Names, Sources, Variables and etc. Quite obviously not every one will want to open Visual Studio to find out what DTS packages we have servicing a Warehouse. Can anyone provide some insight on this?
|||Henry,I haven't heard of anything like that but it sounds like it could be a useful little tool.
Perhaps a .Net utility that uses X-Query to get at the elements of the .dtsx file? I can really see some value in something like this. I imagine someone in the SSIS community will come up with something like that before too long!
-Jamie|||Jamie
As you say someone will come up with something soon. It is going to be a valuable tool. Clients enquire this type feature when we try to sell MS DW solution to them. Maybe Darren and Allan can come up with something? hint hint :-)
Thanks
Sutha
PS - Jamie, I haven't done that mail yet
Subscribe to:
Posts (Atom)