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 I have a cube that I have setup a Report Action on that opens an SSRS report that contains a parameter of @JobNumb.  The SSRS Report is based on a database, NOT a cube.  I can get the Action to appear on the menu when I test the cube in Excel and open the report is SSRS, however I am struggling to pass the parameter over!  I have tried several variations and simply cannot get it to work.

The Parameter Name in SSAS is the same as the Parameter Name is SSRS.
The SSRS Server Details are correct in the SSAS Reporting Action as it opens the report successfully.
If I type in the job number itself as the Parameter Value, eg "170000007" then the Report runs successfully with the correct job no.

I can seem to find lots on passing parameters from a cube to an SSRS Report based ON a cube, but nothing about passing a parameter from a cube to an SSRS Report based ON a database as I think it makes a difference.

I am not good with MDX and have tried the following variations as the Parameter Value, some do return a value in the SSRS Report Job Parameter field (those with a YES) but the majority don't:

"170000007"      yes      works and the report runs successfully with the correct job no.

[Job Trades].[Job Trade].[Job No].&[170000007]      no      
[Job Trades].[Job Trade].[Job No].CurrentMember      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.Name      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.UniqueName      no      
[Job Trades].[Job Trade].[Job No].CurrentMember.Value      no      

…

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

Hello Experts Exchange
I'm new to SSAS cube development.

I have data for cost centres that are going into my cube, please see file attached.

I want to create a SSAS Hierarchy with the data.

The column PARENTH1 is the Parent folder and HIER1 is the Child folder, there can be several levels of folders.

I want to use the PARENTH1 and  HIER1 to create the Hierarchy but I want to display the EVDESCRIPTION field to the user.

How do I do this in SQL Server Analysis Services?

Regards

SQLSearcher
CostCentreFolders.xls

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