CPS アクション アクションセット: 構文

planning.cpsQueryTask <result=results> <status=rc> /

={{

factIdx=integer,

factSetIdx=integer,

objectId=integer,

objectTypeId=integer,

partitionKey=integer,

value=double,

xing={integer-1 <, integer-2, ...>}

}, {...}},

compressedAdditionalsFactIdx={integer-1 <, integer-2, ...>},

compressedAdditionalsFactSetIdx={integer-1 <, integer-2, ...>},

compressedAdditionalsObjectId={integer-1 <, integer-2, ...>},

compressedAdditionalsObjectTypeId={integer-1 <, integer-2, ...>},

compressedAdditionalsPartitionKey={integer-1 <, integer-2, ...>},

compressedAdditionalsValue={double-1 <, double-2, ...>},

={{

xing={integer-1 <, integer-2, ...>}

}, {...}},

={{

compressionTable

caslib="string"

computedOnDemand=TRUE | FALSE

computedVars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

computedVarsProgram="string"

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

groupBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

groupByMode="NOSORT" | "REDISTRIBUTE"

importOptions={fileType="ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}

name="table-name"

orderBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

singlePass=TRUE | FALSE

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

whereTable

casLib="string"

dataSourceOptions={adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}

name="table-name"

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

}

dimTypeId=integer

}, {...}},

cpuIdx=integer,

data=binary-large-object,

dataMapRefresh=TRUE | FALSE,

={{

dimtypeids={integer-1 <, integer-2, ...>},

factsetid=integer,

indexedCutoffPercentage=double,

indexedOrdinals={integer-1 <, integer-2, ...>},

table

caslib="string"

computedOnDemand=TRUE | FALSE

computedVars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

computedVarsProgram="string"

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

groupBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

groupByMode="NOSORT" | "REDISTRIBUTE"

name="table-name"

orderBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

singlePass=TRUE | FALSE

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

whereTable

casLib="string"

name="table-name"

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

}

}, {...}},

={{

bytecode=binary-large-object,

name="string"

}, {...}},

guid=integer,

hints=binary-large-object,

includeIds=TRUE | FALSE,

includeZeros=TRUE | FALSE,

logTaggingGuid="string",

map=binary-large-object,

maxFacts=integer,

nonStreamingMaxFacts=integer,

partitionOrdinal=integer,

queryCubeId=integer,

request=binary-large-object,

splitByFactSetId=TRUE | FALSE,

streamingCutoff=integer,

streamingEnabled=TRUE | FALSE,

caslib="string",

compress=TRUE | FALSE,

indexVars={"variable-name-1" <, "variable-name-2", ...>},

label="string",

lifetime=64-bit-integer,

maxMemSize=64-bit-integer,

memoryFormat="DVR" | "INHERIT" | "STANDARD",

name="table-name",

promote=TRUE | FALSE,

replace=TRUE | FALSE,

replication=integer,

tableRedistUpPolicy="DEFER" | "NOREDIST" | "REBALANCE",

threadBlockSize=64-bit-integer,

timeStamp="string",

where={"string-1" <, "string-2", ...>}

vcubeId=integer,

whereClause="string"

;

必須パラメーター

要約: 入力テーブルと出力テーブル

行にサブパラメーターが含まれる場合は、サブパラメーターに名前、caslibなどを指定できます。サブパラメーターが含まれない場合は、パラメーターに名前、caslibなどを指定できます。

入力テーブルの読み込みパラメーター
パラメーター	サブパラメーター	説明
compressions	required parametercompressionTable
factsets	required parametertable

出力テーブルの作成パラメーター
パラメーター	サブパラメーター	説明
required parameterstreamingReturnTable	—

パラメーターの説明

additionalFacts={{cpsFact-1} <, {cpsFact-2}, ...>}

cpsFact の値は次のいずれかになります:

* factIdx=integer

factSetIdx=integer

デフォルト	-1

* objectId=integer

* objectTypeId=integer

* partitionKey=integer

* value=double

* xing={integer-1 <, integer-2, ...>}

compressedAdditionalsFactCount=integer

