I've installed OLAP, SP1 & 2. But when I try to register that OLAP server from my machine using the OLAP Manager interface, I get the error: 'Cannot retrieve the repository information..'. Any ideas?
Thanks!
I am trying to migrate the default repository that is created when you install OLAP on a server. I have done this on my local server and several other servers without a problem. When I goes through the steps to migrate the repository it says it completes sucessfully but leave the repository pointing at the mdb file. On the other servers it has updated the pointer to the SQL database. I am running SQL2000 SP2, AS SP2 and W2000. The only difference I can find it that the server where it doesn't work also has two named instances on it.
Any help would be appreciated.
Hello All,
Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.
--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220
Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com
"Once in a while you can get shown the light
in the strangest of places if you look at it right"
JG 1942-1995 RIP
How to repair a corrupted OLAP database?
View 2 Replies View RelatedHi all ,
The DTS packages I saved in Repository is found disappeared
But when I tried to save a new one with old package name I got an error message that its already there. What should I do in order to veiw all the stored packages in the repository ?
Thank You all
How can I see the repository dts packages.
I want to move repository dts packages from server1 to server2.
Help me please.
TIA,
Paul
I have several Repository DTS packages on my server, but these are not available on all client machines. I have no problems working on these packages from my workstation, or some of my coworkers, but others cannot even see the packages. In fact, when logged onto the server itself, the packages don't show up!!
Has anyone seen this, and is there a fix?
Thanks,
Patrick
How can move repository stored dts packages. Where do they store?
TIA
paul
... and not being able to open them anymore.
I am working with SQL Server 7.0 SP 1. Everything seemed to be running OK but from some days ago when I create a new DTS package and I save it in MS Repository, the package doesn´t appear under the "Repository Package" folder even when I refresh it.
I know it is there because I can see it in the Metadata folder, but there I can not modify it. What happened? Are DTS packages secure? Should I better use local packeges and save them in SQL Server?
Thanks a lot.
I'm trying to create a Data Dictionary view from system table info like tablename, fieldname, datatype etc. I can find all that I need except for the "description" field which is displayed in Enterprise Manager/ Repository metadata pane.
How can I locate this field so I can reference it in a view? Isn't it stored in a system table? Master, model? Where is it?
Thank in advance,
Phil
Ok .. I know it is my mistake ...
I deleted the Analysis Server Repository database from my development server ....
Is there a way to rebuild it from the files ....
Help Me !!!!!!!!!!!!!
We configured IDERA SQL Safe for backups and restores.we setup an email for notifications. One day we performed manual backup operation for 150 databases from SQL Safe tool. Unnoticed it backed up to C:Backup folder.
We got alerts with the report of backups on C: drive. Then we moved backup files to respective folders.But, I could not clear the records from the report, its been 25 days, still we are receiving the alerts as below.How can I clear this report or to configure or setup anything to avoid this, in future as well.
Below is the sample records from the report. I need this report to be cleared.
Subject: SQL Safe Validation Report
The following files are recorded in the SQLSafe repository, but no longer exist in their locations:
C:BackupLUXOR_DB_GroupEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_InsightEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_IMEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_SiteEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_SiEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_ICEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_vdbEPF_Diff_201402050045 (1 of 1).safe
C:BackupLUXOR_DB_M_SEPF_Diff_201402050045 (1 of 1).safe
if someone can throw light regarding the metadata repository creation,its usuage , it will help me out.
View 5 Replies View Related
Hello to all members.
I am using SQL Server 2005 std edition 32 bit
The database is configured in compatibility mode to sql server 2000
The backup mode for the database is configured as simple
With SQL Server Agent I am running schedule task of the backup script
The question is:
I would like to save only the last 7 days in repository.
This means that when the 8th days has become then the 1st day backup is deleted.
in the 9th day the 2nd day backup file is deleted.
and so on
I am using the the T-SQL BACKUP DATABASE command with the following arguments:
RETAINDAYS = 7
NOFORMAT
NOINIT
SKIP
I am in situation that the command above only append to the backup file and without deleting the expired backup days.
What I need to change in the parameters that the script will delete the expired backup days.
Thanking in advance everyone who assist.
Hello to all members.
I am using SQL Server 2005 std edition 32 bit
The database is configured in compatibility mode to sql server 2000
The backup mode for the database is configured as simple
With SQL Server Agent I am running schedule task of the backup script
The question is:
I would like to save only the last 7 days in repository.
This means that when the 8th days has become then the 1st day backup is deleted.
in the 9th day the 2nd day backup file is deleted.
and so on
I am using the the T-SQL BACKUP DATABASE command with the following arguments:
RETAINDAYS = 7
NOFORMAT
NOINIT
SKIP
I am in situation that the command above only append to the backup file and without deleting the expired backup days.
What I need to change in the parameters that the script will delete the expired backup days.
It is too much work when working with Database Maintenance Wizard.
lets take a scenario that I have 10 database.
I would like that each database will backup into seperate file.
I need to create 10 * 7 Maintenance plans.
I have created a directory with the name SDBbackup.
Now under the directory SDBbackup I have created 7 directories (1,2,3,4,5,6,7).
Each directory is for Sunday=1 , Monday=2 , and etc.
It's very much work if I need to accomplish it with Database Maintenance Wizard.
This is why I am asking a specific question regarding T-SQL.
Thanking in advance everyone who assist.
Greetings:
I am trying to gather into a central location the missing index data from the sys DMV's for dynamic index creation in the next step. In trying to use a cursor, I get the following errors:
Msg 154, Level 15, State 3, Line 20
variable assignment is not allowed in a cursor declaration.
Msg 102, Level 15, State 1, Line 94
Incorrect syntax near 'Get_Data'.
Msg 16916, Level 16, State 1, Line 2
A cursor with the name 'Get_Server' does not exist.
Msg 16916, Level 16, State 1, Line 3
A cursor with the name 'Get_Server' does not exist.
Here is the SQL:
--CREATE PROCEDURE usp_Get_Missing_Index_Data
--AS
--Declare @Sql2 nvarchar(4000)
Declare @Sql nvarchar(4000)
DECLARE Get_Server Cursor -- gets a server name from a list of servers
for
Select MachineName from rsqlaudit1.DBStatistics.dbo.servers
Open Get_Server
Declare @Server nchar(20)
Fetch Next from Get_Server Into
@Server
While (@@FETCH_STATUS = 0) --and (@@FETCH_STATUS <> -2)
BEGIN
DECLARE Get_Data Cursor
FOR
select @sql= 'select distinct id.*
, gs.avg_total_user_cost
, gs.avg_user_impact
, gs.last_user_seek
,gs.unique_compiles
from '+@Server+'.master.sys.dm_db_missing_index_group_stats gs
,'+@Server+'.master.sys.dm_db_missing_index_groups g
,'+@Server+'.master.sys.dm_db_missing_index_details id
where gs.group_handle = g.index_group_handle
and id.index_handle = g.index_handle
order by gs.avg_user_impact desc'
exec (@Sql)
Open Get_Data
DECLARE @Handle int,
@database smallint,
@object int,
@equality nvarchar(4000),
@inequality nvarchar(4000),
@Included nvarchar(4000),
@statement nvarchar(4000),
@avg_user_cost float,
@avg_user_impact float,
@last_seek datetime,
@compiles bigint
Fetch NEXT FROM Get_Data INTO
@Handle,
@database,
@object,
@equality,
@inequality,
@Included,
@statement,
@avg_user_cost,
@avg_user_impact,
@last_seek,
@compiles
While (@@FETCH_STATUS = 0) --and (@@FETCH_STATUS <> -2)
BEGIN
insert into rsqlaudit1.DBStatistics.dbo.Missing_Index_data
values (@Server,
@Handle,
@database,
@object,
@equality,
@inequality,
@Included,
@statement,
@avg_user_cost,
@avg_user_impact,
@last_seek,
@compiles)
FETCH NEXT FROM Get_Data into
@Server,
@Handle,
@database,
@object,
@equality,
@inequality,
@Included,
@statement,
@avg_user_cost,
@avg_user_impact,
@last_seek,
@compiles
Fetch Next from Get_Server Into
@Server
END
CLOSE Get_Data
DEALLOCATE Get_Data
GO
CLOSE Get_Server
DEALLOCATE Get_Server
GO
Any suggestions are appreciated.
Thanks,
Derek
Hi,
I am looking at deploying an ASP.NET site which accesses an OLAP database - Microsoft Analysis Services
My question is how is this normally done:
Straight SQL / Stored Procedures
3rd party Adhoc plugin
Anything else
If there is anyone out there with experience in using ASP.NET and
Analysis Services I would be interested in hearing how they did it -
Database Architecture
System Architecture
and any
pitfalls etc...
Thanks in Advance
Jerry
Does any one know a very good control for OLAP in ASP.NET?
View 2 Replies View RelatedHow do I use vba string functions in MDX queries? The on-line help says that the functions can be used but I can't figure out the right syntax for it. PLEASE HELP!
I want to take the first letter from a level i.e.([NET INCOME] in the e.g. below) and display it.
For eg.
WITH MEMBER [DIMENSION].[NET INCOME].A AS 'LEFT({[DIMENSION].[NET INCOME].MEMBERS,1})'
SELECT
measures ON COLUMNS,
[DIMENSION].MEMBERS ON ROWS
FROM CUBE a.
I have install OLAP srvice on SQL Server 7.0 server.
When I try to connect to OLAP server I get the following error:
'cannot connect to the registry on the server computer'
Does anyone know how to fix this problem.
Thank You,
Mark
Has anyone tried installing an OLAP Manager 2000 instance on a server that already supports SQL 7.0 and OLAP 7.0? We will not be using the OLAP 7.0 instance so we would like to either upgrage OLAP 7.0 to OLAP 2000 or unistall OLAP 7.0 altogether. Any feedback would be helpful. Thanks. James.
View 2 Replies View Relatedhi,
i need "microsoft(r) sql server(tm) 2000 analysis services step by step" in digital,can you help me ?
shawnlee@cena.com.cn
i do not know if i am posting in the right place so forgive me if i have.
also i have search and cannot find any answers to this.
ok, i have Windows server 2003 and i want to run SQL on it, i got SP3a and i found out i need something like OLAP, and my PC does not have OLAP on it.
so i was wondering if someone will tell me how/where i can get if from.
thanks alot.
Mrbob2
Mary writes "Hi
Could you give me some notes about ALAP ? What is ALAP exactly? What is the usage of this part of SQL? Could you give me some example.
Thanx"
I was working with an OLAP Services Processing Task when I ran
into some difficulties. I was prompted with a message which told
me that the object could not be found.
When I went back to the OLAP Manager I was not able to see the
databases for that server.
Does anyone know why I can no longer see these databases i have
tried refreshing/rebooting......??
Thanks,
Ruaidhri.
Analysis services is installed on a Windows 2000 server (call it computer A) in Domain A. SQL 2000 has been installed on the server using mixed security. All of the SQL services are running under an account in Domain A (not local system).
The problem is the computer (call it computer B) I wish to run Analysis Manager on and use to administer the Analysis services on Computer A is in Domain B. There are no trusts between Domain A and Domain B.
Can Analysis services be administered by a computer in a domain not trusting the domain that the server running Analysis server is in?
Any help would be appreciated.
Thanks
Hi,
Can anyone tell me where to fine some good help on designing Date type dimensions in an OLAP cube.
This particular thing has been a pain for me..
I have a Time dimension in my CUBE which has year-week-day as levels.
I want the week to start from Monday and span seven days ( naturally !! ). But OLAP surprises and entertains me by showing different number of days in every week. Whatever I do, it never starts a week on Monday and spans it for next 7 days consistently.
Help.
I've installed SQL7.0 and OLAP service on my PC(windows 95), but I cannot find the OLAP Manager. Can an OLAP Manager be installed on Windows 95? If it cannot, can I create an OLAP database (or application) on my PC?
View 1 Replies View RelatedAnyone managed to get the OLAP server installed onto SQL7 Desktop?
I'm running it on Win98 and the installation only offers the Client and sample applications.
Obviously the client won't connect as there's no server to connect to.
The documentation on what does/doesn't run in Desktop version doesn't mention OLAP server.
Please email reply to me at RussLewis@msn.com
Thanks
I have installed OLAP services along with SQL Server 7.0. I want to use the sample MDX application supplied with the CD. When I try to use the dsample application, it comes up with a dialog to enter the server name and gives me an error unable to connect to the OLAP server.
My computer is Windows 98. Do I need to install OLAP Server ? If so how ?
Thank you
I can't find anything written about licensing for OLAP anywhere. Do I presume correctly that it doesn't require one of its own?
Thanks for any info.
Simon
I keep getting this error when trying to connect users to the OLAP server from
Excel.
"Unable to open connection.
Cannot Connect to server 'OLAP Server Name'.
OLAP server error: The operation failed due to network problems."
When I use this excel locally on my machine it works just fine. Any ideas?
So I am starting to look at an OLAP problem having been an OLTP DB wonk for several years.
All very nice. Am bending my head aorund cubes and the dimensions trciks and learing to choose them more carefully.
Have wokred through the various chapters of various SQL books (OLTP books with a couple of chapters of OLAP I admit) and am starting to feel if not comfortable with it at leats not compleetly terrified.
Now the Analysis manager in SQL is all well and good but I'm not about to hand it to the accounting monkeys that work here.
Does anyone have any suggetsions of some good OLAP specific books and any Cube viewing tools/suites/utilities that I can give to the computer-illiterate bean counters I work for?
many thanks
Steve