OLAP client Flex OLAP View user manual

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.