compressedAdditionalsFactIdx={integer-1 <, integer-2, ...>}

compressedAdditionalsFactSetIdx={integer-1 <, integer-2, ...>}

compressedAdditionalsFactWidth=integer

compressedAdditionalsObjectId={integer-1 <, integer-2, ...>}

compressedAdditionalsObjectTypeId={integer-1 <, integer-2, ...>}

compressedAdditionalsPartitionKey={integer-1 <, integer-2, ...>}

compressedAdditionalsValue={double-1 <, double-2, ...>}

compressedAdditionalsXings={{cpsXing-1} <, {cpsXing-2}, ...>}

* xing={integer-1 <, integer-2, ...>}

compressions={{cpsDimTypeCompressions-1} <, {cpsDimTypeCompressions-2}, ...>}

cpsDimTypeCompressions の値は次のいずれかになります:

* compressionTable={castable}

入力テーブルの設定を指定します。

compressionTable パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

dimTypeId=integer

デフォルト	-1

cpuIdx=integer

デフォルト	0

data=binary-large-object

dataMapRefresh=TRUE | FALSE

デフォルト	FALSE

factsets={{cpsExecuteFactSets-1} <, {cpsExecuteFactSets-2}, ...>}

cpsExecuteFactSets の値は次のいずれかになります:

* dimtypeids={integer-1 <, integer-2, ...>}

* factsetid=integer

* indexedCutoffPercentage=double

* indexedOrdinals={integer-1 <, integer-2, ...>}

* table={castable}

入力テーブルの設定を指定します。

table パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

formulas={{cpsFormula-1} <, {cpsFormula-2}, ...>}

cpsFormula の値は次のいずれかになります:

* bytecode=binary-large-object

* name="string"

guid=integer

* hints=binary-large-object

includeIds=TRUE | FALSE

デフォルト	FALSE

includeZeros=TRUE | FALSE

デフォルト	FALSE

logTaggingGuid="string"

* map=binary-large-object

maxFacts=integer

デフォルト	0

nonStreamingMaxFacts=integer

デフォルト	100000

* partitionOrdinal=integer

performanceLoggingEanbledMask=integer

デフォルト	0

performanceLoggingLevel=integer

デフォルト	0

* queryCubeId=integer

request=binary-large-object

splitByFactSetId=TRUE | FALSE

デフォルト	FALSE

streamingCutoff=integer

デフォルト	0

streamingEnabled=TRUE | FALSE

デフォルト	FALSE

* streamingReturnTable={casouttable}

streamingReturnTable パラメーターの指定の詳細については、共通 casouttable (形式 1) パラメーターを参照してください。

vcubeId=integer

whereClause="string"

cpsQueryTask アクション

リーフまたはロールアップ、あるいはその両方のキューブをクエリ。

Lua 構文

results, info = s:planning_cpsQueryTask{

={{

factIdx=integer,

factSetIdx=integer,

objectId=integer,

objectTypeId=integer,

partitionKey=integer,

value=double,

xing={integer-1 <, integer-2, ...>}

}, {...}},

compressedAdditionalsFactIdx={integer-1 <, integer-2, ...>},

compressedAdditionalsFactSetIdx={integer-1 <, integer-2, ...>},

compressedAdditionalsObjectId={integer-1 <, integer-2, ...>},

compressedAdditionalsObjectTypeId={integer-1 <, integer-2, ...>},

compressedAdditionalsPartitionKey={integer-1 <, integer-2, ...>},

compressedAdditionalsValue={double-1 <, double-2, ...>},

={{

xing={integer-1 <, integer-2, ...>}

}, {...}},

={{

compressionTable

caslib="string"

computedOnDemand=true | false

computedVars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

computedVarsProgram="string"

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

groupBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

groupByMode="NOSORT" | "REDISTRIBUTE"

name="table-name"

orderBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

singlePass=true | false

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

whereTable

casLib="string"

name="table-name"

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

}

dimTypeId=integer

}, {...}},

cpuIdx=integer,

data=binary-large-object,

dataMapRefresh=true | false,

