OLAP Client
Flexolapview User Manual
Overview
flexolapview component is a method for multidimensional analysis.FLASHcontrol, available through theXMLAstandard protocol connected toOLAPservers, such as: Microsoft'sSQL ServerAnalysis Server (MS ssas2005/2008) andPentahoAnalysis Services (Mondrianand so on, it can use the pivot table and a variety of charts to display multidimensional Analysis data for real-time business analysis. This article describes how developers willFlexolapviewThe control is applied to your own project.
See: http://www.flexolap.com
Main interface
The main interface of the system is as follows
650) this.width=650; "Width=" 554 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image002_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image002_0001.jpg "/>
Depending on the initial parameters, different interfaces may appear, such as a multidimensional table only, or only a chart, such as:
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image004_0003. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image004_0003.jpg "/>
Defining a query
Drag dimensions and metrics from the cube tree to a row or column to construct an MDX query that displays the results of the query in a multidimensional table.
650) this.width=650; "Width=" 549 "height=" 319 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image005_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image005_0001.jpg "/>
Defining filters
When you drag a member of a dimension to a filter condition (Filters), a condition is added to the query that displays only the data that meets the criteria.
650) this.width=650; "Width=" 554 "height=" 284 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image007_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image007_0001.jpg "/>
Drill Down
Drill down There are two ways to do this, Method 1: Select the next level in the drop-down list of the dimension
650) this.width=650; "Width=" 133 "height=" 288 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image009_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image009_0001.jpg "/>
For example, if you select the Vendor menu, you drill down to the vendor hierarchy of the Product dimension.
Method 2: Click on the header of the multidimensional table to drill down to the next level of the member that is taking the hit.
650) this.width=650; "Width=" 554 "height=" 284 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image011_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image011_0001.jpg "/>
Roll up (drill up)
There are two ways to roll up, one is to remove the selection from the drop-down list in the dimension
650) this.width=650; "Width=" 133 "height=" 288 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image013_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image013_0001.jpg "/> as left, if removed" The selection status of the product line menu is rolled up to the previous level.
Changing the display mode
The software provides a variety of display modes, the developer can pre-define the display mode, or let the end user himself to change the display mode.
Click on the toolbar 650) this.width=650; "Width=" "height=" src= "http://www.flexolap.com/zh/doc/user_doc2_clip_image015_" 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image015_0001.jpg "/> Button, Switches in the following four display modes:
650) this.width=650; "Width=" 553 "height=" 445 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image017_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image017_0001.jpg "/>
Show MDX
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image019_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image019_0001.jpg "/> Button, The MDX statement for the current query is displayed.
650) this.width=650; "width=" 343 "height=" 181 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image021_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image021_0001.jpg "/>
Clear
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image023_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image023_0001.jpg "/> Button, Clears the current query and the interface goes back to its original state.
Return
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image025_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image025_0001.jpg "/> Button, is returned to the previous query, and the interface goes back to the previous query state.
Rotating
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image027_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image027_0001.jpg "/> Button, Converts the row and column of the current query to rotate the current query result
Display graphics
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image029_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image029_0001.jpg "/> Button, The current query results are displayed graphically
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image004_0004. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image004_0004.jpg "/>
The system provides a variety of graphic display, click on the label 650) this.width=650; "width=" 310 "height=" src= "Http://www.flexolap.com/zh/doc/user_doc2_clip_" Image031_0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image031_0001.jpg "/ > can toggle chart types.
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image033_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image033_0001.jpg "/>
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image035_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image035_0001.jpg "/>
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image037_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image037_0001.jpg "/>
650) this.width=650; "Width=" 553 "height=" 285 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image039_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image039_0001.jpg "/>
Print
Click 650 in the toolbar) this.width=650; "Width=" height= "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image041_ 0001.jpg "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image041_0001.jpg "/> Button, Multidimensional tables and charts that print query results on paper
650) this.width=650; "Width=" 553 "height=" 310 "src=" http://www.flexolap.com/zh/doc/user_doc2_clip_image043_0001. JPG "style=" border:0px;height:auto;vertical-align:middle; "alt=" user_doc2_clip_image043_0001.jpg "/>
OLAP client Flex OLAP View user manual