최신 70-466日本語 무료덤프 - Microsoft Implementing Data Models and Reports with Microsoft SQL Server (70-466日本語版)

설명: (DumpTOP 회원만 볼 수 있음)

Explanation:

Note:
SCOPE THIS END SCOPE
* SCOPE Statement (MDX)
Limits the scope of specified Multidimensional Expressions (MDX) statements to a specified subcube.
* Example:
cope
(
[Date].[Fiscal Year].&[2002],
[Date].[Fiscal].[Month].Members
) ;
This = [Date].[Fiscal].CurrentMember.Parent / 3 ;
End Scope;

설명: (DumpTOP 회원만 볼 수 있음)

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* In Reporting Services, a dataset is based on an existing a data source. A dataset specifies a query, query parameters, filters, and a field collection. You can also specify data options, such as case, collation, kanatype, width, and accent, for the data retrieved from the data source. For more information, see Understanding Report Datasets.
To create a dataset, you must have defined an embedded or shared data source.
* When you deploy Reporting Services, a set of data processing extensions are automatically installed and registered on both the report authoring client and on the report server to provide access to a variety of data source types . SQL Server 2008 Reporting Services (SSRS) installs the following data source types: Microsoft SQL Server, Microsoft SQL Server Analysis Services, Oracle, SAP NetWeaver BI, Hyperion Essbase, Teradata, OLE DB, ODBC, and XML.
* In the Report Data pane, right-click on a dataset created from a SQL Server Analysis Services data source type, and then clickQuery. The MDX query designer opens in Design mode.
* Drag a dimension to the filter area and drop it on the first cell in
theDimensioncolumn.
* In theHierarchycolumn, choose a value from the drop-down list.
* In theOperatorcolumn, choose an operator for the drop-down list.
* In theFilter Expressioncolumn, select individual values from the drop-down list, or click theAllmember to choose all values.
* In theParameterscolumn, select the check box to create a report parameter.
* ClickRun.
* To define a query parameter in MDX in Design modeAfter you run the query, clickDesign on the toolbar to toggle to Query mode to view the MDX query that was created. Do not change the query text in Query mode if you want to continue to use Design mode to develop the query. ClickDesignto toggle back to Design mode.
* Click OK.
* In the Report Data pane, right-click the name of the data source, and then clickAdd Dataset. TheQuerypage of theDataset Propertiesdialog box opens.
* InName, type a name for the dataset or accept the default name.
* In Data source, select the name of an existing shared data source, or click New to create a new embedded data source.
* Select a Query type option. Options vary depending on the data source type.
* In Query, type the query, stored procedure, or table name. Alternatively, click Query Designer to open the graphical or text-based query designer tool, or Import to import the query from an existing report.
* To create a datasetIn a few cases, the field collection specified by the query can only be determined by running the query on the data source. For example, a stored procedure may return a variable set of fields in the result set. Click Refresh Fields to run the query on the data source and retrieve the field names that are needed to populate the dataset field collection in the Report Data pane. The field collection appears under the dataset node after you close the Dataset Properties dialog box.
* In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 0 seconds. When the time out value is 0 seconds, the query does not time out.
* Click OK.
The dataset and its field collection appear in the Report Data pane under the data source node.