={{

dimtypeids={integer-1 <, integer-2, ...>},

factsetid=integer,

indexedCutoffPercentage=double,

indexedOrdinals={integer-1 <, integer-2, ...>},

table

caslib="string"

computedOnDemand=true | false

computedVars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

computedVarsProgram="string"

dataSourceOptions={key-1=any-list-or-data-type-1 <, key-2=any-list-or-data-type-2, ...>}

groupBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

groupByMode="NOSORT" | "REDISTRIBUTE"

name="table-name"

orderBy

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

singlePass=true | false

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

whereTable

casLib="string"

name="table-name"

vars

={{

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

}, {...}}

where="where-expression"

}

}, {...}},

={{

bytecode=binary-large-object,

name="string"

}, {...}},

guid=integer,

hints=binary-large-object,

includeIds=true | false,

includeZeros=true | false,

logTaggingGuid="string",

map=binary-large-object,

maxFacts=integer,

nonStreamingMaxFacts=integer,

partitionOrdinal=integer,

queryCubeId=integer,

request=binary-large-object,

splitByFactSetId=true | false,

streamingCutoff=integer,

streamingEnabled=true | false,

caslib="string",

compress=true | false,

indexVars={"variable-name-1" <, "variable-name-2", ...>},

label="string",

lifetime=64-bit-integer,

maxMemSize=64-bit-integer,

memoryFormat="DVR" | "INHERIT" | "STANDARD",

name="table-name",

promote=true | false,

replace=true | false,

replication=integer,

tableRedistUpPolicy="DEFER" | "NOREDIST" | "REBALANCE",

threadBlockSize=64-bit-integer,

timeStamp="string",

where={"string-1" <, "string-2", ...>}

vcubeId=integer,

whereClause="string"

}

必須パラメーター

要約: 入力テーブルと出力テーブル

入力テーブルの読み込みパラメーター
パラメーター	サブパラメーター	説明
compressions	required parametercompressionTable
factsets	required parametertable

出力テーブルの作成パラメーター
パラメーター	サブパラメーター	説明
required parameterstreamingReturnTable	—

パラメーターの説明

additionalFacts={{cpsFact-1} <, {cpsFact-2}, ...>}

cpsFact の値は次のいずれかになります:

* factIdx=integer

factSetIdx=integer

デフォルト	-1

* objectId=integer

* objectTypeId=integer

* partitionKey=integer

* value=double

* xing={integer-1 <, integer-2, ...>}

compressedAdditionalsFactCount=integer

compressedAdditionalsFactIdx={integer-1 <, integer-2, ...>}

compressedAdditionalsFactSetIdx={integer-1 <, integer-2, ...>}

compressedAdditionalsFactWidth=integer

compressedAdditionalsObjectId={integer-1 <, integer-2, ...>}

compressedAdditionalsObjectTypeId={integer-1 <, integer-2, ...>}

compressedAdditionalsPartitionKey={integer-1 <, integer-2, ...>}

compressedAdditionalsValue={double-1 <, double-2, ...>}

compressedAdditionalsXings={{cpsXing-1} <, {cpsXing-2}, ...>}

* xing={integer-1 <, integer-2, ...>}

compressions={{cpsDimTypeCompressions-1} <, {cpsDimTypeCompressions-2}, ...>}

cpsDimTypeCompressions の値は次のいずれかになります:

* compressionTable={castable}

入力テーブルの設定を指定します。

compressionTable パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

dimTypeId=integer

デフォルト	-1

cpuIdx=integer

デフォルト	0

data=binary-large-object

dataMapRefresh=true | false

デフォルト	false

factsets={{cpsExecuteFactSets-1} <, {cpsExecuteFactSets-2}, ...>}

cpsExecuteFactSets の値は次のいずれかになります:

* dimtypeids={integer-1 <, integer-2, ...>}

* factsetid=integer

* indexedCutoffPercentage=double

* indexedOrdinals={integer-1 <, integer-2, ...>}

* table={castable}

入力テーブルの設定を指定します。

table パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

formulas={{cpsFormula-1} <, {cpsFormula-2}, ...>}

cpsFormula の値は次のいずれかになります:

