Search results for query: *

I have installed SP3a for SQL Server and afterwards SP3a for analysis services as well. This will re-install the MSOLAP drivers. Everything is running smoothly now. Thanks for helping me out V. Borg

This is what I've found : http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307365 After re-investigating I also noticed that there is something not right with my OLAP 8.0 drivers. I will give this article a shot and let you know the outcome. Many thanks for your help. Cheers Borg

Do you remember which dll's were involved? I will search google for it as well in the meantime... Thx Borg

Nope, I can't browse the cube either. No SP3 installed, only SP2 with all possible hotfixes. Thx Borg

Hello, After installing SQL Server Enterprise edition locally, I created two dimensions. (during the creation I already noticed that I could not preview the data) Afterwards, when trying to view the data in each dimension I get the following error : Unable to browse the dimension 'Period'...

Thanks for the answer Duncan. I think you are right.... Thanks Borg

Hello, I have inherited a platform at work that is written in Perl by the collegue I replace. Unfortunately he is no longer here and he left no documentation whatsoever on the code he has written. I managed to sort everything out except for this one rule: grep /^E2EDS01.{48}011\\s*0+\\s/ I...

Hello, I have a dimension which contains numbers representing the months of the year (1 - 12). I would like to display in the cube the names of the months instead of these numbers. I already searched the forum and also looked into the Analysis services manual, but I couldn't find an appropriate...

Hi All, I created a cube that contains 4 dimensions and 1 measure. The dimensions are Region, country, plant and website. The measure is the amount of bytes used. The thing I want to do is show the top 10 most visited(so the ones with the most bytes) sites per region, country, plant. I managed...

Thanks, It seems that Nielson is correct. It does work without SQL Server installed. Thanks for your fast respons Regards Borg

Hi All I was wondering whether it would be possible to install the analysis services on a server that has no SQL Server software on it. On the server there is already Cognos software installed, does anyone knows if this can cause any problems? Thanks in advance Borg

I'm having Analysis Services installed on my PC and want to use a database on a SQL Server. I have read and write access. I manage to create a connection and even create a dimension. But when I want to process a dimension, I get the error "Data source provider error: Login failed for user...

Thanks Andrej, I'll give it a try... Cheers Borg

Hi all, I am having problems connecting to a database residing on a SQL Server2000 machine. However, when creating dimensions I can browse the data. It goes wrong when trying to process a cube. The error I am getting is : Data source provider error: Login failed for user 'NT AUTHORITY\ANONYMOUS...

Ok Mike, Thanks for your help. Cheers Borg

That's how I am doing it now. I was wondering if there was no way to bundle this into one query instead of creating two queries. I mean one SQL statement that extracts the data and saves it into a table. Because a make-table query in access takes quite some time... Thanks Borg

Rookery, Following link may get you started : http://support.microsoft.com/default.aspx?scid=KB;en-us;q164582 Borg

Rookery, If you include the microsoft activex data objects 2.6 reference. You should be able to use ADO. I don't have an example of DAO, but you should be able to find one in Access' helpfile or on the msdn site. Following is an extract from the msdn library : Versions of DAO code prior to 3.6...

SELECT a.DELIVERY_ID , a.DELIVERY_ITEM_NO , a.SAP_SRCE_SYS_CODE , a.CLIENT_ID , a.ROW_INSERT_DATE , a.ROW_INSERT_USER_ID, a.ROW_INSERT_TASK_ID, a.ROW_UPDATE_DATE , a.ROW_UPDATE_USER_ID, a.ROW_UPDATE_TASK_ID...

Hello, the following code is what I'm using... Hope it can help you. Kind regards Borg Set conn = New ADODB.Connection 'Define new ADO connection Set rstmat = New ADODB.Recordse strc = "dsn=DSNNAME;uid=" & Form_frmLogin.txtUserName & ";pwd=" &...