Definations
What is Microsoft SharePoint Services Products?
Microsoft SharePoint Products and Technologies includes SharePoint Portal Server for portal sites and Windows SharePoint Services for team sites.
SharePoint Portal Server is a secure, scalable, enterprise portal server built upon Windows SharePoint Services that you can use to aggregate SharePoint sites, information, and applications into a single portal site. All features of Windows SharePoint Services are available in SharePoint Portal Server.
Windows SharePoint Services is a collection of services for Windows Server that you can use to share information, collaborate with other users on documents, and create lists and Web Part Pages.
For more information about SharePoint please visit http://www.microsoft.com/sharepoint/.
What is Web Part Wizard?
Web Part Wizard is the tool for configuring DSP Web Parts. The wizard needs to be installed on all machines that should be enable to create and configure web parts.
What is Analysis Wizard?
Analysis Wizard is the tool to use when you want to create an analysis against your cube. You can either start the wizard from your desktop or from Analysis Link Web Part. To be able to use Analysis Wizard you have to install the client part of Portal Edition on your client machine.
What is a Data Source?
A data source is a description on how to connect to the OLAP Server or cube file.
What is a Measure?
Measures are quantitative, numerical columns in a fact table. It typically represents the values that are analyzed.
What is a Dimension?
Dimensions are descriptive categories by which the numeric data (i.e. the measures) in a cube are separated for analysis. For example, if a cube's measure is Production Count and its dimensions are Time, Factory Location and Product, users of the cube can separate Production Count into various categories of Time, Factory Location, and Product.
What is Shared and Personal View?
A web part page can either be in Shared or Personal View. There are properties on a web part that can be personal or shared by all users using the page. Layout and Appearance properties are available for configuration in both views but Advanced and Web Part Wizard properties are only available in Shared View.
What is MDX?
MDX, an acronym for Multidimensional Expressions, is a syntax that supports the definition and manipulation of multidimensional objects and data. MDX is similar in many ways to the Structured Query Language (SQL) syntax, but is not an extension of the SQL language; in fact, some of the functionality that is supplied by MDX can be supplied, although not as efficiently or intuitively, by SQL.
Please read SQL Books Online for more information how to use MDX expression.
What is a Named Set?
A named set is a set of dimension members or a set expression that is created to be used again. For example, a cube contains a Salesperson dimension. An end user of the cube wants an easy way to display the 10 salespersons with the highest sales and the 10 salespersons with the lowest sales. You can create two named sets, one for each group of salespersons. Then, in the client application, the end user can place the named sets on an axis in a manner similar to a dimension.
What is Analysis Client?
DSP Analysis Client is a tool included in DSP Portal Edition. With the client installed on your client machine you can create and configure DSP Web Parts. Create and save DSP Analysis. Use the Send, Launch and Copy functionality in published DSP Web Parts.
What is an Action?
An action is an end user-initiated operation upon a selected cube or portion of a cube. The operation can start an application with the selected item as a parameter or retrieve information about the selected item. Actions enable end users to act upon the outcomes of their analyses. By using actions, end users can go beyond traditional analysis and initiate solutions to discovered problems and deficiencies. Actions have the potential of transforming client applications from sophisticated data rendering tools to integral parts of the enterprise's operational system. Actions provide an easy way for end users to step from focusing on specific data to sending that data as input to operational applications. See SQL Server Books Online for more information about actions.
What is a dwp file?
Microsoft® Windows® SharePoint™ Services uses XML documents with the .dwp extension as a way to import and export Web Parts so they can be shared by users. These files capture a snapshot of the property settings for a Web Part, and a reference to the assembly and class used to create it.
What is Microsoft Business Scorecard Manager?
Microsoft Office Business Scorecard Manager is an application that helps organizations evaluate business strategy and monitor business performance through the use of key performance indicators (KPIs) that are directly related to defined business goals. You can track business strategies that are not reflected by any one KPI using collections of KPIs called objectives, and you can combine KPIs and objectives to create scorecards. A scorecard can be configured to show detail information in Report views and you can connect report views to scorecard views so that selections made in the scorecard view determine what is displayed in the report view.
What is PTS?
PTS PivotTable® Service is a collection of dynamic-link libraries (DLLs) that you need have installed on your computer to be able to connect to Analysis Server or a cube file.
There are two setup programs for PTS, Ptslite.exe and Ptsfull.exe. They are provided on the SQL Server 2000 CD-ROM, in the folder \Msolap\Install\Pts. Ptslite.exe installs the PivotTable Service files only.;Ptsfull.exe installs the PivotTable Service files and Microsoft Data Access Components (MDAC) that is required for PTS to work.
You need to use same version of PTS on your client as on your Analysis Server.
PivotTable Services does not work with SQL Server 2005 Analysis Services. Instead, client applications that need connect to Analysis Services in SQL Server 2005 will need to install Analysis Services 9.0 OLE DB Provider.
Please visit Microsoft's SQL Server Home page http://www.microsoft.com/sql to find information of latest service pack for SQL Server.
Use Data Source
It is possible to create a report view without selecting a workspace data source and instead select a data source defined in the wizard. But when using scorecard filters it is strongly recommended to only use workspace data sources to avoid problem when matching member identifiers. If not using workspace data source you have to remove “MDX Unique Name Style” property in the connection string for selected data source in the wizard.
What is Microsoft Analysis Server?
Microsoft Analysis Server is the server component of Microsoft® SQL Server™ 2000 Analysis Services. It is specifically designed to create and maintain multi-dimensional data structures and provide multi-dimensional data in response to client queries. ere.
What is Kerberos Authentication?
The Kerberos authentication protocol is a technology for single sign-on to network resources. Windows 2000 and 2003 uses the Kerberos v5 protocol to provide fast, single sign-on to network services within a domain, and to services residing in trusted domains. Kerberos protocol verifies both the identity of the user and of the network services, providing mutual authentication.
Kerberos Authentication Technical Reference for Windows 2003
http://www.microsoft.com/technet/prodtechnol/windowsserver2003/library/TechRef/b748fb3f-dbf0-4b01-9b22-be14a8b4ae10.mspx
What is a Connection String
A connection string is a description on how to connect to the OLAP Server or cube file.
What is Cascading Style Sheet?
A Cascading Style Sheet (CSS) provides the ability to separate the layout and styles of a web page from the data or information. Styles such as fonts, font sizes, margins, can be specified in one place, then the Web pages feed off this one master list, with the styles cascading throughout the page or an entire site.