* bytecode=binary-large-object

* name="string"

guid=integer

* hints=binary-large-object

includeIds=true | false

デフォルト	false

includeZeros=true | false

デフォルト	false

logTaggingGuid="string"

* map=binary-large-object

maxFacts=integer

デフォルト	0

nonStreamingMaxFacts=integer

デフォルト	100000

* partitionOrdinal=integer

performanceLoggingEanbledMask=integer

デフォルト	0

performanceLoggingLevel=integer

デフォルト	0

* queryCubeId=integer

request=binary-large-object

splitByFactSetId=true | false

デフォルト	false

streamingCutoff=integer

デフォルト	0

streamingEnabled=true | false

デフォルト	false

* streamingReturnTable={casouttable}

streamingReturnTable パラメーターの指定の詳細については、共通 casouttable (形式 1) パラメーターを参照してください。

vcubeId=integer

whereClause="string"

cpsQueryTask アクション

リーフまたはロールアップ、あるいはその両方のキューブをクエリ。

Python 構文

results=s.planning.cpsQueryTask(

=[{

"factIdx":integer,

"factSetIdx":integer,

"objectId":integer,

"objectTypeId":integer,

"partitionKey":integer,

"value":double,

"xing":[integer-1 <, integer-2, ...>]

}<, {...}>],

compressedAdditionalsFactIdx=[integer-1 <, integer-2, ...>],

compressedAdditionalsFactSetIdx=[integer-1 <, integer-2, ...>],

compressedAdditionalsObjectId=[integer-1 <, integer-2, ...>],

compressedAdditionalsObjectTypeId=[integer-1 <, integer-2, ...>],

compressedAdditionalsPartitionKey=[integer-1 <, integer-2, ...>],

compressedAdditionalsValue=[double-1 <, double-2, ...>],

=[{

"xing":[integer-1 <, integer-2, ...>]

}<, {...}>],

=[{

"compressionTable"

"caslib":"string"

"computedOnDemand":True | False

"computedVars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"computedVarsProgram":"string"

"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>}

"groupBy"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"groupByMode":"NOSORT" | "REDISTRIBUTE"

"importOptions":{"fileType":"ANY" | "AUDIO" | "AUTO" | "BASESAS" | "CSV" | "DELIMITED" | "DOCUMENT" | "DTA" | "ESP" | "EXCEL" | "FMT" | "HDAT" | "IMAGE" | "JMP" | "LASR" | "PARQUET" | "SOUND" | "SPSS" | "VIDEO" | "XLS", fileType-specific-parameters}

"name":"table-name"

"orderBy"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"singlePass":True | False

"vars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"where":"where-expression"

"whereTable"

"casLib":"string"

"dataSourceOptions":{adls_noreq-parameters | bigquery-parameters | cas_noreq-parameters | clouddex-parameters | db2-parameters | dnfs-parameters | esp-parameters | fedsvr-parameters | gcs_noreq-parameters | hadoop-parameters | hana-parameters | impala-parameters | informix-parameters | jdbc-parameters | mongodb-parameters | mysql-parameters | odbc-parameters | oracle-parameters | path-parameters | postgres-parameters | redshift-parameters | s3-parameters | sapiq-parameters | sforce-parameters | singlestore_standard-parameters | snowflake-parameters | spark-parameters | spde-parameters | sqlserver-parameters | ss_noreq-parameters | teradata-parameters | vertica-parameters | yellowbrick-parameters}

"name":"table-name"

"vars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"where":"where-expression"

}

"dimTypeId":integer

}<, {...}>],

cpuIdx=integer,

data=binary-large-object,

dataMapRefresh=True | False,

