Data Mining Add In To Excel 2010. SQL 2012

Question

I HAVE PROBLEMS.

NEED HELP.

--- 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?

Answer 1

Hi TheAkaBroken,

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 

Thanks,
Eileen

 

---

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.

Answer 2

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

---

______________________________
Jamie MacLennan
CTO
Predixion Software, Inc.
Take our Survey
My Blog
Follow on Twitter
Email Me

Answer 3

I 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

Why?