RMDX-package: XML/A OLAP interface, specifically Mondrian, but should...

In piersharding/RMDX: RMDX is an XML/A OLAP MDX interface

XML/A OLAP interface, specifically Mondrian, but should support others eg: SAP HANA

Description

XML/A OLAP interface, specifically Mondrian, but should support others eg: SAP HANA

Details

Package:	RMDX
Type:	Package
Version:	1.0
Date:	2015-01-29
License:	GPLv3

~~ An overview of how to use the package, including the most important functions ~~

Author(s)

Piers Harding <[e-mail]>

Maintainer: Piers Harding <[e-mail]>

References

Nada

See Also

yaml

RMDX manpage

Examples

# connect using a YAML file
conn <- RMDX('conn.yml')

# connect using parameters
conn <- RMDX('http://localhost:8080/pentaho/Xmla', 'Admin', 'password')

# list the data sources for a server
olapsources(conn)

# list the catalogs for a data source
olapcatalogs(conn, 'Pentaho')

# list the cubes for a catalog within a data souce
olapcubes(conn, 'Pentaho', 'SampleData')

# list the dimensions and measures for a cube
cubedimensions(conn, 'Pentaho', 'SampleData', 'Quadrant Analysis')
cubemeasures(conn, 'Pentaho', 'SampleData', 'Quadrant Analysis')

# execute an MDX query and get a data.frame back
r <- mdxquery(conn, 'Pentaho', 'SampleData', 'SELECT
    NON EMPTY {Hierarchize({{[Measures].[Actual], [Measures].[Budget], [Measures].[Variance]}})} ON COLUMNS,
    NON EMPTY CrossJoin([Department].[Department].Members, [Positions].[Positions].Members) ON ROWS
    FROM [Quadrant Analysis]')

piersharding/RMDX documentation built on May 17, 2022, 8:42 p.m.