Thursday, September 13, 2012 10:03 PMI HAVE PROBLEMS.
--- HAVE MACHINES OF USERS WHERE HAVE OFFICE 2010 and installed ADD-IN FOR DATA MINING 2012.
--- HAVE A SERVER (WIN7) WITH INSTALLED SQL SERVER 2012, LA MODELS HAVE OLAP AND DATA MINING IMPLEMENTADADOS.
WHAT HAPPENS THROUGH THE U.S. CAN EXCEL ACCESS OLAP CUBES, THROUGH THE ACCOUNTS USER CREATED IN THE AD!
So far so good.
WITH REGARD TO ADD-IN DATA MINING, I CAN NOT ACCESS THE SERVER.
The OPTION TO CHANGE THIS USER BLOCKED ... NOT UNDERSTAND
FOLLOWING TWO IMAGES:
I excel at this:
HOW DO I SET UP MY SERVER (SAAS) AND GIVE USERS TO ACCESS THE MACHINES ACCESS TO DATA MINING THROUGH EXCEL?
Tuesday, September 25, 2012 1:03 AMModerator
Analysis Services provides online analytical processing (OLAP) and data mining functionality for business intelligence applications. in SQL Server 2012, support for OLAP databases and data mining models is available when you install Analysis Services in Multidimensional mode. If you install Analysis Services using default values, you will get an instance that runs multidimensional databases and data mining models. For more information about it, please see:
How to install Analysis Services in Multidimensional and Data Mining Mode: http://msdn.microsoft.com/en-us/library/ms143708.aspx
The process of securing Microsoft SQL Server Analysis Services occurs at multiple levels. You must secure each instance of Analysis Services and its data sources to make sure that only authorized users have read or read/write permissions to selected dimensions, mining models, and data sources. You must also secure underlying data sources to prevent unauthorized users from maliciously compromising sensitive business information. Please refer to:
Security Overview (Data Mining): http://msdn.microsoft.com/en-us/library/bb522420.aspx
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, October 02, 2012 7:14 AM
Tuesday, October 09, 2012 5:29 PM
With the DM Addins, you need to manage security on the analysis services server the users connect to - in many cases you need to give the DM Addin user administrative permissions on SSAS databases.
An alternative is to use Predixion Insight, which extends the DM Addin metaphor, but against a cloud or on-premises Predixion Insight server. It is much easier to manage - more self-service, doesn't require any admin permissions for end-users, and adds a lot of additional features and funcitonality.
You can find out more at www.predixionsoftware.com
Thursday, October 11, 2012 8:38 AMI can not even access the SSAS - through the Add-in for Data Mining, or so through SSRS, Report Builder, I can not access the data source.
This through a machine. and through the intranet, I try to access the BI Server ... But where specified, without success.
However through Excel (pivot table OLAP) and viewing reports through SSRS ... I can access
- Edited by Oliver Kimb Thursday, October 11, 2012 8:42 AM