OLAP client based on XMLA MDX Flexolapview development Multidimensional Analysis application

An XMLA MDX-based OLAP client Flexolapview Development Manual Overview The Flexolapview component is a Flash control for multidimensional analysis that can be connected to an OLAP server via the XMLA standard protocol, such as Microsoft's SQL Server Analysis Server (MS SSAS 2005,008) and Pentaho Analysis Service (Mondrian), etc., it can use the pivot table and a variety of charts to display multidimensional Analysis data, to achieve real-time business analysis. This article describes how developers can apply Flexolapview controls to their own projects. Architecture 650) this.width=650; "Width=" 547 "height=" 284 "src=" http://www.flexolap.com/doc/dev_doc_clip_image002.jpg "border=" 0 "hspace=" 0 "vspace=" 0 "title=" "style=" WIDTH:547PX;HEIGHT:284PX; "alt=" dev_doc_clip_image002.jpg "/> Sample Example You can pass in different parameters, define the presentation form of the Flexolapview, and can display only graphics, multidimensional tables, or complex analysis tool interfaces, for example: 650) this.width=650; "width=" 470 "height=" 381 "src=" http://www.flexolap.com/doc/dev_doc_clip_image004.jpg " Border= "0" hspace= "0" vspace= "0" title= "" style= "width:470px;height:381px;" alt= "dev_doc_clip_image004.jpg"/>         650) this.width=650; "Width=" 466 "height=" 291 "src=" http://www.flexolap.com/doc/dev_ Doc_clip_image006.jpg "border=" 0 "hspace=" 0 "vspace=" 0 "title=" "style=" width:466px;height:291px; "alt=" Dev_doc_clip _image006.jpg "/>         650) this.width=650;" Width= "471" height= "321" src= "http:// Www.flexolap.com/doc/dev_doc_clip_image008.jpg "border=" 0 "hspace=" 0 "vspace=" 0 "title=" "style=" width:471px;height : 321px; "alt=" dev_doc_clip_image008.jpg "/>         650) this.width=650;" Width= "471" height= "294" src= "http://www.flexolap.com/doc/dev_doc_clip_image010.jpg" border= "0" hspace= "0" vspace= "0" title= "" style= " WIDTH:471PX;HEIGHT:294PX, "alt=" dev_doc_clip_image010.jpg "/> Parameter description The developer puts the control into the Web page and sets the following parameters correctly:
Parameters	Description	Notes
Show_mode	Display mode	1:report;  2:view;  3:edit; 4:columnchart 5:piechart 6:linechart 7:barchart
Show_toolbar	Whether to show toolbars	1: Display 0: Do not show
Mdx	MDX query statement	Can be empty
DataSource	Data source	"Provider=mondrian;datasource=pentaho";
CubeName	Cube name	"Steelwheelssales";
Serviceurl	OLAP Services URL	"Http://localhost:8080/pentaho/Xmla?userid=joe&password=password";
Usenumbercolor	Whether to identify data in different colors	0: No 1: Yes
Highcolor	Data color higher than the upper limit	16711680; FF0000
Lowcolor	Data color below the lower limit	204; 0x00FF00
Highthreshold	Maximum Value	10000;
Lowthreshold	Lower value	1000;

Examples are as follows:

Example

<script type= "Text/javascript" > For version detection, set-to-min. required Flash Player version, or 0 (or 0.0.0), for no version detection. var swfversionstr = "11.1.0"; To use Express install, set to playerproductinstall.swf, otherwise the empty string. var xiswfurlstr = "playerproductinstall.swf"; var flashvars = {}; Flashvars.show_mode=3;//1:report;     2:view;  3:edit; 4:columnchart 5:piechart 6:linechart 7:barchart flashvars.show_toolbar=1; flashvars.mdx= "Select NON EMPTY {[Measures]} on columns, {[customers].[ All Customers].children} on the rows from [Steelwheelssales]; flashvars.datasource= "Provider=mondrian;datasource=pentaho"; flashvars.cubename= "Steelwheelssales"; flashvars.serviceurl= "Http://localhost:8080/pentaho/Xmla?userid=joe&password=password"; flashvars.usenumbercolor=0; flashvars.highcolor=16711680;//ff0000 flashvars.lowcolor=204;//0x00ff00 flashvars.highthreshold=10000; flashvars.lowthreshold=1000; var params = {}; Params.quality = "High"; Params.bgcolor = "#ffffff"; params.allowscriptaccess = "Samedomain"; Params.allowfullscreen = "true"; var attributes = {}; Attributes.id = "Flexolapview"; Attributes.name = "Flexolapview"; Attributes.align = "Middle"; SWFOBJECT.EMBEDSWF ( "Flexolapview.swf", "Flashcontent", "100%", "100%", Swfversionstr, Xiswfurlstr, Flashvars, params, attributes); JavaScript enabled so display the Flashcontent div in case it's not replaced with a SwF object. Swfobject.createcss ("#flashContent", "display:block;text-align:left;"); </script>

OLAP client based on XMLA MDX Flexolapview development Multidimensional Analysis application