Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c ?
Thanks.
You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c ?
> Thanks.
|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's
>
>.
>
sql

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............
>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
>> Is there a web page where I can monitor the new/old bugs
>> and issues related to SQL Server & Analysis Services,
SP's
>> e.t.c '
>> Thanks.
>
>.
>

Bugs & Issues

Is there a web page where I can monitor the new/old bugs
and issues related to SQL Server & Analysis Services, SP's
e.t.c '
Thanks.You can see a list of hotfixes and the bugs that they fix at
http://www.aspfaq.com/2160 (anything past 8.00.760 is most likely a bug fix
that deals with at least one symptom).
As for a general list of all bugs, no, Microsoft does not publish this
information.
http://www.aspfaq.com/
(Reverse address to reply.)
"Nick" <anonymous@.discussions.microsoft.com> wrote in message
news:b78c01c48938$7353c460$a501280a@.phx.gbl...
> Is there a web page where I can monitor the new/old bugs
> and issues related to SQL Server & Analysis Services, SP's
> e.t.c '
> Thanks.|||Thanks............

>--Original Message--
>You can see a list of hotfixes and the bugs that they fix
at
>http://www.aspfaq.com/2160 (anything past 8.00.760 is
most likely a bug fix
>that deals with at least one symptom).
>As for a general list of all bugs, no, Microsoft does not
publish this
>information.
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Nick" <anonymous@.discussions.microsoft.com> wrote in
message
>news:b78c01c48938$7353c460$a501280a@.phx.gbl...
SP's[vbcol=seagreen]
>
>.
>

Browser tab error/crash in BIDS when I want to browse data

I just a newbie , for SQL Analysis service 2005

I followed Analyasis Service Tutorial to create Analysis Project when I done everything after create data source , DSV , create cube and processing cube. I click deploy project and when I click browser tab it's crash and BIDS(Business Intelligence Development Studio) hang not response.

What should I do ? Any suggestion. While after deploy I can use other tab near browser tab properly.

What kind of error you are getting?

See what happens if you wait a little bit. The deployment is sending command to Analysis Server that needs to process a cube and then executes a query to show your results in BIDS. This all might take some time. So wait till deplyment finishes and then go and browse your data.

See if installing SP2 helps you getting better performace out of your cube.

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

Browser similar to SSAS required for SSRS

Hi,

How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.

Regards

Spandan

As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.

Browser similar to SSAS required for SSRS

Hi,

How to import analysis browser in SSRS. I need features similar to SSAS Cube browser and SSAS dimention browser.

Regards

Spandan

As you probably know, SSRS has an MDX Designer which you can use if you target SSAS 2005. It is possible to host your own query designer although this feature is currently not documented. You need to contact the RS product group for more details.

Browse Cube

Just a question please,

When i browse(query) the cube in analysis services how can i save those queries?Can they be saved anyware?

(By browse i mean explore,drill down data in the Cube Browser of Analysis services 2005.)

Help please !!!

No, you cannot save queries done through the cube browser in the BI Development Studio (BIDS).

You could use Profiler to capture the MDX queries that are sent, but you would then have to use a different tool (like SSMS or Reporting Services) to run those queries. BIDS is not really meant to be a reporting tool. You will need to look at a different tool to do this, Excel pivot tables are probably one of the cheaper, more accessible solutions.

|||

You can capture the queries using SQL Server Profiler:

http://msdn2.microsoft.com/en-us/library/ms174779.aspx

>>

SQL Server 2005 Books Online

Introduction to Monitoring Analysis Services with SQL Server Profiler

You can use SQL Server Profiler to monitor events generated by an instance of Microsoft . By using SQL Server Profiler, you can do the following:

Monitor the performance of an instance of Analysis Services.

Debug Multidimensional Expressions (MDX) statements.

Identify MDX statements that run slowly.

Test MDX statements in the development phase of a project by stepping through statements to confirm that the code works as expected.

Troubleshoot problems in Analysis Services by capturing events on a production system and replaying them on a test system. This approach is useful for testing or debugging purposes and lets users continue to use the production system without interference.

Audit and review activity that occurred on an instance of Analysis Services. A security administrator can review any one of the audited events. This includes the success or failure of a login try and the success or failure of permissions in accessing statements and objects.

BossEveryWare and Analysis Services

After I installed SQL Server Analysis services, I have a .dsv extension in my registry. My anti-spyware program keeps flagging it as the BossEveryWare spyware program because BEW uses .dsv as one of it's main logging file extensions. I have checked for other traces of BEW and cannot find any. I do not have any wierd tcp packets going out either. Am I safe in assuming that .dsv is also used by Analysis services in a safe manner?

Thanks

http://www.nateandrews.com

When I followed the tutorial for analysis services I recall saving Data Source View files. DSV. From that I can imagine you are not having a spyware problem...

You should be safe with your assumption.