Users get error 'operation was cancelled because of locking conflicts' in excel, when cube is processing, they can access the report from excel or Sharepoint. I need to show custom messages from cube itself. any suggestions please In general how can I replace the system generated message with custom message

Hello ,

We have a report that displays a data dictionary of the SSAS Cube and we have description fileds missing. I wanted to enable users to update the description for say the Measures for certain tables.

Is there any way to do this with excel ? or is there another free tool that will allow them (certain permissions only) to update or generate a script to update the say $SYSTEM.MDSCHEMA_MEASURES ?

Thanks in advance.

Hi Experts ,

  Issue : Linked Server is being created but no catalogs are found when accessing the SSMS (Sql Server Management Studio) with SQL Authentication but with Windows Authentication , I can access the catalogs.



Please Note : WH DB Server /Cube Server / Linked Server are on the same machine.

Here is the code , how I am trying to create a linked server and catalogs .

Please help me with the solution , will appreciate your help in this regard.


if NOT exists (select srvname from master.dbo.sysservers where srvname = 'RPM_Cubes')
BEGIN
Exec master.dbo.sp_addlinkedserver
@server = N'RPM_Cubes',
@srvproduct ='',
@PROVIDER = N'MSOLAP',
@datasrc=N'localhost\sqlserver2016',
@catalog ='RPM_Database'
EXEC master.dbo.sp_serveroption @server=N'RPM_Cubes', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'RPM_Cubes', @optname=N'rpc out', @optvalue=N'true'
END
ELSE
 PRINT 'Link Server already exists'


Thanks,
SRK.

Hi Experts ,

  Issue : Linked Server is being created but no catalogs are found. I am trying to access the SSAS Cubes using the  MSOLAP provider as mentioned below.
Please Note : WH DB Server /Cube Server / Linked Server are on the same machine.

Here is the code , how I am trying to create a linked server. Please let me know if I have to configure any server options to create the catalogs in linked server.

if NOT exists (select srvname from master.dbo.sysservers where srvname = 'Test_Cubes')
BEGIN
Exec master.dbo.sp_addlinkedserver
@server = N'Test_Cubes',
@srvproduct ='',
@PROVIDER = N'MSOLAP',
@datasrc=N'localhost\sqlserver2016',
@catalog ='Test_Database'
EXEC master.dbo.sp_serveroption @server=N'Test_Cubes', @optname=N'rpc', @optvalue=N'true'
EXEC master.dbo.sp_serveroption @server=N'Test_Cubes', @optname=N'rpc out', @optvalue=N'true'
END
ELSE
 PRINT 'Link already exists'


Thanks,
SRK.

hi experts
i am reading about Working with Data Source Views in sql server data tools
i do not understand, As the creation of a relationship can improve performance, do you have any examples?

Create relationships to improve performance

I just installed 2016 SSAS. I am trying to deploy my cube but I keep getting this error. In 2008 there was windows service you could stop and for Analysis service. I dont see that service with the 2016 version. I am running Windows 2012. Any advice on how and where I start this service?

Severity	Code	Description	Project	File	Line
Error		The project could not be deployed to the 'localhost' server because of the following connectivity problems :
A connection cannot be made. Ensure that the server is running.
To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.			0

Select all Open in new window

Hi all,

I have a request from my client how to prevent any user accessing a cube from SQL Server Management studio. My problem is we are deploying and processing  a cube on dedicated server that we can not control all, it means  there are some local admin/ group admin accounts who are sys role privileges. They definitely view data from my cube database.

The question is here how I can prevent them viewing my data from cube although they are  local admin/ group admin accounts?

Thanks,

Hello Experts Exchange
I have followed the instructions of this question;
https://www.experts-exchange.com/questions/29002712/SSAS-Hierarchy-with-columns-with-folder-names.html

But when I browse the cube all my cost centres have the total amount that is in my data.

I have uploaded a screen shot to show what I mean.

How do I get the correct figures for the correct cost centre?

Regards

SQLSearcher
CostCentreFolders_Version2.xls
Cube-Cost-Centre.jpg

Hi,

Can anyone help me regarding scripts for monitoring SSAS (SQL Server 2012).

-- Blocking issues
-- SSAS Services status
-- Cube/Tabular model Performance
-  CPU/Memory/Disk IO utilization.

Thanks,
Chandra

We want to uninstall AD from a Windows 2008 R2 but we want to know what could be affected.

1.-After uninstall is created a new administrator account or we can login with actual administration account just removing the @domain.com.
2.-By this way all other users are removed? We have users for ftp access and other things these users are removed?
3.-The configuration of IIs is damaged?
4.-The Sql Server 2008 and mysql accounts are affected?
5.- What other areas could be affected or changed?

We want to follow this link to uninstall:

https://technet.microsoft.com/en-us/library/cc771844(v=ws.10).aspx

We just want to know before trigger the button and cause a several damage.

Thank you

hi experts

i am reading about: real-time operational analytics
in https://msdn.microsoft.com/en-US/library/dn817827.aspx

whats the mean: real-time operational analytics