Tuesday, July 17, 2018

Attributes and Dimensions

You can set properties on tables, views, and fields to create analysis services
dimensions and attributes. Attributes are fields or columns in a table or view in
the Application Object Tree (AOT); dimensions are groups of attributes.
The defined relationships between dimensions and measure groups in a cube
determine how the data in the cube is sliced. Cube relationships are generated
based on the relationships between the tables and views. When you open a
project in SQL Server Business Intelligence Development Studio (BIDS), you
can view the relationships that were generated. You can define additional or
modify existing relationships between dimensions and measure groups in Cube
Designer.
 

Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...