Below is a fully functional demo of our OlapX Web Control.
It's only limit if that it only can open our demo cube. If you would like to evaluate this control against your data, please download and install our evaluation version.
You might need to install Pivot Table Service from Microsoft for this page to work. Download it here.
| Parameter | Value | Description
|
|---|
| Password | "" | Password used for licensing issues. (Don't use).
|
| VisibleMatrix | -1" | Shows OlapX areas, use -1 for show, 0 for hide.
|
| VisibleChart | "-1" | See above.
|
| VisibleHeading | "-1" | See above.
|
| VisibleTitle | "-1" | See above.
|
| VisibleLayout | "-1" | Layout number to use (0 to 8). It shows different control areas in different places.
|
| VisibleLayoutOrder | "-1" | Use -1 to show data on top or left of chart, otherwise 0.
|
| VisibleToolbar | "-1" | Use -1 to show the control toolbar, otherwise use 0.
|
| VisibleButtonOpen | "-1" | Shows or hides toolbar buttons. Use -1 to show, 0 to hide. Open a new cube.
|
| VisibleButtonSave | "-1" | Saves current view in a file.
|
| VisibleButtonPortfolioAdd | "-1" | Adds current view to the current portfolio.
|
| VisibleButtonPortfolioEdit | "0" | Edits current portfolio.
|
| VisibleButtonPortfolioPlay | "0" | Plays or shows the current portfolio.
|
| VisibleButtonPortfolioSeq | "0" | Shows the first, previous, next and last portfolio buttons.
|
| VisibleButtonCommitCube | "-1" | Commits changes to cube permanently.
|
| VisibleButtonRefreshCube | "-1" | Refreshes the cube with new information.
|
| VisibleButtonRefreshTimer | -1 | Sets the refresh timer on or off.
|
| VisibleButtonSequence | "-1" | Shows the first, previous, next and last history use or view sequence buttons.
|
| VisibleButtonPageSetup | "-1" | Page setup option.
|
| VisibleButtonPrintPreview | "-1" | Print preview button.
|
| VisibleButtonPrint | "-1" | Print button.
|
| VisibleButtonExport | "-1" | Export current view button.
|
| VisibleButtonCopy | "-1" | Copy data to clipboard.
|
| VisibleButtonPaste | "-1" | Paste data from clipboard. (Only for write enabled cubes).
|
| VisibleButtonDirectMDX | "-1" | Shows current MDX.
|
| VisibleButtonShowElements | "-1" | Dialog to choose current cube layout.
|
| VisibleButtonTranspose | "-1" | Transposes chart.
|
| VisibleButtonSwapXY | "-1" | Swaps data axes.
|
| VisibleButtonLayout | "-1" | Shows the layout dialog, to move cube dimensions around.
|
| VisibleButtonCubeOption | "-1" | Shows the cube options dialog.
|
| VisibleButtonDimOption | "-1" | Shows the dimension options dialog.
|
| VisibleButtonGridOption | "-1" | Shows the grid options dialog.
|
| VisibleButtonPreferences | "-1" | Shows the global preferences dialog.
|
| VisibleButtonAbout | "-1" | Shows about dialog.
|
| VisiblePopupMenu | "-1" | Enables or disables the matrix popup menu.
|
| LanguageID | "0" | Use:- 0 for English
- 1 for Spanish
- 2 for Portugues.
|
| OpenLayout | "0" | Shows the Open layout dialog when opening a new cube.
|
| OpenServer | xxx | MS Analysis services (MSAS) server name or IIS datapump directory.
|
| OpenUser | xxx | MSAS user name.
|
| OpenPassword | xxx | MSAS user password.
|
| OpenDB | xxx | MSAS database name (Foodmart 2000).
|
| OpenCube | xxx | MSAS cube name (Sales).
|
| OpenFile | xxx | Local cue file to open (c:\inetpub\wwwroot\OlapX\gs3.cub).
|
| OpenWWWDir | xxx | Local cube or view file to open located on Demo server (http://www.olapXSoftware.com/demo/gs3.cub)."
|
| OpenView | xxx | Local view to open. Must be saved first.
|
| OpenPortfolio | xxx | Local view to open. Must be saved first.
|
| MDX | "" | Sets the MDX to execute for non interactive sessions.
|
| Interactive | "-1" | Enables or disables the control elements. -1 is enable, 0 is not enabled.
|
| Enabled | "-1" | Enables or disables the control elements. -1 is enable, 0 is not enabled.
|
| Caption | "" | Cube view title or caption.
|
| Macro | "" | Reserved for future use.
|
| EmptyHorizontal | "-1" | Show or hides cube empty rows.
|
| EmptyVertical | "-1" | Show or hides cube empty columns.
|
| FormulaListSide | "0" | Paint list formulas before data (-1) or after data (0).
|
| FormulaListChart | "0" | Paint list formulas in chart.
|
| MaxPointsPerPage | "0" | Number of points to paint in chart. Use 0 for all points.
|
| HideChartSubtotals | "0" | Paint cube subtotals in chart.
|
| ChartDefaultLoad | "0" | Deprecated.
|
| ChartDefaultFile | "" | Deprecated.
|
| ViewSaveLayout | "0" | Save cube layout in new views.
|
| ViewGridLayout | "0" | Save grid layout in new views.
|
| ViewGridOptions | "0" | Save grid options in new views.
|
| InvalidNumber | "Error" | Use for printing invalid numbers, for example division by zero among others.
|
| UseDefaultValues | "0" | Specifies wether to use cube default values or not.
|
| AutoRefreshCube | "0" | Forces a ROLAP cube refresh each time the view changes.
|
| Button | Code | Description
|
|---|
| DoSwapXY | OlapXDemo1.doAction("DoSwapXY")| Swaps the XY Axis.
| | Splash | OlapXDemo1.doAction("Splash")| Shows the splash or about... screen.
| | MDX | alert(OlapXDemo1.MDX)| Shows the current MDX statement.
| | Language | OlapXDemo1.languageID = (OlapXDemo1.languageID + 1) % 3;
OlapXDemo1.doAction("Splash")Changes the control language and shows the splash screen.
| | Sort | OlapXDemo1.setValue("Row", 1);
OlapXDemo1.setValue("Col", 1);
OlapXDemo1.setValue("SortFlag", 1);
OlapXDemo1.DoAction("Sort")Chooses colunm and row one and sort the column in descending order.
| | Get/Set Values | OlapXDemo1.setValue("BackColor", "&HD4E1E1");
OlapXDemo1.setValue("Hierarchy", 4, 1);
OlapXDemo1.DoAction("Refresh") | Sets several cube values, backcolor, dimension hierarchy and refreshes the cube view.
| | Drill 1 | OlapXDemo1.setValue("Row", 3);
OlapXDemo1.setValue("Col", 0);
OlapXDemo1.DoAction("Drill") | Chooses a column and a row and drills down a dimension.
| | Drill 2 | OlapXDemo1.setValue("From", 3);
OlapXDemo1.setValue("Row", 3);
OlapXDemo1.setValue("Col", 0);
OlapXDemo1.setValue("Move", -1);
OlapXDemo1.DoAction("Drill") | Exchanges a dimension for the header area to the matrix area.
| | Open View | OlapXDemo1.setValue("OpenServer", "");
OlapXDemo1.setValue("OpenFile", "");
OlapXDemo1.setValue("OpenView", "");
OlapXDemo1.setValue("OpenPortfolio", "");
OlapXDemo1.setValue("OpenWWWDir", "http://www.olapxsoftware.com/demo/ff.oxv");
OlapXDemo1.doAction("OpenParam") | Opens view ff.oxv.
| | Open Portfolio | OlapXDemo1.setValue("OpenServer", "");
OlapXDemo1.setValue("OpenFile", "");
OlapXDemo1.setValue("OpenView", "");
OlapXDemo1.setValue("OpenPortfolio", "");
OlapXDemo1.setValue("OpenWWWDir", "http://www.olapxsoftware.com/demo/olapXDemoWeb.oxb");
OlapXDemo1.doAction("OpenParam") | Opens portfolio olapXDemoWeb.oxb.
| | | | | |