=[{

"dimtypeids":[integer-1 <, integer-2, ...>],

"factsetid":integer,

"indexedCutoffPercentage":double,

"indexedOrdinals":[integer-1 <, integer-2, ...>],

"table"

"caslib":"string"

"computedOnDemand":True | False

"computedVars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"computedVarsProgram":"string"

"dataSourceOptions":{"key-1":{any-list-or-data-type-1} <, "key-2":{any-list-or-data-type-2}, ...>}

"groupBy"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"groupByMode":"NOSORT" | "REDISTRIBUTE"

"name":"table-name"

"orderBy"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"singlePass":True | False

"vars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"where":"where-expression"

"whereTable"

"casLib":"string"

"name":"table-name"

"vars"

:[{

"format":"string",

"formattedLength":integer,

"label":"string",

"name":"variable-name",

"nfd":integer,

"nfl":integer

}<, {...}>]

"where":"where-expression"

}

}<, {...}>],

=[{

"bytecode":binary-large-object,

"name":"string"

}<, {...}>],

guid=integer,

hints=binary-large-object,

includeIds=True | False,

includeZeros=True | False,

logTaggingGuid="string",

map=binary-large-object,

maxFacts=integer,

nonStreamingMaxFacts=integer,

partitionOrdinal=integer,

queryCubeId=integer,

request=binary-large-object,

splitByFactSetId=True | False,

streamingCutoff=integer,

streamingEnabled=True | False,

"caslib":"string",

"compress":True | False,

"indexVars":["variable-name-1" <, "variable-name-2", ...>],

"label":"string",

"lifetime":64-bit-integer,

"maxMemSize":64-bit-integer,

"memoryFormat":"DVR" | "INHERIT" | "STANDARD",

"name":"table-name",

"promote":True | False,

"replace":True | False,

"replication":integer,

"tableRedistUpPolicy":"DEFER" | "NOREDIST" | "REBALANCE",

"threadBlockSize":64-bit-integer,

"timeStamp":"string",

"where":["string-1" <, "string-2", ...>]

vcubeId=integer,

whereClause="string"

)

必須パラメーター

要約: 入力テーブルと出力テーブル

入力テーブルの読み込みパラメーター
パラメーター	サブパラメーター	説明
compressions	required parametercompressionTable
factsets	required parametertable

出力テーブルの作成パラメーター
パラメーター	サブパラメーター	説明
required parameterstreamingReturnTable	—

パラメーターの説明

additionalFacts=[{cpsFact-1} <, {cpsFact-2}, ...>]

cpsFact の値は次のいずれかになります:

* "factIdx":integer

"factSetIdx":integer

デフォルト	-1

* "objectId":integer

* "objectTypeId":integer

* "partitionKey":integer

* "value":double

* "xing":[integer-1 <, integer-2, ...>]

compressedAdditionalsFactCount=integer

compressedAdditionalsFactIdx=[integer-1 <, integer-2, ...>]

compressedAdditionalsFactSetIdx=[integer-1 <, integer-2, ...>]

compressedAdditionalsFactWidth=integer

compressedAdditionalsObjectId=[integer-1 <, integer-2, ...>]

compressedAdditionalsObjectTypeId=[integer-1 <, integer-2, ...>]

compressedAdditionalsPartitionKey=[integer-1 <, integer-2, ...>]

compressedAdditionalsValue=[double-1 <, double-2, ...>]

compressedAdditionalsXings=[{cpsXing-1} <, {cpsXing-2}, ...>]

* "xing":[integer-1 <, integer-2, ...>]

compressions=[{cpsDimTypeCompressions-1} <, {cpsDimTypeCompressions-2}, ...>]

cpsDimTypeCompressions の値は次のいずれかになります:

* "compressionTable":{castable}

入力テーブルの設定を指定します。

compressionTable パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

"dimTypeId":integer

デフォルト	-1

cpuIdx=integer

デフォルト	0

data=binary-large-object

dataMapRefresh=True | False

デフォルト	False

factsets=[{cpsExecuteFactSets-1} <, {cpsExecuteFactSets-2}, ...>]

cpsExecuteFactSets の値は次のいずれかになります:

* "dimtypeids":[integer-1 <, integer-2, ...>]

* "factsetid":integer

* "indexedCutoffPercentage":double

* "indexedOrdinals":[integer-1 <, integer-2, ...>]

* "table":{castable}

入力テーブルの設定を指定します。

table パラメーターの指定の詳細については、共通 castable (形式 1) パラメーターを参照してください。

