Description Usage Arguments Details Value Note Author(s) See Also Examples
Query Pentaho via the cda web service interface. CDA is the Community Data Access - http://www.webdetails.pt/ctools/cda.html. This enables users to construct a uniform data interface to any of the Pentaho data sources. The cda web service provides a JSON based result payload that converts easily to R structures. In this case all resultsets are given back to the user as a data.frame.
1 |
pentaho |
Pentaho connection object |
file |
CDA file name |
id |
CDA Id |
solution |
CDA solution name - this is usually the top level directory name |
path |
CDA path from the solution to the file name |
withFactors |
Convert character vectors to Factors - default FALSE |
toNumeric |
Convert numeric vector types to Numeric - default TRUE |
toDate |
Attempt to convert Date labelled vectors to POSIXct date types - default TRUE |
... |
Any other named parameters are passed as paramters to the web service call |
cdaquery
calls the cda web service to execute a predefined CDA query. The query results are parsed and converted into a data.frame object eg:
df <- cdaquery(pentaho, solution='sol', file='cde1.cda', id='MDX1')
Returns a data.frame.
Not much to note here.
Piers Harding
RPentaho
, cdaquery
, cdbquery
, cdbgroups
1 2 3 4 5 6 7 |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.