| Home : Ebooks : MSAS |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
MSAS Listings
|
|
Total:
70 | Displaying: 31 - 40 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
|
The predictive model of the decision tree helps users determine whether similar cases will have a similar behavior. The attributes of the tree can be examined for impact analysis by using the Dependency Network Browser. This can be opened by right clicking on a decision tree data mining model in the Analysis services explorer tree control.
Updated: 05/07/2005
|
|
|
Let us assume FoodMart wants the members with Golden Membership to be studied. It wants to focus on broadening the membership of the Gold Card. This can be done now using the Decision Tree Model.
Updated: 05/07/2005
|
|
|
The process of probing into a set of information for descriptive and predictive purposes is called data mining. The purpose is to identify those trends and patterns which indicate the direction of effort to achieve desired outcomes. SQL Server 2000 and Analysis Services, has inbuilt powerful data mining capabilities including algorithms for Clustering and for Decision Trees.
Updated: 05/07/2005
|
|
|
When roles are assigned for cubes the user has access or no access to the cube. When roles are assigned to a dimension, the user gains only partial access to parts of the cube. The simplest method of restricting access to a dimension is to prevent access to all levels except the top level of the dimension. In the Cube role dialog box all users were given complete access to the sales cube. Let us restrict the access of users by permitting them to see only values broken out by fiscal years.
Updated: 05/07/2005
|
|
|
In the Analysis Manager console tree, expand the cubes folder and right click the Sales cube and click Manage roles
Updated: 05/07/2005
|
|
|
When a new database is created a default role is created for all OLAP Administrators to have access to the Analysis Manager. However, other users have to be given rights to access the database and its objects. Users can be given rights to Browse the cubes and objects but not to use Analysis Manager. If the user has to be given a right to use both the database objects and the Analysis Manager, specific rights have to be assigned.
Updated: 05/07/2005
|
|
|
The enforcement of security defined by the roles must be preceded by user authentication. When the user connects to the Analysis server, the first thing that happens is authentication. The user login is validated and the user is given access to the data on the server in accordance with the roles. If authentication is unsuccessful, he will not be able to access the data on the server
Updated: 05/07/2005
|
|
|
Security of data is of paramount importance to most industries and organizations. All organizations want to restrict access to data hierarchically or define role based access. Analysis Services provides for this need.
Updated: 05/07/2005
|
|
|
Dimensions can be modified so that the contents of the dimension changes. The impact of these changes can be viewed by end users browsing cubes. End user’s get an added analytical option due to this process.(This option is only available in the Enterprise Edition of Microsoft SQL Server 2000).
Updated: 05/07/2005
|
|
|
Actions used by end users to select a single cube cell and retrieve a result set from the source data of the cell are known as Drillthrough actions. Drillthrough has to be enabled if administrators want to drillthrough in a Cube Browser and the Cube Editor data tab.
Updated: 05/07/2005
|
|
|
MSAS Listings
|
|
Total:
70 | Displaying: 31 - 40 | Pages: << 1 2 3 4 5 6 7 >> |
|
|
