Data warehouse entry (experiment 7) Deployment Analysis Service Database

1. Deploy to SSAS1. check SSAS2. view the Product dimension under the "properties" pane of the Error List, and move the cursor to the blue line, show "do not use the visible Attribute Hierarchy of attributes as user-defined

1. Deploy to SSAS1. check SSAS2. view the Product dimension under the "properties" pane of the Error List, and move the cursor to the blue line, show "do not use the visible Attribute Hierarchy of attributes as user-defined

1. Deploy to SSAS

1. Check SSAS

2. view the Error List

The Product dimension in the "properties" pane is marked with a blue wavy line. Move the mouse over it to display "avoid using the visible property hierarchy of the attribute as a level in the User-Defined hierarchy ". This is because the Color and Size members appear in both the Attribute Hierarchy and the custom hierarchy. You can change their AttributeHierarchyVisible attribute to False. Here we ignore this warning.

3. Deployment

4. View deployment results

Ii. Browsing

1. Browsing hierarchy

Select the "Browser" tab. If the browser is disconnected from SSAS, click "reconnect" on the toolbar of this tab.

In "hierarchy", select Product Category to view its hierarchy.

2. Release alert

For some alarms, if we ignore them, we can select "release ".

This article is from the "MSSQL we have Chased Together" blog and is not reposted!