Showing posts with label analysis. Show all posts
Showing posts with label analysis. Show all posts

Sunday, March 11, 2012

another problem using permissions in analysis services

Hello!
I have a problem getting information about accuracy (percentage of the right predictions) of the model using DMX. Is it possible to get information about accuracy of the model using DMX? I didn't find any useful function... My second idea was to build and process the model. And then compare states of the predictable columns of the test data to states that the model predicts on the same data. And count them. That would be the way to get percantage of the right predictions... The problem is that usage of the function COUNT is not allowed? I tried:SELECT COUNT(*) FROM [My Model Name].Cases and it didn't work like in standard SQL...
Is it possible to count rows in DMX? Any idea how to get accuracy (percentage) of the model? I would need this information in my application...
Thanx for any idea,
Ziga

Hello

The simplest way to get the percentage of right predictions is to use the Mining Accuracy Chart. Both the lift chart and the classification matrix can give you good information about the overall accuracy.

You can also use SQL Profiler to record the queries sent to the server when the charts are computed, so that you can reuse the queries and get the accuracy information programmatically.

COUNT(*) is not supported in DMX. However, given that you are trying to get the number of rows in the training set (SELECT COUNT(*) FROM MODEL.CASES), this can be replaced with

CALL SystemOpenQuery( [DS], "SELECT COUNT(*) FROM SourceTable")

Where DS is the data source you used in creating the mining structure/model and source table is the main table or view used in creating the data source. SystemOpenQuery executes your query directly against the relational data source behind the mining model

Hope this helps,

thanks

bogdan

|||

Bogdan!

Thanx a lot for your advice! I found a way to count rows in a mining model using AdoDataAdapter which is used to pull the rows from the mining model and put them into DataSet where it is possible to count them in my application. But in a way it is a waste of memory space to pull all the data out of the table.

So it is possible to see which DMX statements or stored procedures Analysis services use while processing mining models and counting accuracy charts using SQL Profiler?

Bye,

Ziga

|||

>But in a way it is a waste of memory space to pull all the data out of the table

you are right, this is potentially consuming lots of memory. Have you tried my suggestion, executing