formulas=[{cpsFormula-1} <, {cpsFormula-2}, ...>]

cpsFormula の値は次のいずれかになります:

* "bytecode":binary-large-object

* "name":"string"

guid=integer

* hints=binary-large-object

includeIds=True | False

デフォルト	False

includeZeros=True | False

デフォルト	False

logTaggingGuid="string"

* map=binary-large-object

maxFacts=integer

デフォルト	0

nonStreamingMaxFacts=integer

デフォルト	100000

* partitionOrdinal=integer

performanceLoggingEanbledMask=integer

デフォルト	0

performanceLoggingLevel=integer

デフォルト	0

* queryCubeId=integer

request=binary-large-object

splitByFactSetId=True | False

デフォルト	False

streamingCutoff=integer

デフォルト	0

streamingEnabled=True | False

デフォルト	False

* streamingReturnTable={casouttable}

streamingReturnTable パラメーターの指定の詳細については、共通 casouttable (形式 1) パラメーターを参照してください。

vcubeId=integer

whereClause="string"

cpsQueryTask アクション

リーフまたはロールアップ、あるいはその両方のキューブをクエリ。

R 構文

results <– cas.planning.cpsQueryTask(s,

=list( list(

factIdx=integer,

factSetIdx=integer,

objectId=integer,

objectTypeId=integer,

partitionKey=integer,

value=double,

xing=list(integer-1 <, integer-2, ...>)

) <, list(...)>),

compressedAdditionalsFactIdx=list(integer-1 <, integer-2, ...>),

compressedAdditionalsFactSetIdx=list(integer-1 <, integer-2, ...>),

compressedAdditionalsObjectId=list(integer-1 <, integer-2, ...>),

compressedAdditionalsObjectTypeId=list(integer-1 <, integer-2, ...>),

compressedAdditionalsPartitionKey=list(integer-1 <, integer-2, ...>),

compressedAdditionalsValue=list(double-1 <, double-2, ...>),

=list( list(

xing=list(integer-1 <, integer-2, ...>)

) <, list(...)>),

=list( list(

compressionTable

=list(

caslib="string"

computedOnDemand=TRUE | FALSE

computedVars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

computedVarsProgram="string"

dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>)

groupBy

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

groupByMode="NOSORT" | "REDISTRIBUTE"

name="table-name"

orderBy

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

singlePass=TRUE | FALSE

vars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

where="where-expression"

whereTable

=list(

casLib="string"

name="table-name"

vars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

where="where-expression"

)

dimTypeId=integer

) <, list(...)>),

cpuIdx=integer,

data=binary-large-object,

dataMapRefresh=TRUE | FALSE,

=list( list(

dimtypeids=list(integer-1 <, integer-2, ...>),

factsetid=integer,

indexedCutoffPercentage=double,

indexedOrdinals=list(integer-1 <, integer-2, ...>),

table

=list(

caslib="string"

computedOnDemand=TRUE | FALSE

computedVars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

computedVarsProgram="string"

dataSourceOptions=list(key-1=list(any-list-or-data-type-1) <, key-2=list(any-list-or-data-type-2), ...>)

groupBy

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

groupByMode="NOSORT" | "REDISTRIBUTE"

name="table-name"

orderBy

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

singlePass=TRUE | FALSE

vars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

where="where-expression"

whereTable

=list(

casLib="string"

name="table-name"

vars

=list( list(

format="string",

formattedLength=integer,

label="string",

name="variable-name",

nfd=integer,

nfl=integer

) <, list(...)>)

where="where-expression"

)

) <, list(...)>),

=list( list(

bytecode=binary-large-object,

name="string"

) <, list(...)>),

guid=integer,

hints=binary-large-object,

includeIds=TRUE | FALSE,

includeZeros=TRUE | FALSE,

logTaggingGuid="string",

map=binary-large-object,

maxFacts=integer,

nonStreamingMaxFacts=integer,

partitionOrdinal=integer,

queryCubeId=integer,

request=binary-large-object,

splitByFactSetId=TRUE | FALSE,

streamingCutoff=integer,

streamingEnabled=TRUE | FALSE,