Analysis Server Repository
Apr 15, 2004Ok .. 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 !!!!!!!!!!!!!
ADVERTISEMENT
DTS In MS Repository
Oct 27, 1999Hi 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
Analysis :: Power BI Analysis Services Connector - Remote Server Returned Error
Mar 5, 2015I have, a SSAS 2012 tabular instance with SP2, there is a database on the instance with a read role with everyone assigned permissions. When configuring the Power BI analysis services connector, at the point where you enter Friendly Name, Description and Friendly error message, when you click next I receive the error "The remote server returned an error (403)." I've tested connecting to the database from Excel on a desktop and connect fine.I don't use a "onmicrosoft" account so don't have that problem to deal with.
We use Power BI Pro with our Office 365. As far as I can tell that part is working ok as I pass that stage of the configuration with a message saying connected to Power BI.The connector is installed on the same server as tabular services, its a Win2012 Standard server. The tabular instance is running a domain account that is the admin account for the instance (this is a dev environment) that account is what I've used in the connector configuration. It's also a local admin account. There is no gateway installed on the server.
Urgent-Repository DTS
Jan 21, 2002How can I see the repository dts packages.
I want to move repository dts packages from server1 to server2.
Help me please.
TIA,
Paul
Repository DTS Packages Not Available
Jul 9, 1999I 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
Moving Repository Dts Packages?
Jan 21, 2002How can move repository stored dts packages. Where do they store?
TIA
paul
OLAP - Cannot Retrieve Repository
Jan 17, 2001I'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!
Saving DTS Packages In The Repository...
Sep 29, 2000... 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 doesnt 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.
Where Is "description" Col In Repository Metadata
Apr 20, 2000I'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
Migrate Example Olap Repository
Nov 6, 2002I 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.
SQL 2012 :: How To Remove Records From Repository / Alerts
Feb 18, 2014We 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
Where Is The Repository Gets Created For SSIS( Integration Services) 2005?
Apr 19, 2007if someone can throw light regarding the metadata repository creation,its usuage , it will help me out.
View 5 Replies View RelatedSchedule Backup Of Specific Database While Only Saving The Last 7 Days In Repository
Apr 15, 2008
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.
Schedule Backup Of Specific Database While Only Saving The Last 7 Days In Repository
Apr 19, 2008
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.
Collect Missing Index Data Into Central Repository From Sys.dm_db_missing_index_group_stats, Groups, Details
Nov 2, 2007
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
Analysis :: Cube Needs To Be Deployed From VS After SSIS Analysis Services Processing Task Completes?
May 13, 2014I have a cube that we are processing nightly via an Analysis Service Processing Task in SSIS. In order to increase the performance of the processing time, we elected to use a lot of rigid dimension attributes, and do a full process of everything in the SSIS task. The issue that I am having is that after that task completes, I need to go into Visual Studio to deploy the cube becuase we are unable to browse or use the cube. This issue seemed to start once we changed the SSIS Analysis Service Processing Task to do a full process on the dimensions, rather than an incremental.
I would expect that once development is done, and it is processed and deployed, that is it. My thinking is that the SSIS task should just update the already deployed cube,
Analysis :: How To Right Choose Key Column In Mining Structure For Microsoft Analysis Services
Jun 12, 2015How to right choose key column in"Mining Structure" for Microsoft Analysis Services?
I have table:
"Incoming goods"
Create table Income (
ID int not null identity(1, 1)
[Date] datetime not null,
GoodID int not null,
PriceDeliver decimal(18, 2) not null,
PriceSalse decimal(18, 2) not null,
CONSTRAINT PK_ Income PRIMARY KEY CLUSTERED (ID),
CONSTRAINT FK_IncomeGood foreign key (GoodID) references dbo.Goods ( ID )
)
I'm trying to build a relationship(regression) between “Price Sale” from Good and “Price Deliver”.But I do not know what column better choose as “key column”: ID or GoodID ?
Analysis :: Create Analysis Services Project In Visual Studio 2012 Data Tools?
Feb 18, 2013It is possible to create Analysis Services project (*.dwproj) in Visual Studio 2012 Data Tools?
View 5 Replies View RelatedAnalysis :: Excel 2013 Pivot-table / Grouping On Date That Comes From Analysis Service 2008?
Nov 24, 2015I am using
SSAS: version 2008
Excel: version 2013
I am connecting to SSAS cube from Excel and I have date dimension with 4 fields (I have others but I don't use it for this case). I created 4 fields in order to test all possible scenarios that I could think of:
DateKey:
- Type: System.Integer
- Value: yyyyMMdd
Date:
- Type: System.DateTime
DateStr0:
- Type: System.String
- Value: dd/MM/yyyy (note: I am not using US culture)
- Example: 01/11/2015
DateStr1:
- Type: System.String
- Value: %d/%M/yyyy (note: I am not using US culture)
- Example: 1/11/2015
Filtering on date is working fine:
Initially, in excel, filtering on date was not working. But after changing dimensional type to time, and setting DataType to Date, as mentioned in [URL] filter is working fine as you can see in the picture.Grouping on date is not working:
I have hierarchy in my Date dimension and I can group based on hierarchy, no problem. But user is used to pre-build grouping function of excel, and he wants to use that. Pre-build functions of Excel, Group and ungroup seems to be available as you can see in following picture:
But when user clicks 'Group', excel groups it as if it is a string, and that is the problem. User wants to group using pre-build grouping function available in Pivot table. I also find out that Power Pivot Table does not support this excel grouping functionality. And if I understood well, this pre-build grouping functionality of excel, needs to do calculation at run time, and that is not viable solution if you have millions of rows. So Power pivot table does not support pre-build grouping functionality of excel and hence we need to use dimension hierarchy to do the grouping. But I am not using Power Pivot table, I am using simple Pivot Table. So I expect grouping functionality to be working fine. Then I tried to do simple test. I created a simple data source in excel itself. And use it as source of my Pivot table. Then grouping is working fine. The only difference that I can see is (When double click the Measure value in Excel),For date values of my simple test, excel consider them as 'Date'.
For date values of my data coming from cube, excel consider them as 'General'
2.1. But value here is same as it was in simple test.
2.2. 'Date Filter' works just fine.
2.3. If I just select this cell and unselect it, then excel change type to 'Date' though for that cell.
2.4. I have created 4 different types of fields in my date dimension thinking that values of attribute of my dimension might be the problem, but excel consider 'General' for all of them.
2.5 This value (that can be seen when double clicking on measure) comes from 'Name Column' of the attribute. And the DataType defined is WChar. And I thought that might be the reason of issue. And I changed it to 'Date'. But SSAS does not allow it to change to 'Date' giving error : The 'Date' data type is not allowed for the 'NameColumn' property; 'WChar' should be used.
So, I don't know, what is the puzzle piece that I am missing.
1. Date filter works, group does not work
2. Excel consider it as 'General' string.
3. SSAS does not allow to change 'NameColumn' to Date.
Analysis :: Running Analysis Service In Terms Of Port Usage?
May 30, 2015I would like to know the best practice for running analysis service in terms of port usage. Is it better to run on a specific port or have dynamic ports ? We have clustered servers that run default on 2383 but not sure with non clustered what's the best way to get performance.
View 2 Replies View RelatedAnalysis :: Creating Roles In Analysis Service Without AD Account
Aug 6, 2015I want to find out if it is possible to create a role in a cube without an AD account, e.g. using a GMail email address.
View 3 Replies View RelatedSQL Server Admin 2014 :: Analysis Services Tabular AND Multidimensional On Same Server
Jul 24, 2014Is it possible to have Analysis Services in both modes or are they mutually exclusive?I have a machine setup with Multidimensional AS and would like to know if it's possible to add a Service in Tabular mode.
View 2 Replies View RelatedSQL Server,SQL Server Agent,SQL Analysis Resources Failing In SQL 2005 Cluster
Aug 17, 2007Hi.
I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online.
Below is the brief of my setup
1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2.
2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2.
3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2.
4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2.
5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search.
6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2.
7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2.
8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online.
10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully.
11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
Plz Advice.
Regards
Khalid
Dont Think Discretization Function Is Necessary On The Analysis Service Server In SQL Server 2005
Apr 28, 2006Hi, all here,
I am just wondering about the Discretization function available on analysis service server (which can not actually discretize data into user-defined expressions) . Isnt it redundant ? I mean since users can discretize their data more meaningfully based on their own expressions in database engine of SQL Server 2005.
Thanks a lot.
Analysis :: ASMCD To Sync Cubes From Cubebuild Server To Reporting Server
Jul 7, 2015we are using ASMCD to sync our cubes from a Cubebuild Server to a Reporting Server. We migrated some days ago from 2012 to 2014. We are also using rel. Engine with StoredProcs for calling and executing xp_cmdshell for the Ascmd.Actually all works fine for our smaller cubes. For the bigger one we got the following issue. The cube is being synced but the proc delivers error.In the log we found this entry:
(7/7/2015 11:26:22 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.dbLocal Controlling Cube.0.cub' could not be deleted. Please check the directory for permissions.
(Source: ?D:SSAS_LOGmsmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210020)
(7/7/2015 11:26:34 AM) Message: The directory '?D:SSAS_DATAGPMR Local CNTR.510.db' could not be deleted. Please check the directory for permissions.
[code]...
How Can I Connect To SQL Server 2005 Analysis Services Server Programmatically?
Jun 9, 2006Hi, all here,
Would please anyone here give me any idea about how can I connect to SQL Server 2005 analysis services server and send XML request to it programmatically (with Business intelligence development studio in SQL Server 2005)? Thanks a lot.
With best regards,
Yours sincerely,
Analysis :: Connecting To Cube On Another Server Using Linked Server?
Aug 19, 2015I want to populate data in SQL server database (SQL server 2008 R2) from SSAS cube located on different server (SQL server 2012). My SQL database present on Server A and cube on Server B.
To implement I am trying to create linked server. But its giving errors related to provider and product.
Analysis Server . Pl. Help
Jul 23, 2002Hello ,
I have a SQL 2000 with Analysis server installed on it . Its in a different domain . When i am trying to register the server remotely i.e from another domain ,from another server it gives me an error that :
'Cannot connect to the repository .
Analysis Server : <Server_name>
Error : Cannot open database requested in Login '<Database_name > Login fails . Do you wish to register this server ? '
Both the domains are trusted . Except that the OS where the Analysis server is running is Windows 2000 . I am trying to connect through SQL 2000 Server with Windows NT 4.0 Server .
We have another Analysis server which is running but on Windows NT 4.0 OS where i can easily register that server .
I tried providing access with all the rights to concerned domains , but in vain .
I am exhausted trying to figure out the problem .
Any assistance in this regard would be of great help to me .
Thanks
Ravi .
Analysis Server And C#
Dec 11, 2007hi
thanks a lot for your answer
but (excuse me for this request ) if you gave a sample in this forum and gave cods for my question ,that was very better for me .
and please say link for downloading your book ,and i dont know why i can't do any works that has said in this say
please fo yu can,say the codes for my request,
and again say thanks a lot.
Connect To Analysis Server
Nov 2, 2004Helo!
Analysis manager is not able to coonect to analysis server. I can't register server -> Network error [Internal error].
Tnx, E
Analysis Services Server Not Available
Dec 21, 2004Hi
I installed Analysis Services yesterday and was building some test cubes from our receipts data, today, when I tried opening my cubes, it appears that my Analysis Server (on local machine - laptop) is not available giving the error message of :
"Unable to connect to the registry on the server FJKILKEN-MOBL, or you are not a member of the OLAP Administrators group on this server"
I have shut-down/restarted, and then checked that all appropriate services (SQL server, OLAP server etc) are running which they are any idea on what the issue could be?
Thanks a lot
Fergal
Analysis Server In Different Domain
Oct 2, 2001I am trying to connect to a sql server with analysis services installed in a seperate domain with the Analysis Manager. I am getting a error connecting to server message when I try to register the server. It looks like it has to do with permission issues in that I am in a different domain. Any ideas on how to get around this without forming a trust between the two domains and then adding myself to the olap administrators group on the remote sql server?
Thanks,
John
Cannot Connect To Analysis Server
Dec 21, 2004I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution???
View 1 Replies View Related