CALL SystemOpenQuery([Data Source], 'SELECT Count(*) FROM SourceTable' ?

This should work.

An even simpler solution: execute a SELECT * FROM YourModel.CONTENT. The first content node, usually labeled 'All' should contain statistics about the attributes and their states. You can fiure out the number of rows in the training set either by inspecting the NODE_SUPPORT column of the first node or by summing the support for all states of either attribute in the NODE_DISTRIBUTION column.

> So it is possible to see which DMX statements or stored procedures Analysis services use while processing mining models and counting accuracy charts using SQL Profiler?

Yes, just start the Profiler, connect to your server and then play around with the viewers, particularly with the Accuracy Chart tool. In the profiler, you will capture all the statements sent to the server

Hope this helps

thanks,

Bogdan Crivat

SQL Server Data Mining|||

Hello!

Thank you for taking your time...

I tried:

CALL SystemOpenQuery([Data Source], 'SELECT Count(*) FROM SourceTable' )

Actually it didn't work. It looks like the COUNT function is not supported here.

The worning was: The server sent an unrecognizable response

But this statemen without count worked:

CALL SystemOpenQuery([Data Source], 'SELECT * FROM SourceTable'

Aniway, I found the information about nodes using: SELECT * FROM YourModel.CONTENT

Thanx a lot,

Ziga

|||

Hi again!
I have another problem. Permission problems in Analysis services using DMX statement.
In Analysis services I have two databases, DB1 and DB2. Both have Imersonation default. And each database has one data source, first database has data source DS1 and second has DS2. Both of two datasources also have Impersonation default.
When I try to see the content of data using datasources in DMX statement:
1. CALL SYSTEMOPENQUERY([DS1], 'select * FROM table')

2. CALL SYSTEMOPENQUERY([DS2], 'select * FROM table')

The first Query works well and show all data, but the second query does not work.
The error is:
Either the 'DOMA\ziga' user does not have permission to access the 'DS2' object, or the object does not exist.

Object (DS2) surely exist! But I dont know what s wrong with permissions. They' re set just like in the first case which works (default).
Interesting is that both data sources point to the same relational database!

Thanx for any good idea...
Ziga

|||

Hi, Nekdo

Your problem is caused by the permission issue.

To resolve it, first add a role to the Roles directory of targeted Analysis Service Database and check the "read definition" option below the dialog box.

Then, from the membership list item (at top-right corner), choose the account you like.

Finally, click the the data source menu item and make the access of specified data sources to be Read.

Cheers,

Ricky.

another problem using permissions in analysis services

Hello!
I have a problem getting information about accuracy (percentage of the right predictions) of the model using DMX. Is it possible to get information about accuracy of the model using DMX? I didn't find any useful function... My second idea was to build and process the model. And then compare states of the predictable columns of the test data to states that the model predicts on the same data. And count them. That would be the way to get percantage of the right predictions... The problem is that usage of the function COUNT is not allowed? I tried:SELECT COUNT(*) FROM [My Model Name].Cases and it didn't work like in standard SQL...
Is it possible to count rows in DMX? Any idea how to get accuracy (percentage) of the model? I would need this information in my application...
Thanx for any idea,
Ziga

Hello

The simplest way to get the percentage of right predictions is to use the Mining Accuracy Chart. Both the lift chart and the classification matrix can give you good information about the overall accuracy.

You can also use SQL Profiler to record the queries sent to the server when the charts are computed, so that you can reuse the queries and get the accuracy information programmatically.

COUNT(*) is not supported in DMX. However, given that you are trying to get the number of rows in the training set (SELECT COUNT(*) FROM MODEL.CASES), this can be replaced with

CALL SystemOpenQuery( [DS], "SELECT COUNT(*) FROM SourceTable")

Where DS is the data source you used in creating the mining structure/model and source table is the main table or view used in creating the data source. SystemOpenQuery executes your query directly against the relational data source behind the mining model

Hope this helps,

thanks

bogdan

|||

Bogdan!

Thanx a lot for your advice! I found a way to count rows in a mining model using AdoDataAdapter which is used to pull the rows from the mining model and put them into DataSet where it is possible to count them in my application. But in a way it is a waste of memory space to pull all the data out of the table.

So it is possible to see which DMX statements or stored procedures Analysis services use while processing mining models and counting accuracy charts using SQL Profiler?

Bye,

Ziga

|||

>But in a way it is a waste of memory space to pull all the data out of the table

you are right, this is potentially consuming lots of memory. Have you tried my suggestion, executing

CALL SystemOpenQuery([Data Source], 'SELECT Count(*) FROM SourceTable' ?

This should work.

An even simpler solution: execute a SELECT * FROM YourModel.CONTENT. The first content node, usually labeled 'All' should contain statistics about the attributes and their states. You can fiure out the number of rows in the training set either by inspecting the NODE_SUPPORT column of the first node or by summing the support for all states of either attribute in the NODE_DISTRIBUTION column.

> So it is possible to see which DMX statements or stored procedures Analysis services use while processing mining models and counting accuracy charts using SQL Profiler?

Yes, just start the Profiler, connect to your server and then play around with the viewers, particularly with the Accuracy Chart tool. In the profiler, you will capture all the statements sent to the server

Hope this helps

thanks,

Bogdan Crivat SQL Server Data Mining|||

Hello!

Thank you for taking your time...

I tried:

CALL SystemOpenQuery([Data Source], 'SELECT Count(*) FROM SourceTable' )

Actually it didn't work. It looks like the COUNT function is not supported here.

The worning was: The server sent an unrecognizable response

But this statemen without count worked:

CALL SystemOpenQuery([Data Source], 'SELECT * FROM SourceTable'

Aniway, I found the information about nodes using: SELECT * FROM YourModel.CONTENT

Thanx a lot,

Ziga

|||

Hi again!
I have another problem. Permission problems in Analysis services using DMX statement.
In Analysis services I have two databases, DB1 and DB2. Both have Imersonation default. And each database has one data source, first database has data source DS1 and second has DS2. Both of two datasources also have Impersonation default.
When I try to see the content of data using datasources in DMX statement:
1. CALL SYSTEMOPENQUERY([DS1], 'select * FROM table')

2. CALL SYSTEMOPENQUERY([DS2], 'select * FROM table')

The first Query works well and show all data, but the second query does not work.
The error is:
Either the 'DOMA\ziga' user does not have permission to access the 'DS2' object, or the object does not exist.

Object (DS2) surely exist! But I dont know what s wrong with permissions. They' re set just like in the first case which works (default).
Interesting is that both data sources point to the same relational database!

Thanx for any good idea...
Ziga

|||

Hi, Nekdo

Your problem is caused by the permission issue.

To resolve it, first add a role to the Roles directory of targeted Analysis Service Database and check the "read definition" option below the dialog box.

Then, from the membership list item (at top-right corner), choose the account you like.

Finally, click the the data source menu item and make the access of specified data sources to be Read.

Cheers,

Ricky.

Saturday, February 25, 2012

Anonymous Access from Pivot Table to OLAP 2005

My asp-net web application connect to Analysis Services 2005 through Pivot Table client.

To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous".

Which property give me the same thing with AS2005?

Thanks!

Hi,

The SSPI connection property is still there, so it should work the same. Are you getting an error?

David Botzenhart

|||

Hey David - good to hear from you !

Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standard OLEDB property for this purpose, i.e.

Protection Level=none

It has slightly better (more standard) behavior.

Mosha (http://www.mosha.com/msolap )

|||

Thanks, it's working.

But, if i set "Impersonation Level" property to Anonymous? Is this the same of SSPI=anonymous?

Announcing the Analysis Services Stored Procedure Project

A few months ago, a few community-spririted Analysis Services guys (including me) got together to create some example Analysis Services stored procedures. I'm happy to announce that beta 1 of our project is now available to download here:
http://www.codeplex.com/Wiki/View.aspx?ProjectName=ASStoredProcedures
The idea was to create a set of useful extensions to MDX to help solve common problems and at the same time provide some example source code to help people writing their own stored procedures. Please take a look and tell us what you think!

Very Nice!

How about a function that takes care of divide-by-zero and returns NULL if the denominator is 0? Ie. ReturnDivide(division). That would clean up a lot of iif mdx.

|||

We discussed this exact problem, but Mosha explained that using a sproc in this way would do more harm than good. Basically, the problem is that there's no way of marking a sproc as being deterministic (ie will always return the same result for the same cell) and so that means that if you use a sproc in a calculated member then the value returned by that calculation will never be cached. As a result, it's probably better to use IIF instead so that subsequent requests for the result returned by a calculation for any given cell in the cube will be returned from the cache.

To answer your other question about IIF, if <mdxstatement> is a calculated measure whose result can be cached, then no, it will only be executed once and the second time it's evaluated the value will be returned from the cache. So it's good idea to create a calculated measure to hold the value of <mdxstatement> even if you don't intend to display the result to the user and set its Visible property to False.

HTH,

Chris

|||

Just so I understand:
You are saying that the following MDX script will make the server calculate [measures].[summation] once in the scope iif statement:

Create Member [Measures].[Summation] AS

Aggregate({[DimMember1], [DimMember2]});

Scope ([DimMemberX]);

this = iif([Measures].[Summation] = 0, NULL, [SomeSet] / [Mesures].[Summation];

End Scope;

Whereas this statement will make it calculate it twice:

Scope ([DimMemberX]);

this = iif(aggregate({[Dimmember1], [Dimmember2]}) = 0, NULL, [Someset] / aggregate([DimMember1], [DimMember2]));

End Scope;

|||

Yes, that's what I understand.

Chris

Announcement: MSDN Article "Integrating Analysis Services with Reporting Services" Availab

The following whitepaper is now available on MSDN:
"Integrating Analysis Services with Reporting Services" at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp.
Summary: Create a compelling solution for your customer that defines and
manages great-looking Analysis Services reports, and quickly answers
analytical questions to improve traditional reporting scenarios. (33 printed
pages)
The following topics are covered:
Introduction
Developing OLAP Reports Using Analysis Services 2000 and Reporting Services
Datasets and Data Regions in SQL Server 2000 Reporting Services
Defining a Data Source
Building a Static Report with Analysis Services Data
Adding Parameters to an OLAP Report
Adding Additional Interactivity to Reports
Analysis Services Actions
Conclusion
--
Sean Boon
Microsoft Office BI
This posting is provided "AS IS" with no warranties, and confers no rights.In news:OLSM2s7VEHA.1888@.TK2MSFTNGP11.phx.gbl,
Sean Boon [MS] <seanboon@.online.microsoft.com> typed:
> The following whitepaper is now available on MSDN:
> "Integrating Analysis Services with Reporting Services" at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/htm
l/olapasandrs.asp.
> Summary: Create a compelling solution for your customer
> that defines and
> manages great-looking Analysis Services reports, and
> quickly answers
> analytical questions to improve traditional reporting
> scenarios. (33 printed
> pages)
> The following topics are covered:
> Introduction
> Developing OLAP Reports Using Analysis Services 2000 and
> Reporting Services
> Datasets and Data Regions in SQL Server 2000 Reporting
> Services
> Defining a Data Source
> Building a Static Report with Analysis Services Data
> Adding Parameters to an OLAP Report
> Adding Additional Interactivity to Reports
> Analysis Services Actions
> Conclusion
Am I missing something or does the sample code require anything other than
VS 2003 and RS? I wonder about xxx.RDL.XML, which is not recognized to be a
valid report file by ReportDesigner.
Sorry if I'm too stupid to catch the things.
r.

Sunday, February 19, 2012

Anaylsis Services over HTTP

Hi guys,
I am hoping this will be a quick one. I am using Analysis Services 2000 with SP4 on Windows XP. It is the Developer Edition so I should have all the functionality of the Enterprise Edition without the scalability.

Ok, so I have followed the “INF: How to Connect to Analysis Server 2000 By Using HTTP Connection” (http://support.microsoft.com/?kbid=279489) article on MSDN. On completing the steps I did see a blank page, which suggests everything is working properly. However, when I try to connect to Analysis Services via HTTP it is unable to see the OLAP database. I have tried this with the MDX Sample Application, Excel and an OLAP Report web application and neither can connect to the database using HTTP. I can, however, connect to the OLAP database if I connect to the server without using HTTP.

I could well be missing something very simple and if that’s the case then great. I have tried changing the security of IIS to use anonymous, basic authentication and windows integrated authentication but neither affect the visibility of the OLAP database. I have also examined the IIS log files but there is nothing that indicates errors.

Any help would be gratefully appreciated.

Let's try to get this straight:

- you can connect to the server over HTTP

- but you can't see any databases

Is that accurate? If yes, then most likely it is a permissions issue -- turn *off* the Anonymous access and turn *on* Integrated authentication. Then try again.

HTH,

Akshai

Analyzer Tools

Hi,
Is there any tools can help me doing the analysis using SQL Profiler (trc)
files?
Thanks,
Kenny
See if my scripts can help:
http://vyaskn.tripod.com/analyzing_profiler_output.htm
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Kenny" <keejh@.hotmail.com> wrote in message
news:uu5r9EZFFHA.3728@.TK2MSFTNGP14.phx.gbl...
Hi,
Is there any tools can help me doing the analysis using SQL Profiler (trc)
files?
Thanks,
Kenny
|||See read80trace.exe
http://support.microsoft.com/default...b;en-us;887057
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Kenny" <keejh@.hotmail.com> wrote in message
news:uu5r9EZFFHA.3728@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is there any tools can help me doing the analysis using SQL Profiler (trc)
> files?
> Thanks,
> Kenny
>
|||Kenny wrote:
> Hi,
> Is there any tools can help me doing the analysis using SQL Profiler
> (trc) files?
> Thanks,
> Kenny
You can check out our Coefficient product (14-day free trial available).
David Gugick
Imceda Software
www.imceda.com

Thursday, February 16, 2012

Analysis: How to put this in tables?

Hi,
I have some question:
How do I put the folowing stuff into tables:
210004000231023551079690000463 1000000000010000230204841010060
2302040370100
23000400020000000000000000000000 BANQUE ACCORD
59110 LA MADELEINE FR 000
210004000331023551079690000463 1000000000022000230204841010060
2302040370100
23000400030000000000000000000000 BANQUE ACCORD
59110 LA MADELEINE FR 000
210004000431023551079690000463 1000000000008000230204841010060
2302040370100
23000400040000000000000000000000 BANQUE ACCORD
59110 LA MADELEINE FR 000
210004000531023551079690000463 1000000000008400230204841010110
2302040371100
23000400050000000000000000000000 BANQUE ACCORD
59110 LA MADELEINE FR 001
310004000631023551079690000463 84101000100430003 01100 00001408804 11
0 1
310004000731023551079690000463 841010001001BANQUE ACCORD
0 1
310004000831023551079690000463 841010001001RUE JEANNE MAILLOTTE 4/6
0 1
310004000931023551079690000463 84101000100159110 LA MADELEINE FR
0 1
310004001031023551079690000463 841010001002COM 2EME SEM
0 1
310004001131023551079690000463 841010001005SOGEFRPPLLM
0 1
310004001231023551079690000463 841010000 Pi ce justificative en annexe
Votre ordre de paiemen t de 1 0
3200040012 22.000,00 EUR R f rences de l'op ration:
H1040223K007969 Frais du ba nquier correspon 1 0
3300040012dant 1 0,00 EUR Commission de
paiement 0 1
It's really simple:
- 21-records: these are records beginning with "21": they are the
'main'-records containing the information
- 22 and 23-records starting with 22 or 23: details of the 21-record
- 31, 32, 33-records: also details of the 21-records.
positions in 21-record:
- On position 35 I have an indiciation of Credit/Debit
- 83-90: Coding of the 21-record
- 91: Strucutred or Non-Structured.
-> I need these 3 things to identify in some way the 21-record.
Now my question is: I have to put all this stuf in tables, and I need to be
able to do easily and fast query's with it.
I guess the most performant way would be to put every record in it's own
kidn of table: so I would create an tbl21, tbl22, tbl23, tbl31, etc Liek
that I would be able to put the Credit/Debit, Coding etc in there own Column
and than I can do some fast query's on it.
But on the other hand: When I put everything in different tables, it will be
more difficult to have a nice overview of the whole file (21 + 22 + 23 +
... ), and to be able to know which cmae after which one etc.
So I thought about putting everything in one table.
like this:
CREATE TABLE [dbo].[tblExtractChild128] (
[ExtractID] [int] NOT NULL , -> unique ID
[ParentID] [int] NULL , -> indicates which is
the
Parent of the 22, 23, 31-record (so the ID of the 21-record)
[Identification] [varchar] (2) COLLATE French_CI_AS NULL , ->
"21",
"22", "23", "31", "32", "33": to easily see which type of record it is
[Text] [varchar] (128) COLLATE French_CI_AS NULL , ->
contains the whole Line ("210004000231023551079690000463
1000000000010000230204841010060
2302040370100"
[CD] [bit] NULL
-> position 35 of the 21-line: Credit/Debit
[Amount] [decimal](18, 0) NULL
-> Amount = value in EURO of the record
[Coding] [varchar] (8) COLLATE French_CI_AS NULL , ->
83-90:
Coding of the 21-record
[Structured] [bit]
-> 91: Strucutred or Non-Structured.
) ON [PRIMARY]
GO
In which I put all the records, and for the 21-records I use the Columns CD,
Coding and Structured, for the others I don't.
Like this I can do query's:
SELECT DISTINCT r21.*
FROM tblExtractChild128 r21 LEFT JOIN tblExtractChild128 r23 ON (r21.ID =
r23.ParentID)
LEFT JOIN tblExtractChild128 r31 ON (r21.ID = r31.ParentID)
WHERE (r21.Identification = '21')
AND (r21.Coding= '84101006')
AND (r22.Text LIKE '%BANQUE ACCORD%')
AND (r31.Text LIKE '%RUE JEANNE MAILLOTTE%')
Ok, this works: but I have my doubts if this is really the best way to do
all this stuff. Is there a way which will have much more performance? Work
nicer, more easily for maintenance etc?
For those who read this untill the end and try to formulate an answer:
thanks a lot! hehe :-)
PieterPieter,
You may want to start explaining what this data is all about. Then start
identifying what the entity types, their attributes and relationships among
them. Without such information, it is hard to provide any worthy
suggestions.
Anith

Analysis Svc security problem

Hi All
Whether I set roles or non at all to my cubes ANY user can
connect and read data from them via excel.
Is this a known issue? Anyone else having this problem or
am I doing something wrong?
Thanks
JHi,
The Users can access the Cubes by any means, only if they have enough access
rights to the Cube.
Check whether you have added "Everyone" in the Cube Roles mistakenly or whet
her "Everyone" has been added to the System Administrator group or OLAP Admi
nistrator group.
Cheers,
Sanka
-- J wrote: --
Hi All
Whether I set roles or non at all to my cubes ANY user can
connect and read data from them via excel.
Is this a known issue? Anyone else having this problem or
am I doing something wrong?
Thanks
J

Analysis services?

Hi!
I am confused ...downloaded Microsoft SQL server 2005 (for reporting services) to my Windows 2002 (32-bit systems), but it asks me to install the service packs as well...

So Windows XP Service Pack 2 is already installed.
And I need to download Windows server 2000 or 2003 R2, but where could I find a free trial version?

Do I also need Asp.net and IIS?
I would be very grateful for some help... to clarify which components needed.

Since you're wanting RS, you'll need to install SQL Server Express with Advanced Services. Here's the link:

http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx

This product is supported on XP SP2, so you won't need to do any OS upgrades.

Thanks,
Sam Lester (MSFT)

|||Thank you so much!
I get the following answer though "Your OS does nor support the Service Pack required for this SQL server release."

So my OS is 2002...
How do I check which SP required?
I did not find any .net Framework 2.0 SP.|||I managed to download SQL Server 2005 Express Edition with Advanced

Services SP1, and noticed Reporting services are available but how about "Analysis services" ?
|||

Analysis Services does not ship with any of the Express SKUs. It is part of the other SKUs (Enterprise, Standard, etc). If you want to play around with it, you can download the evaluation version found here:

http://www.microsoft.com/sql/downloads/trial-software.mspx

Thanks,
Sam Lester (MSFT)

Analysis Services: Deploy a cube

I'm making my first attempt at creating a cube using Analysis Services based on my exisiting datamart. Datasource, views, and dimensions have been defined. But comes deploying the cube, it's giving the error saying "A connection cannot be made. Ensure that the server is running." The Deploy Target server and database are the same where my datamart is. Or, maybe I don't know what I'm doing.

Would appreciate any suggestion for my enlightenment. ThanksJodJim,

I am assuming you properly specified target server name. Next steps:
1. Make sure that SQL Server Analysis Services service is running. It is not the same service as SQL service. You can do this in Adminitrator Tools ->Services. This is most likely cause why you cannot deploy
2. Make sure you are member of administrators local group on SSAS server. This will give you admin right required to deploy database.

If that does not work:
Start SQL Server Management Studio and connect to analysis services. Any problems? Any messages?

Vidas Matelis
http://www.ssas-info.com
http://www.ssas-info.com/VidasMatelisBlog

Analysis Services: Data source provider error

Trying to go through the Analysis Services tuturial. Logged in as Administrator on a 64 bit W2K server. SQL Server 2000 AS and SP4.

As I come to the Design Storage step I get a message saying
Data source provider error: ; Time:2006-04-10 19:51:47
There are no further details given and the Event Logger has nothing.

Grateful for any help.

Screenshot: http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem.png

And the version Screenshot:
http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem2.pngReason was probably that I defined the data source as a User DSN. Should have been System DSN.

I opted to use Jet instead or the Access driver - solved it.|||I'm just starting out with Analysis Services. Also new working with databases. A friend of mine sent me a couple of Databases and they are files with .mdf file extensions. When I try and setup datasource in the control panel wizard, there are no drivers with the .mdf extensions. Just .dbo and others.

Could you explain to me what I need to do to get AS to work with my databases?

Thanks in advance,
Milfredo|||No idea how the drivers are distributed, but I guess installing MS Access will do it. Probably instaling Analys Services includes driver installation.

I am more of a unix guy, so do not trust me. :D

Analysis Services, msmdpump.dll and IIS.

Hello:

I have two servers, one hosting Analysis Services and the other just serves as webserver.

I have configured msmdpump.dll on the Analysis Services server succesfully using basic authentication. But now I need the webserver to provide Analysis Services data. I thought that I would be sufficient to repeat on the webserver the same configuration steps that I folowed on the Analysis Services server and change the <ServerName> tag in the msmdpump.ini file to point to the last one.
Well, this isn't working.

What am I missing? Is there any tutorial or resource to accomplished?

I guess the problem you are having has to do with configuring permissions.

First make sure you can connect from your web server to Analysis Server using some client application. Then try and run your client application with the credentials of the user configured for your vitutual directory in IIS. Make sure you can connect in this case.

Some help with troubleshooting connectivity problems is found here: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

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

|||

Some files inetinfo.exeRandomNumber.mdbp or .hdmp (c:\windows\pchealth\errorrep\userdumps) and RadomNumber.cab or.txt (c:\windows\pchealth\errorrep\qsignoff) are eating away my Disk Space and I do not know how to stop it. Please help me. TIA. Gilda

PS: I have ISS 6.0 installed in a Windows Server 2003 in which is installled the exchange 2003.

Analysis Services, msmdpump.dll and IIS.

Hello:

I have two servers, one hosting Analysis Services and the other just serves as webserver.

I have configured msmdpump.dll on the Analysis Services server succesfully using basic authentication. But now I need the webserver to provide Analysis Services data. I thought that I would be sufficient to repeat on the webserver the same configuration steps that I folowed on the Analysis Services server and change the <ServerName> tag in the msmdpump.ini file to point to the last one.
Well, this isn't working.

What am I missing? Is there any tutorial or resource to accomplished?

I guess the problem you are having has to do with configuring permissions.

First make sure you can connect from your web server to Analysis Server using some client application. Then try and run your client application with the credentials of the user configured for your vitutual directory in IIS. Make sure you can connect in this case.

Some help with troubleshooting connectivity problems is found here: http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx

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

|||

Some files inetinfo.exeRandomNumber.mdbp or .hdmp (c:\windows\pchealth\errorrep\userdumps) and RadomNumber.cab or.txt (c:\windows\pchealth\errorrep\qsignoff) are eating away my Disk Space and I do not know how to stop it. Please help me. TIA. Gilda

PS: I have ISS 6.0 installed in a Windows Server 2003 in which is installled the exchange 2003.

Analysis Services with Oracle

Does anyone know if using Analysis Services with Oralce via OLEDB adversly affects performance compared to using it with a SQL Server Database?I use Oracle 8.1.7 with Analysis Services. I can't really compare between the performance with SQL Server, but performance is OK with Oracle. We use views as the sources, so those needed to be tuned.
The processing of a cube gives you the exact SQL statement it performs, so you can tune these. These will eat up considerable space in the Oracle temp tablespace, because of the sorts.
Another factor is of course the network speed between the database server and the Analysis Services server.

BTW: Because we encountered 'Data Source errors' we now use (after some hours searching for a solution) the Oracle provided OLE DB provider for defining the cubes and dimensions and the 'Microsoft OLE DB provider for Oracle' for processing those. Don't ask me what the difference exactly is, but this way it works fine for me.

Good luck, Edwin

Analysis Services will not start after failover

On Thursday, everything was fine. On Friday my second virtual instance
of SQL Server was now on Node 2 for some reason. I tried to move it
back to Node 1 and it failed and continued to go back to Node 2. I
looked for errors in the SQL Error log and the system error logs and no
information why the system failed in the first place.
Now I was able to get the second instance of SQL Server back over to
Node 1 but the Analysis Services and the MSOlap resources along with
one additional resource will not come back on either Node.
When Analysis Services was first installed on the cluster (yes I know
it isn't cluster aware), I failed over the node and Analysis Services
worked fine.
Anyone have any ideas? Luckily this is the test system, but until I
get this figured out, I won't even think about production.
If you have absolutely no errors, then you'll have to open a support case
with PSS. I couldn't even begin to guess what might be wrong without an
error message to point to something
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Benny" <wildfire77@.peoplepc.com> wrote in message
news:1144166302.904251.252350@.u72g2000cwu.googlegr oups.com...
> On Thursday, everything was fine. On Friday my second virtual instance
> of SQL Server was now on Node 2 for some reason. I tried to move it
> back to Node 1 and it failed and continued to go back to Node 2. I
> looked for errors in the SQL Error log and the system error logs and no
> information why the system failed in the first place.
> Now I was able to get the second instance of SQL Server back over to
> Node 1 but the Analysis Services and the MSOlap resources along with
> one additional resource will not come back on either Node.
> When Analysis Services was first installed on the cluster (yes I know
> it isn't cluster aware), I failed over the node and Analysis Services
> worked fine.
> Anyone have any ideas? Luckily this is the test system, but until I
> get this figured out, I won't even think about production.
>

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workaroundsBTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>

Analysis Services web application authentication problem

In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds
BTW: If the web app uses basic authentication then everything works......
"Andrew Wiles" <ajw@.nospam.please> wrote in message
news:edNjY9rhEHA.1964@.tk2msftngp13.phx.gbl...
> In the following sceanrio
>
> Web application uses Analysis Services to present data.
> Web App (IIS) is installed on a different server to the SQL Server
instance.
> Web app uses Windows Integrated authentication.
>
> It appears that the authentication is not correctly passed to AS and that
> the app then fails.
>
> This does not seem to be the case where AS and IIS are installed on the
same
> machine.
>
> Does this sound familiar and if so are you aware of any fixes/workarounds
>
|||Hi Andrew,
I realise this post is getting quite old now, but We are experiencing the same problem here,
Did you manage to get it resolved?

Quote:

Originally posted by Andrew Wiles
In the following sceanrio
Web application uses Analysis Services to present data.
Web App (IIS) is installed on a different server to the SQL Server instance.
Web app uses Windows Integrated authentication.
It appears that the authentication is not correctly passed to AS and that
the app then fails.
This does not seem to be the case where AS and IIS are installed on the same
machine.
Does this sound familiar and if so are you aware of any fixes/workarounds

Analysis Services vs Report Models

What are the differences beetwen AS and RM?
KamelAS is much bigger and its a Datawarehousing tool. RM is just to create adhoc
queries. You can see RM as a tool you can give it to your top management so
that they can create reports on the fly. by giving user friendly columns even
top management can create reports they need. AS on the otherhand will arrange
data in such a way that viewing data pertaining to previous years are fairly
simple.
More search on the "sql server books 2005 online."
Amarnath
"kamel" wrote:
> What are the differences beetwen AS and RM?
> Kamel
>|||Thank you!
But still I can create Report Model from AS, so what's the difference?
Kamel

Analysis Services upgrade to Enterprise Edition

I was running SQL 2000 Standard with the Analysis Services
repository in a SQL database.
I upgraded SQL to Enterprise. When a user tried to create
a partitioned cube he got: user-defined partitions are
available only if you install Analysis Services SQL Server
2000 Enterprise Edition
I "upgraded" to Analysis Services Enterprise - actually
all it did was reinstall. Since I had already migrated
the repository to SQL, my cubes did not exist.
Here is probably where my mistake occurred: I "re-
migraded" the repository to SQL ... my cubes are still not
there.
I have since restored the repository database from a pre-
upgraded Analysis Services version ... my cubes are still
not there.
I have a large project that is waiting for these cubes.
Please tell me I have a chance of getting these cubes back!
Does anyone have any suggestiongs?
TIA
WadeIf you were using SQL Database A as repository before upgrading and
migrating repsitory to SQL Database B after upgrading, then restore the
backup to Database A won't help. You need to edit the repository connection
string so it points to the database holds the right meta data for OLAP.
Thanks
Wei Zhang
Microsoft OLAP Support