Page 94 - DCAP606_BUSINESS_INTELLIGENCE
P. 94
Unit 6: Business Intelligence Project
7. To hide Solution Explorer, click the Auto Hide button on the title bar. To unhide Solution Notes
Explorer, click the Auto Hide button again.
Self Assessment
Fill in the blanks:
6. To maximize the Microsoft Visual Studio development environment, click the
................................... button.
7. To view the tables in the Diagram pane at 50 per cent, click the ............................ icon on the
Data Source View Designer toolbar.
8. To hide Solution Explorer, click the .............................. button on the title bar.
6.3 Modifying the Data View
You can use the DataView to add, delete, or modify rows of data in the table. The ability to use
the DataView to modify data in the underlying table is controlled by setting one of three
Boolean properties of the DataView: AllowNew, AllowEdit, and AllowDelete. They are set to
true by default.
Properties are AllowNew, AllowEdit, and AllowDelete. They are set to true by default.
Properties action works in following way:
If AllowNew is true, you can use the AddNew method of the DataView to create a new
DataRowView.
If AllowNew is false, an exception is thrown if you call the AddNew method of the
DataRowView.
If AllowEdit is true, you can modify the contents of a DataRow via the DataRowView. You
can confirm changes to the underlying row using DataRowView.
If AllowEdit is false, an exception is thrown if you attempt to modify a value in the
DataView.
If AllowDelete is true, you can delete rows from the DataView using the Delete method of
the DataView or DataRowView object and the rows will be deleted from the Data table.
If AllowDelete is false, an exception is thrown if you call the Delete method of the DataView
or DataRowView.
6.4 Creating Dimensions, Time and Modifying Dimensions
6.4.1 Creating Dimensions
A database dimension is a collection of associated objects, called attributes, which can be used to
supply information about fact data in one or more cubes.
Example: Usual attributes in a product dimension might be product title, product
category, product line, product dimensions, and product price. These things are compelled to
one or more columns in one or more tables in a data source view. By default, these attributes are
visible as attribute hierarchies and can be utilised to realise the detail data in a cube.
LOVELY PROFESSIONAL UNIVERSITY 89
